Errors in zentyal-manage-logs cron job

[jjdejong@…]

Get this in the hourly log processing:

/etc/cron.hourly/90zentyal-manage-logs:
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /usr/share/perl5/EBox/MyDBEngine.pm line 405.
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /usr/share/perl5/EBox/MyDBEngine.pm line 405.
run-parts: /etc/cron.hourly/90zentyal-manage-logs exited with return code 25

[jamor@…]

Hello jjdejong,

have you disabled the consolidation process as it was indicated in #4080?.

Regards,

Javier

[jjdejong@…]

Yes, I changed "disable_consolidation" from "no" (its original value) to "yes". Since then, I get the above error every hour.

I also get an error similar to #4080 in the daily log now instead of the hourly log:

/etc/cron.daily/logrotate:
Use of uninitialized value $auth_type in string eq at /usr/share/perl5/EBox/Ldap.pm line 122, line 17.
Use of uninitialized value $auth_type in string eq at /usr/share/perl5/EBox/Ldap.pm line 122, line 17.
Use of uninitialized value $auth_type in string eq at /usr/share/perl5/EBox/Ldap.pm line 122, line 17.
Use of uninitialized value $auth_type in string eq at /usr/share/perl5/EBox/Ldap.pm line 122, line 17.
Use of uninitialized value $auth_type in string eq at /usr/share/perl5/EBox/Ldap.pm line 122, line 17.
/etc/cron.daily/zentyal:
Use of inherited AUTOLOAD for non-method EBox::SysInfo::df() is deprecated at /usr/share/perl5/EBox/SysInfo.pm line 419.
Undefined method dfDBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EPOCH FROM last_date) AS date FROM report_consolidation WHERE report_table = 'sy' at line 1 at /usr/share/perl5/EBox/MyDBEngine.pm line 398.
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EPOCH FROM last_date) AS date FROM report_consolidation WHERE report_table = 'sy' at line 1 at /usr/share/perl5/EBox/MyDBEngine.pm line 398.
run-parts: /etc/cron.daily/zentyal exited with return code 255

[jamor@…]

Hello again,

my fault, the 'disable_consolidation' must be set to 'yes' (I was caught by the doble negative).

The consolidation process is not migrated to 2.3 so better disable it.

Could you do so and check what errors do you get?.

[jjdejong@…]

It is set to "yes"!

[jamor@…]

Ok, forgive about 'disable_consolidation' then.

I had fixed the AUTOLOAD errors and the DBD::Mysql::st errors in this git branch ->  http://git.zentyal.org/zentyal.git/shortlog/refs/heads/jag/logs-migration-mysql

If you apply the changes for /usr/share/perl5/EBox/SysInfo.pm and /usr/share/perl5/EBox/Logs.pm you should get rid of both errors.

Regards,

Javier