Cannot Change PSQL Password During Installation

[jonwatson]

Hi All,

I'm building a Scalix VM using Ubuntu 6.06. The system is headless and therefore no X.

I'm following the Manual Installation procedure here: http://www.scalix.com/wiki/index.php?ti ... _Selection

Everything was going very well (great instructions!) until I hit the section on " Setting up Scalix-Postgres (Scalix 11 only)" (Yes, I am installing Scalix 11.)

There are three script commands in this section:

Code: Select all

cd /opt/scalix-postgres/bin
./sxpsql-init
./sxpsql-setpwd mypassword    # This is a database password you select
./sxpsql-whitelist 127.0.0.1

The first and last commands work as expected, but attempting to set the database password (the second command) fails.

If I attempt to run it as root I get the following error:

Code: Select all

psql: could not connect to server: Permission denied.
Is the server running locally and accepting
connections on the Unix domain socket "/var/opt/scalix/ml/postgresql/data/.s.PSGQL.5.7.33"?

If I attempt to execute the script as a normal user, I get this error:

Code: Select all

chown changing ownership of '/var/opt/scalix/ml/postgres': Operation not permitted.
su: must be run from a terminal.


I am attempting to run the command from the /opt/scalix-postgres/bin directory as:

Code: Select all

./sxpsql-setpwd mungedpassword

Anyone have any idea what's going on?

Thanks!

[Valerion]

Make sure the postgres server is properly running

Code: Select all

/etc/init.d/scalix-postgres start

on my machine

[jonwatson]

Will do, thanks. I would have thought it was running because the other commands excute successfully, however I didn't actually get into the script to look. Perhaps the swtpwd command is the only one of those commands that actually talks to the DB.

I'll give this a whirl when I get back to my VM and post the results.

[bernharf]

Hi all,
I installed Scalix 11 on open SuSE 10.2. Everything is fine so far - but when I try this

Code: Select all

./sxpsql-setpwd mungedpassword

I get something like (I get it in german):

Code: Select all

Database scalix does not exist

Any ideas, what went wrong. I just installed the SuSE rpms.


Thank you

[florian]

At this point, we haven't validated the manual install instructíons for non-debian platforms.

For SuSE-based systems, we recommend using openSUSE 10.1 and just run the installer. This will get you going in less than 10 minutes.

Otherwise, your main problem might not be what you're looking at right now but the fact that the server binaries have not been compiled on a openSUSE 10.2 system yet und you might run into trouble there.

Your particular issue is caused by the fact that the debian deb-package postinst script for scalix-postgres creates the database. it uses something like sxpsql-initdb for this. The RPM doesn't and the command is called by the installer when that's being used.

Florian.