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 <k...@puppetlabs.com> 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
> puppet-users+unsubscr...@googlegroups.com.
> To post to this group, send email to puppet-users@googlegroups.com.
> 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 puppet-users+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users.
For more options, visit https://groups.google.com/groups/opt_out.
