Install and Configure BonitaSubscription 7.9.x bundle Tomcat at CentOS7 with PostgreSQL 9.2
Hello,
I'm trying to install and configure BonitaSubscription 7.9.x bundle with Tomcat 8 at CentOS7 server with PostgreSQL 9.2.... Unfortunately getting some errors at configuration stage :(
Installed PostgreSQL 9.2. with Tomcat 8 and trying to configure according to: Platform configuration setup tool
When using a setup tool, either way, "setup.sh init " or "setup.sh configure" getting the errors like:
[ERROR] HikariPool-1 - Exception during pool initialization.
org.postgresql.util.PSQLException: An error occurred while setting up the SSL connection.
Please advise how to resolve the issue and run Bonita Platform.
Thank you!
Here is some error output log:
(Platform Setup 7.9.4)
[INFO] Starting PlatformSetupApplication on centosbonita1.localdomain with PID 14118 (/opt/BonitaSubscription-7.9.4-tomcat/setup/lib/platform-setup-7.9.4.jar started by root in /opt/BonitaSubscription-7.9.4-tomcat/setup)
[DEBUG] Running with Spring Boot v2.1.3.RELEASE, Spring v5.1.5.RELEASE
[INFO] The following profiles are active: default
[INFO] configuration for Database vendor: postgres
[INFO] Started PlatformSetupApplication in 1.322 seconds (JVM running for 1.805)
[ERROR] HikariPool-1 - Exception during pool initialization.
org.postgresql.util.PSQLException: An error occurred while setting up the SSL connection.
at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:439)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:94)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:454)
at org.postgresql.Driver.connect(Driver.java:256)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSetup.java:449)
at org.bonitasoft.platform.setup.PlatformSetup.initPlatformSetup(PlatformSetup.java:479)
at org.bonitasoft.platform.setup.PlatformSetup.init(PlatformSetup.java:98)
at org.bonitasoft.platform.setup.command.InitCommand.execute(InitCommand.java:45)
at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(PlatformSetupApplication.java:105)
at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSetupApplication.java:79)
at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformSetupApplication.java:64)
[DEBUG] ERROR:
org.bonitasoft.platform.exception.PlatformException: org.postgresql.util.PSQLException: An error occurred while setting up the SSL connection.
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSetup.java:455)
at org.bonitasoft.platform.setup.PlatformSetup.initPlatformSetup(PlatformSetup.java:479)
at org.bonitasoft.platform.setup.PlatformSetup.init(PlatformSetup.java:98)
at org.bonitasoft.platform.setup.command.InitCommand.execute(InitCommand.java:45)
at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(PlatformSetupApplication.java:105)
at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSetupApplication.java:79)
at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformSetupApplication.java:64)
Caused by: org.postgresql.util.PSQLException: An error occurred while setting up the SSL connection.
at org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:439)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:94)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:454)
at org.postgresql.Driver.connect(Driver.java:256)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSetup.java:449)
... 6 common frames omitted
From the configuration file you shared I can see that your configured the PostgreSQL database connection to use port 8080
. Port 8080
is usually the default port used by a Java application server such as Tomcat.
PostgreSQL use by default port 5432
. Are you sure that your PostgreSQL server is listening on port 8080
?
Comments
You were right this was my fault (for some reasons I choose 8080.. ) now it is fixed.
(Platform Setup 7.9.4)
[INFO] configuration for Database vendor: postgres
[INFO] Connected to 'postgres' database with url: 'jdbc:postgresql://localhost:5432/bonita_db' with user: 'bonita_db_user'
[INFO] Platform is already created.
[INFO] Upgrading default configuration with files from folder: platform_conf/initial
[INFO] Tomcat environment detected with root /opt/BonitaSubscription-7.9.4-tomcat
[INFO] Running auto-configuration using file /opt/BonitaSubscription-7.9.4-tomcat/setup/database.properties
[INFO] Same configuration detected for file 'server/bin/setenv.bat'. No need to change it.
[INFO] Same configuration detected for file 'server/bin/setenv.sh'. No need to change it.
[INFO] Same configuration detected for file 'server/conf/Catalina/localhost/bonita.xml'. No need to change it.
[INFO] Your postgres driver file 'server/lib/bonita/postgresql-42.2.5.jar' already exists. Skipping the copy.
[INFO] Your postgres driver file 'server/lib/bonita/postgresql-42.2.5.jar' already exists. Skipping the copy.
[INFO] Tomcat auto-configuration complete.
Setup seemed to complete without errors.
However Bonita platform still not running. I might have some configuration mistakes (sorry, but those docs I found are not very clear).
After 'setup.sh init', also done 'setup.sh configure' and push/pull to make sure no errors...
I have Bonita logs saved in the same shared folder. here is the link to the gzip file :
I would appreciate your help.
Many thanks!
Hi,
It took a while, I had to re-do everything 2-3 times... still have some issues, but to summarize:
Re tomcat:
There was an issue when I tried to start the service of the tomcat install (installed onto: /opt/tomcat, and also use "systemctl enable tomcat" to make it start with the system). This tomcat instance did not run at the time when system starts.
However when I start Bonita bundle ( installed into: /opt/bonita/) by startup script: ./start-bonita.sh - everything is fine, and I can reach Bonita by localhost:8080/bonita
I used documentation available on site and also other related docs.. anyway... I would appreciate if some one responsible could review and revise documentation link to make sure there is no steps missed/messed up.
If this comment does not solve your issue, please create another post on the forum. It well other users looking for solving similar issues to find the information
I could continue discussion of the subject to help to improve the documentation in another topic if this one is not suitable. No problems.
Thanks!
Hi,
Thank you, this is fixed now, Bonita Platform starts as service in my configuration.
I had to disable startup of Tomcat from /opt/tomcat and enable another version comes with Bonita bundle from /opt.bonita/server (not sure if this is correct way to fix the issue, but it works). I had to change tomcat service configuration in /etc/systemd/system/tomcat.service so it reflects the actual path:
Environment=JAVA_HOME=/usr/lib/jvm/jre
Environment=CLASSPATH=/opt/bonita/server/lib/:/opt/bonita/server/bin
Environment=CATALINA_PID=/opt/bonita/server/temp/tomcat.pid
Environment=CATALINA_HOME=/opt/bonita/server
Environment=CATALINA_BASE=/opt/bonita/server
Environment='CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC'
Environment='JAVA_OPTS=-Djava.awt.headless=true -Djava.security.egd=file:/dev/./urandom'
ExecStart=/opt/bonita/start-bonita.sh
ExecStop=/bin/kill -15 $MAINPID
Also I had to modify a file path to "startup.sh" in the bonita platform startup script " /opt/bonita/start-bonita.sh" so it points to:
./bin/startup.sh
instead of:
./server/bin/startup.sh
"Your issue is that you have two installations of Tomcat configured to use the same port"
- Looks like this is the case.
Following the current docs: https://documentation.bonitasoft.com/bonita/7.9/ubuntu-openjdk-tomcat-postgresql - I have installed Tomcat into /opt/tomcat (as per step "Install Tomcat 8.5") and configured Tomcat to start as service from /opt/tomcat, then unpacked the Bonita deploy bundle into /opt/bonita .. At some point I got lost in the docs and messed with configuration...
Comments
Hi,
As you are using Bonita Subscription (i.e. the Enterprise Edition) may I suggest that you reach out to Bonitasoft commercial support?
Still I can try to help. Can you share the full log output in a separated file hosted for example on Google Drive, Dropbox...?
Also can you share the
database.properties
file?Thanks
Hi,
Yes, I'm trying to install a platform server Bonita Subscription 7.9.4.
OS: CentOS 7; SQLDB: PostgreSQL 9.2.24; Tomcat 8.5.46
Bonita Studio has no problem running with the same environment (but I used only H2 instead of PostgreSQL). This installation is to prepare migration from Windows to Linux as server platform.
Here is the Dropbox link:
BonitaFolder
Please let me know if you need more information,
Many thanks!