Updating with ispconfig_update.sh gives this output. There seems to be something with the mysql-backup. How to make this work? Code: >> Update Operating System: Debian 10.0 (Buster) 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... Unable to connect to mysql server Access denied for user 'root'@'localhost' (using password: NO) MySQL root password []: xxxxxxxxxxx mysqldump: unknown variable 'sql_mode=' PHP Warning: chmod(): No such file or directory in /tmp/update_runner.sh.88I526fH00/install/lib/update.lib.php on line 62 PHP Warning: chown(): No such file or directory in /tmp/update_runner.sh.88I526fH00/install/lib/update.lib.php on line 63 PHP Warning: copy(existing_db.sql): failed to open stream: No such file or directory in /tmp/update_runner.sh.88I526fH00/install/lib/update.lib.php on line 77 PHP Warning: chmod(): No such file or directory in /tmp/update_runner.sh.88I526fH00/install/lib/update.lib.php on line 78 PHP Warning: chown(): No such file or directory in /tmp/update_runner.sh.88I526fH00/install/lib/update.lib.php on line 79 PHP Warning: chgrp(): No such file or directory in /tmp/update_runner.sh.88I526fH00/install/lib/update.lib.php on line 80 Checking ISPConfig database .. mysqlcheck: unknown variable 'sql_mode=' OK mysql: unknown variable 'sql_mode=' Unable to call mysql command line with credentials from mysql_clientdb.conf
Is this server installed according to the perfect server guide? Have you made any changes? Is the correct MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf?
Yes, I did the installation according to the perfect server guide and no, I did not do any changes. The password is correct.
Which mysql or mariadb version do you use? Does the mysql root password in that file contain special chars that might cause issues in shell scripts?
Ok, so I did a mysql -V to see the version and I got the same error: mysql: unknown variable 'sql_mode=' In /etc/mysql/my.cnf I found this Code: # Import all .cnf files from configuration directory !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mariadb.conf.d/ sql_mode = "" After commenting out the sql_mode, the update ran smooth. Thanks for the help!
