PHP Fatal error: Uncaught mysqli_sql_exception: DELETE command denied

Hi All,
Here is my case :
------------------------------- INSTALLATION guide :
https://www.howtoforge.com/ispconfig-autoinstall-debian-ubuntu/
------------------ ISPConfig installation particular command
wget -O - https://get.ispconfig.org | sh -s -- --channel=stable --interactive --debug --roundcube --use-nginx --use-ftp-ports=40110-40210 --use-php=5.6,7.0,7.1,7.2,7.3,7.4,8.0,8.1,8.2,8.3 --monit --monit-alert-email --unattended-upgrades

------------------During the installation : messages :
WARM : Unexpected resolver response: Server: ONE OF MY IP DNS SERVER ( /lib/....../class.ISPConfigDebianOS.inc.php:1708 )

----------------
COMMAND : php -v
PHP 8.2.17 (cli) (built: Mar 22 2024 11:33:40) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.2.17, Copyright (c) Zend Technologies
with Zend OPcache v8.2.17, Copyright (c), by Zend Technologies
----------------
----------------
COMMAND : lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 12 (bookworm)
Release: 12
Codename: bookworm
----------------
COMMAND : wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

##### SERVER #####
IP-address (as per hostname): ***.***.***.***
[WARN] could not determine server's ip address by ifconfig
[INFO] OS version is Debian GNU/Linux 12 (bookworm)

[INFO] uptime: 21:10:51 up 1:23, 1 user, load average: 0.11, 0.13, 0.09

[INFO] memory:
total utilisé libre partagé tamp/cache disponible
Mem: 5.8Gi 2.3Gi 2.9Gi 60Mi 977Mi 3.5Gi
Échange: 974Mi 0B 974Mi

[INFO] systemd failed services status:
UNIT LOAD ACTIVE SUB DESCRIPTION
● networking.service loaded failed failed Raise network interfaces

LOAD = Reflects whether the unit definition was properly loaded.
ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
SUB = The low-level unit activation state, values depend on unit type.
1 loaded units listed.

[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.2.11p2


##### VERSION CHECK #####

[INFO] php (cli) version is 8.2.17
[INFO] php-cgi (used for cgi php in default vhost!) is version 8.2.17

##### PORT CHECK #####

[WARN] Port 443 (Webserver SSL) seems NOT to be listening
[WARN] Port 22 (SSH server) seems NOT to be listening

##### MAIL SERVER CHECK #####

[WARN] I found no "smtps" entry in your postfix master.cf
[INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connections you have to enable this.

##### RUNNING SERVER PROCESSES #####

[INFO] I found the following web server(s):
Unknown process (nginx (PID 1744)
[INFO] I found the following mail server(s):
Postfix (PID 1396)
[INFO] I found the following pop3 server(s):
Dovecot (PID 830)
[INFO] I found the following imap server(s):
Dovecot (PID 830)
[INFO] I found the following ftp server(s):
PureFTP (PID 1157)

##### LISTENING PORTS #####
(seulement ()
Adresse (distante)
***.***.***.***:53 (835/named)
[anywhere]:2812 (972/monit)
***.***.***.***:53 (835/named)
[localhost]:11334 (887/rspamd
[localhost]:11332 (887/rspamd
[localhost]:11333 (887/rspamd
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
[anywhere]:8080 (1744/nginx
[anywhere]:8081 (1744/nginx
[localhost]:6379 (846/redis-server)
***.***.***.***:53 (835/named)
[localhost]:11211 (834/memcached)
***.***.***.***:53 (835/named)
[anywhere]:3306 (935/mariadbd)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
[anywhere]:995 (830/dovecot)
[anywhere]:993 (830/dovecot)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
[anywhere]:587 (1396/master)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
[anywhere]:465 (1396/master)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
[localhost]:10023 (451/postgrey)
***.***.***.***:53 (835/named)
[anywhere]:143 (830/dovecot)
[anywhere]:110 (830/dovecot)
[anywhere]:80 (1744/nginx
***.***.***.***:53 (835/named)
[anywhere]:4190 (830/dovecot)
[anywhere]:21 (1157/pure-ftpd)
[anywhere]:25 (1396/master)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
[localhost]:53 (835/named)
[localhost]:953 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:18 (1737/sshd
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
***.***.***.***:53 (835/named)
*:*:*:*::*:2812 (972/monit)
*:*:*:*::*:10023 (451/postgrey)
*:*:*:*::*:8080 (1744/nginx
*:*:*:*::*:8081 (1744/nginx
*:*:*:*::*:53 (835/named)
*:*:*:*::*:953 (835/named)
*:*:*:*::*:3306 (935/mariadbd)
*:*:*:*::*:995 (830/dovecot)
*:*:*:*::*:993 (830/dovecot)
*:*:*:*::*:11333 (887/rspamd
*:*:*:*::*:11332 (887/rspamd
*:*:*:*::*:11334 (887/rspamd
*:*:*:*::*:587 (1396/master)
*:*:*:*::*:465 (1396/master)
[localhost]43 (830/dovecot)
[localhost]10 (830/dovecot)
*:*:*:*::*:80 (1744/nginx
*:*:*:*::*:4190 (830/dovecot)
*:*:*:*::*:21 (1157/pure-ftpd)
*:*:*:*::*:25 (1396/master)
*:*:*:*::*:6379 (846/redis-server)
*:*:*:*::**:*:*:*::*53 (835/named)


I have skipped firewall output.


##### LET'S ENCRYPT #####
acme.sh is installed in /root/.acme.sh/acme.sh

-------------------------- Observations : job queue blocked

--------------------------- what i have done :
-1- force ISPconfig reinstallation
-2- reboot server
-3- follow this: https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
-4- i have launch manually the script : /usr/local/ispconfig/server/server.sh
---------------------------- The error message :
31.03.2024-19:35 - WARNING - There is already a lockfile set, but no process running with this pid (3745). Continuing.
PHP Warning: Undefined array key "origin" in /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php on line 348
PHP Deprecated: substr(): Passing null to parameter #1 ($string) of type string is deprecated in /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php on line 348
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


--------------------------------- delete the lock file
-5- i have delete de lockfile doing this :
rm /usr/local/ispconfig/server/temp/.ispconfig_lock
---------------------------------- manual run again
-6- i run again manually the script
/usr/local/ispconfig/server/server.sh

------------------------------------- i get the following result and still job queue blocked :
PHP Warning: Undefined array key "origin" in /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php on line 348
PHP Deprecated: substr(): Passing null to parameter #1 ($string) of type string is deprecated in /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php on line 348
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


---------------------------------- CONCLUSION : I have probably done something wrong like update the PHP. But idea how to solve this ?
By the way :
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12

If one of you gat an idea i will appreciate.
Regards
Elvé.

 

Hi Till,
You are a King !
Thank you very much. You are 100% right. The command you indicate solved the evoqued problem. Sorry for my mistake not to find it alone. One agai thank you.
Elvé