ISPConfig not creating /www/client...

Discussion in 'Installation/Configuration' started by bruno_floyd, Oct 25, 2010.

  1. bruno_floyd

    bruno_floyd New Member

    Hi everydoby,

    I installed the ISPConfig 3.0.2.2 on a multiserver setup following the tutorial provided here on how to run VM's on KVM and the ISPConfig on a multiserver setup...

    I installed everything and when I go to the Websites module and create a new Webdomain, the entry is sucessfully inserted on the ISPConfig database, however the User directory is not created whatsoever. I looked everywhere and I couldn't find the directories...

    Does anyone have a clue on this issue?

    Thanks guys!
    :)
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Most likely a database permission issue.

    Did you follow the tutorial to the letter? Did you insert all the lines in the hosts file as the tutorial explained and did you use the hostanmes and not IP addresses when you installed ispconfig? It is important that every slave server has a local mysql database and that this local mysql database is used. If you selected a external database when you get prompted for the local one, then the system will not work.
     
  3. bruno_floyd

    bruno_floyd New Member

    Hi again tiil,

    I doubled checked the hostnames and IP adressess according to the tutorial (http://www.howtoforge.com/perfect-server-debian-lenny-ispconfig3-p3)

    I also checked if I installed MySQL on the other slave servers and it's ok... but you said that the database has to be selected otherwise it won't work. How can I check if I'm using the slaves databases on each slave?

    Thanks!
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    You can check the database settings in /usr/local/ispconfig/interface/lib/config.inc.php on each node.
     
  5. bruno_floyd

    bruno_floyd New Member

    I decided to reinstall all over again! hehe

    Reviewing the tutorial I saw this line: "Go back to the shell of server1.example.tld and download the latest ISPConfig 3 stable release" after creating the users on PHPMyadmin of the Webserver...

    On my case I have a Ubuntu host and KVM with 5 VMs (web,mail,db,ns1,ns2) (http://www.howtoforge.com/virtualization-with-kvm-on-ubuntu-9.10)

    Do my Ubuntu host has to be Webserver? Initially I installed the Web on the Web VM... the Mail on Mail VM, and so on.
     
  6. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Do you mean the KVM host? No.
     
  7. bruno_floyd

    bruno_floyd New Member

    Ok!
    I installed on the VMs then...

    When I reinstalled the ispconfig, i got this error on some of the 5 servers.

    Code:
    Configuring DBServer
    Installing Crontab
    sh: crontab: not found
    sh: crontab: not found
    Installation completed.
    
    When I ran update.php I get this error:

    Code:
    Possible problem with dumping the database. We will stop here. Please check the file existing_db.sql
    
    Is this related to my problem initially?
    I still don't get my web directories created. =/
     
    Last edited: Oct 29, 2010
  8. bruno_floyd

    bruno_floyd New Member

    Well... I created a PHP file to make a simple insertion on my mail.example.tld virtual machine MySQL.

    I put the PHP file inside the web.example.tld and tried to execute, but the mail.example.tld didn't allow me to connect:

    Code:
    Warning: mysql_connect() [function.mysql-connect]: Host 'web.example.tld' is not allowed to connect to this MySQL server in /var/www/teste.php on line 6
    Host 'web.example.tld' is not allowed to connect to this MySQL server
    
    If I can't connect, the ISPConfig does not create the dir and other stuff, right? :p
     
  9. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Correct. So you should check now why you can not connect anymore. E.g. you installed a firewall or edited the mysql configuration on that server which now prevents the connections.
     
  10. bruno_floyd

    bruno_floyd New Member

    I didn't installed any other firewall... nor changed the mysql configs on the server I'm trying to conect...

    I did install Phpmyadmin on all my servers to check out the User table on the Mysql, and I realized that the hostname on every server was wrong, it was vm2.server1.com in this case, then I changed... now my User table looks like this on all the servers except from the Webserver that it has more users:

    Code:
    localhost 		root 			*PASSWORD 	
    mail.example.tld 	root 			*PASSWORD 	
    127.0.0.1 		root 			*PASSWORD 	
    localhost 		debian-sys-maint 	*PASSWORD 	
    localhost 		ispconfig 		*PASSWORD 	
    localhost 		phpmyadmin 		*PASSWORD
    
    I inserted the host, user and password from where I'm trying to connect (web.example.tld, root, PASS) in this table user. Now i'm able to connect and make and insertion, but the ISPConfig keeps not creating...
     
    Last edited: Oct 29, 2010
  11. bruno_floyd

    bruno_floyd New Member

    any ideas guys? :p
     
  12. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    1) restart mysql on all systems.
    2) Correct the /etc/hosts files on all systems.
    3) Check the config.inc.php files on all slave systems and ensure that they contain localhost as mysql hostanme for the local db and the correct hostname of the master server for the master server mysql connection.
    4) The record for the IP address(es) seem to be missing. Vor every ispconfig and ispcsrv user there have to be a line for the hostname and one for the IP.
     
  13. bruno_floyd

    bruno_floyd New Member

    1) restart mysql on all systems.

    Restarted!

    2) Correct the /etc/hosts files on all systems.

    On the virtual machines, the hosts files looks like this:
    127.0.0.1 localhost
    127.0.1.1 mail.example.tld
    80.80.80.101 web.example.tld
    80.80.80.102 mail.example.tld
    80.80.80.103 db.example.tld
    80.80.80.104 ns1.example.tld
    80.80.80.105 ns2.example.tld
    I guess they are right, no?

    3) Check the config.inc.php files on all slave systems and ensure that they contain localhost as mysql hostanme for the local db and the correct hostname of the master server for the master server mysql connection.

    Checked if it's localhost on local db, they are all right.
    Now the configs for the master server looks like this (Webserver):

    Code:
    //** Database settings for the master DB. This setting is only used in multiserver setups
    $conf["dbmaster_type"]			= 'mysql';
    $conf["dbmaster_host"]			= '';
    $conf["dbmaster_database"]		= 'dbispconfig';
    $conf["dbmaster_user"]			= '';
    $conf["dbmaster_password"]		= 'PASS';
    
    And on the other servers looks like this (the user changes):
    Code:
    //** Database settings for the master DB. This setting is only used in multiserver setups
    $conf["dbmaster_type"]			= 'mysql';
    $conf["dbmaster_host"]			= 'web.example.tld';
    $conf["dbmaster_database"]		= 'dbispconfig';
    $conf["dbmaster_user"]			= 'ispcsrv2';
    $conf["dbmaster_password"]		= 'PASS';
    
    But when I try to login on Web database, using the user "ispcsrv2" and PASS, I can't access. This happens with all the ispcsrvX users.

    4) The record for the IP address(es) seem to be missing. Vor every ispconfig and ispcsrv user there have to be a line for the hostname and one for the IP.

    For every ispcsrv on Webserver there is one for IP and one for hostname.
    The ispconfig users on all the databases are at localhost only.

    My users list on Webserver looks like this:

    Code:
    debian-sys-maint	localhost  		Yes  	ALL PRIVILEGES   			Yes  	
    root 			localhost 		Yes 	ALL PRIVILEGES 				Yes
    ispconfig 		localhost 		Yes 	USAGE 					No	
    ispcsrv2 		80.80.80.102 		Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No	
    ispcsrv2 		mail.example.tld 	Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No		
    ispcsrv3 		80.80.80.103 		Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No	
    ispcsrv3 		db.example.tld 		Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No	
    ispcsrv4 		80.80.80.104 		Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No	
    ispcsrv4 		ns1.example.tld 	Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No	
    ispcsrv5 		80.80.80.105 		Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No	
    ispcsrv5 		ns2.example.tld 	Yes 	SELECT, INSERT, UPDATE, DELETE, CREATE 	No	
    phpmyadmin 		localhost 		Yes 	USAGE 					No	
    root 			127.0.0.1 		Yes 	ALL PRIVILEGES 				Yes 	
    root 			80.80.80.102 		Yes 	ALL PRIVILEGES 				Yes 	
    root 			80.80.80.103 		Yes 	ALL PRIVILEGES 				Yes 	
    root 			80.80.80.104 		Yes 	ALL PRIVILEGES 				Yes 	
    root 			80.80.80.105 		Yes 	ALL PRIVILEGES 				Yes 	
    root 			db.example.tld 		Yes 	ALL PRIVILEGES 				Yes 		
    root 			mail.example.tld 	Yes 	ALL PRIVILEGES 				Yes 	
    root 			ns1.example.tld 	Yes 	ALL PRIVILEGES 				Yes 	
    root 			ns2.example.tld 	Yes 	ALL PRIVILEGES 				Yes 	
    root 			web.example.tld 	Yes 	ALL PRIVILEGES 				Yes
    
     
    Last edited: Nov 1, 2010
  14. bruno_floyd

    bruno_floyd New Member

    Are my configs right?
     
    Last edited: Nov 5, 2010
  15. bruno_floyd

    bruno_floyd New Member

    Can you guys please compare yours configs with mine?
    :)
     
  16. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Can you log into the database on the shell?
    Code:
    mysql -h web.example.tld -u ispcsrv2 -p
    Is web.example.tld the master server?
     
  17. bruno_floyd

    bruno_floyd New Member

    - Yes, I able to do that... and when I copy the pass from each config.inc.php slave servers, I can login.

    - That's right, it's my master server.

    I can't imagine what i'm missing now. How does the ispconfig internally sends the requisition to the other servers to create de dbs... mails and so on?

    Even on the master server (web.example.tld) I cannot create the directories.

    Thanks falko!
    ;)
     
  18. bruno_floyd

    bruno_floyd New Member

    I realized here that my mail.example.tld node server works. I create an mail account through the Web interface and when I go check on the server and on the mail server database, it's there.

    I don't know why... when I compare the configs among the servers, they don't look diferent.

    What else can I check?

    Thanks fellas!
     
  19. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Is the php-mysql module installed?
     
  20. bruno_floyd

    bruno_floyd New Member

    Do you mean the modules on the linux or the PHP and MySQL modules from the ispconfig?

    They both are installed...
     

Share This Page