> When I have a look at the logs I see that I'm getting password > authentication failures for the puppetdb user: > > [root@puppet:/etc/puppet] #tail -30 /var/log/puppetdb/puppetdb.log > 2014-10-05 16:25:36,339 ERROR [c.j.b.h.AbstractConnectionHook] Failed to > acquire connection Sleeping for 7000ms and trying again. Attempts left: 1. > Exception: null > 2014-10-05 16:25:43,340 ERROR [c.j.b.PoolWatchThread] Error in trying to > obtain a connection. Retrying in 7000ms > org.postgresql.util.PSQLException: FATAL: password authentication failed for > user "puppetdb" > > ......... > > > This is what I have in my /etc/puppetdb/conf.d/database.ini > > [database] > classname = org.postgresql.Driver > subprotocol = postgresql > subname = //127.0.0.1:5432/puppetdb > username = puppetdb > password = secret > log-slow-statements = 10 > > > Yet when I try to log into the postgres database using those credentials I > get no error: > > [root@puppet:~] #su - postgres > -bash-4.1$ psql -h 127.0.0.1 -p 5432 -U puppetdb -W puppetdb > Password for user puppetdb: > psql (8.4.20) > Type "help" for help. > > puppetdb=>
So this might potentially be a problem with your pg_hba.conf, I'm guessing though. Try the above again, but as the root user, not as postgres, and show us the results. Here is my pg_hba.conf fwiw: https://gist.github.com/kbarber/0fd98ec424687c1bea9d. Send us yours and we can take a look. ken. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAE4bNTnmXHx2vWp8GuYRQkXNrrya9HT5SFeqr0TDQjb629G-AQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
