Could not connect to MySQL server!

[bruma]

Hi!

I've changed mysql server passwd (in shell). Then I change/adopt passwd in /home/admispconfig/ispconfig/lib/config.inc.php. But now when I restart ispconfig, I get error:

root@madcow:/home/admispconfig# /etc/init.d/ispconfig_server restart
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd stopped
ISPConfig system stopped!
Starting ISPConfig system...
/root/ispconfig/httpd/bin/apachectl startssl: httpd started
Could not connect to MySQL server!ISPConfig system is now up and running!

What is wrong? Is there another file that should be updated?
I could normaliy login in mysql ($mysql -u root -p), my mysql passwd cointains just alphanumeric characters.

[sjau]

When you change the mysql password you need to either flush the privileges or restart the mysql server... the same goes if you alter the privileges altogether

[bruma]

Yes, I did flush privileges and also restart mysql server.

I'm using ISPConfig 2.2.6. Will reinstall fix that problem? I don't want to lose current configuration and data.

[falko]

Please check your MySQL password in config.inc.php for typos.
Can you connect on the shell with

mysql -u root -p

using the same password?

[bruma]

Yes, passwd is exactly the same, I also double check for typos in config.inc.php.

[sjau]

can you test this script and tell me the output?

<?

//Global variables:
$username = ""; // Username for database here
$password = ""; // Password for database here
$db_host = "localhost"; // DB Server
$db_name =  ""; //name of your database here

// Connect to DB
mysql_connect("$db_host","$username","$password")
	or die("Unable to connect to SQL server!");
mysql_select_db("$db_name")
	or die("Unable to select database!");

echo "Connection established to $db_name";

?>

[bruma]

Originally Posted by sjau

can you test this script and tell me the output?

<?

//Global variables:
$username = ""; // Username for database here
$password = ""; // Password for database here
$db_host = "localhost"; // DB Server
$db_name =  ""; //name of your database here

// Connect to DB
mysql_connect("$db_host","$username","$password")
	or die("Unable to connect to SQL server!");
mysql_select_db("$db_name")
	or die("Unable to select database!");

echo "Connection established to $db_name";

?>

This is the output:

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/web/mysqldb.php on line 10
Unable to connect to SQL server!

My server is Ubuntu 6.06. Installed mysql packages:
ii mysql-client 5.0.22-0ubuntu6.06 mysql database client (current version)
ii mysql-client-5.0 5.0.22-0ubuntu6.06 mysql database client binaries
ii mysql-common 5.0.22-0ubuntu6.06 mysql database common files (e.g. /etc/mysql
ii mysql-server 5.0.22-0ubuntu6.06 mysql database server (current version)
ii mysql-server-5.0 5.0.22-0ubuntu6.06 mysql database server binaries

[sjau]

Now this is interesting. Is php actually built with mysql?

<? phpinfo(); ?>

You should get something like this:

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.0.24
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient

[bruma]

from <? phpinfo(); ?>:

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.0.24
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

[sjau]

Maybe this helps: http://www.whoopis.com/howtos/mysql-auth-fix.html

Otherwise here's a goole search with results on that issue:

http://www.google.ch/search?q=Client...en-US:official