Scalix Forums

Hello all,

I'm following the manual install wiki of scalix, and when in need to type a password for the database,

/opt/scalix-postgres/bin/sxpsql-setpwd mypassword # This is a database password you select

I get the following error:
psql: 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/mr/postgres/data/.s.PGSQL.5733"?

I ignored this and went on configuring the things as described in the wiki.
But I would like to have this problem fixed.

So does anyone know what to do now?

Thanks,

I've uninstalled and then installed everything again and started the configuration, up to this point everything goes fine, but when I enter

/opt/scalix-postgres/bin/sxpsql-setpwd mypassword

I still get the same error.

Is there really no way to fix this?

Thanks,

If you're using Redhat, Fedora, or Centos, try doing a "service scalix-postgres start"

It looks like Postgres isn't running.

Hi,

I'm installing on a Ubuntu 6.06 LAMP.
The strange thing is that the service is starting,

Just to make sure I type:

/etc/init.d/scalix-postgres start

Then terminal returns:
Starting scalix-postgres service (mailserver): ok

This is the output of
ps xa|grep postmaster

root@mailserver:/home/patrick# ps xa|grep postmaster
5105 ? S 0:00 /usr/lib/postgresql/7.4/bin/postmaster -c unix_socket_directory=/var/run/postgresql -D /var/lib/postgresql/7.4/main
5145 ? S 0:00 /usr/lib/postgresql/8.1/bin/postmaster -D /var/lib/postgresql/8.1/main -c unix_socket_directory=/var/run/postgresql -c config_file=/etc/postgresql/8.1/main/postgresql.conf -c hba_file=/etc/postgresql/8.1/main/pg_hba.conf -c ident_file=/etc/postgresql/8.1/main/pg_ident.conf
6132 pts/0 S+ 0:00 grep postmaster


This is the outcome of lsof -i:


root@mailserver:/home/patrick# lsof -i
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
hpiod 4334 hplip 0u IPv4 10583 TCP localhost.internetstarters: 49439 (LISTEN)
hpiod 4334 hplip 2u IPv4 10586 TCP localhost.internetstarters: 49439->localhost.internetstarters:40498 (ESTABLISHED)
python 4341 hplip 4u IPv4 10619 TCP localhost.internetstarters: 55731 (LISTEN)
python 4341 hplip 7u IPv4 10625 TCP localhost.internetstarters: 40498->localhost.internetstarters:49439 (ESTABLISHED)
amavisd-n 4387 amavis 4u IPv4 10732 TCP localhost.internetstarters: 10024 (LISTEN)
amavisd-n 4387 amavis 5u IPv4 11634 UDP internetstarters.nl:54636-> 111.i-provide.nl:domain
cupsd 4412 cupsys 1u IPv4 10775 TCP localhost.internetstarters: ipp (LISTEN)
spamd 4425 root 5u IPv4 10802 TCP localhost.internetstarters: spamd (LISTEN)
spamd 4425 root 6u IPv4 11656 UDP internetstarters.nl:38020-> 111.i-provide.nl:domain
couriertc 4611 root 5u IPv6 11118 TCP *:imap2 (LISTEN)
couriertc 4636 root 5u IPv6 11145 TCP *:pop3 (LISTEN)
amavisd-n 4807 amavis 4u IPv4 10732 TCP localhost.internetstarters: 10024 (LISTEN)
amavisd-n 4807 amavis 5u IPv4 11634 UDP internetstarters.nl:54636-> 111.i-provide.nl:domain
amavisd-n 4808 amavis 4u IPv4 10732 TCP localhost.internetstarters: 10024 (LISTEN)
amavisd-n 4808 amavis 5u IPv4 11634 UDP internetstarters.nl:54636-> 111.i-provide.nl:domain
spamd 4809 root 5u IPv4 10802 TCP localhost.internetstarters: spamd (LISTEN)
spamd 4809 root 6u IPv4 11656 UDP internetstarters.nl:38020-> 111.i-provide.nl:domain
spamd 4810 root 5u IPv4 10802 TCP localhost.internetstarters: spamd (LISTEN)
spamd 4810 root 6u IPv4 11656 UDP internetstarters.nl:38020-> 111.i-provide.nl:domain
mysqld 4877 mysql 13u IPv4 11833 TCP localhost.internetstarters: mysql (LISTEN)
master 5070 root 11u IPv4 12590 TCP *:smtp (LISTEN)
master 5070 root 12u IPv6 12591 TCP *:smtp (LISTEN)
master 5070 root 99u IPv4 12710 TCP localhost.internetstarters: 10025 (LISTEN)
postmaste 5105 postgres 4u IPv4 12850 UDP localhost.internetstarters: 32770->localhost.internetstarters:32770
postmaste 5108 postgres 4u IPv4 12850 UDP localhost.internetstarters: 32770->localhost.internetstarters:32770
postmaste 5145 postgres 3u IPv4 12949 TCP localhost.internetstarters: 5433 (LISTEN)
postmaste 5145 postgres 5u IPv4 12954 UDP localhost.internetstarters: 32771->localhost.internetstarters:32771
postmaste 5147 postgres 5u IPv4 12954 UDP localhost.internetstarters: 32771->localhost.internetstarters:32771
postmaste 5148 postgres 5u IPv4 12954 UDP localhost.internetstarters: 32771->localhost.internetstarters:32771
sshd 5314 root 3u IPv6 13356 TCP *:ssh (LISTEN)
ldapmappe 5383 root 3u IPv4 13407 TCP localhost.internetstarters: 5757 (LISTEN)
advmail.s 5492 root 4u IPv4 13623 TCP *:scalixual (LISTEN)
omnssck 5511 scalix 3u IPv4 13681 UDP localhost.internetstarters: scalixns
omnssck 5511 scalix 4u IPv4 13682 UDP internetstarters.nl:scalixn s
omdrs 5515 scalix 4u IPv4 13684 UDP *:x500ms
sxeventse 5526 scalix 4u IPv4 13708 TCP *:5768 (LISTEN)
omslapd 5530 root 8u IPv4 13716 TCP *:ldap (LISTEN)
miniserv. 5768 root 5u IPv4 14304 TCP *:10000 (LISTEN)
miniserv. 5768 root 6u IPv4 14305 UDP *:10000


Thanks,

You must've missed something in the install guide or made a typo (sorry, I'm an enterprise user, I can't say this for sure).

Postgres should be listening on port 5733 not 5433, check you configuration files.

Installed everything again, problem still remains...