> I've installed puppetdb on my puppetmaster. I have puppet-server-3.7.1, > puppetdb-2.2 and puppetdb-terminus-2.2. > > I've setup puppetdb like this: > > [root@puppet:/etc/puppet] #cat /etc/puppetdb/conf.d/database.ini > [database] > classname = org.postgresql.Driver > subprotocol = postgresql > subname = //127.0.0.1:5432/puppetdb > username = puppetdb > password = secret > log-slow-statements = 10 > > > [root@puppet:/etc/puppet] #cat /etc/puppet/puppetdb.conf > [main] > server = puppet.jokefire.com > port = 8081 > > [root@puppet:/etc/puppet] #cat /etc/puppet/routes.yaml > --- > master: > facts: > terminus: puppetdb > cache: yaml > > [root@puppet:/etc/puppet] #grep storeconfigs puppet.conf > storeconfigs = true > storeconfigs_backend = puppetdb > > I'm running puppet via passenger and using foreman 1.6.0. And I've selected > postgres as the database for puppetdb as you can see above. When I perform > puppet runs everything seems to go OK. Which I thought meant that everything > as good between puppet and the puppetdb. > > However, when I connect to the postgres database and try to show tables for > the puppetdb database, it says that 'no relations are found'. > > [root@puppet:/etc/puppet] #su - postgres > -bash-4.1$ psql > psql (8.4.20) > Type "help" for help. > > postgres=# \c puppetdb > psql (8.4.20) > You are now connected to database "puppetdb". > puppetdb=# \dt > No relations found. > > So my question is, if I have everything setup correctly, why am I not seeing > any tables inside the puppetdb database? Am I missing any steps that I need > in order for this to work?
Is PuppetDB actually working at all? Or is this just a symptom you are trying to track down. Well couple of things, can you show your puppetdb.log for starters, perhaps the initial startup might be useful. I'm hoping this isn't it, but there is a small chance you have a duplicate entry in your conf.d directory, I've always found this methology to be a good one for checking this: # cd /etc/puppetdb/conf.d # grep '' * Can you show us the results of this (with secrets removed also) it might give us another clue. It sounds to me like if its working its either using a different database than we think it is, or potentially HSQLDB which is the embedded one. You should be able to see clues if you are accidentally using HSQLDB in this regard in /var/lib/puppetdb/db: root@puppetdb1:~# ls /var/lib/puppetdb/db/ db.log db.properties db.script db.tmp None of what you have provided shows this to be true so far, but worth double checking :-). ken. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAE4bNTnUcKLxxfCdp2NjkVdSekNL-%2BwSOvUvVpu_w%3DgvzZFaiw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
