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

[Stephen Delano < >]

Hi there,

Let me start by asking a few questions:

1. What version of the open source Chef Server are you running. We just recently released an updated version (11.1.3) with some tightened security around PostgreSQL permissions.

2. Where did you get the default password "snakepliskin"? The Chef Server generates the database passwords on the initial reconfigure.

3. (Not a question) Backing up just the SQL database will not be enough to restore your Chef Server to a functional state in a disaster recovery scenario. You'll also need to back up the Bookshelf (cookbook content) data that is stored as files on disk as well as the Solr index.

-Stephen

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.

-- 
Stephen Delano
Software Development Engineer
Opscode, Inc.
1008 Western Avenue
Suite 601
Seattle, WA 98104