Hello
Am trying to install openbravoERP (it needs postgresql) on Kubuntu 8.4.
Through adept manager, I installed postgresql 8.3.
Initially it would not recognise postgres as a user - following tips on the
internet
I had to change the following line in the folder /etc/postgres/8.3/main
and in file pg_hba.conf - replaced
the line 'local all all ident sameuser' with 'local all all md5'
Though the K Menu ->SystemServices->Advanced->SystemServices I notice
that though postgres is part of the init.d script to start automatically on
boot, it is not running.
When I try to restart it, I get the following message:
* Starting PostgreSQL 8.3 database server
* The PostgreSQL server failed to start. Please check the log output:
2008-06-09 18:39:40 IST FATAL: could not access private key file "server.key":
Permission denied
...fail!
I googled on the above and searched postgresforum to come across your post here
... and followed some
instructions on changing the permissions on the server.key file under
/etc/ssl_cert/private. However
it did not work for me.
Here is a clip of my window:
======================
[EMAIL PROTECTED]:/var/lib/postgresql/8.3/main# chmod 740 server.key
[EMAIL PROTECTED]:/var/lib/postgresql/8.3/main# ls -l
total 40
drwx------ 5 postgres postgres 4096 2008-06-07 18:21 base
drwx------ 2 postgres postgres 4096 2008-06-09 15:56 global
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_clog
drwx------ 4 postgres postgres 4096 2008-06-07 18:21 pg_multixact
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_subtrans
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_tblspc
drwx------ 2 postgres postgres 4096 2008-06-07 18:21 pg_twophase
-rw------- 1 postgres postgres 4 2008-06-07 18:21 PG_VERSION
drwx------ 3 postgres postgres 4096 2008-06-07 18:21 pg_xlog
-rw------- 1 postgres postgres 125 2008-06-09 15:15 postmaster.opts
lrwxrwxrwx 1 root root 31 2008-06-07 18:21 root.crt ->
/etc/postgresql-common/root.crt
lrwxrwxrwx 1 root root 36 2008-06-07 18:21 server.crt ->
/etc/ssl/certs/ssl-cert-snakeoil.pem
lrwxrwxrwx 1 root root 38 2008-06-07 18:21 server.key ->
/etc/ssl/private/ssl-cert-snakeoil.key
[EMAIL PROTECTED]:/var/lib/postgresql/8.3/main# ls -l
/etc/ssl/private/ssl-cert-snakeoil.key
-rwxr----- 1 root ssl-cert 891 2008-05-28 16:19
/etc/ssl/private/ssl-cert-snakeoil.key
[EMAIL PROTECTED]:/var/lib/postgresql/8.3/main# /etc/init.d/postgresql-8.3 start
* Starting PostgreSQL 8.3 database server
* The PostgreSQL server failed to start. Please check the
log output:
2008-06-09 18:34:12 IST FATAL: could not access private key file "server.key":
Permission denied
==================
what should I do to get postgresql 8.3 running on my system?
Thanks
Ddrake
PS: Hardware config (Acer aspire 4710 - core2duo, 2GB RAM, 160 GB hd)
--
/etc/ssl/private/ssl-cert-snakeoil.key is world readable
https://bugs.launchpad.net/bugs/225125
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
