Scalix Forums

Ok .. we are stumped .. upgrade from 11.1.04 I think it was .. the last GA of the Network Version failed .. seems it fails over and over again on Postgres

RedHat AS 4.5

Configuring PostgreSQL...
Fatal error occured: Msg: An error occurred configuring Web applications -- check the log for errors.
Scalix Installer - cleaning up...
Scalix Installer - done.
[root@mail scalix-11.2.0-GA]#

LOG: database system was shut down at 2007-09-29 21:00:07 PDT
LOG: checkpoint record is at 0/33A70C
LOG: redo record is at 0/33A70C; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 565; next OID: 10794
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
FATAL: database "scalix" does not exist
ERROR: database "scalix" does not exist
FATAL: database "scalix" does not exist
LOG: received fast shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: logger shutting down
LOG: database system was shut down at 2007-09-29 21:08:10 PDT
LOG: checkpoint record is at 0/33A750
LOG: redo record is at 0/33A750; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 567; next OID: 10794
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
FATAL: database "scalix" does not exist
LOG: received fast shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: logger shutting down

I have uninstalled and rebooted and still the same error?? .. Ideas on how to recover from this .. our email server is now DOWN.

BRW

Hi BRW,

you uninstalled everything and reinstalled?

It sounds like the postgres database is missing, try to recreate it with http://www.scalix.com/wiki/index.php?ti ... recreatedb

Chris

No joy ..

Configuring PostgreSQL...
Fatal error occured: Msg: An error occurred configuring Web applications -- check the log for errors.
Scalix Installer - cleaning up...
Scalix Installer - done.
[root@mail scalix-11.2.0-GA]# cd ..
[root@mail ~]# ./scalixdb.sh
Starting scalix-postgres service (mail): [FAILED]
dropdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/opt/scalix/ml/postgres/data/.s.PGSQL.5733"?
[root@mail ~]# ./scalixdb.sh
Starting scalix-postgres service (mail): [FAILED]
dropdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/opt/scalix/ml/postgres/data/.s.PGSQL.5733"?


Ideas ?? This seems to happen about once every other update and then it forces us to have to start all over again .. I sure hope this is not going to be the case again

BRW

It's certainly not an error I've seen - and I think I've seen a lot of 'em ;p

Anyway, can you confirm that postgres is not running and listening on port 5733?

Is the whitelist in /var/opt/scalix/*/postgres/data/pg_hba.conf correctly filled in?

Should look like:

# List of Scalix Platform hosts begins here
host scalix scalix 192.168.188.131/32 md5

Can you post the relevant contents of /var/opt/scalix/*/postgres/pgstartup.log?

Chris

I split this thread off from viewtopic.php?t=8893 to make it easier for others to find the discussion around postgres.

Chris

Ok .. so thats what I thought as well so I did this .. which did not help by the way ..

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust

DETAIL: The data directory was initialized by PostgreSQL version 8.1, which is not compatible with this version 7.4.16.
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 8.1, which is not compatible with this version 7.4.16.


Ok .. Maybe this is the issue?? .. How do I start over without starting over?? In one of this boxes upgrade cycles it did pull in Postgres v8.1 however I removed and reinstalled v7.4 ..

Ideas??

BRW

Are you running multiple databases on the box? If not, is there a reason not just to upgrade to 8.1? I have no idea how to downgrade a postgres database from 8.x format to 7.x format - if it's even possible.

If you don't want to upgrade, you could manuall remove the postgres rpm and the /var/opt/scalix/*/postgres directory, and then reinstall the scalix-postgres package via the installer. However, I think that's much more likely to involve "complications" than just upgrading postgres.

Using postgres 8.1 with Scalix should be no problem.

Chris

Strange stuff

Uninstalled again ..

Then went in and deleted the Postgres data directory ..

Re-installed and now all appears to be working as it should be .. Thats a first for me.

Chris thanks for the hand holding

BRW

Not a problem - glad you got that sorted!

I would assume that things should be correct from now on, seeing as the database will have been initialized by postgres 7.4

Cheers,

Chris

Hmm .. Ok spoke to soon .. Logged into the web interface without issue ..

I can see that I have msg in my inbox but can not view them .. I get an error code of GUI022 when I attempt to view any of the email .. Can not view the calendar either ??

BRW

ok, no problem, i'm still online ;p

1) did postgres start cleanly according to /var/opt/scalix/*/postgres/pgstartup.log?

2) do you see any errors in /var/opt/scalix/*/tomcat/logs/scalix-api.log, scalix-swa.log or similar? what about catalina.out?

Chris

Ok .. so it appears after folllowing this I was able to solve this issue ..

viewtopic.php?t=8836&highlight=gui022

Thanks agian for sticking with me

BRW

Excellent! Hope it stays fixed this time ;p

Chris