Hello,,
With the debug i've the next log
------------------
[root@master lib]# puppetdb-foreground --debug
2013-08-15 00:37:13,737 DEBUG [main] [puppetlabs.utils] Debug logging enabled
2013-08-15 00:37:13,829 DEBUG [main] [puppetlabs.ssl] Loaded PEM object of type
'class org.bouncycastle.jcajce.provider.asymmetric.x509.X509CertificateObject'
from '/etc/puppetdb/ssl/ca.pem'
2013-08-15 00:37:13,847 DEBUG [main] [puppetlabs.ssl] Loaded PEM object of type
'class java.security.KeyPair' from '/etc/puppetdb/ssl/private.pem'
2013-08-15 00:37:13,854 DEBUG [main] [puppetlabs.ssl] Loaded PEM object of type
'class org.bouncycastle.jcajce.provider.asymmetric.x509.X509CertificateObject'
from '/etc/puppetdb/ssl/public.pem'
2013-08-15 00:37:13,959 INFO [main] [cli.services] PuppetDB version 1.4.0
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
2013-08-15 00:37:13,992 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 5. Exception: null
2013-08-15 00:37:20,993 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 4. Exception: null
2013-08-15 00:37:27,994 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 3. Exception: null
2013-08-15 00:37:34,995 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 2. Exception: null
2013-08-15 00:37:41,996 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 1. Exception: null
2013-08-15 00:37:48,998 ERROR [BoneCP-pool-watch-thread]
[bonecp.ConnectionHandle] Database access problem. Killing off all remaining
connections in the connection pool. SQL State = 08001
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
at java.sql.DriverManager.getConnection(DriverManager.java:640)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256)
at
com.jolbox.bonecp.ConnectionHandle.obtainInternalConnection(ConnectionHandle.java:211)
at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:170)
at
com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:101)
at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:679)
2013-08-15 00:37:56,001 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 5. Exception: null
2013-08-15 00:38:03,002 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 4. Exception: null
2013-08-15 00:38:10,003 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 3. Exception: null
2013-08-15 00:38:17,004 ERROR [BoneCP-pool-watch-thread]
[hooks.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms
and trying again. Attempts left: 2. Exception: null
--------------
El 23-08-2013, a las 19:28, Ken Barber <[email protected]> escribió:
>> postgres=# SELECT datname,pid,query_start from pg_stat_activity;
>> datname | pid | query_start
>> ----------+------+-------------------------------
>> postgres | 5866 | 2013-08-23 09:17:36.913697-04
>> (1 row)
>
> That pretty much confirms PuppetDB is not connecting to PostgreSQL at all.
>
> Try this, stop puppetdb, and run it in the foreground instead with the
> --debug setting:
>
> $ puppetdb-foreground --debug
>
> Now, I'm interested in the initial setup part of the log, can you put
> that in a gist so we can take a look? (double check the content
> though, make sure it doesn't have any 'sensitive' data in it of course
> :-).
>
>> When i tried to show all config settings i see the value "incorrect" for
>> example "storeconfig" value is "false" and the "dbadapter" is "sqlite3" but
>> i've already configured the postgres for storeconfig.
>>
>> [root@master manifests]# puppet agent --configprint all| grep dbadapter
>> dbadapter = sqlite3
>>
>> [root@master manifests]# puppet agent --configprint all| grep storeconfigs
>> async_storeconfigs = false
>> storeconfigs = false
>> storeconfigs_backend = active_record
>> thin_storeconfigs = false
>>
>> ¿Why not apply my configuration?
>
> You really want: puppet master --configprint all | grep storeconfigs
> ... not puppet agent etc.
>
> 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.
