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? Thanks. El 22-08-2013, a las 15:18, Ken Barber <[email protected]> escribió: > 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 > <[email protected]> wrote: >> 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 = 20000 >> [command-processing] >> >> [database] >> classname = org.postgresql.Driver >> subprotocol = postgresql >> subname = //localhost:5432/puppetdb >> username = puppetdb >> password = puppetdb >> >> [jetty] >> port = 8080 >> [……………..] >> >> My routes.yaml >> >> [……………..] >> /etc/puppet/routes.yaml >> >> master: >> facts: >> terminus: puppetdb >> cache: yaml >> [……………..] >> >> My /etc/puppet/puppetdb.conf >> >> [……………..] >> [main] >> >> server = master.example.com >> port = 8081 >> [……………..] >> >> Thanks. >> >> El 22-08-2013, a las 12:47, Ken Barber <[email protected]> escribió: >> >>> 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 at 7:34 AM, Miguel Angel Coa Morales >>> <[email protected]> wrote: >>>> 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 of databases >>>> Name | Owner | Encoding | Collation | Ctype | Access >>>> privileges >>>> -----------+----------+----------+-------------+-------------+----------------------- >>>> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>>> puppetdb | puppetdb | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>>> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>>> : >>>> postgres=CTc/postgres >>>> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>>> : >>>> postgres=CTc/postgres >>>> (4 rows) >>>> >>>> >>>> Note: The 10.0.0.132 is my puppetmaster and server puppetdb with postgres . >>>> ¿Is possible that the information is stored elsewhere? >>>> >>>> Thanks!! >>>> >>>> El 21-08-2013, a las 18:39, Ellison Marks <[email protected]> escribió: >>>> >>>> psql -h 127.0.0.1 puppetdb puppetdb >>>> >>>> >>>> -- >>>> 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. >>> >>> -- >>> 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. > > -- > 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.
