...after running gitlab-reconfigure: User was created successfully, mapping in pg_ident.conf is there... But pgsql haven't been restarted. So Chef failed. After running again succeeded.
Recipe: gitlab::postgresql * group[gitlab-psql] action create (up to date) * user[gitlab-psql] action create (up to date) * directory[/var/opt/gitlab/postgresql] action create (up to date) * directory[/var/opt/gitlab/postgresql/data] action create (up to date) * directory[/var/log/gitlab/postgresql] action create (up to date) * link[/var/opt/gitlab/postgresql/data] action create (skipped due to not_if) * file[/var/opt/gitlab/postgresql/.profile] action create (up to date) * service[procps] action nothing (skipped due to action :nothing) * template[/etc/sysctl.d/90-postgresql.conf] action create (up to date) * execute[/opt/gitlab/embedded/bin/initdb -D /var/opt/gitlab/postgresql/data -E UTF8] action run (skipped due to not_if) * template[/var/opt/gitlab/postgresql/data/postgresql.conf] action create (up to date) * template[/var/opt/gitlab/postgresql/data/pg_hba.conf] action create (up to date) * template[/var/opt/gitlab/postgresql/data/pg_ident.conf] action create - update content in file /var/opt/gitlab/postgresql/data/pg_ident.conf from a0ea2a to 5b3bd4 --- /var/opt/gitlab/postgresql/data/pg_ident.conf 2014-09-14 13:14:59.199049759 +0200 +++ /tmp/chef-rendered-template20141107-29492-1vx46eq 2014-11-07 19:06:33.625193496 +0100 @@ -41,6 +41,7 @@ # MAPNAME SYSTEM-USERNAME PG-USERNAME gitlab git gitlab +gitlab gitlab-ci gitlab_ci # Default to a 1-1 mapping between system usernames and Postgres usernames gitlab /^(.*)$ \1 * directory[/opt/gitlab/sv/postgresql] action create (up to date) * directory[/opt/gitlab/sv/postgresql/log] action create (up to date) * directory[/opt/gitlab/sv/postgresql/log/main] action create (up to date) * template[/opt/gitlab/sv/postgresql/run] action create (up to date) * template[/opt/gitlab/sv/postgresql/log/run] action create (up to date) * template[/var/log/gitlab/postgresql/config] action create (up to date) * ruby_block[reload postgresql svlogd configuration] action nothing (skipped due to action :nothing) * file[/opt/gitlab/sv/postgresql/down] action delete (up to date) * directory[/opt/gitlab/sv/postgresql/control] action create (up to date) * template[/opt/gitlab/sv/postgresql/control/t] action create (up to date) * link[/opt/gitlab/init/postgresql] action create (up to date) * link[/opt/gitlab/service/postgresql] action create (up to date) * ruby_block[supervise_postgresql_sleep] action run (skipped due to not_if) * service[postgresql] action nothing (skipped due to action :nothing) * execute[create gitlab database user] action run (skipped due to not_if) * execute[create gitlabhq_production database] action run (skipped due to not_if) * execute[create gitlab_ci database user] action run - execute /opt/gitlab/embedded/bin/psql --port 5432 -d template1 -c "CREATE USER gitlab_ci" * execute[create gitlab_ci_production database] action run - execute /opt/gitlab/embedded/bin/createdb --port 5432 -O gitlab_ci gitlab_ci_production Recipe: gitlab::database_migrations * execute[initialize gitlab-ci database] action run ================================================================================ Error executing action `run` on resource 'execute[initialize gitlab-ci database]' ================================================================================ Mixlib::ShellOut::ShellCommandFailed ------------------------------------ Expected process to exit with [0], but received '1' ---- Begin output of /opt/gitlab/bin/gitlab-ci-rake setup ---- STDOUT: -- enable_extension("plpgsql") STDERR: FATAL: Peer authentication failed for user "gitlab_ci" /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in `initialize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in `new' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in `connect' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:556:in `initialize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `new' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/postgresql_adapter.rb:41:in `postgresql_connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout' /opt/gitlab/embedded/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection' /opt/gitlab/embedded/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_handling.rb:79:in `retrieve_connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/connection_handling.rb:53:in `connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/postgresql_database_tasks.rb:8:in `connection' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/postgresql_database_tasks.rb:17:in `create' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/database_tasks.rb:73:in `create' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/database_tasks.rb:87:in `block in create_current' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/database_tasks.rb:183:in `block in each_current_configuration' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/database_tasks.rb:182:in `each' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/database_tasks.rb:182:in `each_current_configuration' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/tasks/database_tasks.rb:86:in `create_current' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.0.10/lib/active_record/railties/databases.rake:20:in `block (2 levels) in <top (required)>' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:240:in `call' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:240:in `block in execute' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:235:in `each' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:235:in `execute' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:172:in `invoke_with_call_chain' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:201:in `block in invoke_prerequisites' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:199:in `each' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:199:in `invoke_prerequisites' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:178:in `block in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:172:in `invoke_with_call_chain' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:201:in `block in invoke_prerequisites' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:199:in `each' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:199:in `invoke_prerequisites' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:178:in `block in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:172:in `invoke_with_call_chain' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:165:in `invoke' /opt/gitlab/embedded/service/gitlab-ci/lib/tasks/setup.rake:7:in `setup_db' /opt/gitlab/embedded/service/gitlab-ci/lib/tasks/setup.rake:3:in `block in <top (required)>' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:240:in `call' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:240:in `block in execute' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:235:in `each' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:235:in `execute' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain' /opt/gitlab/embedded/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:172:in `invoke_with_call_chain' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/task.rb:165:in `invoke' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:150:in `invoke_task' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:106:in `block (2 levels) in top_level' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:106:in `each' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:106:in `block in top_level' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:115:in `run_with_threads' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:100:in `top_level' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:78:in `block in run' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:176:in `standard_exception_handling' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/lib/rake/application.rb:75:in `run' /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/rake-10.3.2/bin/rake:33:in `<top (required)>' /opt/gitlab/embedded/service/gem/ruby/2.1.0/bin/rake:23:in `load' /opt/gitlab/embedded/service/gem/ruby/2.1.0/bin/rake:23:in `<main>' Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "database"=>"gitlab_ci_production", "pool"=>10, "username"=>"gitlab_ci", "password"=>nil, "host"=>nil, "port"=>5432, "socket"=>nil} rake aborted! PG::ConnectionBad: FATAL: Peer authentication failed for user "gitlab_ci" Tasks: TOP => db:schema:load (See full trace by running task with --trace) ---- End output of /opt/gitlab/bin/gitlab-ci-rake setup ---- Ran /opt/gitlab/bin/gitlab-ci-rake setup returned 1 Resource Declaration: --------------------- # In /opt/gitlab/embedded/cookbooks/gitlab/recipes/database_migrations.rb 26: execute "initialize gitlab-ci database" do 27: command "/opt/gitlab/bin/gitlab-ci-rake setup" 28: action :nothing 29: end 30: Compiled Resource: ------------------ # Declared in /opt/gitlab/embedded/cookbooks/gitlab/recipes/database_migrations.rb:26:in `from_file' execute("initialize gitlab-ci database") do action [:nothing] retries 0 retry_delay 2 guard_interpreter :default command "/opt/gitlab/bin/gitlab-ci-rake setup" backup 5 returns 0 cookbook_name :gitlab recipe_name "database_migrations" end Recipe: gitlab::gitlab-ci * execute[clear the gitlab-ci cache] action run - execute /opt/gitlab/bin/gitlab-ci-rake cache:clear Recipe: gitlab::database_migrations * bash[migrate gitlab-ci database] action run ================================================================================ Error executing action `run` on resource 'bash[migrate gitlab-ci database]' ================================================================================ Mixlib::ShellOut::ShellCommandFailed ------------------------------------ Expected process to exit with [0], but received '1' ---- Begin output of "bash" "/tmp/chef-script20141107-29492-1onu98c" ---- STDOUT: rake aborted! PG::ConnectionBad: FATAL: Peer authentication failed for user "gitlab_ci" Tasks: TOP => db:migrate (See full trace by running task with --trace) STDERR: ---- End output of "bash" "/tmp/chef-script20141107-29492-1onu98c" ---- Ran "bash" "/tmp/chef-script20141107-29492-1onu98c" returned 1 Resource Declaration: --------------------- # In /opt/gitlab/embedded/cookbooks/gitlab/definitions/migrate_database.rb 19: bash "migrate #{params[:name]} database" do 20: code <<-EOH 21: set -e 22: log_file="/tmp/#{params[:name]}-db-migrate-$(date +%s)-$$/output.log" 23: umask 077 24: mkdir $(dirname ${log_file}) 25: #{params[:command]} 2>& 1 | tee ${log_file} 26: exit ${PIPESTATUS[0]} 27: EOH 28: action params[:action] 29: end 30: end Compiled Resource: ------------------ # Declared in /opt/gitlab/embedded/cookbooks/gitlab/definitions/migrate_database.rb:19:in `block in from_file' bash("migrate gitlab-ci database") do params {:command=>"/opt/gitlab/bin/gitlab-ci-rake db:migrate", :action=>:nothing, :name=>"gitlab-ci"} action [:nothing] retries 0 retry_delay 2 guard_interpreter :default command "\"bash\" \"/tmp/chef-script20141107-29492-1onu98c\"" backup 5 returns 0 code " set -e\n log_file=\"/tmp/gitlab-ci-db-migrate-$(date +%s)-$$/output.log\"\n umask 077\n mkdir $(dirname ${log_file})\n /opt/gitlab/bin/gitlab-ci-rake db:migrate 2>& 1 | tee ${log_file}\n exit ${PIPESTATUS[0]}\n" interpreter "bash" cookbook_name :gitlab recipe_name "database_migrations" end Recipe: gitlab::ci-redis * ruby_block[reload ci-redis svlogd configuration] action create - execute the ruby block reload ci-redis svlogd configuration Recipe: gitlab::postgresql * service[postgresql] action restart - restart service service[postgresql] Running handlers: [2014-11-07T19:06:59+01:00] ERROR: Running exception handlers Running handlers complete [2014-11-07T19:06:59+01:00] ERROR: Exception handlers complete [2014-11-07T19:06:59+01:00] FATAL: Stacktrace dumped to /opt/gitlab/embedded/cookbooks/cache/chef-stacktrace.out Chef Client failed. 51 resources updated in 40.023985095 seconds [2014-11-07T19:06:59+01:00] ERROR: Chef::Exceptions::MultipleFailures [2014-11-07T19:06:59+01:00] FATAL: Chef::Exceptions::ChildConvergeError: Chef run process exited unsuccessfully (exit code 1) -- You received this message because you are subscribed to the Google Groups "GitLab" group. To unsubscribe from this group and stop receiving emails from it, send an email to gitlabhq+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/gitlabhq/b3bfc165-bf53-4da3-a7fe-f799201092c5%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.