Bug/Problem with BIND Zone-Updates on IspConfig 3.1.11
I've updated IspConfig recently. Today I've tried to update a dns-zone multiple times which looked fine at first. After noticing it is not working (bind zone-file did not update after change in ispconfig web-interface) I've notice this warning after manually executing server.sh.
WARNING - Falsche Anfrage / Wrong QuerySQL-Query = UPDATE named.records SET zone = 'xxxxx.de', ttl = '86400', primary_ns = 'pns1.cloudns.net.', resp_contact = 'firstname.lastname@example.org.', serial = '2018051420', refresh = '3600', retry = '1200', expire = '604800', minimum = '86400' WHERE ispconfig_id = '61' AND type = 'SOA' -> 1142 (UPDATE command denied to user 'ispconfig'@'localhost' for table 'records')
In fact this db-table does not exist! But the table 'records' exists. Why is there a prefix with 'named.' and the table does not exist? Is this a bug or is there any way to update the database-schema manually if that is the problem?
There is no issue for web-interface DNS - all zones are listed properly from records-table.
Any help is welcome.