Error installing Bonita-6.3.8-deploy with jdk1.8, Tomcat7 and Mysql in CentOS7

Q&A
1

Hi, I am facing problem in installing the deploy bundle. I have checked through the documentation and been googling around but no luck. The logs are as follows:
I am sure platform table is created, and tried re-creating database and removing tenant folder but no luck.

Anyone can help me? Thanks in advance

Part of catalina.out:
2014-11-12 16:14:43 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
WARN: SQL Error: 1146, SQLState: 42S02
2014-11-12 16:14:43 org.hibernate.engine.jdbc.spi.SqlExceptionHelper
ERROR: Table ‘bonita.platform’ doesn’t exist

Part of bonita log:
2014-11-12 16:15:18 org.bonitasoft.console.common.server.servlet.PlatformTenantListener
SEVERE: Error while initializing the default tenant
java.lang.NullPointerException
at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy8.login(Unknown Source)
at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.initializeDefaultTenant(PlatformTenantListener.java:61)
at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:44)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4994)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5492)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1861)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at < ========== Beginning of the server stack trace ========== >. ( )
at java.lang.StringBuilder.(StringBuilder.java:112)
at org.bonitasoft.engine.api.HTTPServerAPI.createHttpPost(HTTPServerAPI.java:177)
at org.bonitasoft.engine.api.HTTPServerAPI.executeHttpPost(HTTPServerAPI.java:163)
at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:135)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy8.login(Unknown Source)
at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.initializeDefaultTenant(PlatformTenantListener.java:61)
at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:44)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4994)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5492)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1861)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filters
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘ApplicationResourceCacheFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘AuthorizationFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘Tomcat WebSocket (JSR356) Filter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘SecurityFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘CacheFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘BonitaHomeFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘TokenGeneratorFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘TokenValidatorFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘NoCacheFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘InternalSSOFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘RestAPIAuthorizationFilter’
2014-11-12 16:15:18 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita]
FINE: Starting filter ‘BPMURLSupportFilter’
2014-11-12 16:15:26 org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter
SEVERE: Can’t retrieve default tenant id
org.bonitasoft.console.common.server.utils.DefaultTenantIdException: Can’t retrieve default tenant id
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:205)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.getDefaultTenantId(TenantIdAccessor.java:52)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.ensureTenantId(TenantIdAccessor.java:46)
at org.bonitasoft.console.common.server.login.filter.AutoLoginRule.doAuthorize(AutoLoginRule.java:31)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.isAuthorized(AuthorizationFilter.java:97)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doAuthorizationFiltering(AuthorizationFilter.java:79)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter.doFilter(InternalSSOFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.SecurityFilter.doFilter(SecurityFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy8.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:200)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.getDefaultTenantId(TenantIdAccessor.java:52)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.ensureTenantId(TenantIdAccessor.java:46)
at org.bonitasoft.console.common.server.login.filter.AutoLoginRule.doAuthorize(AutoLoginRule.java:31)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.isAuthorized(AuthorizationFilter.java:97)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doAuthorizationFiltering(AuthorizationFilter.java:79)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter.doFilter(InternalSSOFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.SecurityFilter.doFilter(SecurityFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
at < ========== Beginning of the server stack trace ========== >. ( )
at java.lang.StringBuilder.(StringBuilder.java:112)
at org.bonitasoft.engine.api.HTTPServerAPI.createHttpPost(HTTPServerAPI.java:177)
at org.bonitasoft.engine.api.HTTPServerAPI.executeHttpPost(HTTPServerAPI.java:163)
at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:135)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy8.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:200)
… 32 more

2014-11-12 16:15:26 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[homepage]
SEVERE: Servlet.service() for servlet [homepage] in context with path [/bonita] threw exception [org.bonitasoft.console.common.server.utils.DefaultTenantIdException: Can’t retrieve default tenant id] with root cause
java.lang.NullPointerException
at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy8.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:200)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.getDefaultTenantId(TenantIdAccessor.java:52)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.ensureTenantId(TenantIdAccessor.java:46)
at org.bonitasoft.console.common.server.login.filter.AutoLoginRule.doAuthorize(AutoLoginRule.java:31)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.isAuthorized(AuthorizationFilter.java:97)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doAuthorizationFiltering(AuthorizationFilter.java:79)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter.doFilter(InternalSSOFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.SecurityFilter.doFilter(SecurityFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
at < ========== Beginning of the server stack trace ========== >. ( )
at java.lang.StringBuilder.(StringBuilder.java:112)
at org.bonitasoft.engine.api.HTTPServerAPI.createHttpPost(HTTPServerAPI.java:177)
at org.bonitasoft.engine.api.HTTPServerAPI.executeHttpPost(HTTPServerAPI.java:163)
at org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:135)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy8.login(Unknown Source)
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:200)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.getDefaultTenantId(TenantIdAccessor.java:52)
at org.bonitasoft.console.common.server.login.TenantIdAccessor.ensureTenantId(TenantIdAccessor.java:46)
at org.bonitasoft.console.common.server.login.filter.AutoLoginRule.doAuthorize(AutoLoginRule.java:31)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.isAuthorized(AuthorizationFilter.java:97)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doAuthorizationFiltering(AuthorizationFilter.java:79)
at org.bonitasoft.console.common.server.login.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter.doFilter(InternalSSOFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.SecurityFilter.doFilter(SecurityFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)

2014-11-12 16:15:26 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[jsp]
FINE: Disabling the response for futher output

2

Hi there,

Tomcat 7 is not yet supported by Bonita, you must use Tomcat 6.

All i can say is it is coming according to an answer I received asking the same question, however when, that we are not yet told…

regards
Seán

3

First of all Java 8 is not yet supported and there are known issues with it (at least for Bonita Studio, not sure about Bonita Portal and Bonita Engine).

Tomcat 7 is officially supported and I personally did several successful installations with it.

About MySQL, there are known issues with the management of XA transactions by MySQL engine and driver: see MySQL bugs 17343 and 12161 for more details. Thus, using MySQL database in a production environment is not recommended. Our recommendation is to use another database like PostgreSQL.

Still it should be possible to successfully start Bonita with MySQL.
Can you please try to:

  • Shutdown Tomcat server
  • Delete all logs files
  • Use a clean version of Bonita home with proper settings
  • Try to start again
  • Share the full content of bonita and catalina log files (using a online service such as Dropbox or Google Drive)

Note that the warning about the missing platform table is a false positive. In fact, on first startup, Engine will check if table exist. If not it will initialize the database (create all tables) and also initialize Bonita home folder.

I can also recommend to check the following point if tables are not created in Database:

4

Thank you very much guys. Seems I should try with JAVA7, tomcat7 and PostgreSQL as a combination.

A quick question:
Is there any recommended version of PostgreSQL?

5

Apologies, I was referring to when will Bonita bundles (like Studio and Tomcat Bundle) be provided with Tomcat 7. Not that the Deploy version can be used with Tomcat 7.

Is there any published documentation of installing the Deploy version on Tomcat 7, as I’ve not seen any as yet or is it the same as Tomcat 6?

However one thing that’s missing is “Tomcat 7 is officially supported” from any of the release notes…I’ve gone back to 6.0.2 and found no mention of Tomcat 7 being supported. Maybe with the next release note?

I’ve never got it to work, hence my previous answer/question.

Thanks and regards
Sean

6

Documentation focus on Tomcat 6 mainly because all provided bundles are using this version.

Anyway it’s possible to deploy Bonita in Tomcat 7 (you can find that Bonita work on Tomcat 7 in the official documentation).
Basic steps of such installation is to merge the content of the files provided in deploy bundle for Tomcat 6 with your Tomcat 7 installation. The only difference is that Tomcat configuration file server.xml include some minor change between version 6 and 7. So you will need to merge what’s inside the deploy bundle with the existing Tomcat 7 file instead of simply replace it.

Bundle with Apache Tomcat 7 will come with next Bonita BPM release.

7

Thanks Antoine, the link you provided though goes to a PreProd documentation site where authorization is required… :slight_smile:

8

I use the latest - the drivers (connectors) all seem to work regardless of version.

Sean

9

I would recommend to use the latest version of PostgreSQL 9.3 branch.
For the JDBC driver, as explain on the dedicated web site you should get the latest version that is backward compatible with previous version of PostgreSQL.

10

Thanks for the notification, I fixed the link: http://documentation.bonitasoft.com/product-bos-sp/hardware-and-software-requirements

11

Thank you so much for all the helpful tips. Have a good weekend.