Chef automate error while configuring


#1

I am facing issue while configuring chef automate. I have attached error in this mail can you please look into it.

Thanks,
Vishnu


#2

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.