Author Topic: Isn't it about time the daily cron got fixed?  (Read 3238 times)

0 Members and 1 Guest are viewing this topic.

Isn't it about time the daily cron got fixed?
« on: June 03, 2019, 06:51:51 PM »
A google search always throws up the same queries from years ago, with regards to the faulty mysqldump, during the daily cron task.
Quote
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
Quote
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!  ::)
« Last Edit: June 03, 2019, 06:54:56 PM by ejsolutions »

[Solved] Isn't it about time the daily cron got fixed?
« Reply #1 on: June 06, 2019, 09:24:05 AM »
 :o Well, I got a wee surprise on CWP Pro, this morning:
Quote
...
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.  :D

Hopefully this change will propagate from CWP Pro, to the free tier, too. ;)
« Last Edit: June 06, 2019, 09:46:15 AM by ejsolutions »

[Solved] Isn't it about time the daily cron got fixed?
« Reply #2 on: June 07, 2019, 10:54:15 AM »
Pleased to report that free tier also has been changed.

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

Re: Isn't it about time the daily cron got fixed?
« Reply #3 on: February 11, 2020, 05:23:50 PM »
Recent installation and the Percona dependency has shown again..

Quote
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
« Last Edit: February 11, 2020, 05:27:21 PM by ejsolutions »