Comment 9 for bug 225125

Revision history for this message
Mohan (mohan-eai-san) wrote :

Hi Lukasz and Martin

 Thanks a lot for your quick response.

Here is the output desired:
--------------------------
root@Ananda:/# ls -ld /etc/ssl/private/
drwxr-x--- 2 root ssl-cert 4096 2008-05-28 16:19 /etc/ssl/private/
root@Ananda:/# ls -l /etc/ssl/private/
total 4
-rwxr----- 1 root ssl-cert 891 2008-05-28 16:19 ssl-cert-snakeoil.key
root@Ananda:/#
-------------------------------

Just FYI, my needs have changed - openbravo 2.35MP1 the current release
works only with Postgresql 8.2 and not 8.3. So I am forced to purge 8.3 installation.
I have not been a postgres user/admin. I have run into an interesting problem pattern -
with postgres on kubuntu 8.04 - thought I should share that as well:
------------------------
root@Ananda:/# psql -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
root@Ananda:/# su postgres
postgres@Ananda:/$ psql -U postgres
Welcome to psql 8.2.7, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# \q
postgres@Ananda:/$ exit
exit
root@Ananda:/# psql -U postgres
psql: FATAL: Ident authentication failed for user "postgres"
=============================
Question: I thought 'psql -U postgres' should work irrespective of who
is invoking it ( I expected it to prompt me for the password).
Is this behaviour odd? Has this got to do anything with
the authentication (or the ssl-cert-snakeoil.key permissions?)

thanks once more
Mohan