[chef] Re: Backing up Open Source Chef Server 11

[DV < >]

The following two files might be helpful in determining what are the generated passwords:

/etc/chef-server/chef-server-running.json

/etc/chef-server/chef-server-secrets.json

On Wed, Jul 2, 2014 at 1:14 PM, Matthew Hollingdale < " target="_blank"> > wrote:

ohai Chefs,

I'm wanting to perform an sql backup on my chef server. I used the omnibus installer to install the service and left all the attributes at default.

Using the default password ("snakepliskin") will not get me in

/opt/chef-server/embedded/bin/pg_dump -h localhost -p 5432 -U opscode_chef  > chefserver_20140702.sql

Password:

pg_dump: [archiver (db)] connection to database "opscode_chef" failed: FATAL:  password authentication failed for user "opscode_chef"

Even a console connection fails:

:~# /opt/chef-server/embedded/bin/psql -h 127.0.0.1 -p 5432 -U opscode_chef

Password for user opscode_chef:

psql: FATAL:  password authentication failed for user "opscode_chef"

I know there are a bunch of cool gems for knife that can use the API to get everything, but I'd like to keep it simple.

Any ideas?

Thanks in advance.

--
Best regards, Dmitriy V.