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:
root@chef-server:~# /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.
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.
Where did you get the default password "snakepliskin"? The Chef Server
generates the database passwords on the initial reconfigure.
(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.
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:
root@chef-server:~# /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
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:
root@chef-server:~# /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.
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:
root@chef-server:~# /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.
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.
Where did you get the default password "snakepliskin"? The Chef Server
generates the database passwords on the initial reconfigure.
(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.
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:
root@chef-server:~# /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