Scalix Forums

I just tried to Install 11.2.0-GA on my server with fc7...everytime i start the scalix-installer it stops at the following step

-> Please specify comma-separated list of IP addresses where Scalix Messaging Services is or will be installed []:
Configuring PostgreSQL...
Fatal error occured: Msg: An error occurred configuring Web applications -- check the log for errors.
Scalix Installer - cleaning up...
Scalix Installer - done.

the logfile is as follow

2007-12-14 18:39:59,973 INFO Reading SWA config from /var/opt/scalix/on/webmail/swa.properties
2007-12-14 18:40:09,622 INFO Reading SIS config from /var/opt/scalix/on/sis/sis.properties
2007-12-14 18:40:20,284 WARNING Could not determine PostgreSQL whitelist, OK.
2007-12-14 18:40:34,223 INFO Configuring PostgreSQL...
2007-12-14 18:42:40,488 ERROR Operation failed: Failed to initialize the PostgreSQL database.

postgresql version is 8.2.xx
kernel version is 2.6.23.1-10.fc7

i just tried the following: uninstall scalix (except scalix-server), delete the postgres directory, reinstall scalix
but i get the same error

does anybody know how to fix the problem?

thanks for help
luke

Make sure you have the correct password for postgres database - when you install it asks for it - if not the correct password it will fail.

If you do not know the password then reset it and then re-install the ScalixDB.

i don't know what you mean there...while installing scalix the installer asks for a password thats correct...then i have to confirm the passward...so i think the password will be new..or am i wrong that way?

Luke512 wrote:i don't know what you mean there...while installing scalix the installer asks for a password thats correct...then i have to confirm the passward...so i think the password will be new..or am i wrong that way?

its only applicable if your upgrading and already had postgres installed. I am going to assume you are installing a new scalix server.

please see the following post http://www.scalix.com/forums/viewtopic.php?t=9144&highlight=postgresql+fatal+error+install

It solves a permissions problem for postgres database creation, which is likely to be your problem also.
It shows you how to run the installer in debug mode to attain more info.

p.s. search the forums for your problem first before posting. Then if you still have issues post a question ;)

i recommend you use CentOS as it is more stable than fedora, especially if this will end up being a production environment.

i just read that topic and tried that way by removing postgres data directory but that doesn't work for me...and you are right i want to make a fresh install of sclaix...postgresql i have installed first and did the steps as discribed in your linked topic

centOs is not what i want, and the 11.2.0 should be for fc7!

what else can i try to solve the prob?

Luke512 wrote:i just read that topic and tried that way by removing postgres data directory but that doesn't work for me...and you are right i want to make a fresh install of sclaix...postgresql i have installed first and did the steps as discribed in your linked topic

centOs is not what i want, and the 11.2.0 should be for fc7!

what else can i try to solve the prob?

run the installer with the debug switch added, see the other forum post, then post the debug output. Then we will see what really is going on.

here is the output of the log file

