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 <k...@puppetlabs.com> 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 > <miguelc...@gmail.com> 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 <k...@puppetlabs.com> 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 >>> <miguelc...@gmail.com> 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 <gty...@gmail.com> 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 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 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. > > -- > 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.
