I tried to update the master server (got a couple in a multi-server setup) to latest version but getting: PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'ispconfig'@'localhost' (using password: YES) in With the password that is in the file /usr/local/ispconfig/server/lib/config.inc.php I can connect fine: $@controlpanel:~$ mysql -u ispconfig -pmypass -e "SHOW DATABASES LIKE 'dbispconfig';" +------------------------+ | Database (dbispconfig) | +------------------------+ | dbispconfig | +------------------------+ I can also connect fine with the user that I got into the: /usr/local/ispconfig/server/lib/mysql_clientdb.conf what am I missing?
Take the password from the config file and use that to set the password for ISPConfig user on localhost and 127.0.0.1 in MariaDB using phpmyadmin. Nothing has been changed in ISPConfig in this regard in the past few versions, so I'm not sure what might have caused this on your system.
I've already did the above and still gives that error.With same pass I can connect fine from terminal and phpmyadmin. stelios@controlpanel:~$ sudo ispconfig_update.sh -------------------------------------------------------------------------------- _____ ___________ _____ __ _ |_ _/ ___| ___ \ / __ \ / _(_) | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ | | `--. \ __/ | | / _ \| '_ \| _| |/ _` | _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | \___/\____/\_| \____/\___/|_| |_|_| |_|\__, | __/ | |___/ -------------------------------------------------------------------------------- >> Update Please choose the update method. For production systems select 'stable'. WARNING: The update from GIT is only for development systems and may break your current setup. Do not use the GIT version on servers that host any live websites! Note: On Multiserver systems, enable maintenance mode and update your master server first. Then update all slave servers, and disable maintenance mode when all servers are updated. Select update method (stable,nightly,git-develop) [stable]: Downloading ISPConfig update. Unpacking ISPConfig update. -------------------------------------------------------------------------------- _____ ___________ _____ __ _ ____ |_ _/ ___| ___ \ / __ \ / _(_) /__ \ | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ / | | `--. \ __/ | | / _ \| '_ \| _| |/ _` | |_ | _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | ___\ \ \___/\____/\_| \____/\___/|_| |_|_| |_|\__, | \____/ __/ | |___/ -------------------------------------------------------------------------------- >> Update Operating System: Debian 12.0 (Bookworm) or compatible This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: no PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /tmp/user/0/update_runner.sh.X5SLIl9aL7/install/update.php:260 Stack trace: #0 /tmp/user/0/update_runner.sh.X5SLIl9aL7/install/update.php(260): mysqli_connect() #1 {main} thrown in /tmp/user/0/update_runner.sh.X5SLIl9aL7/install/update.php on line 260
Have you tested both, IP 127.0.0.1 and localhost? Code: mysql -u ispconfig -h localhost -p dbispconfig mysql -u ispconfig -h 127.0.0.1 -p dbispconfig
See output below: Code: stelios@controlpanel:~$ mysql -u ispconfig -h localhost -p dbispconfig Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 175165 Server version: 10.11.11-MariaDB-0+deb12u1 Debian 12 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [dbispconfig]> quit Bye stelios@controlpanel:~$ mysql -u ispconfig -h 127.0.0.1 -p dbispconfig Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 175166 Server version: 10.11.11-MariaDB-0+deb12u1 Debian 12 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [dbispconfig]> quit Bye stelios@controlpanel:~$ # then I run the update and: >> Update Operating System: Debian 12.0 (Bookworm) or compatible This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: no PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /tmp/user/0/update_runner.sh.TTun90pWyz/install/update.php:260 Stack trace: #0 /tmp/user/0/update_runner.sh.TTun90pWyz/install/update.php(260): mysqli_connect() #1 {main} thrown in /tmp/user/0/update_runner.sh.TTun90pWyz/install/update.php on line 260
That's strange. The MySQL command is working, but PHP is not able to connect with the same username and password. This update in ISPConfig has not changed this. Has anything changed in your MariaDB or PHP setup since you last updated ISPConfig?
