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
Hello Ken,
I make query for check activity and the only database with activity is the
postgres.
postgres=# SELECT datname,pid,query_start from pg_stat_activity;
datname | pid | query_start
--+--+---
postgres | 5866 | 2013-08-23
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
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
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
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
Yes I can connect but when i list tables i have the next message No relations
found.
1. Connect from my node: [root@node1 ~]# psql -h 10.0.0.132 puppetdb puppetdb
2. Show tables: puppetdb= \d
No relations found.
3. My databases are:
puppetdb= \l puppetdb
List
Check your /etc/puppetdb/database.ini, it may be configured for
hsqldb. If in doubt provide the file here and we can take a look.
Instructions for configuring this specifically for PostgreSQL are
here: http://docs.puppetlabs.com/puppetdb/1.4/configure.html#using-postgresql
On Thu, Aug 22, 2013
My setting for db I've the next:
[…..]
[root@master puppet]# cat /etc/puppetdb/conf.d/config.ini | grep -v ^#
[global]
vardir = /var/lib/puppetdb
logging-config = /etc/puppetdb/log4j.properties
resource-query-limit = 2
[command-processing]
[database]
classname = org.postgresql.Driver
Do you see any active connections? A query like this in pgsql might
give you some information:
SELECT datname,procpid,current_query FROM pg_stat_activity;
On Thu, Aug 22, 2013 at 9:54 AM, Miguel Angel Coa Morales
miguelc...@gmail.com wrote:
My setting for db I've the next:
[…..]
Hello,
I have configured puppet and puppetdb (storeconfig) with postgresql and the
service run and the collecting are good for example:
I can make query with the next command and responds ok .
[.]
[root@master]# curl -X GET -H 'Accept: application/json'
11 matches
Mail list logo