Created
September 16, 2017 21:10
-
-
Save jmi4/8b0dadc656cc5a87effc40ddb0318f48 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
did not fix, instead I just used automate in opsworks