hey ken,
Thanks again for your help. I changed the password on a temporary basis to
an absurdly simple one. I'm both happy to say that puppetdb is working now.
And sad to have taken up your time with this. Sorry about that.
But after changing to the absurdly simple password and then being really
careful about setting the password back to a complex one, I can now get
successful puppet runs with the puppetdb in place. And I can also see
tables in the postgres database.
puppetdb=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------------+-------+----------
public | catalog_resources | table | puppetdb
public | catalogs | table | puppetdb
public | certnames | table | puppetdb
public | edges | table | puppetdb
public | environments | table | puppetdb
public | fact_paths | table | puppetdb
public | fact_values | table | puppetdb
public | facts | table | puppetdb
public | factsets | table | puppetdb
public | latest_reports | table | puppetdb
public | report_statuses | table | puppetdb
public | reports | table | puppetdb
public | resource_events | table | puppetdb
public | resource_params | table | puppetdb
public | resource_params_cache | table | puppetdb
public | schema_migrations | table | puppetdb
public | value_types | table | puppetdb
(17 rows)
Thanks again for your help!
Tim
On Mon, Oct 6, 2014 at 7:21 AM, Ken Barber <k...@puppetlabs.com> wrote:
> > 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.
>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
--
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/CAOZy0emgeWikwq13a8tG52heTqLS9%2B%2B56SmeVAgGrSze3EmnCw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
