Hello Ken,
I resolved the database problem configure the value connection in the
"/etc/puppetdb/conf.d/database.ini" file. Before i've the value in the
"/etc/puppetdb/conf.d/config.ini" and not found.
[…………..]
[database]
subname = file:/var/lib/puppetdb/db/db;hsqldb.tx=mvcc;sql.syntax_pgs=true
log-slow-statements = 10
[database]
classname = org.postgresql.Driver
subprotocol = postgresql
subname = //localhost:5432/puppetdb
username = puppetdb
password = puppetdb
[jetty]
port = 8080
[…………..]
Respect to variables "storeconfigs" and "dbadapter" i setting the value in
the section [main] of "/etc/puppet/puppet.conf"
[…………..]
[main]
storeconfigs = true
storeconfigs_backend = puppetdb
dbadapter = postgresq
[…………..]
[…………..]
[root@master ~]# puppet agent --configprint all| egrep "dbadapter|storeconfig"
async_storeconfigs = false
dbadapter = postgresql
storeconfigs = true
storeconfigs_backend = puppetdb
thin_storeconfigs = false
[…………..]
Tables database
[…………..]
puppetdb=> \d
List of relations
Schema | Name | Type | Owner
--------+-------------------------+-------+----------
public | catalog_resources | table | puppetdb
public | catalogs | table | puppetdb
public | certname_catalogs | table | puppetdb
public | certname_facts | table | puppetdb
public | certname_facts_metadata | table | puppetdb
public | certnames | table | puppetdb
public | edges | table | puppetdb
public | reports | table | puppetdb
public | resource_events | table | puppetdb
public | resource_params | table | puppetdb
public | schema_migrations | table | puppetdb
(11 rows)
puppetdb=>
[…………..]
Thanks.
El 24-08-2013, a las 0:36, Ken Barber <[email protected]> escribió:
>> With the debug i've the next log
>>
>> 2013-08-15 00:37:13,960 DEBUG [main] [bonecp.BoneCPDataSource] JDBC URL =
>> jdbc:postgresql://127.0.0.1:5432/puppetdb, Username = pupetdb, partitions =
>> 1, max (per partition) = 50, min (per partition) = 1, helper threads = 3,
>> idle max age = 60 min, idle test period = 45 min
>
> The username you probably want here is 'puppetdb' not 'pupetdb' right ...?
>
>> 2013-08-15 00:37:48,999 ERROR [BoneCP-pool-watch-thread]
>> [bonecp.PoolWatchThread] Error in trying to obtain a connection. Retrying in
>> 7000ms
>> java.sql.SQLException: No suitable driver found for
>> jdbc:postgresql://127.0.0.1:5432/puppetdb
>
> So you might have a typo somewhere in your configuration for
> [database] but looking back in your history I cannot see it, take a
> look at mine and make sure it matches:
> https://gist.github.com/kbarber/6326050 ... otherwise provide your
> database.ini/config.ini again so I can see if there is a mistake. Your
> configuration that you provided earlier does not match what you have
> in your log (ie. pupetdb) as well ... which is weird.
>
> Just to double check - where did you get the package for PuppetDB? And
> what distro/release are you running? I notice all your configuration
> is in /etc/puppetdb/conf.d/config.ini ... are there any other files in
> your /etc/puppetdb/conf.d? This smells like a non-standard build (we
> ship extra files like jetty.ini, database.ini, repl.ini and config.ini
> for example).
>
> ken.
>
> --
> You received this message because you are subscribed to a topic in the Google
> Groups "Puppet Users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/puppet-users/ELg35FS1fZg/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/puppet-users.
> For more options, visit https://groups.google.com/groups/opt_out.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-users.
For more options, visit https://groups.google.com/groups/opt_out.
