Solution is pretty straight forward - reset the passwords to what the system things the passwords should be.
1.
Open up /etc/opscode-reporting/opscode-reporting-secrets.json
Grab opscode_reporting & opscode_reporting_ro passwords and pipe them to opscode-pgsql
echo "ALTER USER opscode_reporting PASSWORD 'XXXXX' " | su -l opscode-pgsql -c 'psql'
echo "ALTER USER opscode_reporting_ro PASSWORD 'XXXXX' " | su -l opscode-pgsql -c 'psql'
You should get the result "ALTER ROLE" from each of the 'echo' commands
2.
Next, make sure rabbitmq password is in sync:
In the same .json file, in the "opscode_reporting" section, grab the "rabbitmq_password" and use it in place of XXXXX
PATH=/opt/opscode/embedded/bin:$PATH rabbitmqctl change_password runs XXXXX
3.
then chef-server-ctl restart opscode-reporting
4.
And finally, you might still be broken.
If you look at the process list and see an error similar to below, send the HUP to svlogd to reload the configs.
root 1456 0.0 0.0 4092 196 ? Ss 2015 3:12 runsvdir -P /opt/opscode/service log: vlogd: pausing: unable to rename current: /var/log/opscode/opscode-reporting: file does not exist?svlogd: pausing: unable to rename current: /var/log/opscode/opscode-reporting: file does not exist?svlogd: pausing: unable to rename current: /var/log/opscode/opscode-reporting: file does not exist?svlogd: pausing: unable to rename current: /var/log/opscode/opscode-reporting: file does not exist?
So grab the correct pid by running chef-server-ctl status
...
run: opscode-reporting: (pid 17407) 30088s; run: log: (pid 32415) 88051s
...
kill -HUP 32415