Query Logs > Full Reports always says "There are no logs for this domain"

[arch@…]

I have 3.0-RC1 running at two sites. One was a fresh install from your 3.0-RC1 ISO image an doen was an upgrade from 2.3. Both show as "Core version 2.3.21".

In both cases, neither will show anything under Query Logs > Full Reports for anything except "Administrator sessions" and "Bandwidth usage". In each case, I have all the items checked "Configure logs" and purge is set to a week. Even the two that I listed "Administrator sessions" and "Bandwidth usage" will not show anything once you have viewed the information once.

The one I find most valuable and that I really need is "HTTP Proxy" however it is one that does not work (I can see the logs getting written under Dansguardian as the sites are written.

As I clicked on the different reports, the output from /var/log/zentyal/zentyal.log is shown below.

2012/08/28 09:23:02 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:02 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:02 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:06 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:06 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:06 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:13 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:13 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:13 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:20 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/perl5/EBox/EventDaemon.pm (pid: 17953) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:23:21 DEBUG> Manager.pm:216 EBox::Model::Manager::_componentByPath - Missing argument: composite 2012/08/28 09:24:12 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/perl5/EBox/EventDaemon.pm (pid: 17989) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:24:13 DEBUG> Manager.pm:216 EBox::Model::Manager::_componentByPath - Missing argument: composite 2012/08/28 09:24:13 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:24:13 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd 2012/08/28 09:24:14 DEBUG> Sudo.pm:165 EBox::Sudo::_root - /usr/share/zentyal/cgi/ebox.cgi Logs/Index? (pid: 5161) - /bin/cat /var/lib/zentyal/conf/zentyal-mysql.passwd

[jamor@…]

Hello Arch,

Can you check if you have the log modules enabled?.

If it enabled make sure that /usr/share/zentyal/loggerd is running. If it is not, the logs are never inserted into the database.

If it is running, try to enter into the database (use the password in /var/lib/zentyal/conf/zentyal-mysql.passwd ) and look whether if the log tables are empty or if they have data

[arch@…]

1. If I go to System > logs > Configure logs > all of these are checked: audit, Events, bwmonitor, Firewall, dhcp, ids,squid
2. If I do a ps -e < i see see "4131 ? 00:00:02 loggerd" 4234 ? 00:00:06 collectd....does that mean its running??
3. I used the password in "/var/lib/zentyal/conf/zentyal-mysql.passwd" to use webmin to open MySQL Databases. I see fiev databases: information_schema , mysql

performance_schema,test, and zentyal. Which do I look at?? For the heck of it, I looked at two tables and tried to view them: Table events in database zentyal said "This table contains no data."

Table events_report in database zentyal said "This table contains no data. Data in this table cannot be edited because it has no primary key."

Note, I foudn a couple that had stuff in them for example: Table sysinfo_disk_usage in database zentyal had a bunch of

[jacalvo@…]

We haven't been able to reproduce this, HTTP proxy logs always work for us. Don't now if you have done something special. I acknowledge that probably migrating from an old 2.3.X version could break things, but fresh install of 3.0-rc1 should work. Please reopen if you can provide more information to help us to discover this issue. Thanks!