cannot configure the production environment (BonitaBPMCommunity-7.5.4)

1
0
-1

bundle : BonitaBPMCommunity-7.5.4-wildfly-10.1.0.Final

[INFO] Starting PlatformSetupApplication on shariff-PC with PID 4384 (C:\BonitaB
PMCommunity-7.5.4-wildfly-10.1.0.Final\setup\lib\platform-setup-7.5.4.jar starte
d by shariff in C:\BonitaBPMCommunity-7.5.4-wildfly-10.1.0.Final\setup)
[DEBUG] Running with Spring Boot v1.3.2.RELEASE, Spring v4.3.7.RELEASE
[INFO] The following profiles are active: default
[INFO] configuration for Database vendor: mysql
[INFO] Started PlatformSetupApplication in 2.871 seconds (JVM running for 3.713)

Sun Sep 03 23:55:19 AST 2017 WARN: Establishing SSL connection without server's
identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ an
d 5.7.6+ requirements SSL connection must be established by default if explicit
option isn't set. For compliance with existing applications not using SSL the ve
rifyServerCertificate property is set to 'false'. You need either to explicitly
disable SSL by setting useSSL=false, or set useSSL=true and provide truststore f
or server certificate verification.
Sep 03, 2017 11:55:19 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to create initial connections of pool.
java.sql.SQLSyntaxErrorException: Unknown database 'bonita_journal.db'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
a:536)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
a:513)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(
SQLExceptionsMapping.java:115)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606
)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:633)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)

    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.j

ava:219)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(Poole
dConnection.java:307)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection
.java:200)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(Connectio
nPool.java:708)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(Connectio
nPool.java:642)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:4
64)
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java
:141)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourcePro
xy.java:115)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProx
y.java:102)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceP
roxy.java:126)
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSe
tup.java:354)
at org.bonitasoft.platform.setup.PlatformSetup.initPlatformSetup(Platfor
mSetup.java:382)
at org.bonitasoft.platform.setup.PlatformSetup.init(PlatformSetup.java:9
5)
at org.bonitasoft.platform.setup.command.InitCommand.execute(InitCommand
.java:43)
at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(Platfo
rmSetupApplication.java:105)
at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSe
tupApplication.java:79)
at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformS
etupApplication.java:64)

[DEBUG] ERROR:
org.bonitasoft.platform.exception.PlatformException: java.sql.SQLSyntaxErrorExce
ption: Unknown database 'bonita_journal.db'
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSe
tup.java:359) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetup.initPlatformSetup(Platfor
mSetup.java:382) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetup.init(PlatformSetup.java:9
5) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.command.InitCommand.execute(InitCommand
.java:43) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(Platfo
rmSetupApplication.java:105) [platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSe
tupApplication.java:79) [platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformS
etupApplication.java:64) [platform-setup-7.5.4.jar:na]
Caused by: java.sql.SQLSyntaxErrorException: Unknown database 'bonita_journal.db
'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
a:536) ~[mysql-connector-java-6.0.6.jar:6.0.6]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
a:513) ~[mysql-connector-java-6.0.6.jar:6.0.6]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(
SQLExceptionsMapping.java:115) ~[mysql-connector-java-6.0.6.jar:6.0.6]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606
) ~[mysql-connector-java-6.0.6.jar:6.0.6]
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:633) ~[my
sql-connector-java-6.0.6.jar:6.0.6]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)
~[mysql-connector-java-6.0.6.jar:6.0.6]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.j
ava:219) ~[mysql-connector-java-6.0.6.jar:6.0.6]
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(Poole
dConnection.java:307) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection
.java:200) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(Connectio
nPool.java:708) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(Connectio
nPool.java:642) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:4
64) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java
:141) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourcePro
xy.java:115) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProx
y.java:102) ~[tomcat-jdbc-8.0.30.jar:na]
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceP
roxy.java:126) ~[tomcat-jdbc-8.0.30.jar:na]
at org.bonitasoft.platform.setup.PlatformSetup.initDataSource(PlatformSe
tup.java:354) ~[platform-setup-7.5.4.jar:na]
... 6 common frames omitted

mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bonita_data |
| bonita_journal |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)

#

Bonita BPM database properties

#

valid values are (h2, postgres, sqlserver, oracle, mysql)

db.vendor=mysql

when using h2, no server or port setting is needed since connexion is made using file protocol mode using relative directory:

db.server.name=localhost
db.server.port=3306
db.database.name=bonita_journal.db
db.user=root
db.password=mysql

#

Business Data database properties

#

valid values are (h2, postgres, sqlserver, oracle, mysql)

bdm.db.vendor=mysql
bdm.db.server.name=localhost
bdm.db.server.port=3306
bdm.db.database.name=business_data.db
bdm.db.user=root
bdm.db.password=mysql

IMPORTANT NOTE regarding H2 database: in case you move whole setup folder to another directory, you must change property below to point to original folder containing h2 database folder new value can be relative or absolute since it still points to the right folder WARNING for Windows users: keep forward slashes like below (instead of backslashes):

h2.database.dir=../h2_database

1 answer

1
0
-1

You have created two databases named bonita_journal and bonita_data but in your configuration file you set the name to be bonita_journal.db and business_data.db.

Editing the configuration file to match the database name should fix the issue.

Comments

Submitted by akashpanigrahi9... on Tue, 01/02/2018 - 13:28

Also I would say to remove the '.db ' part in the configuration file.

Notifications