postgresql: FATAL: could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
Hi there,
As I use this recipe to install postgresql, I run into this error:
FATAL: could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
I have tried all the recommended solutions to solve it, including changing the owner and group of the key to postgres. Nothing works. To verify that it doesn’t work even with that, I ran the following command on the key:
sudo -u postgres cat ssl-cert-snakeoil.key
The result was:
cat: ssl-cert-snakeoil.key: Permission denied
(I am running Ubuntu 14.04 with Vagrant. Using passenger/ruby-20 image and Docker as provider.)
About this issue
- Original URL
- State: closed
- Created 10 years ago
- Comments: 23
Commits related to this issue
- - https://github.com/hw-cookbooks/postgresql/issues/156 — committed to andreycizov/docker-postgres by andreycizov 10 years ago
- Merge pull request #156 from Odaeus/patch-1 Correct mod_basic/digest recipe names in README — committed to chris-rock/postgresql by drpebcak 10 years ago
hmm, in my case, solution was to add
postgrestossl-certgroup. Not quite sure this was the right thing to do, but it did work.was the missing ssl-cert group for the postgres user here on debian (usermod postgres -g ssl-cert)
As far as I know users that wants to access files in
/etc/ssl/private/needs to be in the groupssl-certon Ubuntu systems. Have you checked that?