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

Daily Executive Report some entry missing after Update 9.4.04-5

Hi,

after update to 9.404-5 there are some entry’s in the Daily Executive Report missing like VPN, Network usage.

Perhaps a Software problem on my Box?

Cheers

Andy



This thread was automatically locked due to age.
Parents
  • What do you see for the missing items in Reporting in WebAdmin?  Are you missing just the data or also the graphs?

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • The Graphs are there, but the data is missing.

    Cheers

    Andy

  • Andy, are you saying that the graphs show and continue to be populated in Reporting, but, for example, nothing is visible on the 'Bandwidth Usage' tab?

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Bob, thats correct there an example:

    Netzwerknutzung:

     

     

    WebAdmin-Anmeldungen:

     

    Verarbeiteter Datenverkehr:

    0

     

    Erfolgreich:

    0

    Verwaltete Verbindungen:

    0

     

    Fehlgeschlagen:

    0

     

     

     

     

     

    Network Protection:

     

     

    Konsolenanmeldungen:

     

    Von Firewall blockierte Pakete:

    271 250

     

    Erfolgreich:

    0

    Von IPS blockierte Angriffe:

    0

     

    Fehlgeschlagen:

    0

     

     

     

     

     

    Webfilter:

     

     

    Up2Date:

     

    Website-Anfragen gesamt:

    71564

     

    Erfolgreiche Anfragen

    88

    Blockierte URLs

    0

     

    Fehlgeschlagene Anfragen

    0

    Blockierte HTTP/S-Viren

    0

     

    Installierte Firmware-Aktualisierungen:

    0

    Blockierte HTTP/S-Malware

    0

     

    Installierte Pattern-Aktualisierungen:

    54

     

     

     

     

     

    E-Mail-Filter:

     

     

    System:

     

    Verarbeitete E-Mails:

    0

     

    Systemneustarts:

    0

    Blockierte Spam-Mails:

    0

     

    Uplink-Failover:

    0

    Blockierte Viren-Mails:

    0

     

    HA/Cluster-Failover:

    0

     

     

     

     

     

    VPN:

     

     

     

     

    VPN-Verbindungen:

    0

     

     

     

    VPN-Datenverkehr:

    not accounted

     

     

     

  • That's from the Executive Report.  I'm asking about graphs in 'Protokolle & Berichte >> Netzwerknutzung' and content on the 'Bandbreitnutzung' tab.  I suspect that your PostgreSQL databases are broken, but before telling you to re-initialize them, I'd like confirmation of my suspicions.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Hi Bob,

    Sorry, yes tap "Bandbreitnutzung" is empty.

    Cheers

    Andy 

Reply Children
  • OK, it does sound like your PostGreSQL data bases have been hosed, so the fact that the following erases all existing data in them shouldn't be a problem. As root at the command line:

    /etc/init.d/postgresql92 rebuild

    This is a rare occurrence - probably one in a thousand upgrades.  Andy got the brass ring!

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • Hi Bob,

    sorry for the late request, rebulid run without error but unortunately the Bandwidth Usage' tab stay empty.

    to solve the Problem, i have reinstall the Appliance over the Weekend, now is everything working.

    thanks for your Help

    Andy

  • You did the right thing, Andy.  The rebuild usually works, but sometimes a re-imaging is the only solution.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA