Isn't it about time the daily cron got fixed?

A google search always throws up the same queries from years ago, with regards to the faulty mysqldump, during the daily cron task.

mysqldump: Got error: 1142: "SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts'" when using LOCK TABLES
Database Backup: performance_schema --> /backup/mysql/daily//performance_schema.sql

Also note the double forward slash (looks like a typo) which could be fixed at the same time. I tried to debug the issue but centos-webpanel decided in their wisdom to ioncube encode /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php. Why? To hide poor coding skills perhaps; I can't imagine any other reason, when I'm sure there are many more encoded files. Take Blesta Billing for example, who only encode four files.

Here's even a suggested solution but unable to verify due to the encoded file, so don't even know if you're using some form of automysqlbackup.conf

Code: [Select]

CONFIG_db_exclude=( 'performance_schema' 'information_schema' )
Related to this is the out-of-the-box

error: Failed dependencies:
        perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch

Eh, it's a dependency of your locked file(s), so why not install it during the installation process?

This is basic stuff guys! 

  Well, I got a wee surprise on CWP Pro, this morning:

...
Database Backup: oauthv2 --> /backup/mysql/daily//oauthv2.sql
Skipping database: performance_schema.
Database Backup: postfix --> /backup/mysql/daily//postfix.sql..

Yay, to the silent bug assassin. 

Hopefully this change will propagate from CWP Pro, to the free tier, too.

Pleased to report that free tier also has been changed.

(Surprised others haven't pressed for this fix.)

Recent installation and the Percona dependency has shown again..

error: Failed dependencies:
        perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.16-1.noarch

Code: [Select]

yum -y install perl-DBD-MySQL