package postgresql-8.3 failed to install: could not access private key file "server.key": Permission denied

[jmaustpc]

Binary package hint: postgresql-8.3

It comes up with an error saying the permissions are wrong on the postgres folder, yet I deleted the folders in question and then reinstalled postgres and it came back with the same error again.

Kubuntu 9.04

ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 9.04
ErrorMessage: subprocess post-installation script returned error exit status 1
NonfreeKernelModules: wl
Package: postgresql-8.3 8.3.7-1
SourcePackage: postgresql-8.3
Title: package postgresql-8.3 8.3.7-1 failed to install/upgrade: subprocess post-installation script returned error exit status 1
Uname: Linux 2.6.28-13-generic i686

[Martin Pitt (pitti)]

That's the error:
2009-06-20 10:01:30 EST FATAL: could not access private key file "server.key": Permission denied

Please give me the output of these commands:

  id postgres
  ls -ld /etc/ssl/private/
  sudo ls -l /etc/ssl/private/ssl-cert-snakeoil.key

[Wolfhere (bfriedkin)]

same results here this morning on update manager. I used synaptic to remove postgresql. Please provide server key.

[Martin Pitt (pitti)]

Wolfhere, can you please provide the information I asked for in comment 2?

[jmaustpc (jmaustpc)]

Hi Martin

this is the bash shell text from your request in comment #2

user@HP-laptop:~$ id postgres
id: postgres: No such user
user@HP-laptop:~$ ls -ld /etc/ssl/private/
drwx--x--- 2 root ssl-cert 4096 2009-07-12 13:23 /etc/ssl/private/
user@HP-laptop:~$ sudo ls -l /etc/ssl/private/ssl-cert-snakeoil.key
[sudo] password for user:
-rw-r----- 1 root ssl-cert 887 2009-07-12 13:23 /etc/ssl/private/ssl-cert-snakeoil.key
user@HP-laptop:~$

Sorry to take so long to reply, I thought I had some how stuffed up the config so I used Synaptic to do a complete removal including config files and reinstall to hopefully start again - which got me nowhere, so I gave up.

I started a fresh install on a different box and followed some instructions I found via QGIS for setting up postgres for QGIS and it worked on the other machine, so I just gave up on this one.

I don't know if the above is any use to you or not as I have now un-installed the postgresql server packages. Note that I had originally installed the postgis geographic location extentions package to create a database for QGIS, if that makes any difference.

Thank you for your time, I greatly appreciate your efforts.

Jim

[Martin Pitt (pitti)]

> user@HP-laptop:~$ id postgres
> id: postgres: No such user
> [...]
> so I used Synaptic to do a complete removal including config files

Right, this explains the absence of the postgres user. The ssl-cert permissions look correct, so unfortunately I cannot conclude anything from this output any more.

Keeping bug open for Wolfhere, though.

Thank you!

[Jean-Baptiste Lallement (jibel)]

@Wolfhere, if it's still an issue, could you please provide the information requested by Martin ? Thanks.

[Launchpad Janitor (janitor)]

[Expired for postgresql-8.3 (Ubuntu) because there has been no activity for 60 days.]