Trying to setup new client on my ISPConfig Server

Hello good day, please recently i am having some issue with the ISPConfig server, it has been working very fine for over 6 months already, but after the last upgrade version to version 3.2.9p1 i noticed my changes are no longer being processed in the server, at first the ispconfig log say access denied to update a table in the ispconfig database, then i give the ispconfig dabase user full privilege then i get the following error and yet the queue has refused to be processed below are the errors

Code:

Mon Mar 13 04:30:04 UTC 2023 13.03.2023-05:30 - WARNING - There is already a lockfile set, but no process running with this pid (2082). Continuing.
Mon Mar 13 04:30:04 UTC 2023 which: no incrond in (/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin)
Mon Mar 13 04:30:04 UTC 2023 PHP Fatal error:  Uncaught mysqli_sql_exception: Table 'named.records' doesn't exist in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:302
Mon Mar 13 04:30:04 UTC 2023 Stack trace:
Mon Mar 13 04:30:04 UTC 2023 #0 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(302): mysqli_query()
Mon Mar 13 04:30:04 UTC 2023 #1 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(339): db->_query()
Mon Mar 13 04:30:04 UTC 2023 #2 /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php(158): db->query()
Mon Mar 13 04:30:04 UTC 2023 #3 /usr/local/ispconfig/server/lib/classes/plugins.inc.php(120): bind_dlz_plugin->soa_update()
Mon Mar 13 04:30:04 UTC 2023 #4 /usr/local/ispconfig/server/mods-available/dns_module.inc.php(104): plugins->raiseEvent()
Mon Mar 13 04:30:04 UTC 2023 #5 /usr/local/ispconfig/server/lib/classes/modules.inc.php(302): dns_module->process()
Mon Mar 13 04:30:04 UTC 2023 #6 /usr/local/ispconfig/server/lib/classes/modules.inc.php(235): modules->raiseTableHook()
Mon Mar 13 04:30:04 UTC 2023 #7 /usr/local/ispconfig/server/server.php(180): modules->processDatalog()
Mon Mar 13 04:30:04 UTC 2023 #8 {main}
Mon Mar 13 04:30:04 UTC 2023 thrown in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 302

 

Start with this: https://forum.howtoforge.com/threads/please-read-before-posting.58408/
Did the upgrade version 3.2.9p1 show any errors? It is strange database is missing a table.
Changing rights of database user is most likely wrong way to solve and may make situation worse. If system worked 6 months with the set of permission the were most likely correct.

 

There was no error during the upgrade process, I don't know how to recreate the missing tables

 

Below is the output of the above command

Code:

total 116
drwxr-x---  2 root root 4096 Jul 24  2022 .
drwxr-x--- 13 root root 4096 Mar 13 03:07 ..
lrwxrwxrwx  1 root root   68 Jul 24  2022 apache2_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php
lrwxrwxrwx  1 root root   71 Jul 24  2022 apps_vhost_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/apps_vhost_plugin.inc.php
lrwxrwxrwx  1 root root   64 Jul 24  2022 aps_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/aps_plugin.inc.php
lrwxrwxrwx  1 root root   67 Jul 24  2022 backup_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/backup_plugin.inc.php
lrwxrwxrwx  1 root root   69 Jul 24  2022 bind_dlz_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php
lrwxrwxrwx  1 root root   65 Jul 24  2022 bind_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/bind_plugin.inc.php
lrwxrwxrwx  1 root root   73 Jul 24  2022 cron_jailkit_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/cron_jailkit_plugin.inc.php
lrwxrwxrwx  1 root root   65 Jul 24  2022 cron_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/cron_plugin.inc.php
-rwxr-x---  1 root root   45 Mar  8 02:41 empty.dir
lrwxrwxrwx  1 root root   69 Jul 24  2022 firewall_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/firewall_plugin.inc.php
lrwxrwxrwx  1 root root   73 Jul 24  2022 ftpuser_base_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/ftpuser_base_plugin.inc.php
lrwxrwxrwx  1 root root   68 Jul 24  2022 getmail_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/getmail_plugin.inc.php
lrwxrwxrwx  1 root root   72 Jul 24  2022 maildeliver_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/maildeliver_plugin.inc.php
lrwxrwxrwx  1 root root   68 Jul 24  2022 mailman_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/mailman_plugin.inc.php
lrwxrwxrwx  1 root root   70 Jul 24  2022 mail_plugin_dkim.inc.php -> /usr/local/ispconfig/server/plugins-available/mail_plugin_dkim.inc.php
lrwxrwxrwx  1 root root   65 Jul 24  2022 mail_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/mail_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 mysql_clientdb_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php
lrwxrwxrwx  1 root root   77 Jul 24  2022 network_settings_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/network_settings_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 postfix_filter_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/postfix_filter_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 postfix_server_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/postfix_server_plugin.inc.php
lrwxrwxrwx  1 root root   67 Jul 24  2022 rspamd_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/rspamd_plugin.inc.php
lrwxrwxrwx  1 root root   76 Jul 24  2022 server_services_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/server_services_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 shelluser_base_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/shelluser_base_plugin.inc.php
lrwxrwxrwx  1 root root   78 Jul 24  2022 shelluser_jailkit_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/shelluser_jailkit_plugin.inc.php
lrwxrwxrwx  1 root root   76 Jul 24  2022 software_update_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/software_update_plugin.inc.php
lrwxrwxrwx  1 root root   70 Jul 24  2022 webserver_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/webserver_plugin.inc.php
lrwxrwxrwx  1 root root   84 Jul 24  2022 z_php_fpm_incron_reload_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/z_php_fpm_incron_reload_plugin.inc.php

 

