Chef-reporting database problems after installation

Chef Infra (archive)
1

Hi,
I'm trying for several days to install and run chef-reporting. Install was easy, but reporting service is not working, and in opscode-reporting logs i found:

Undefined:Undefined#Undefined [error] <0.134.0> CRASH REPORT Process <0.134.0> with 0 neighbours exited with reason: invalid_password in gen_server:init_it/6 line 320
Undefined:Undefined#Undefined [error] <0.109.0> pool 'sqerl' failed to start member: {error,invalid_password}
Undefined:Undefined#Undefined [error] <0.139.0> Unable to start database connection: invalid_password
Undefined:Undefined#Undefined [error] <0.107.0> Supervisor pooler_sqerl_member_sup had child sqerl_client started with {sqerl_client,start_link,undefined} at <0.134.0> exit with reason invalid_password in context child_terminated

and

Undefined:Undefined#Undefined [error] <0.517.0> gen_server <0.517.0> terminated with reason: socket_closed_unexpectedly
Undefined:Undefined#Undefined [error] <0.517.0> CRASH REPORT Process <0.517.0> with 0 neighbours exited with reason: socket_closed_unexpectedly in gen_server:terminate/6 line 744
Undefined:Undefined#Undefined [error] <0.515.0> Supervisor {<0.515.0>,amqp_connection_sup} had child at module undefined at <0.517.0> exit with reason socket_closed_unexpectedly in context child_terminated
Undefined:Undefined#Undefined [error] <0.515.0> Supervisor {<0.515.0>,amqp_connection_sup} had child at module undefined at <0.517.0> exit with reason reached_max_restart_intensity in context shutdown
Undefined:Undefined#Undefined [error] <0.293.0> "Could not connect, scheduling reconnect.", error: {{error,{badmatch,{error,{auth_failure_likely,{socket_closed_unexpectedly,{gen_server,call,[<0.517.0>,connect,in
finity]}}}}},[{bunny_util,connect,1,[{file,"src/bunny_util.erl"},{line,191}]},{gen_bunny_mon,do_connect,3,[{file,"src/gen_bunny_mon.erl"},{line,192}]},{gen_bunny_mon,handle_info,2,[{file,"src/gen_bunny_mon.erl"},{line,134}]},{gen_server,
handle_msg,5,[{file,"gen_server.erl"},{line,604}]},{proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,239}]}]},{connection_info,{network,{127,0,0,1},5672,{<<"runs">>,<<"e0fd02a2....">>},<<"/analytics">>}}}

I will be grateful for any advice how to solve this problem.

P.S. I tried to manually log in to the database with the credentials from /etc/opscode-reporting/opscode-reporting-secrets.json But its also not working

/opt/opscode/embedded/bin/psql -U opscode_reporting -h localhost -W
Password for user opscode_reporting:
psql: FATAL: password authentication failed for user "opscode_reporting"

2

If you run opscode-reporting-ctl reconfigure, does that help? You may also want to try a reconfigure on your chef server, chef-server-ctl reconfigure (probably want to run the cher server reconfigure first).

It seems, as you noticed, that for some reason reporting isn’t picking up the proper password, so there is a disconnect somewhere. Typically running the reconfigures will fix this.

If it doesn’t, is there anything that might be unique about your setup?

  • Mark Mzyk
    Chef Engineering Manager
3

Thank you for your answer, problem was in incorrect passwords in database and RabbitMQ.
Reconfigure didn’t help, eventually helped manually change passwords in above services.

4

@Parasit, I have the same issue after my Frontend node upgrade. I am running in HA cluster my backend nodes.
Can you please let me know the services which you changed the password?

5

@Parasit @mmzyk how do i change passwords on those services?