Hello, I'm struggeling with a PuppetDB 3.2.2 Installation on a CentOS 7 x86_64 VM. PuppetDB is starting with the standard hsqldb, but when I switch to postgresql 9.4.5 i get this error message in puppetdb.log and the service did not start:
2015-12-21 09:59:55,656 INFO [o.e.j.u.log] Logging initialized @44718ms
2015-12-21 10:00:04,209 INFO [p.t.s.n.nrepl-service] nREPL service
disabled, not starting
2015-12-21 10:00:04,210 INFO [p.t.s.w.jetty9-service] Initializing web
server(s).
2015-12-21 10:00:04,333 INFO [p.p.pdb-routing] Starting PuppetDB, entering
maintenance mode
2015-12-21 10:00:04,381 INFO [p.t.s.w.jetty9-service] Starting web
server(s).
2015-12-21 10:00:04,789 INFO [p.t.s.w.jetty9-core] Starting web server.
2015-12-21 10:00:04,818 INFO [o.e.j.s.Server] jetty-9.2.z-SNAPSHOT
2015-12-21 10:00:04,902 INFO [o.e.j.s.h.ContextHandler] Started
o.e.j.s.h.ContextHandler@370349f{/pdb,null,AVAILABLE}
2015-12-21 10:00:04,973 INFO [o.e.j.s.ServerConnector] Started
ServerConnector@6845b7c8{HTTP/1.1}{localhost:8080}
2015-12-21 10:00:05,152 INFO [o.e.j.s.ServerConnector] Started
ServerConnector@435d2cfe{SSL-HTTP/1.1}{0.0.0.0:8081}
2015-12-21 10:00:05,153 INFO [o.e.j.s.Server] Started @54218ms
2015-12-21 10:00:05,156 INFO [p.p.metrics] Starting metrics server
2015-12-21 10:00:05,159 INFO [o.e.j.s.h.ContextHandler] Started
o.e.j.s.h.ContextHandler@25f8722c{/metrics,null,AVAILABLE}
2015-12-21 10:00:05,241 INFO [p.p.c.services] PuppetDB version 3.2.2
2015-12-21 10:00:05,658 INFO [c.j.b.BoneCP] Shutting down connection
pool...
2015-12-21 10:00:05,666 INFO [c.j.b.BoneCP] Connection pool has been
shutdown.
2015-12-21 10:00:05,673 ERROR [p.t.internal] Error during service start!!!
org.postgresql.util.PSQLException: FEHLER: Relation „schema_migrations“
existiert nicht
Position: 21
The complete log is attached. I can connect to postgresql with the puppetdb
user, but no tables get created in the puppetdb-DB. During the puppetdb
startup i can see the following lines in the postgresql-log:
< 2015-12-21 10:00:05.638 CET >FEHLER: Relation „schema_migrations“
existiert nicht bei Zeichen 21
< 2015-12-21 10:00:05.638 CET >ANWEISUNG: SELECT version FROM
schema_migrations ORDER BY version
The puppetdb user can create tables in postgresql and I can see no
differences to the puppetdb user on a working local testing-VM with puppet
enterprise. I tried the installation with puppetdb-packages from the
official puppetlabs yum repo as well as installing with the
puppetlabs-module. I got the same errormessage. Changing to nightly builds
of puppetdb doesn't change the behaviour.
I'm not sure if the message concerning the missing schema_migrations is the
reason for the service not to start, but i cannot find any other hint
(debug-logs).
It would be a big help if somebody has a hint for resolving this problem,
cause I'm struggeling and searching for 3 days now.
Kind regards
Benjamin
--
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/5aaa5bcb-d626-4365-9821-8a65fba88b1e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
puppetdb.log
Description: Binary data