Thanks that really solve my problem.

 

Hi,
I get a similar error abd would appriate any help.
---------------
MY DETAILS :
---------------
ISPconfig version : 3.2.11 ( a master and a slave only for DNS services )
OS : DEBIAN 11 on both master and slave
PHP version 7.4.33
mysql : Version du serveur : 10.5.19-MariaDB-0+deb11u2 - Debian 11
the DNS service should be served by BIND.
On the master the ISPConfig panel is running.
---------------
The error log via COMMAND : /usr/local/ispconfig/server/server.sh
---------------
15.09.2023-18:02 - WARNING - There is already a lockfile set, but no process running with this pid (3112963). Continuing.
15.09.2023-18:02 - DEBUG [plugins.inc:155] - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
15.09.2023-18:02 - DEBUG [server:177] - Found 49 changes, starting update process.
15.09.2023-18:02 - DEBUG [plugins.inc:118] - Calling function 'rr_delete' from plugin 'bind_dlz_plugin' raised by event 'dns_rr_delete'.
15.09.2023-18:02 - DEBUG [db mysql.inc:523] - NON-String given in escape function! (boolean)
PHP Fatal error: Uncaught mysqli_sql_exception: DELETE command denied to user 'ispconfig'@'localhost' for table `named`.`dns_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()
#1 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(339): db->_query()
#2 /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php(348): db->query()
#3 /usr/local/ispconfig/server/lib/classes/plugins.inc.php(120): bind_dlz_plugin->rr_delete()
#4 /usr/local/ispconfig/server/mods-available/dns_module.inc.php(115): plugins->raiseEvent()
#5 /usr/local/ispconfig/server/lib/classes/modules.inc.php(302): dns_module->process()
#6 /usr/local/ispconfig/server/lib/classes/modules.inc.php(235): modules->raiseTableHook()
#7 /usr/local/ispconfig/server/server.php(180): modules->processDatalog()
#8 {main}
thrown in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 302

---------------
The result of the ls -la /usr/local/ispconfig/server/plugins-enabled/ COMMAND :
---------------
lrwxrwxrwx 1 root root 68 6 oct 2017 apache2_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php
lrwxrwxrwx 1 root root 71 6 oct 2017 apps_vhost_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/apps_vhost_plugin.inc.php
lrwxrwxrwx 1 root root 64 6 oct 2017 aps_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/aps_plugin.inc.php
lrwxrwxrwx 1 root root 67 6 oct 2017 backup_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/backup_plugin.inc.php
lrwxrwxrwx 1 root root 69 29 mar 13:20 bind_dlz_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php
lrwxrwxrwx 1 root root 65 6 oct 2017 bind_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/bind_plugin.inc.php
lrwxrwxrwx 1 root root 73 6 oct 2017 cron_jailkit_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/cron_jailkit_plugin.inc.php
lrwxrwxrwx 1 root root 65 6 oct 2017 cron_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/cron_plugin.inc.php
-rwxr-x--- 1 root root 45 12 aoû 14:10 empty.dir
lrwxrwxrwx 1 root root 69 6 oct 2017 firewall_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/firewall_plugin.inc.php
lrwxrwxrwx 1 root root 73 6 oct 2017 ftpuser_base_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/ftpuser_base_plugin.inc.php
lrwxrwxrwx 1 root root 75 6 oct 2017 mysql_clientdb_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php
lrwxrwxrwx 1 root root 77 6 oct 2017 network_settings_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/network_settings_plugin.inc.php
lrwxrwxrwx 1 root root 76 1 fév 2021 server_services_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/server_services_plugin.inc.php
lrwxrwxrwx 1 root root 75 6 oct 2017 shelluser_base_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/shelluser_base_plugin.inc.php
lrwxrwxrwx 1 root root 78 6 oct 2017 shelluser_jailkit_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/shelluser_jailkit_plugin.inc.php
lrwxrwxrwx 1 root root 76 6 oct 2017 software_update_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/software_update_plugin.inc.php
lrwxrwxrwx 1 root root 70 6 oct 2017 webserver_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/webserver_plugin.inc.php
lrwxrwxrwx 1 root root 84 27 jui 2019 z_php_fpm_incron_reload_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/z_php_fpm_incron_reload_plugin.inc.php

---------------
Some mores details
---------------
The problems appear during previous ISPConfig updates since august.
I think a misconfiguration choose during the update process has be done ( somethink like the service MyDNS is not activated do you want to activate it. )

Unfortunately i do not see more info but can reply to any. Thank you in advance for your lights .
Regards
Elvé

 

I believe the problem you describe is not related to this old thread, so you should have created a new thread.
Anyway, start with this: https://forum.howtoforge.com/threads/please-read-before-posting.58408/
Then remember to post listings and code in CODE tags.
Did you run the server.sh on the master or the slave?
Have you checked the passwords for DB users are correct in the slave and master for all users ispconfig needs?

 

Hi Mister Taleman, Hi Till,

First, ( For Mister Taleman ) i am sorry if "my problem" is different from the one evocated by a user called " Chukwu-Nonso ". You are 100% right cause the databased he mentionned was "Table 'named.records'" while the ones into my error logs was " table `named`.`dns_records`". Let says that after having look for hours , hours , hours and hours this thread was the one in my opinion the nearst the evocated problem. In one word ALL WAS THE SAME as symptoma except the name of the table. I also add the fact that for Chukwu_Nonso AND me those table were NON existant into the ispconfig database. ( This info could help others reader in similar cases )

I confirm i wrote not ONE time for FOUR times the ( https://forum.howtoforge.com/threads/please-read-before-posting.58408/ ) BEFORE posting with the eyes of a newbee who has probably forgot some details. But the fact that my OS, my ISPCONFIG version, my PHP version, even the database base version are indicated is maybe the consequence of those reading.

Concerning the questions :
Did you run the server.sh on the master or the slave? RESPONSE : I run it on the MASTER to get the log i sent into post number 8. But during my research before posting and ask for help i have also run it on the slave. i do not remember the result but as i remember the error here was only linked with lock file. ( i am not sure )

Have you checked the passwords for DB users are correct in the slave and master for all users ispconfig needs? RESPONSE : YES no changes were done and the access from the slave to the master and from the master to itself database was ok. But there is a but ( i have used the crontab -e command to disable during a long period ( this night ) the command started by " * * * * * /usr/local/ispconfig/server/server.sh 2>&1 ........ " i suppose that when the mysql received "too much" request that can not work the system refused connexion EVEN if the couple [ user ; pwd ] is ok. This a supposition i am not sure of that.

Now i reply to Till question :
Did you do what I described in #7, and did this solve your problem? RESPONSE : NO i had NOT cause even if my resquest was according to me VERY VERY VERY similar to the post of the user Chuwu_Nonso i had a doubt ( apparently like Mister Taleman who indicates i quote : "I believe the problem you describe is not related to this old thread, so you should have created a new thread.")

Netheless after having read Till instructions into post number 10 i have run on the master ( where the panel is installed ) the command "rm -f /usr/local/ispconfig/server/plugins-enabled/bind_dlz_plugin.inc.php " ( the one you mention into your post number 7 )
The master was still with the first lie of the crontab DISABLED,
i run on the master the COMMAND : /usr/local/ispconfig/server/server.sh
At this step many operations which look GOOD appear on the screen. In one word the queued command were executed.
I have enabled the crontab correctly like into production mode.

After some few tests i can conclude that according to my own experience : FOR both problems illustrated by the user Chukwu_Nonso AND the problem illustrated by me, the solution provided by Till IS THE CORRECT ONE.
I have NO idea if i should open a new Thread but in case you need my contribution to do it just tell me and i will do it to eventutaly add informations to help others users.

Last but not least, Till when you write "The bind_dlz_plugin.inc.php should not be enabled" it makes ALL the difference between instruction into post number 7 and instructions into post 10 for "beginnner". I know it very complexe and probably the more complexe thing to try to think like others who are NOT at your level. But i am sure according to your high level that you will appreaciate this CONSTRUCTIVE remarks. Thank you Thank you AND Thank you.

Thank you very much to both of you for your help and for having create this application.
Best Regards,
Elvé