0

I am running into a problem with rundeck community version 5.16.0 where I start the service and after about a minute the service stops itself.

It looks like an error when trying to connect to the postgresql database but I cannot figure out where I am going wrong and what is causing the problem.

Environment Setup

  • Debian 12
  • java 17
  • postgres version 15
  • rundeck community 5.16.0

Installation

** Note: The rundeck package itself was downloaded on an apt-mirror server and the package was copied over to the VM where rundeck will live

Prerequisites

sudo apt install openjdk-17-jre-headless postgresql libpostgresql-jdbc-java uuid-runtime 

Database Setup

sudo -u postgresql psql CREATE DATABASE rundeckdb; CREATE USER rundeckuser WITH PASSWORD 'strongpasswordhere'; GRANT ALL PIRVILEGES ON DATABASE rundeckdb TO rundeckuser; \q 

Rundeck Installation

sudo dpkg -i rundeck_5.16.0-*.deb sudo apt -f install 

Rundeck Configuration

  • in rundeck-config.properties
dataSource.driverClassName = org.postgresql.Driver dataSource.url = jdbc:postgresql://localhost:5432/rundeckdb dataSource.username = rundeckuser dataSource.password = strongpassword 

Error

 ERROR pool.ConnectionPool - Unable to create initial connections of pool. │ java.sql.SQLException: Unable to load class: org.postgresql.Driver from ClassLoader:org.springframewor│ k.boot.loader.LaunchedURLClassLoader@6576fe71;ClassLoader:org.springframework.boot.loader.LaunchedURLClas│ sLoader@6576fe71 │ Caused by: java.lang.ClassNotFoundException: Unable to load class: org.postgresql.Driver from ClassLoa│ der:org.springframework.boot.loader.LaunchedURLClassLoader@6576fe71;ClassLoader:org.springframework.boot.│ loader.LaunchedURLClassLoader@6576fe71 │ Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver 

What I have Tried

  • I have tried installing the psotgres.jar file directly in libext and bootstrap and have tried to restart the rundeck service still with the same error
sudo install -o rundeck -g rundeck -m 0644 /usr/share/java/postgresql.jar /var/lib/rundeck/libext/postgresql.jar sudo install -d -o rundeck -g rundeck /var/lib/rundeck/bootstrap/lib sudo install -o rundeck -g rundeck -m 0644 /usr/share/java/postgresql.jar /var/lib/rundeck/bootstrap/lib/postgresql.jar 

Any help would be appreciated as I have been trying to troubleshoot this now for a couple of days

Cheers

0

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.