Management, Networking, Logging and Reporting 'Today's threat status' all zero

UTM Firewall requires membership for participation - click to join

Thread Info

State Not Answered
Locked Locked
Replies 4 replies
Subscribers 2 subscribers
Views 1582 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

'Today's threat status' all zero

BAlfson over 16 years ago

I just noticed that these stats are all zero. Is there a way to fix that short of reloading[:(]?

Thanks - Bob

This thread was automatically locked due to age.

Parents

0 Jack Daniel over 16 years ago

Does the system log show any signs of a database problem? We may need to rebuild the reporting DB for you.

Jack
Cancel
Vote Up 0 Vote Down

Cancel
0 BAlfson over 16 years ago in reply to Jack Daniel

Indeed
21-21:18:06 (none) ulogd[2557]: pg1: ERROR: index "accounting_pkey" contains unexpected zero page at block 0 HINT: Please REINDEX it.

Whoa! The system logfile was 8.7KB on the 13th and 519kb on the 16th.
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 BAlfson over 16 years ago in reply to Jack Daniel

Indeed
21-21:18:06 (none) ulogd[2557]: pg1: ERROR: index "accounting_pkey" contains unexpected zero page at block 0 HINT: Please REINDEX it.

Whoa! The system logfile was 8.7KB on the 13th and 519kb on the 16th.
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 andreas over 16 years ago in reply to BAlfson

Hi,
which version are you running?

What needs to be done depends on the kind of error you're running into. If the above error is the only problem it is easy to fix, you just need to rebuild the index as stated in the hint. As root, do the following:
# psql -U reporting -c "REINDEX DATABASE reporting"

Cheers,
andreas
Cancel
Vote Up 0 Vote Down

Cancel
0 BAlfson over 16 years ago in reply to andreas

Thanks, Andreas. This problem is resolved.

Cheers - Bob
Cancel
Vote Up 0 Vote Down

Cancel