This repository was archived by the owner on Jan 23, 2019. It is now read-only.
Database server build not working on Ubuntu Server 15.04 #153
Description
My chef/knife run completes successfully. The server does not start (log output below). Also, when I ssh into my newly created system and 'sudo su - postgres' it seems that I am now the postgres user, but I'm not.
whoami #=> postgres
id -u #=> returns uid for user: uuid
id -g #=> returns gid for group: ssh
The server does not start. Contents of /var/log/postgresql/*.log:
2015-08-12 12:10:51 GMT LOG: database system was shut down at 2015-08-12 12:10:46 GMT
2015-08-12 12:10:51 GMT LOG: MultiXact member wraparound protections are now enabled
2015-08-12 12:10:51 GMT LOG: database system is ready to accept connections
2015-08-12 12:10:51 GMT LOG: autovacuum launcher started
2015-08-12 12:10:51 GMT LOG: incomplete startup packet
2015-08-12 12:11:21 GMT LOG: received fast shutdown request
2015-08-12 12:11:21 GMT LOG: aborting any active transactions
2015-08-12 12:11:21 GMT LOG: autovacuum launcher shutting down
2015-08-12 12:11:21 GMT LOG: shutting down
2015-08-12 12:11:21 GMT LOG: database system is shut down
2015-08-12 12:11:22 GMT FATAL: could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
Some investigation into the referenced key:
postgres@cb-dbtest01:~$ ls -la /etc/ssl/private/ssl-cert-snakeoil.key
-rw-r----- 1 root ssl-cert 1704 Aug 12 08:10 /etc/ssl/private/ssl-cert-snakeoil.key
postgres@cb-dbtest01:~$ cat /etc/group | grep ssl
ssl-cert:x:120:postgres
My recipe/attributes is basically a copy-n-paste from the README... I don't think I'm committing any unnatural acts here. Thoughts?