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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs