dns update failing with error emial

Hey all.
multi server setup - ispconfig 3.2.11p2 - debian 12
I am getting dns errors on changes im submitting

Code:

ns1.tlwebservices.co.uk - 17.04.2024-10:17 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = UPDATE `dns_soa` SET `rendered_zone`='$TTL        3600\n@       IN      SOA     ns1.tlwebservices.co.uk. dave.tlsystems.co.uk. (\n                        2024041702       ; serial, todays date + todays serial #\n                        3600              ; refresh, seconds\n                        600              ; retry, seconds\n                        1209600              ; expire, seconds\n                        3600 )            ; minimum, seconds\n;\n\nmail 3600      A          88.97.88.83\nthe-lair.co.uk. 3600      A          88.97.88.82\nwww 3600      A          88.97.88.82\nthe-lair.co.uk. 3600      CAA        0 issue \"letsencrypt.org\"\nthe-lair.co.uk. 3600      MX     10  mail.the-lair.co.uk.\nthe-lair.co.uk. 3600      NS         ns1.tlwebservices.co.uk.\nthe-lair.co.uk. 3600      NS         ns2.tlwebservices.co.uk.\nthe-lair.co.uk. 3600      NS         ns3.tlwebservices.co.uk
 .\nthe-lair.co.uk. 3600      TXT        \"v=spf1 mx a ip4:88.97.88.93 ip4:88.97.88.82 a:web01.tlwebservices.co.uk a:web06.tlwebservices.co.uk -all\"\nthe-lair.co.uk. 3600      TXT        \"google-site-verification=L82d23cyxwz5zDvD1BFDcEL4hfdHu3jVwCsG6KPY5ww\"\n' WHERE id='15' -> 1143 (UPDATE command denied to user 'ispcsrv5'@'ns1.tlwebservices.co.uk' for column 'rendered_zone' in table 'dns_soa')

 

Hi,
this can have different causes. Do you use any DNS plugin? The active plugins are listed in /usr/local/ispconfig/server/plugins-enabled/
Did you update ISPConfig or changed any DB User settings/priviledges recently? Is there enough disk space on all servers available?

 

hey, thanks @pyte for reply
i have not got any plugins added after setting everything up.
I have recently updated from 3.2.11p1 to 3.2.11p2 a few weeks ago though.
My 3 dns servers are at 45% storage.
Not changed any settings.

This last bit, is this the user with the issue ?

Code:

UPDATE command denied to user 'ispcsrv5'@'ns1.tlwebservices.co.uk' for column 'rendered_zone' in table 'dns_soa

 

Well yes, but as i said this can have multiple causes.

The master aswell?

Can you post the output of "ls /usr/local/ispconfig/server/plugins-enabled/" from the master?

 

@pyte
Panel / master is at 52% used.
huh..

Code:

root@panel:~# ls /usr/local/ispconfig/server/plugins-enabled/
apache2_plugin.inc.php
mysql_clientdb_plugin.inc.php
apps_vhost_plugin.inc.php
network_settings_plugin.inc.php
aps_plugin.inc.php
server_services_plugin.inc.php
backup_plugin.inc.php
shelluser_base_plugin.inc.php
cron_jailkit_plugin.inc.php
shelluser_jailkit_plugin.inc.php
cron_plugin.inc.php
software_update_plugin.inc.php
empty.dir
webserver_plugin.inc.php
firewall_plugin.inc.php
z_php_fpm_incron_reload_plugin.inc.php
ftpuser_base_plugin.inc.php

 

Well i don't know what else to check. I would run server.sh manually and check if there is any information that explains what is causing the error.

https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/

 

@pyte ok thanks for helping,
on the panel or the ns1?

dave

 

@pyte
On my panel crontab, mine is slightly different.. is this standard

Code:

root@panel:~# crontab -l
51 0 * * * "/root/.acme.sh"/acme.sh --cron --home "/root/.acme.sh" > /dev/null
* * * * * /usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done
* * * * * /usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done

###EDIT###
I edited the crontab and hashed out 2nd line.

Code:

root@panel:~# /usr/local/ispconfig/server/server.sh
finished server.php.

 

To be honest i'm out of ideas. Does the error occure on every DNS change you do or is it just a specific action?

Maybe someelse has an idea or knows whats wrong

 

Hello there

i have to report i running the same error here, mine is a bit different but looks like the same bug?

(UPDATE command denied to user 'ispconfig_interface'@'172.28.0.4' for table `named`.`records`)

there is no `named` table in the ispconfig database

i running a clean install of ispconfig3 (updated today)

this error happens only when the dns-server is not installed at the ispconfig-panel server

** EDIT

looking at the source-code i have found this plugin
@gitgub/cyberkathosting/ispconfig3/blob/develop/server/plugins-available/bind_dlz_plugin.inc.php

"/usr/local/ispconfig/server/plugins-enabled/bind_dlz_plugin.inc.php" is safe to disable or i have to add this table at the dns-server database?

changes are working, there is just an error showing at the ispconfig-panel

wish everyone great day

 

Sorry about the late reply

indeed was that plugin. Error gone after running "rm -f /usr/local/ispconfig/server/plugins-enabled/bind_dlz_plugin.inc.php"

Thanks for your time

wish you a nice day

regards