Hi team I am running the update and get this error msg Code: >> 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]: Creating backup of "/usr/local/ispconfig" directory... Creating backup of "/etc" directory... Creating backup of "/root/.acme.sh" directory... Creating backup of "/etc/letsencrypt" directory... Checking MariaDB version 10.11.11 .. OK Checking ISPConfig database .. mysqlcheck: Got error: 1698: Access denied for us er 'root'@'localhost' when trying to connect OK ERROR 1698 (28000): Access denied for user 'root'@'localhost' Unable to call mysql command line with credentials from mysql_clientdb.conf root@server1:~# Think something is wrong with the update or??
You probably changed MariaDB settings after installing ISPConfig, or you changed the MariaDB root password without updating it in ISPConfig. Ensure that the correct MariaDB root password is set in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf and then run the update again. Also ensure that you did not disable networking in MariaDB.
Yep that was it Till thanks.. Just for my understanding to get it.. I did a fresh install yesterday with the automated install option for the first time.. normally I did this through the perfect setup guides, and than you fill in the password yourself, so yes I chanced the msql password to the one I was using, but did not change it in that file. So when I am using the automated install I need to reconfigure that file with my own password, or leave it as it is with the generated one you get after the install complets..yes? Again thanks have a nice sunny Sunday Appie
If you change the mysql root password, you must change it in that file. Similar to the manual installation, if you change the password after the manual installation, you will also need to update it in the file.
