Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
[2017-09-16T16:09:26-05:00] INFO: Retrying execution of runit_service[postgresql], 18 attempt(s) left
(up to date)
* enterprise_pg_database[chef_compliance] action create[2017-09-16T16:09:28-05:00] INFO: Processing enterprise_pg_database[chef_compliance] action create (chef-compliance::_postgresql-enable line 47)
* execute[create_database_chef_compliance] action run[2017-09-16T16:09:28-05:00] INFO: Processing execute[create_database_chef_compliance] action run (/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/enterprise/resources/pg_database.rb line 22)
[execute] createdb: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[2017-09-16T16:09:28-05:00] INFO: Retrying execution of execute[create_database_chef_compliance], 29 attempt(s) left
[2017-09-16T16:09:30-05:00] INFO: execute[create_database_chef_compliance] ran successfully
- execute createdb --template template0 --encoding UTF-8 chef_compliance
* enterprise_pg_user[chef_compliance] action create[2017-09-16T16:09:30-05:00] INFO: Processing enterprise_pg_user[chef_compliance] action create (chef-compliance::_postgresql-enable line 52)
* execute[create_postgres_user_chef_compliance] action run[2017-09-16T16:09:30-05:00] INFO: Processing execute[create_postgres_user_chef_compliance] action run (/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/enterprise/providers/pg_user.rb line 19)
[execute] CREATE ROLE
[2017-09-16T16:09:31-05:00] INFO: execute[create_postgres_user_chef_compliance] ran successfully
- execute psql --dbname template1 --command "CREATE USER chef_compliance WITH ENCRYPTED PASSWORD '0228399695858efbe882bf4544458edd5acb4c0204f28e95ae70157e85c137a3e5294dc397f9d50d3b3e321b47121a9b939c';"
* enterprise_pg_user[chef_compliance_ro] action create[2017-09-16T16:09:31-05:00] INFO: Processing enterprise_pg_user[chef_compliance_ro] action create (chef-compliance::_postgresql-enable line 58)
* execute[create_postgres_user_chef_compliance_ro] action run[2017-09-16T16:09:31-05:00] INFO: Processing execute[create_postgres_user_chef_compliance_ro] action run (/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/enterprise/providers/pg_user.rb line 19)
[execute] CREATE ROLE
[2017-09-16T16:09:31-05:00] INFO: execute[create_postgres_user_chef_compliance_ro] ran successfully
- execute psql --dbname template1 --command "CREATE USER chef_compliance_ro WITH ENCRYPTED PASSWORD '364fa265a3816992f9f8e85543c81651f7cb3acd5e3fdde7d067f113851c2fafe7b05617a1a31bccab6c9eff48743b91d532';"
* chef_compliance_pg_sqitch[/opt/chef-compliance/embedded/service/core/schema] action deploy[2017-09-16T16:09:31-05:00] INFO: Processing chef_compliance_pg_sqitch[/opt/chef-compliance/embedded/service/core/schema] action deploy (chef-compliance::_postgresql-enable line 65)
- Deploying schema from /opt/chef-compliance/embedded/service/core/schema
* execute[sqitch_deploy_/opt/chef-compliance/embedded/service/core/schema] action run[2017-09-16T16:09:31-05:00] INFO: Processing execute[sqitch_deploy_/opt/chef-compliance/embedded/service/core/schema] action run (/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/chef-compliance/providers/pg_sqitch.rb line 11)
[execute] FATAL: no pg_hba.conf entry for host "192.168.1.201", user "chef-pgsql", database "chef_compliance", SSL off
================================================================================
Error executing action `run` on resource 'execute[sqitch_deploy_/opt/chef-compliance/embedded/service/core/schema]'
================================================================================
Mixlib::ShellOut::ShellCommandFailed
------------------------------------
Expected process to exit with [0, 1], but received '2'
---- Begin output of sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify ----
STDOUT:
STDERR: FATAL: no pg_hba.conf entry for host "192.168.1.201", user "chef-pgsql", database "chef_compliance", SSL off
---- End output of sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify ----
Ran sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify returned 2
Cookbook Trace:
---------------
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:78:in `run_action'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block (2 levels) in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `each'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:105:in `converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:78:in `run_action'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block (2 levels) in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `each'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:105:in `converge'
Resource Declaration:
---------------------
# In /opt/chef-compliance/embedded/cookbooks/cache/cookbooks/chef-compliance/providers/pg_sqitch.rb
11: execute "sqitch_deploy_#{new_resource.name}" do
12: command <<-EOM.gsub(/\s+/," ").strip!
13: sqitch --engine pg
14: --db-name #{new_resource.database}
15: --db-host #{new_resource.hostname}
16: --db-port #{new_resource.port}
17: --db-user #{new_resource.username}
18: --top-dir #{new_resource.name}
19: deploy #{target} --verify
20: EOM
21: environment "PERL5LIB" => "", # force us to use omnibus perl
22: "PGPASSWORD" => new_resource.password
23:
24: # Sqitch Return Codes
25: # 0 - when changes are applied
26: # 1 - when everything is ok but no changes were made
27: # 2(+?) - when an error occurs.
28: returns [0,1]
29: end
30: end
Compiled Resource:
------------------
# Declared in /opt/chef-compliance/embedded/cookbooks/cache/cookbooks/chef-compliance/providers/pg_sqitch.rb:11:in `block (2 levels) in class_from_file'
execute("sqitch_deploy_/opt/chef-compliance/embedded/service/core/schema") do
action [:run]
retries 0
retry_delay 2
default_guard_interpreter :execute
command "sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify"
backup 5
environment {"PERL5LIB"=>"", "PGPASSWORD"=>"2cea0983529f4e11ba6febb5efcce5369c6732164ff1e025c8cccbb5f851b4546c47b62e6fbe78a6263475074849fc949010"}
returns [0, 1]
declared_type :execute
cookbook_name "chef-compliance"
end
Platform:
---------
x86_64-linux
[2017-09-16T16:09:31-05:00] INFO: Running queued delayed notifications before re-raising exception
================================================================================
Error executing action `deploy` on resource 'chef_compliance_pg_sqitch[/opt/chef-compliance/embedded/service/core/schema]'
================================================================================
Mixlib::ShellOut::ShellCommandFailed
------------------------------------
execute[sqitch_deploy_/opt/chef-compliance/embedded/service/core/schema] (/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/chef-compliance/providers/pg_sqitch.rb line 11) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0, 1], but received '2'
---- Begin output of sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify ----
STDOUT:
STDERR: FATAL: no pg_hba.conf entry for host "192.168.1.201", user "chef-pgsql", database "chef_compliance", SSL off
---- End output of sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify ----
Ran sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify returned 2
Cookbook Trace:
---------------
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:78:in `run_action'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block (2 levels) in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `each'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:105:in `converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:78:in `run_action'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block (2 levels) in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `each'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:106:in `block in converge'
/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/compat_resource/files/lib/chef_compat/monkeypatches/chef/runner.rb:105:in `converge'
Resource Declaration:
---------------------
# In /opt/chef-compliance/embedded/cookbooks/cache/cookbooks/chef-compliance/recipes/_postgresql-enable.rb
65: chef_compliance_pg_sqitch '/opt/chef-compliance/embedded/service/core/schema' do
66: hostname postgres['vip']
67: port postgres['port']
68: username postgres['username']
69: password postgres['db_superuser_password']
70: database 'chef_compliance'
71: end
72:
Compiled Resource:
------------------
# Declared in /opt/chef-compliance/embedded/cookbooks/cache/cookbooks/chef-compliance/recipes/_postgresql-enable.rb:65:in `from_file'
chef_compliance_pg_sqitch("/opt/chef-compliance/embedded/service/core/schema") do
action [:deploy]
retries 0
retry_delay 2
default_guard_interpreter :default
declared_type :chef_compliance_pg_sqitch
cookbook_name "chef-compliance"
recipe_name "_postgresql-enable"
hostname "127.0.0.1"
port 5432
username "chef-pgsql"
password "2cea0983529f4e11ba6febb5efcce5369c6732164ff1e025c8cccbb5f851b4546c47b62e6fbe78a6263475074849fc949010"
database "chef_compliance"
end
Platform:
---------
x86_64-linux
[2017-09-16T16:09:31-05:00] INFO: Running queued delayed notifications before re-raising exception
[2017-09-16T16:09:31-05:00] INFO: enterprise_pg_cluster[/var/opt/chef-compliance/postgresql/9.5/data] sending restart action to runit_service[postgresql] (delayed)
* runit_service[postgresql] action restart[2017-09-16T16:09:31-05:00] INFO: Processing runit_service[postgresql] action restart (chef-compliance::_postgresql-enable line 43)
(up to date)
[2017-09-16T16:09:31-05:00] INFO: template[/var/log/chef-compliance/postgresql/config] sending run action to execute[restart_postgresql_log_service] (delayed)
* execute[restart_postgresql_log_service] action run[2017-09-16T16:09:31-05:00] INFO: Processing execute[restart_postgresql_log_service] action run (chef-compliance::_postgresql-enable line 19)
[execute] ok: run: /opt/chef-compliance/sv/postgresql/log: (pid 28638) 0s
[2017-09-16T16:09:32-05:00] INFO: execute[restart_postgresql_log_service] ran successfully
- execute /opt/chef-compliance/embedded/bin/sv restart /opt/chef-compliance/sv/postgresql/log
Running handlers:
[2017-09-16T16:09:32-05:00] ERROR: Running exception handlers
Running handlers complete
[2017-09-16T16:09:32-05:00] ERROR: Exception handlers complete
Chef Client failed. 21 resources updated in 13 seconds
[2017-09-16T16:09:32-05:00] FATAL: Stacktrace dumped to /opt/chef-compliance/embedded/cookbooks/cache/chef-stacktrace.out
[2017-09-16T16:09:32-05:00] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
[2017-09-16T16:09:32-05:00] FATAL: Mixlib::ShellOut::ShellCommandFailed: chef_compliance_pg_sqitch[/opt/chef-compliance/embedded/service/core/schema] (chef-compliance::_postgresql-enable line 65) had an error: Mixlib::ShellOut::ShellCommandFailed: execute[sqitch_deploy_/opt/chef-compliance/embedded/service/core/schema] (/opt/chef-compliance/embedded/cookbooks/cache/cookbooks/chef-compliance/providers/pg_sqitch.rb line 11) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0, 1], but received '2'
---- Begin output of sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify ----
STDOUT:
STDERR: FATAL: no pg_hba.conf entry for host "192.168.1.201", user "chef-pgsql", database "chef_compliance", SSL off
---- End output of sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify ----
Ran sqitch --engine pg --db-name chef_compliance --db-host 127.0.0.1 --db-port 5432 --db-user chef-pgsql --top-dir /opt/chef-compliance/embedded/service/core/schema deploy --verify returned 2
@som3guy
Copy link
Author

som3guy commented Sep 18, 2017

did not fix, instead I just used automate in opsworks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment