Control Web Panel
WebPanel => CentOS-WebPanel Bugs => Topic started by: ejsolutions 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.
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
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! ::)
-
:o 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. :D
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
yum -y install perl-DBD-MySQL