ISPConfig 3.2.9p1 pending updates stuck

Discussion in 'General' started by gkovacs, Apr 14, 2023.

  1. gkovacs

    gkovacs Member

    I'm running ISPConfig 3.2.9p1 on Debian 10 and PHP7.2, but recently it stopped updating, and is currently stuck with 16 changes pending (first in line are BIND zone changes). Running the server script produces the following output:
    Code:
    # /usr/local/ispconfig/server/server.sh
    14.04.2023-17:50 - WARNING - There is already a lockfile set, but no process running with this pid (30334). Continuing.
    14.04.2023-17:50 - DEBUG [plugins.inc:155] - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    14.04.2023-17:50 - DEBUG [server:177] - Found 16 changes, starting update process.
    14.04.2023-17:50 - DEBUG [plugins.inc:118] - Calling function 'rr_update' from plugin 'bind_dlz_plugin' raised by event 'dns_rr_update'.
    PHP Fatal error:  Uncaught mysqli_sql_exception: UPDATE command denied to user 'ispconfig'@'10.100.100.100' for table 'records' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:302
    Stack trace:
    #0 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(302): mysqli_query(Object(mysqli), 'UPDATE named.re...')
    #1 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(339): db->_query('UPDATE named.re...', 'zzzzzzz.h...', '86400', 'CAA', '@', '0 issue "letsen...', '20')
    #2 /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php(332): db->query('UPDATE named.re...', 'zzzzzzzs.h...', '86400', 'CAA', '@', '0 issue "letsen...', '20')
    #3 /usr/local/ispconfig/server/lib/classes/plugins.inc.php(120): bind_dlz_plugin->rr_update('dns_rr_update', Array)
    #4 /usr/local/ispconfig/server/mods-available/dns_module.inc.php(114): plugins->raiseEvent('dns_rr_update', Array)
    #5 /usr/local/ispconfig/server/lib/classes/modules.inc.php(302): dns_module->process('dns_rr', 'u', Array)
    #6 /usr/local/ispconfig/serve in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 302
    
    Especially this line is interesting, as there is no table called "records" in the dbispconfig database!
    PHP Fatal error: Uncaught mysqli_sql_exception: UPDATE command denied to user 'ispconfig'@'10.100.100.100' for table 'records' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:302

    Any idea what to do next?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Run:

    rm -f /usr/local/ispconfig/server/plugins-enabled/bind_dlz_plugin.inc.php

    to disable the bind_dlz plugin again. It is quite unlikely that you want to use that as its not the regular BIND plugin used by ISPConfig to configure DNS zones.
     
    gkovacs likes this.
  3. gkovacs

    gkovacs Member

    Wow thanks @till , it solved the problem instantly.
    Not sure who or what enabled that plugin, I do not recall doing anything like that.
     
    ahrasis likes this.

Share This Page