Audit database plugin with PostgreSQL

Question

I'm trying to use the audit database plugin with postgresql without success.

https://wiki.jenkins-ci.org/display/JENKINS/Audit+To+Database+Plugin

My DB is up and running, an other plugin called Database charts works well with postgresql, I configured the Driver as org.postgresql.Driver but always got a error

org.hibernate.HibernateException: JDBC Driver class not found: org.postgresql.Driver

Does anyone succeed to use PG with this plugin ?

Answer 1

Older thread, but ran into this issue today, and needed to figure out which plugin directory I needed to add the driver to.
Followed the above posters good advice, and here is how I configured PostgreSQL to work with the Audit to Database Plugin.

I already had the Global Database Plugin installed and configured for PostgreSQL, so I just needed to copy the postgres driver from that plugin dir to the "audit2db" plugin dir:

cp -p /var/lib/jenkins/plugins/database-postgresql/WEB-INF/lib/postgresql-9.1-901-1.jdbc4.jar /var/lib/jenkins/plugins/audit2db/WEB-INF/lib

As far as configuring the JDBC driver and URL refered to the official PostgreSQL docs: https://jdbc.postgresql.org/documentation/head/connect.html

JDBC Driver class: org.postgresql.Driver JDBC Url: jdbc:postgresql:jenkins

Hope this helps