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