Hello HTF Friends, Setup : Multi-server OS : Ubuntu 16.0.4 Server type : Nginx Databse : mySql Services : postfix, dovecot I can't seem to get database backups to work. Website backups work very well. When i try to run a backup i get the error Code: server2.website.com - 12.01.2021-21:46 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = SELECT * FROM web_database WHERE server_id = 20 AND parent_domain_id = 90 -> 1142 (SELECT command denied to user 'ispcsrv3'@'server2.website.com' for table 'web_database') Looks like a permission issue. Should i just modify the table permissions in the database or do i have something incorrectly set-up in the config? Regards, Jeremy
Several backup issues where fixed in 3.2.2, please update all servers to that. (also, several security issues are fixed in 3.2.2)
May be wise to update the OS as well as Ubuntu 16.04 LTS is nearing EOL unless you already bought the extended Ubuntu support.
@Th0m . Updated to 3.2.2 but didn't resolve the issue. @ahrasis - Yes, i do plan to update. I noticed the user "ispcsrv3" is not present on the destination server. The command is executed from the panel server.
What error do you get now? When updating did you answer yes to update permissions on the master db? If not, run the installer on all your servers again and do that.