Postgresql 9.x can't start due to missing SSL certificates

[hufman]

The attributes file sets ssl=on in the postgresql.conf file, but it does not create a server.key and server.pem file in the data directory. I am on Debian, so my previous fix has been to recreate the server.key and server.pem symlink to the apppropriate snakeoil files in /etc/ssl. Now I add the ssl_cert_file and ssl_key_file attributes to the environment to point to the /etc/ssl snakeoil files.

[vmihailenco]

Same situation here on Ubuntu 12.04.

[orangethunder]

Also on Ubuntu 12.04, Postgres 9.3. I have a similar fix:

node.default["postgresql"]["config"]["ssl_cert_file"] = "/etc/ssl/certs/ssl-cert-snakeoil.pem"
node.default["postgresql"]["config"]["ssl_key_file"] = "/etc/ssl/private/ssl-cert-snakeoil.key"

Based on:

https://github.com/escobera/chef-postgresql/commit/4be67561ecb4949d1930980d5fc5c8e90fa03c47

[thmsobrmlr]

We should add these to default attributes. Done in pull request.

[michaelkirk]

Is this still an issue?

It looks like this was solved with #116

[thmsobrmlr]

@michaelkirk Yes it was solved with pull request #116. The issue can be closed.

[slyness]

Resolved. Closing.

[lock]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.