Cron errors from /etc/cron.hourly/90zentyal-manage-logs

[innocenti_jr]

Whenever I print a document on a shared printer I get two identical mails from Cron Daemon:

Argument "HP-LJ1200-PCL" isn't numeric in addition (+) at /usr/share/perl5/EBox/Module/Base.pm line 1562.
Argument "HP-LJ1200-PCL" isn't numeric in addition (+) at /usr/share/perl5/EBox/Module/Base.pm line 1563.

HP-LJ1200-PCL is my share name of the used printer and indeed it's a string / not numeric. However, Zentyal's printers log gets filled correctly.

[innocenti_jr]

I'll check if  http://trac.zentyal.org/changeset/23592 will fix this. Thanks!

[jacalvo@…]

any news on this? not sure if the above changeset was intended for this report or for another similar one, but it would be great to confirm if it also fixes it

[jamor@…]

Since the changeset changed the parsing of printers logs and innocenti_jr says that it fixed the issue, we close this as fixed.

[innocenti_jr]

Sorry, I missed your updates on this (Trac had troubles).

CS 23592 does not fix this issue.

I did another test on friday and could reproduce this:

• 16:17: I printed something.
• 18:05: Got the mentioned mail from cron.

• cron.hourly is set to run at 5 minutes after every full hour.
• I set an alias for root to Zentyal's postmaster, so I receive mails addressed to root.
• I have no clue why I didn't receive the mail at 17:05.

Can you reproduce the error? I don't think my printer names are too exotic.

[jamor@…]

Hello innocenti_jr,

this an error of consolidation of logs, so you could not reproduce it easily. If you give me dump of your printers logs DB tables, I would try to reproduce it myself. In the tables are data of jobs, printers, pages printed so I don't think you will expose any confidential data on them,

To get the dump, use this command:

sudo su postgres -c'pg_dump -t printers_pages -t printers_jobs eboxlogs' > /tmp/printers.out

Then mail me the file /tmp/printers.out my email is jamor@…

Regards,

Javier

[innocenti_jr]

Thanks, Javier!

I just sent the relevant information via PM.

Kind regards - Oliver

[jamor@…]

(In [23752]) Fixed problem in consalidation report when accumulatign results from queries having a "group by table.field" closes #3344

[jamor@…]

Thanks a lot for your feedback, Olivier.

It was not a problem with your printers name but in the report consolidation algorithm

To hotfix the server:

1) Download the new Base.pm from  http://trac.zentyal.org/export/23752/branches/jag/2.2-oct10/core/src/EBox/Module/Base.pm

2) Use it to replace /usr/share/perl5/EBox/Module/Base.pm

In the next 90zentyal-manage-logs invocation the new file will be used.

Unfortunately it has corrupted some of the printer usage data (which is used to generate the report in the cloud) and it must be manually cleaned up. To clean up the date do the following:

root@btw:~# sudo su postgres -c' psql eboxlogs'
psql (8.4.8)
Type "help" for help.

eboxlogs=# delete from printers_usage_report where printer='0';
DELETE 1

Ctrl+d to exists the psql shell...

Regards,

Javier

[innocenti_jr]

Thanks again! It's working now. :-)