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

ASG 7.306: No longer generating executive reports etc.

I've had this problem several times during the upgrade process to 7.306. The symptoms are:

HTTP Proxy reporting reports: undefined
Dashboard stats never update

Can anyone advise me how to fix this? It's my home installation so it's not under support. I presume I need to rebuild or populate certain tables in PGSQL?

TIA,

j.

This thread was automatically locked due to age.

Parents

0 BAlfson over 16 years ago

I'd go with the re-index first, but I'm impressed that you are one of the elite few who's had a problem with the 7.306 upgrade... Only someone with your gift could accomplish that. [;)]

Cheers - Bob
Cancel
Vote Up 0 Vote Down

Cancel
0 James Bourne over 16 years ago in reply to BAlfson

I'm not sure when it happened but the box is at 7.306 and hasn't been producing reports for quite some time.

Do you know what commands I need to issue at the CLI?

j.
Cancel
Vote Up 0 Vote Down

Cancel
0 BarryG over 16 years ago in reply to James Bourne

I think what you need is here:
https://community.sophos.com/products/unified-threat-management/astaroorg/f/95/t/67367

Backup your config first.

Barry
Cancel
Vote Up 0 Vote Down

Cancel
0 andreas over 16 years ago in reply to BarryG

If you're not afraid of dropping and re-creating manually, the thread linked to by Barry is the way to go. Since this is a home installation you could also just try to run the up2dates to 7.401; there's a database conversion in 7.400 during which broken tables will be automatically dropped and re-created. This should get things into a working state again.
Cheers,
andreas
Cancel
Vote Up 0 Vote Down

Cancel
0 James Bourne over 16 years ago in reply to andreas

I tried following the instructions in the referred post today. This is what I got:

fw1:/opt/tmpfs # psql -U reporting reporting
psql: FATAL: "pg_tblspc/16519/16520" is not a valid data directory
DETAIL: File "pg_tblspc/16519/16520/PG_VERSION" is missing.

How can I fix / workaround that?
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 James Bourne over 16 years ago in reply to andreas

I tried following the instructions in the referred post today. This is what I got:

fw1:/opt/tmpfs # psql -U reporting reporting
psql: FATAL: "pg_tblspc/16519/16520" is not a valid data directory
DETAIL: File "pg_tblspc/16519/16520/PG_VERSION" is missing.

How can I fix / workaround that?
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data