Mysql backups not created multiserver env

Discussion in 'General' started by c3n, Mar 22, 2021.

  1. c3n

    c3n Member

    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
  2. c3n

    c3n Member

    all VPS that was build last month have proper backups...
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
  4. c3n

    c3n Member

    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]
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Run the update again on one of the slave servers with: --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.
  6. c3n

    c3n Member

    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...

Share This Page