Re: [Puppet Users] PuppetDB Cannot Find Postgresql Driver

[Deepak Giridharagopal]

On Tue, May 14, 2013 at 5:18 PM, Tim Schaefer <asysar...@gmail.com> wrote:

Puppet 3.3.1 // CentOS release 6.4 (Final)

rpm -qa | grep puppet

puppetlabs-release-6-7.noarch

puppet-3.1.1-1.el6.noarch

puppetdb-1.3.0-1.el6.noarch

puppet-server-3.1.1-1.el6.noarch

puppetdb-terminus-1.3.0-1.el6.noarch

Installed from yum packages:

Running Transaction

  Installing : puppetdb-1.3.0-1.el6.noarch                                                                                                                                                           1/1 

Certificate was added to keystore

Backing up /etc/puppetdb/conf.d/jetty.ini to /etc/puppetdb/conf.d/jetty.ini.bak.1368570333 before making changes

Updated default settings from package installation for ssl-host in /etc/puppetdb/conf.d/jetty.ini.

Updated default settings from package installation for ssl-port in /etc/puppetdb/conf.d/jetty.ini.

Updated default settings from package installation for key-password in /etc/puppetdb/conf.d/jetty.ini.

Updated default settings from package installation for trust-password in /etc/puppetdb/conf.d/jetty.ini.

Updated default settings from package installation for keystore in /etc/puppetdb/conf.d/jetty.ini.

Updated default settings from package installation for truststore in /etc/puppetdb/conf.d/jetty.ini.

  Verifying  : puppetdb-1.3.0-1.el6.noarch                                                                                                                                                           1/1 

Installed:

  puppetdb.noarch 0:1.3.0-1.el6                                                                                                                                                                          

Complete!

After following numerous posts all over the net, and of course PuppetLabs' docs I simply cannot get PuppetDB to run.  It cannot find the Java Driver and dies after about a minute of running:

java.lang.ClassNotFoundException: org.postgresql.jdbcDriver

at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

at java.net.URLClassLoader$1.run(URLClassLoader.java:355)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:354)

at clojure.lang.DynamicClassLoader.findClass(DynamicClassLoader.java:61)

at java.lang.ClassLoader.loadClass(ClassLoader.java:423)

at java.lang.ClassLoader.loadClass(ClassLoader.java:356)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:188)

at com.puppetlabs.jdbc$make_connection_pool.invoke(jdbc.clj:161)

at com.puppetlabs.jdbc$pooled_datasource.invoke(jdbc.clj:189)

at com.puppetlabs.puppetdb.cli.services$_main.doInvoke(services.clj:366)

at clojure.lang.RestFn.invoke(RestFn.java:421)

at clojure.lang.Var.invoke(Var.java:419)

at clojure.lang.AFn.applyToHelper(AFn.java:163)

at clojure.lang.Var.applyTo(Var.java:532)

at clojure.core$apply.invoke(core.clj:601)

at com.puppetlabs.puppetdb.core$_main.doInvoke(core.clj:79)

at clojure.lang.RestFn.applyTo(RestFn.java:137)

at com.puppetlabs.puppetdb.core.main(Unknown Source)

================

Puppet Settings

================

/etc/sysconfig/puppet    - default - no change

/etc/sysconfig/puppetdb - default- no change

----------------------------------------------

/etc/puppet/routes.yaml 

---

master:

  facts:

    terminus: puppetdb

    cache: yaml

-----------------------------------------------

/etc/puppet/puppet.conf

[master]

storeconfigs         = true

storeconfigs_backend = puppetdb

reports              = store,puppetdb

        facts_terminus       = puppetdb-terminus

------------------------------------------------

/etc/puppet/puppetdb.conf

[main]

server = fqdn-hostname

port   = 8081

-----------------------------------------------------

/etc/puppetdb/log4j.properties  - default - no change

/etc/puppetdb/conf.d/config.ini - default - no change

/etc/puppetdb/conf.d/jetty.ini  - default - no change

/etc/puppetdb/conf.d/repl.ini   - default - no change

-----------------------------------------------------

/etc/puppetdb/conf.d/database.ini:

classname   = org.postgresql.jdbcDriver

I think you want org.postgresql.Driver here; see http://docs.puppetlabs.com/puppetdb/latest/configure.html#using-postgresql

 

subprotocol = postgresql

subname     = //localhost:5432/puppetdb

username    = puppetdb

password    = puppetdb

gc-interval = 60

log-slow-statements = 10

=================================================

Postgresql Settings

=================================================

psql -U puppetdb

Password for user puppetdb: 

psql (8.4.13)

Type "help" for help.

puppetdb=> \l

                                   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 | =Tc/puppetdb

                                                             : puppetdb=C*T*c*/puppetdb

 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)

puppetdb=> \du

            List of roles

 Role name | Attributes  | Member of  

-----------+-------------+------------

 postgres  | Superuser   | {}

           : Create role   

           : Create DB     

 puppetdb  |             | {postgres}

===============================================================

Java Stuff

===============================================================

java -version

java version "1.7.0_19"

OpenJDK Runtime Environment (rhel-2.3.9.1.el6_4-x86_64)

OpenJDK 64-Bit Server VM (build 23.7-b01, mixed mode)

rpm -qa | grep java

java-1.7.0-openjdk-1.7.0.19-2.3.9.1.el6_4.x86_64

tzdata-java-2013b-1.el6.noarch

java-1.6.0-openjdk-1.6.0.0-1.61.1.11.11.el6_4.x86_64

rpm -qa | grep postgr

postgresql-8.4.13-1.el6_3.x86_64

postgresql-devel-8.4.13-1.el6_3.x86_64

postgresql-libs-8.4.13-1.el6_3.x86_64

postgresql-server-8.4.13-1.el6_3.x86_64

postgresql-contrib-8.4.13-1.el6_3.x86_64

postgresql-jdbc-8.4.701-8.el6.noarch

find / -name *postgres*.jar

/usr/share/java/postgresql-jdbc2ee.jar

/usr/share/java/postgresql-8.4-703.jdbc3.jar

/usr/share/java/postgresql-jdbc-8.4.701.jar

/usr/share/java/postgresql-8.4-703.jdbc4.jar

/usr/share/java/postgresql-jdbc2.jar

/usr/share/java/postgresql-jdbc.jar

/usr/share/java/postgresql-jdbc3.jar

--
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...@googlegroups.com.
To post to this group, send email to puppet...@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.