Some how we lost the privileges in mysql database, when we restored the grants of the sites they worked all right, but not the ispconfig we can not login as admin, it would reject the password. we get "Username or Password empty". We can login to phpmyadmin and see al databases. the system is debian 6
Check that you can login to mysql with the username ispconfig and the password from the file /usr/local/ispconfig/interface/lib/config.inc.php
Default Can´t login as admin in Ispconfig 3.0.5.4p3 We can login to to mysql with the user ispconfig like this: mysql -uispconfig -p We are getting in the cron.log these: vie oct 31 07:15:16 CST 2014 PHP Warning: mysqli::escape_string(): Couldn't fetch db in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 215vie oct 31 07:16:27 CST 2014 DB::__construct Access denied for user 'ispconfig'@'localhost' (using password: YES) vie oct 31 07:16:27 CST 2014 PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 72 vie oct 31 07:16:27 CST 2014 PHP Warning: mysqli::close(): Couldn't fetch db in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 82 Thnak´s
Default Default Can´t login as admin in Ispconfig 3.0.5.4p3 Im´sorry NO, we can´t login with both of these $conf['db_password'] = 'aaaaaa...aaaaaaa'; $conf['dbmaster_password'] = 'Xxxxxx...xxxxx'; we can login with the the one in mysql_clientdb.conf Thank´s
Ok, so you know the probelm. when the mysql passwod of ispconfig is wrong, then ispconfig cant use its database. The password is the one in the line "$conf['db_password']". take that password and set it in mysql for the ispconfig user.
