Hello. I noticed that web backups are performed but mysql not. Lots of servers in multi env. backup is mounted in separate DC... was working fine for several years. I found topic on Github about ISPCONFIG problem with permissions being checked while processing MYSQL... guys, any solution on this? I upgraded ISP on main and slave... no effect. It is urgent for me because it is tool that clients use to backup or reverse. I got also 2 other backup (rsync for such disaster as last OVH on separate DC and full snapshots of VPS made)... but still need ISPconfig backups... On main server backups are OK. I checked few domains and dates are from last night. But all slaves have 2-3 months old... I think that upgrade of ISPconfig broke something. Waiting for Your kindly reply, Maciej
1) Which ISPConfig version? there were issues in early 3.2.x versions which have been resolved in 3.2.3. Do you use ISPConfig 3.2.3? 2) Is the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf file correct?
Yes, I've checked one server and it is lates ISP 3.2.3 (no update available) and #2 is ok checked root password. When I click on demand MYSQL i got this email hostname.dummy - 22.03.2021-14:09 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = SELECT * FROM web_database WHERE server_id = (NUMBER) AND parent_domain_id = (NUMBER) -> (NUMBER) (SELECT command denied to user 'ispcsrv20'@'IPADDRESS' for table 'web_database') [of course I removed hostname, IPs and all client numbers]
Run the update again on one of the slave servers with: ispconfig_update.sh --force and choose to reconfigure permissions in master database. This should update the mysql users of all slaves in master database to ensure that they have access to the necessary tables.
Thanks @till for fast answer ok, that fix works. I've checked manual and it is creating DB on 10 servers with updated/reconfigure permissions last hour... I'll give more info tomorrow after cron update...
