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

[ejsolutions]

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 Expand

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! 

[ejsolutions]

  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.

[ejsolutions]

Pleased to report that free tier also has been changed.

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

[ejsolutions]

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 Expand

yum -y install perl-DBD-MySQL