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.
