I am facing issue while configuring chef automate. I have attached error in this mail can you please look into it.
Thanks,
Vishnu
Called from /var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/libraries/db_helpers.rb:38:in `db_unix_con’
[2017-09-19T08:14:00-04:00] WARN: Error from postgresql: FATAL: no pg_hba.conf entry for host “[local]”, user “chef-pgsql”, database “template1”, SSL off. Retrying after 4s. Retries remaining: 2
[2017-09-19T08:14:04-04:00] WARN: Error from postgresql: FATAL: no pg_hba.conf entry for host “[local]”, user “chef-pgsql”, database “template1”, SSL off. Retrying after 8s. Retries remaining: 1
[2017-09-19T08:14:12-04:00] WARN: Error from postgresql: FATAL: no pg_hba.conf entry for host “[local]”, user “chef-pgsql”, database “template1”, SSL off. Retrying after 16s. Retries remaining: 0
[2017-09-19T08:14:28-04:00] ERROR: Error from postgresql: FATAL: no pg_hba.conf entry for host “[local]”, user “chef-pgsql”, database “template1”, SSL off. Retries have been exhausted.
================================================================================
Error executing action `create` on resource 'delivery_db_user[delivery]'
================================================================================
PG::ConnectionBad
-----------------
FATAL: no pg_hba.conf entry for host "[local]", user "chef-pgsql", database "template1", SSL off
Cookbook Trace:
---------------
/var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/libraries/db_helpers.rb:43:in `initialize'
/var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/libraries/db_helpers.rb:43:in `new'
/var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/libraries/db_helpers.rb:43:in `block in db_unix_con'
/var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/libraries/db_helpers.rb:55:in `with_retries'
/var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/libraries/db_helpers.rb:38:in `db_unix_con'
/var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/resources/db_user.rb:15:in `block in class_from_file'
Resource Declaration:
---------------------
# In /var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/recipes/delivery_database.rb
7: delivery_db_user delivery['sql_user'] do
8: db_username delivery['sql_user']
9: db_password delivery['sql_password']
10: superuser false
11: username postgresql['username']
12: end
13:
Compiled Resource:
------------------
# Declared in /var/opt/delivery/embedded/cookbooks/cache/cookbooks/delivery/recipes/delivery_database.rb:7:in `from_file'
delivery_db_user("delivery") do
action [:create]
retries 0
retry_delay 2
default_guard_interpreter :default
declared_type :delivery_db_user
cookbook_name "delivery"
recipe_name "delivery_database"
username "chef-pgsql"
db_username "delivery"
db_password "b71d1bbe51427ec536c1fe742f029aabd08da8c5794e0696865857bf22a108776a2d093d21de8d667acf8e81fc58c045e272"
superuser false
database "template1"
end
System Info:
------------
chef_version=12.21.1
platform=oracle
platform_version=7.1
ruby=ruby 2.2.5p319 (2016-04-26 revision 54774) [x86_64-linux]
program_name=chef-client worker: ppid=12603;start=08:13:46;
executable=/opt/delivery/embedded/bin/chef-client
[2017-09-19T08:14:28-04:00] INFO: Running queued delayed notifications before re-raising exception
Running handlers:
[2017-09-19T08:14:28-04:00] ERROR: Running exception handlers
Running handlers complete
[2017-09-19T08:14:28-04:00] ERROR: Exception handlers complete
Chef Client failed. 6 resources updated in 42 seconds
[2017-09-19T08:14:28-04:00] FATAL: Stacktrace dumped to /var/opt/delivery/embedded/cookbooks/cache/chef-stacktrace.out
[2017-09-19T08:14:28-04:00] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
[2017-09-19T08:14:28-04:00] ERROR: delivery_db_user[delivery] (delivery::delivery_database line 7) had an error: PG::ConnectionBad: FATAL: no pg_hba.conf entry for host “[local]”, user “chef-pgsql”, database “template1”, SSL off
[2017-09-19T08:14:28-04:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1)
Users of this Automate server may elect to share anonymized usage data with
Chef Software, Inc. Chef uses this shared data to improve Automate.
Please visit https://chef.io/privacy-policy for more information about the
information Chef collects, and how that information is used.