Update 3.1.15 unknown variable

Discussion in 'Installation/Configuration' started by Racing-Ralph, Sep 8, 2019.

Tags:
  1. Racing-Ralph

    Racing-Ralph Member

    Hello,

    ich just tried to update from 3.1.14p2 to 3.1.15.

    I get an error while creating the backup :

    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...
    Checking ISPConfig database .. OK
    mysql: unknown variable 'general_log_file=/var/log/mysql/mysql.log'
    Unable to call mysql command line with credentials from mysql_clientdb.conf

    Any idea what this can be ?

    regards, Ralph
     
  2. ahrasis

    ahrasis Well-Known Member HowtoForge Supporter

    Is your database software the one that is shipped with your OS or is it taken from other third party repository?
     
  3. Racing-Ralph

    Racing-Ralph Member

    I`m not shure, but i think so
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if you changed something in mysql/mariadb config files which broke the database system. Search for the mentioned line "general_log_file=/var/log/mysql/mysql.log" in the mysql or mariadb config files and comment it out.
     
  5. Racing-Ralph

    Racing-Ralph Member

    Its already commented out
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Then search further for duplicates of this line. Mysql would not complain about it if it is commented out.
     
    ahrasis and Racing-Ralph like this.
  7. Racing-Ralph

    Racing-Ralph Member

    I found an other file and commented ist out, now it works.
    THANKS !!!

    Should I leave it now commented out ?
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes. The error that you got is directly from mysql, its not an ispconfig error. It means that this config option may not be added where you found it now.
     
    Racing-Ralph likes this.
  9. Racing-Ralph

    Racing-Ralph Member

    Thanks once more !
     

Share This Page