2007-12-16 19:11:54,734 DEBUG | Success. You can now start the database server using:
2007-12-16 19:11:54,736 DEBUG |
2007-12-16 19:11:54,737 DEBUG | /usr/bin/postgres -D /var/opt/scalix/on/postgres/data
2007-12-16 19:11:54,739 DEBUG | or
2007-12-16 19:11:54,740 DEBUG | /usr/bin/pg_ctl -D /var/opt/scalix/on/postgres/data -l logfile start
2007-12-16 19:11:54,742 DEBUG |
2007-12-16 19:11:54,743 DEBUG | Starting scalix-postgres service (obi-waan): ^[[60G[^[[0;32m OK ^[[0;39m]
2007-12-16 19:11:54,745 DEBUG | createdb: could not connect to database postgres: could not connect to server: No such file or directory
2007-12-16 19:11:54,746 DEBUG | Is the server running locally and accepting
2007-12-16 19:11:54,748 DEBUG | connections on Unix domain socket "/var/opt/scalix/on/postgres/data/.s.PGSQL.5733"?
2007-12-16 19:11:54,750 ERROR Operation failed: Failed to initialize the PostgreSQL database.

what is wrong?

Luke512 wrote:here is the output of the log file

2007-12-16 19:11:54,734 DEBUG | Success. You can now start the database server using:
2007-12-16 19:11:54,736 DEBUG |
2007-12-16 19:11:54,737 DEBUG | /usr/bin/postgres -D /var/opt/scalix/on/postgres/data
2007-12-16 19:11:54,739 DEBUG | or
2007-12-16 19:11:54,740 DEBUG | /usr/bin/pg_ctl -D /var/opt/scalix/on/postgres/data -l logfile start
2007-12-16 19:11:54,742 DEBUG |
2007-12-16 19:11:54,743 DEBUG | Starting scalix-postgres service (obi-waan): ^[[60G[^[[0;32m OK ^[[0;39m]
2007-12-16 19:11:54,745 DEBUG | createdb: could not connect to database postgres: could not connect to server: No such file or directory
2007-12-16 19:11:54,746 DEBUG | Is the server running locally and accepting
2007-12-16 19:11:54,748 DEBUG | connections on Unix domain socket "/var/opt/scalix/on/postgres/data/.s.PGSQL.5733"?
2007-12-16 19:11:54,750 ERROR Operation failed: Failed to initialize the PostgreSQL database.

what is wrong?

looks like the postgres directory is missing, or has bad permissions. There's probably a bit more in the debug before that stuff which would also help.

Nonetheless.....

You are yet to use scalix so....

remove scalix completely. use the installer script.
Then remove manually /var/opt/scalix, /etc/opt/scalix and /etc/opt/scalix-tomcat

Then with a clean state re-run the installer (with --debug) and see how it goes. If it still fails post the full debug output.

i just tried the way you described, but it still doesn't work

in the following link you can read the whole debug log

http://nopaste.info/074b18a0be.html

Luke512 wrote:i just tried the way you described, but it still doesn't work

in the following link you can read the whole debug log

http://nopaste.info/074b18a0be.html

subsection of that log....

# 2007-12-17 09:40:53,213 DEBUG | WARNING: enabling "trust" authentication for local connections
# 2007-12-17 09:40:53,214 DEBUG | You can change this by editing pg_hba.conf or using the -A option the
# 2007-12-17 09:40:53,216 DEBUG | next time you run initdb.
# 2007-12-17 09:40:53,217 DEBUG |
# 2007-12-17 09:40:53,219 DEBUG | Success. You can now start the database server using:
# 2007-12-17 09:40:53,220 DEBUG |
# 2007-12-17 09:40:53,222 DEBUG | /usr/bin/postgres -D /var/opt/scalix/on/postgres/data
# 2007-12-17 09:40:53,223 DEBUG | or
# 2007-12-17 09:40:53,224 DEBUG | /usr/bin/pg_ctl -D /var/opt/scalix/on/postgres/data -l logfile start
# 2007-12-17 09:40:53,226 DEBUG |
# 2007-12-17 09:40:53,227 DEBUG | Starting scalix-postgres se[ OK ]bi-waan):
# 2007-12-17 09:40:53,229 DEBUG | createdb: could not connect to database postgres: could not connect to server: No such file or directory
# 2007-12-17 09:40:53,230 DEBUG | Is the server running locally and accepting
# 2007-12-17 09:40:53,232 DEBUG | connections on Unix domain socket "/var/opt/scalix/on/postgres/data/.s.PGSQL.5733"?
# 2007-12-17 09:40:53,234 ERROR Operation failed: Failed to initialize the PostgreSQL database.

ok looks like postgres got installed ok but couldn't create the db.

do you have a /var/opt/scalix/on/postgres/data directory?

What are the permissions on that directory? is it owned by scalix:scalix?

Is postgres running?
netstat -apn |grep 5733

Do you have any firewalling enabled which might be blocking port 5733?

Do you have selinux enabled? if so i think you need to disable it for scalix to work.

ok..here are some answers

[root@obi-waan ~]# ls -l /var/opt/scalix/on/postgres
insgesamt 4
drwx------ 11 postgres postgres 4096 17. Dez 09:40 data
-rw------- 1 postgres postgres 0 17. Dez 09:40 pgstartup.log
[root@obi-waan ~]# netstat -apn |grep 5733
tcp 0 0 192.168.1.11:5733 0.0.0.0:* LISTEN 11101/postmaster
unix 2 [ ACC ] STREAM HÖRT 152272 11101/postmaster /var/opt/scalix/on/postgres/data/.s.PGSQL.5733
[root@obi-waan ~]# service iptables status
Firewall wurde beendet.

looks like theres a permission error because the owner of the data directory is postgres itself, the firewall is stopped

i will try to change the permission and start istalling again

selinux is in permissive mode cause i make setenforce 0

Luke512 wrote:ok..here are some answers

[root@obi-waan ~]# ls -l /var/opt/scalix/on/postgres
insgesamt 4
drwx------ 11 postgres postgres 4096 17. Dez 09:40 data
-rw------- 1 postgres postgres 0 17. Dez 09:40 pgstartup.log
[root@obi-waan ~]# netstat -apn |grep 5733
tcp 0 0 192.168.1.11:5733 0.0.0.0:* LISTEN 11101/postmaster
unix 2 [ ACC ] STREAM HÖRT 152272 11101/postmaster /var/opt/scalix/on/postgres/data/.s.PGSQL.5733
[root@obi-waan ~]# service iptables status
Firewall wurde beendet.

looks like theres a permission error because the owner of the data directory is postgres itself, the firewall is stopped

i will try to change the permission and start istalling again

selinux is in permissive mode cause i make setenforce 0

Sorry, i got that wrong, permissions look right. I've just checked my server, the files and directories should be owned by postgres:postgres.

[root@mail ~]# ls -la /var/opt/scalix/ml/postgres/data
total 84
drwx------ 11 postgres postgres 4096 Nov 13 00:01 .
drwxr-xr-x 3 postgres postgres 4096 Jun 19 18:13 ..
drwx------ 6 postgres postgres 4096 Nov 12 23:48 base
drwx------ 2 postgres postgres 4096 Dec 18 17:19 global
drwx------ 2 postgres postgres 4096 Jun 19 18:13 pg_clog
-rw------- 1 postgres postgres 3535 Nov 12 23:59 pg_hba.conf
-rw------- 1 postgres postgres 1460 Jun 19 18:13 pg_ident.conf
drwx------ 2 postgres postgres 4096 Jun 25 00:00 pg_log
drwx------ 4 postgres postgres 4096 Jun 19 18:13 pg_multixact
drwx------ 2 postgres postgres 4096 Oct 28 18:06 pg_subtrans
drwx------ 2 postgres postgres 4096 Jun 19 18:13 pg_tblspc
drwx------ 2 postgres postgres 4096 Jun 19 18:13 pg_twophase
-rw------- 1 postgres postgres 4 Jun 19 18:13 PG_VERSION
drwx------ 3 postgres postgres 4096 Nov 28 11:01 pg_xlog
-rw------- 1 postgres postgres 13699 Jun 19 18:13 postgresql.conf
-rw------- 1 postgres postgres 122 Nov 13 00:01 postmaster.opts
-rw------- 1 postgres postgres 59 Nov 13 00:01 postmaster.pid
srwxrwxrwx 1 postgres postgres 0 Dec 18 17:44 .s.PGSQL.5733
-rw------- 1 postgres postgres 39 Dec 18 17:44 .s.PGSQL.5733.lock


It must be something else......

I notice in the debug log you have 2 interfaces detected....

192.168.2.11 and 192.168.1.11

Perhaps its getting confused about which one to setup. maybe try having the second interface down when you install?

i just stopped eth0 and tried a fresh install, but i stille get the same error

the system is unable to initialize the database
for me it seems that theres a problem with postgres, maybe something with the password

i don't know what else i could try to get the problem solved

Luke512 wrote:i just stopped eth0 and tried a fresh install, but i stille get the same error

the system is unable to initialize the database
for me it seems that theres a problem with postgres, maybe something with the password

i don't know what else i could try to get the problem solved

Gee it shouldn't be this difficult, Would love to see you get over this hurdle.

What are the contents of /var/opt/scalix/on/postgres/pgstartup.log ??

going back to some basics.....

has /etc/hosts got entries for 127.0.0.1, and the other 2 ip's correct?

maybe try with your server hostname not including a "-" as the mailnode gets built from this and this may cause a problem (not likely but its worth a shot - keep it simple).

the password you set for postgres - make sure its just alhanumeric, no special characters etc.

Which version of postgres is it? 7 or 8? do you use postgres for anything else?

Perhaps another clean remove of scalix and postgres too this time including removing all directories.
When i setup my scalix servers i just rpm install postgresql and postgresql-server and leave it at that. I let the scalix installer do the rest.

Lastly....

This post shows some manual instructions for setting up postgres.

viewtopic.php?t=7782&p=35312

Those instructions may help, or at the very least potentially show you any errors.

Good luck, let me know how you go.