Guest User!

You are not Sophos Staff.

Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 6 replies
  • Subscribers 2 subscribers
  • Views 1413 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Web security usage logging disabled.

reddyfire
I received an executive report one night and noticed that under web usage the top 10 urls displayed the following message: "This report is disabled by configuration."  Also in the live logging it was no longer displaying live traffic of what sites people were going to. 

 So I went in and disabled the Web Proxy under Web Security - HTTP/s and enabled it 5 minutes later.  This brought back the web logging again. Then 3 days later it stopped showing the logs again.  Turned off and restarted the web proxy multiple times.  No luck this time.  Anything else I should try to get it working again?  Thanks.


This thread was automatically locked due to age.
  • 0
    If this is not a home Astaro, you should submit a support request.

    Cheers - Bob
  • 0
    I have already asked the forum and still no answer from Astaro

    https://community.sophos.com/products/unified-threat-management/astaroorg/f/53/t/32929

    not sure what the problem is but it happens randomly
  • 0
    Wingman, since yours is a home installlation, did you try initializing the http postgresql database - did that fix it?

    Cheers - Bob
  • 0
    There is nothing with regards to corrupted database on the system log. I want to make sure there is an issue with the reporting database first before I re initialise. I't only the web security report though.Everything else is fine.The only errors are: 



    /var/log/system/2010/07/system-2010-07-17.log.gz:2010:07:17-19:45:22        snmpd[4604]: error finding row index in _ifXTable_container_row_restore
    /var/log/system/2010/07/system-2010-07-17.log.gz:2010:07:17-19:45:22        snmpd[4604]: error finding row index in _ifXTable_container_row_restore
    /var/log/system/2010/07/system-2010-07-17.log.gz:2010:07:17-19:45:22        snmpd[4604]: error finding row index in _ifXTable_container_row_restore
    /var/log/system/2010/07/system-2010-07-18.log.gz:2010:07:18-18:40:01        count_active_ip[26702]: error trying to update /var/log/reporting/rrd/active_users.rrd (1279407600:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1279407600 when last update time is 1279407600 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-19.log.gz:2010:07:19-18:40:02        count_active_ip[20811]: error trying to update /var/log/reporting/rrd/active_users.rrd (1279494000:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1279494000 when last update time is 1279494000 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-20.log.gz:2010:07:20-18:40:02        count_active_ip[24177]: error trying to update /var/log/reporting/rrd/active_users.rrd (1279580400:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1279580400 when last update time is 1279580400 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-21.log.gz:2010:07:21-18:40:02        count_active_ip[18273]: error trying to update /var/log/reporting/rrd/active_users.rrd (1279666800:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1279666800 when last update time is 1279666800 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-22.log.gz:2010:07:22-18:40:01        count_active_ip[9732]: error trying to update /var/log/reporting/rrd/active_users.rrd (1279753200:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1279753200 when last update time is 1279753200 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-23.log.gz:2010:07:23-18:40:02        count_active_ip[8436]: error trying to update /var/log/reporting/rrd/active_users.rrd (1279839600:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1279839600 when last update time is 1279839600 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-24.log.gz:2010:07:24-18:40:02        count_active_ip[1952]: error trying to update /var/log/reporting/rrd/active_users.rrd (1279926000:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1279926000 when last update time is 1279926000 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-25.log.gz:2010:07:25-18:40:01        count_active_ip[23424]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280012400:6): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280012400 when last update time is 1280012400 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-26.log.gz:2010:07:26-18:40:02        count_active_ip[10341]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280098800:6): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280098800 when last update time is 1280098800 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-27.log.gz:2010:07:27-18:40:02        count_active_ip[1403]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280185200:6): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280185200 when last update time is 1280185200 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-27.log.gz:2010:07:27-19:13:30        snmpd[4610]: error finding row index in _ifXTable_container_row_restore
    /var/log/system/2010/07/system-2010-07-27.log.gz:2010:07:27-19:13:30        snmpd[4610]: error finding row index in _ifXTable_container_row_restore
    /var/log/system/2010/07/system-2010-07-27.log.gz:2010:07:27-19:13:30        snmpd[4610]: error finding row index in _ifXTable_container_row_restore
    /var/log/system/2010/07/system-2010-07-27.log.gz:2010:07:27-19:13:30        snmpd[4610]: error finding row index in _ifXTable_container_row_restore
    /var/log/system/2010/07/system-2010-07-28.log.gz:2010:07:28-18:40:02        count_active_ip[28039]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280271600:5): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280271600 when last update time is 1280271600 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-29.log.gz:2010:07:29-18:40:02        count_active_ip[17744]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280358000:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280358000 when last update time is 1280358000 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-30.log.gz:2010:07:30-18:40:02        count_active_ip[11380]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280444400:7): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280444400 when last update time is 1280444400 (minimum one second step)
    /var/log/system/2010/07/system-2010-07-31.log.gz:2010:07:31-18:40:02        count_active_ip[11441]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280530800:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280530800 when last update time is 1280530800 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-01.log.gz:2010:08:01-18:40:02        count_active_ip[31921]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280617200:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280617200 when last update time is 1280617200 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-02.log.gz:2010:08:02-18:40:02        count_active_ip[21652]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280703600:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280703600 when last update time is 1280703600 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-03.log.gz:2010:08:03-18:40:02        count_active_ip[12133]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280790000:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280790000 when last update time is 1280790000 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-04.log.gz:2010:08:04-18:40:02        count_active_ip[30353]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280876400:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280876400 when last update time is 1280876400 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-05.log.gz:2010:08:05-18:40:01        count_active_ip[5165]: error trying to update /var/log/reporting/rrd/active_users.rrd (1280962800:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1280962800 when last update time is 1280962800 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-06.log.gz:2010:08:06-18:40:02        count_active_ip[28698]: error trying to update /var/log/reporting/rrd/active_users.rrd (1281049200:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1281049200 when last update time is 1281049200 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-07.log.gz:2010:08:07-18:40:02        count_active_ip[17031]: error trying to update /var/log/reporting/rrd/active_users.rrd (1281135600:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1281135600 when last update time is 1281135600 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-08.log.gz:2010:08:08-18:40:02        count_active_ip[6785]: error trying to update /var/log/reporting/rrd/active_users.rrd (1281222000:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1281222000 when last update time is 1281222000 (minimum one second step)
    /var/log/system/2010/08/system-2010-08-09.log.gz:2010:08:09-18:40:02        count_active_ip[31955]: error trying to update /var/log/reporting/rrd/active_users.rrd (1281308400:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1281308400 when last update time is 1281308400 (minimum one second step)
    /var/log/system.log:2010:08:10-18:40:02        count_active_ip[26635]: error trying to update /var/log/reporting/rrd/active_users.rrd (1281394800:8): /var/log/reporting/rrd/active_users.rrd: illegal attempt to update using time 1281394800 when last update time is 1281394800 (minimum one second step)
  • 0
    I've used the commands below

    1.) /etc/init.d/ulogd stop
    2.) /etc/init.d/syslogng stop
    3.) /var/storage/pgsql/init/reporting_db_init.sh
    4.) /etc/init.d/syslogng start
    5.) /etc/init.d/ulogd start

    Nothing on the report still .i only got the following errors on the system
    2010:08:13-18:48:52 ****** snmpd[4589]: error finding row index in _ifXTable_container_row_restore
    2010:08:13-18:48:52 ****** snmpd[4589]: error finding row index in _ifXTable_container_row_restore
    2010:08:13-18:48:52 *** snmpd[4589]: error finding row index in _ifXTable_container_row_restore
  • 0
    I am still facing the same issue. Anything else I can try ? (pic below)