ISPConfig not creating /www/client...

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!

 

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!

 

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

 

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.

 

Do you mean the KVM host? No.

 

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. =/

 

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?

 

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...

 

any ideas guys?

 

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

 

Are my configs right?

 

Can you guys please compare yours configs with mine?

 

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?

 

- 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!

 

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!

 

Is the php-mysql module installed?

 

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

They both are installed...