Koozali.org: home of the SME Server

Automysqlbackup + Racktables

Offline ReetP

  • *
  • 3,722
  • +5/-0
Automysqlbackup + Racktables
« on: November 20, 2019, 05:29:46 PM »
FYI

We had been testing RackTables on a SME v9 box.

We were using SCL MySQL 5.5

We run automysqlbackup and we noticed that it started throwing an error:

Code: [Select]
mysqldump: Couldn't execute 'show create table `Location`': SHOW VIEW command denied to user 'backupuser'@'localhost' for table 'Location' (1142)
Not helpful as it doesn't tell you the offending DB.

After hunting a bit we realised it was the RackTables DB.

The cure was to add the SHOW VIEW permission to the backup user

The SQL taken from phpmyadmin that does this is:

Code: [Select]
REVOKE ALL PRIVILEGES ON * . * FROM 'backupuser'@'localhost';
REVOKE GRANT OPTION ON * . * FROM 'backupuser'@'localhost';
GRANT SELECT ,
LOCK TABLES , EVENT,
SHOW VIEW ON * . * TO 'backupuser'@'localhost';

And fixed.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation