Install server BonitaBPMCommunity-7.5.4-Tomcat-7.0.76 fail with MySql

Q&A
1

Please, can someone tell me what this error is in the Server installation with Mysql?
It does not let me start in production.

Works perfect with H2 in test.

Server Centos 6.5
Java jre1.8.0_144
MySql version: 5.5.57 - MySQL Community Server (GPL) by Remi

Thank you in advance

please, please, please

[DEBUG] ERROR:
java.lang.IllegalArgumentException: Illegal group reference: group index is missing
        at java.util.regex.Matcher.appendReplacement(Unknown Source) ~[na:1.8.0_144]
        at java.util.regex.Matcher.replaceAll(Unknown Source) ~[na:1.8.0_144]
        at java.lang.String.replaceAll(Unknown Source) ~[na:1.8.0_144]
        at org.bonitasoft.platform.setup.command.configure.BundleConfigurator.replace(BundleConfigurator.java:247) ~[platform-setup-7.5.4.jar:na]
        at org.bonitasoft.platform.setup.command.configure.BundleConfigurator.replaceValues(BundleConfigurator.java:151) ~[platform-setup-7.5.4.jar:na]
        at org.bonitasoft.platform.setup.command.configure.TomcatBundleConfigurator.updateBonitaXmlFile(TomcatBundleConfigurator.java:132) ~[platform-setup-7.5.4.jar:na]
        at org.bonitasoft.platform.setup.command.configure.TomcatBundleConfigurator.configureApplicationServer(TomcatBundleConfigurator.java:74) ~[platform-setup-7.5.4.jar:na]
        at org.bonitasoft.platform.setup.command.configure.ConfigureCommand.execute(ConfigureCommand.java:37) ~[platform-setup-7.5.4.jar:na]
        at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(PlatformSetupApplication.java:105) [platform-setup-7.5.4.jar:na]
        at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSetupApplication.java:79) [platform-setup-7.5.4.jar:na]
        at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformSetupApplication.java:64) [platform-setup-7.5.4.jar:na]
[root@proyectosti BonitaBPMCommunity-7.5.4-Tomcat-7.0.76]#
2

you have verified that the server has the mysql drivers?

3

I think that issue is not related with the MySQL Driver but maybe with some incorrect syntax in one of the configuration file. Do you have special character such as $ or \ ?
You can take a look at this other blog post: https://community.bonitasoft.com/questions-and-answers/add-special-characters-databaseproperties-file

4

The special characters \ or $ did not work, it still has the same problem.

[INFO] Starting PlatformSetupApplication on proyectosti.net with PID 14418 (/opt/BonitaBPMCommunity-7.5.4-Tomcat-7.0.76/setup/lib/platform-setup-7.5.4.jar started by root in /opt/BonitaBPMCommunity-7.5.4-Tomcat-7.0.76/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.267 seconds (JVM running for 3.047)
[INFO] Connected to ‘mysql’ database with url: ‘jdbc:mysql://localhost:3306/bonita_journal.db?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8’ with user: ‘root@localhost’
[INFO] Platform is already created. Nothing to do.
[INFO] Tomcat environment detected with root /opt/BonitaBPMCommunity-7.5.4-Tomcat-7.0.76
[INFO] Running auto-configuration using file /opt/BonitaBPMCommunity-7.5.4-Tomcat-7.0.76/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.
[DEBUG] ERROR:
java.lang.IllegalArgumentException: Illegal group reference: group index is missing
at java.util.regex.Matcher.appendReplacement(Unknown Source) ~[na:1.8.0_144]
at java.util.regex.Matcher.replaceAll(Unknown Source) ~[na:1.8.0_144]
at java.lang.String.replaceAll(Unknown Source) ~[na:1.8.0_144]
at org.bonitasoft.platform.setup.command.configure.BundleConfigurator.replace(BundleConfigurator.java:247) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.command.configure.BundleConfigurator.replaceValues(BundleConfigurator.java:151) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.command.configure.TomcatBundleConfigurator.updateBonitaXmlFile(TomcatBundleConfigurator.java:132) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.command.configure.TomcatBundleConfigurator.configureApplicationServer(TomcatBundleConfigurator.java:74) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.command.configure.ConfigureCommand.execute(ConfigureCommand.java:37) ~[platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetupApplication.execute(PlatformSetupApplication.java:105) [platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetupApplication.run(PlatformSetupApplication.java:79) [platform-setup-7.5.4.jar:na]
at org.bonitasoft.platform.setup.PlatformSetupApplication.main(PlatformSetupApplication.java:64) [platform-setup-7.5.4.jar:na]
[root@xxxxxectosti BonitaBPMCommunity-7.5.4-Tomcat-7.0.76]#

5

Can you share the setup/database.properties file?
Also can you confirm that your database username or password does not includes $ or \ ?

6

great, had not understood the previous help. I am a beast, I had the $ character as part of the database user’s password

thank you, thank you

sorry