[campcaster-support] [Campcaster Support] Re: postgresql error

[Ferenc Gerlits]

phorum at code.campware.org wrote on 09/18/2007 05:35 PM:
> Author: hammer v2
> Link:  https://www.campware.org/phorum/read.php?20,5733,5734#msg-5734
> --------------------------------------------------------------------------------
> Setting up postgresql-8.2 (8.2.3-3) ...
>  * Starting PostgreSQL 8.2 database server                                       * The PostgreSQL server failed to start. Please check the log output:
> 2007-09-18 22:34:53 ICT FATAL:  unsafe permissions on private key file "server.key"
> 2007-09-18 22:34:53 ICT DETAIL:  File must be owned by the database user or root, must have no write permission for "group", and must have no permissions for "other".
>                                                                          
> invoke-rc.d: initscript postgresql-8.2, action "start" failed.

I don't know any more about this than you, but I can read the error 
message for you, if that helps. :)
Something messed up the permissions of the "server.key" file in your 
Postgresql data directory (which is /var/lib/postgresql/8.2/main/ on 
Ubuntu Feisty).  This is a softlink to the file 
/etc/ssl/private/ssl-cert-snakeoil.key.  I don't know which package 
generated this (could be libssl0.9.8, but I'm not sure); if you can find 
that out, the cleanest solution would be to reinstall that package.
Short of that, you can fix the permissions for the file manually; the 
error message above tells you what it should look like.  Mine has these 
permissions: -rw-r----- root ssl-cert.  Afterwards, try to fix the state 
of your packages with "sudo apt-get install -f".  If it complains about 
another file, fix that one as well, etc.
Ferenc