The installation guide was followed to the "T" - all servers are Debian Lenny 5.07 VMs.

There are no issue in creating sites, FTP users, adding/removing/editing DNS records, propagation of these between ns1 and ns2 servers, or problems with mail accounts/databases on mail1.

However, whenever we create a database & user, it is NOT being created at db1. Ironically, the first website and db we setup did work, but something since has broken and we can't seem to figure it out.

/etc/mysql/my.cnf has been checked and confirmed to be listening on all interfaces (both web1 and db1).

Does anyone have any suggestions/advice on what we can check to try and correct?

Have you changed the password of the mysql root user on the db server? If yous, please change it in /usr/local/ispconfig/server/lib/mysql_clientdb.conf file too or ispconfig is not able to create databases anymore.

Have you changed the password of the mysql root user on the db server? If yous, please change it in /usr/local/ispconfig/server/lib/mysql_clientdb.conf file too or ispconfig is not able to create databases anymore.

Click to expand...

Hi Till,

Thanks for the quick reply! There haven't been any password changes to the MySQL root user (at least, best I know), but I'll check the file suggested and advise.

Question - does it matter if the root account on all servers use the same password?

*Edit - Confirmed - there have been no password changes after checking the file.

1) You are sure that you selected this db server as target for the new database and not one of the other nodes?
2) Have you deleted any records in the ispconfig database manually or did you try to reset ispconfig somehow after your first working tests?

1) You are sure that you selected this db server as target for the new database and not one of the other nodes?
2) Have you deleted any records in the ispconfig database manually or did you try to reset ispconfig somehow after your first working tests?

Click to expand...

Yes, in fact there is no option to select any other servers.

No - ISPCONFIG db (dbispconfig) has not been touched at all.

We are getting by through manually creating the dbs on db1 at the shell level which is fine for clients/situations that we manage directly. But until this is sorted out, any designs we had of allowing resellers to create their own webs/dbs through the console is not going to be possible.

Ok. So the problem is what I suggested in post #2 of this thread. It is not possible to login to the mysql database with the mysql login details that are in the mysql_clientdb.conf file.

Please ensure that a login with the details in that file as root user to localhost is possible. You can test that with the command:

mysql -h localhost -u root -p

and then enter the password that you find in the mysql_clientdb.conf file on the db server.

Strange - running the same command again I get:

Click to expand...

Thats not strange, as the transacrtion has been closed and no other transactions are waiting. Also the jobs that are processed at a given time vary as not every monitoriyng process gets called every time you execute the script to ensure that the system does not get overloaded.

Ok. So the problem is what I suggested in post #2 of this thread. It is not possible to login to the mysql database with the mysql login details that are in the mysql_clientdb.conf file.

Please ensure that a login with the details in that file as root user to localhost is possible. You can test that with the command:

mysql -h localhost -u root -p

and then enter the password that you find in the mysql_clientdb.conf file on the db server.

Thats not strange, as the transacrtion has been closed and no other transactions are waiting. Also the jobs that are processed at a given time vary as not every monitoriyng process gets called every time you execute the script to ensure that the system does not get overloaded.

Click to expand...

I can't login as localhost but I can login with the FQDN of the server... But I'm using the same password as in the conf file. Why would that be?

*Edit AGAIN - it's working now!

I could login to mysql using the FQDN of the server, but not localhost. So I logged in with:

Code:

mysql -h {fqdn} -u root -p

Then ran:

Code:

mysql > GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY {rootpwd};
quit

Mysql has a authentication record for different hostnames and IP addresses, so root@fqdn can have a different password then root@localhost. Seems as if seomone changed the record for the fqdn and not for localhost. Or someone changed the /etc/hosts file so that there is no valid localhost entry in there anymore.

Check the /etc/hosts file and make sure that localhost is mapped to IP 127.0.0.1. If thats ok, login to your mysql db with phpmyadmin or on the shell and set the correct root password for localhost.

Mysql has a authentication record for different hostnames and IP addresses, so root@fqdn can have a different password then root@localhost. Seems as if seomone changed the record for the fqdn and not for localhost. Or someone changed the /etc/hosts file so that there is no valid localhost entry in there anymore.

Check the /etc/hosts file and make sure that localhost is mapped to IP 127.0.0.1. If thats ok, login to your mysql db with phpmyadmin or on the shell and set the correct root password for localhost.

Hi Till, popping in to evesdrop this conversation... my problem is that I cannot login to phpmyadmin with a client's credentials. I have followed the steps that you posted to get debug info, and here is my ouput:

So in my case it seems to have created the user and database, but I can't access it.

The steps I took were:
1. I went into ISPConfig 3.0.4.5 and created a client
2. Logged in to ISPC as that client
3. Created new databse and user
4. Clicked the manage icon which opened up 31.222.179.30:8080/phpmyadmin/
5. Tried to login with the client db credentials, and get "#1045 Cannot log in to the MySQL server"

Any help would be very appreciated. Thanks in advance

---------------------------

So turns out after hours of fiddling that the problem was me being a moron....

in my.cnf I had commented out bind-address like so "#bind" instead of "# bind".... For you newbies, notice the space?