Thread Info
  • State Suggested Answer
  • +2 person also asked this people also asked this
  • Locked Locked
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 29 subscribers
  • Views 11462 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

All Reports broken

Nitr01

I am on the latest version and every once in a while my system reporting stops working.  All reports on the "Reports" page change to "No Record Found".  I can re-install the firmware and restore my backup and it fixes it for a while but then it happens again.  No changes are made at the time this occurs.



This thread was automatically locked due to age.
Parents
  • 0

    Hey Nitr01,

     

    I wanted to bring this back up as I'm now experiencing the same issue you are. I've recently upgrade to 17.5.3 MR-3 and the next day I it was working just fine. Over the weekend, it must of died as when I came into work Monday it was showing "No record found" for everything. I haven't tired re-installing firmware or restoring the backup as I wish to stay away from downtime if possible.

     

    I've followed the steps on here: community.sophos.com/.../123209

     

     SFV4C6_SO01_SFOS 17.5.3 MR-3# service -S
    lcdd UNTOUCHED
    postgres RUNNING
    sigdb RUNNING
    reportdb RUNNING
    crreport UNREGISTERED
    awarrensmtp UNREGISTERED
    smtpd RUNNING
    nasm RUNNING
    ntpclient RUNNING
    garner RUNNING

    console> show on-box-reports
    Local Reporting : on

    console> system diagnostics show disk
    Partition Utilization(%)
    ===============================
    configuration 18%
    content 1%
    report 37%

    SFV4C6_SO01_SFOS 17.5.3 MR-3# df -h
    Filesystem Size Used Available Use% Mounted on
    rootfs 301.9M 2.6M 279.3M 1% /
    df: /newroot: No such file or directory
    df: /newroot/dev: No such file or directory
    df: /newrootrw: No such file or directory
    none 301.9M 2.6M 279.3M 1% /
    none 11.7G 40.0K 11.7G 0% /dev
    none 11.7G 54.3M 11.7G 0% /tmp
    none 11.7G 14.6M 11.7G 0% /dev/shm
    /dev/conf 385.4M 68.6M 316.7M 18% /conf
    /dev/content 43.6G 378.0M 43.2G 1% /content
    /dev/var 368.7G 136.5G 232.2G 37% /var

     

    To verify, this is what the problem looks like.

    and yes, logging is enabled for almost all of my firewall rules. 

  • +2 in reply to H Obe RS

    Hello H Obe RS,

     

    I'm in the process of rebooting my firewall. Most likely will be able to get down time approval tomorrow morning. I made a case with Sophos Support and this is what they wanted me to do after restarting reporting database. Apparently this daemon has to have a reboot of the firewall to restart. 

  • 0 in reply to JeffDurga

    Great Answer, I just read your post and not answer this post, sorry for that,

     

    Done, the problem was Solved by rebooting the system, so at my post but your post got clearance from the boss.

     

    Thank you for the Reboot

  • 0 in reply to H Obe RS

    Good to hear H Obe RS. I also rebooted my firewall and it worked for me as well. 

Reply Children
No Data