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?)
Hi Lukasz and Martin
Thanks a lot for your quick response.
Here is the output desired: ------- ------- ----- snakeoil. key ------- ------- ------- ---
-------
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-
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 ======= ======= ======= = snakeoil. key permissions?)
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-
thanks once more
Mohan