Guest User!

You are not Sophos Staff.

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

Logging and Reporting Questions/Error

Al3
We have ASG 320 Security Gateway with firmware version: 7.402 and pattern version: 9525.

Few Questions:

1) In the WebAdmin portal when clicking on Logging>View Log Files>System messages>Live Log, all i can see is the following: 

2009:05:04-14:10:01 202 /usr/sbin/cron[22513]: (root) CMD ( /usr/local/bin/reportcontrol.sh) 

2009:05:04-14:10:01 202 postgres[22518]: [3-1] FATAL: database "reporting" does not exist 

2009:05:04-14:10:01 202 postgres[22525]: [3-1] FATAL: database "reporting" does not exist 

2009:05:04-14:10:02 202 postgres[22526]: [3-1] FATAL: database "reporting" does not exist 

2009:05:04-14:10:03 202 postgres[22527]: [3-1] FATAL: database "reporting" does not exist 

2009:05:04-14:10:03 202 postgres[22528]: [3-1] FATAL: database "reporting" does not exist 

2009:05:04-14:10:05 202 postgres[22529]: [3-1] FATAL: database "reporting" does not exist 

2009:05:04-14:10:05 202 ulogd[3217]: pg1: unable to connect: FATAL: database "reporting" does not exist 

2009:05:04-14:10:10 202 postgres[22530]: [3-1] FATAL: database "reporting" does not exist 

2009:05:04-14:10:10 202 ulogd[3217]: pg1: unable to connect: FATAL: database "reporting" does not exist 

2009:05:04-14:10:15 202 postgres[22532]: [3-1] FATAL: database "reporting" does not exist
 

Can anyone help me to find out why is this happenning. I read the sticky thread, but it was dated 2005, therefore I made a new one.

2)Just to confirm going in to Reporting>Network Usage>Daily, the graphical display shows the last 24 hours from 6:00pm to 4:00pm, therefore the display is from evening time day before yesterday to yesterday evening, Is this correct?

3)When clicking on Reporting>Network Usage>Weekly why does it show the date from 25th Wednesday to 31st Tuesday, when infact it should show from 27th Monday to 3rd Sunday. (I just checked and the 25th Wednesday to 31st Tuesday was in March 2009, how come it is showing dates in March, when it should show the last week of May and and first week of April dates) [screenshot in zip file, the file size is too big and for some reason can only be opened in Ms-Paint]

Thanks in advance.


This thread was automatically locked due to age.
  • 0
    It looks like the database is broken - actually, it even doesn't exist. It would be really interesting to know what happened just before the first appearance of the "FATAL: database 'reporting' does not exist" error messages.
    Since the reporting database is no longer there no new reports can be generated, therefore the reports only show old data. There are a couple of threads out there dealing with database corruption and re-initialization of the reporting database, those should help you out.

    Cheers,
     andreas
  • 0 in reply to andreas
    Hi andreas,

    I have tried to go in through the shell entering the following commands

    202:/home/login # mkdir /var/log/reporting/pgsql
    mkdir: cannot create directory `/var/log/reporting/pgsql': File exists
    202:/home/login # chown postgres[:P]ostgres /var/log/reporting/pgsql
    202:/home/login # /var/storage/pgsql/init/reporting_db_init.sh
    ERROR:  directory "/var/log/reporting/pgsql" is not empty
    createdb: database creation failed: ERROR:  tablespace "reporting" does not exist
    createlang: could not connect to database reporting: FATAL[:D]atabase "reporting" does not exist
    psql: FATAL:  database "reporting" does not exist
    psql: FATAL:  database "reporting" does not exist

    Can you please point me towards the right thread/post which I can follow.

    Kind Regards,
    Ali
  • 0 in reply to Al3
    On the Search drop-down menu at the top of this page, select Advanced Search.  Search on postgresql in a post by andreas.

    Cheers - Bob