Updating issue 3.2.4 > 3.2.7

Discussion in 'Installation/Configuration' started by Joost De Bock, Nov 21, 2021.

Tags:
  1. Joost De Bock

    Joost De Bock New Member

    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
     
    Joost De Bock, Nov 21, 2021
    #1
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    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?
     
    Th0m, Nov 21, 2021
    #2
  3. Joost De Bock

    Joost De Bock New Member

    Yes, I did the installation according to the perfect server guide and no, I did not do any changes.
    The password is correct.
     
    Joost De Bock, Nov 22, 2021
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
    till, Nov 22, 2021
    #4
  5. Joost De Bock

    Joost De Bock New Member

    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!
     
    Joost De Bock, Nov 22, 2021
    #5

Share This Page