Koozali.org: home of the SME Server

Obsolete Releases => SME 9.x Contribs => Topic started by: ReetP on November 20, 2019, 05:29:46 PM

Title: Automysqlbackup + Racktables
Post by: ReetP 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.

Title: Re: Automysqlbackup + Racktables
Post by: Jean-Philippe Pialasse on November 21, 2019, 12:43:08 AM

see

https://wiki.contribs.org/AutoMysqlBackup#Mysql53.2C_Mysql55.2C_Mysql57.2C_MariaDB

and

https://bugs.contribs.org/show_bug.cgi?id=10808