Re: [Puppet Users] Confusion with puppetdb (storeconfig) and query database

2013-08-26 Thread Miguel Angel Coa Morales
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

Re: [Puppet Users] Confusion with puppetdb (storeconfig) and query database

2013-08-23 Thread Miguel Angel Coa Morales
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

Re: [Puppet Users] Confusion with puppetdb (storeconfig) and query database

2013-08-23 Thread Miguel Angel Coa Morales
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: […..] [root

Re: [Puppet Users] Confusion with puppetdb (storeconfig) and query database

2013-08-23 Thread Miguel Angel Coa Morales
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

Re: [Puppet Users] Confusion with puppetdb (storeconfig) and query database

2013-08-22 Thread Miguel Angel Coa Morales
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

Re: [Puppet Users] Confusion with puppetdb (storeconfig) and query database

2013-08-22 Thread Miguel Angel Coa Morales
for configuring this specifically for PostgreSQL are here: http://docs.puppetlabs.com/puppetdb/1.4/configure.html#using-postgresql On Thu, Aug 22, 2013 at 7:34 AM, Miguel Angel Coa Morales miguelc...@gmail.com wrote: Yes I can connect but when i list tables i have the next message No relations found. 1

Re: [Puppet Users] Store configuration problem (mysql)

2013-03-19 Thread Miguel Angel Coa Morales
I don't have idea of mysql and backed becoming obsolete. My guide is the book: Pro Puppet, but within the section stored configuration speak about: mysql, postgres, sqlite and oracle and never puppetdb. (Thanks for this tips). Respect whether puppet master is running, yes is ok and the ports

Re: [Puppet Users] Schedule yum update not found

2013-01-04 Thread Miguel Angel Coa Morales
Hello jcbollinger, I resolved the problem with sudo in the command syntax . [………...] class updateso { schedule{ weekly: range = 14 - 16, repeat = 2, } exec { sudo yum --exclude=drbd* --exclude=kernel* --exclude=mysql* --exclude=php* update -y: user = root, #

Re: [Puppet Users] Schedule yum update not found

2013-01-03 Thread Miguel Angel Coa Morales
Hello, I resolved the structure inside my init.pp, but the command in the puppet agent fails: [………] Jan 3 12:25:45 mail2 puppet-agent[31902]: (/Stage[main]/Updateso/Exec[yum --exclude=drbd* --exclude=kernel* --exclude=mysql* --exclude=php* update -y]/returns) change from notrun to 0 failed:

Re: [Puppet Users] Agent error with class (puppet server)

2012-12-05 Thread Miguel Angel Coa Morales
Thanks for the clarification. I edit the source in my class with the mention of Craig and now is solved. Best regards! El 05-12-2012, a las 8:07, Diogo Martinez diogo.p.marti...@gmail.com escribió: Craig is correct. Directory files doesnt need to be declared. It is resolved by puppet