Guest User!

You are not Sophos Staff.

Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 7 replies
  • Subscribers 2 subscribers
  • Views 1666 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

Network Statistics Problem

rbasukala
Hello Friends,

I got some problem with "Network Statistics - Today" under Network.

"Top accounting services" and "Top source hosts" are showing nothing. I restarted the firewall but still it is not showing anything?

Can you guys please help me to find out the problem?

Thanks,
RB


This thread was automatically locked due to age.
Parents Reply
  • 0 in reply to BAlfson
    I wouldn't advertise this as the magical bullet to solve all reporting problems, as this has some serious downsides  (like losing all your accounting data, and all other reporting data stored in the database). I'd suggest you check if you are really affected by this (more information can be found in the thread that was linked by BAlfson). And at least the version of your ASG would be well appreciated if you want to get good answers; without any information given, answering is more guessing than anything.

    Cheers,
     andreas
Children
  • 0 in reply to andreas
    VD, Andreas.  I'll remember to pass on your warning the next time I refer someone to that.

    Gruss - Bob
  • 0 in reply to BAlfson
    I am using Astaro Security Gateway V7, Release 7.302

    Thanks,
    RB
  • 0 in reply to rbasukala
    I had assumed that you were fairly current since this is a problem that began with the new database in the V7.300 release.

    The post I linked to above was one by Andreas.  Please read his comment about this process deleting accounting and reporting data.  Most don't use that, but your organization might.  You can copy the files off beforehand if you have to keep them.  If you have a lot to copy, a little Linux knowledge and a free program like WinSCP will make the task easier.
  • 0 in reply to BAlfson
    Thank you very much. It solves my problem.
  • 0 in reply to rbasukala
    Hi
    Well, we had the same issue a few times already.
    All this time it was fixed by Astaro, just to happened again two-three weeks later.
    Some of astaro comments:
    1. we have another problem with the postgresQL database
    2. There is a autocleaning process which deleted a version file from the data folder in /var/log/reporting/pgsql. Without that version file you get these error messages.
    3. is it possible to reduce the timeframe from 1 week to 1 or 2 days? That will reduce the reporting database.

    It seems there is a problem with the postgresQL....