# portal doesn't start up after setting up mysql

**URL:** <https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460>\
**Category:** Q&A\
**Created:** [17 September 2015 15:05 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460 "2015-09-17T15:05:19Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![dijifo](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@dijifo](https://community.ofelia.com/u/dijifo)\
**Post date:** [17 September 2015 15:05 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/1 "2015-09-17T15:05:19Z")

</div>

Any hints on why my portal is not opening? I setup mysql according to the documentation.

This is what the log says:  
2015-09-17 10:50:14.399 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Initializing Bonita Engine…  
2015-09-17 10:50:14.399 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Initializing Spring context…  
2015-09-17 10:50:28.790 -0400 org.hibernate.type.TypeFactory org.hibernate.type.TypeFactory$TypeScopeImpl injectSessionFactory  
WARN: HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@2615d574 after already scoped org.hibernate.internal.SessionFactoryImpl@6370c634  
2015-09-17 10:50:35.321 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Initializing platform…  
2015-09-17 10:50:35.321 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initPlatform  
INFO: Creating platform…  
2015-09-17 10:50:35.665 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
WARN: SQL Error: 1146, SQLState: 42S02  
2015-09-17 10:50:35.665 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
ERROR: Table ‘bonita.platform’ doesn’t exist  
2015-09-17 10:50:47.547 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Platform initialized successfully.  
2015-09-17 10:50:47.548 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer startPlatform  
INFO: Starting platform…  
2015-09-17 10:50:48.770 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
WARN: SQL Error: 0, SQLState: S1000  
2015-09-17 10:50:48.772 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
ERROR: Packet for query is too large (4246135 \> 4194304). You can change this value on the server by setting the max\_allowed\_packet’ variable.  
2015-09-17 10:50:48.782 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Exception while initializing the engine: org.bonitasoft.engine.platform.StartNodeException: Platform starting failed.  
2015-09-17 10:50:48.783 -0400 org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener contextInitialized  
SEVERE: Error while initializing the Engine  
org.bonitasoft.engine.platform.StartNodeException: Platform starting failed.  
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:248)  
at org.bonitasoft.engine.PlatformTenantManager.updatePlatform(PlatformTenantManager.java:53)  
at org.bonitasoft.engine.PlatformTenantManager.startPlatform(PlatformTenantManager.java:60)  
at org.bonitasoft.engine.EngineInitializer.startPlatform(EngineInitializer.java:147)  
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:101)  
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:42)  
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)  
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)  
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:1862)  
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.util.concurrent.FutureTask.run(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.lang.Thread.run(Unknown Source)  
Caused by: org.bonitasoft.engine.exception.UpdateException: Unable to start service: org.bonitasoft.engine.page.impl.PageServiceImpl  
at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:81)  
at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:40)  
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:316)  
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startServicesOfTenants(PlatformAPIImpl.java:452)  
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.startNode(PlatformAPIImpl.java:232)  
… 18 more  
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.GenericJDBCException: could not execute statement  
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:422)  
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:349)  
at org.bonitasoft.engine.page.impl.PageServiceImpl.getPageByName(PageServiceImpl.java:311)  
at org.bonitasoft.engine.page.impl.PageServiceImpl.importProvidedPage(PageServiceImpl.java:601)  
at org.bonitasoft.engine.page.impl.PageServiceImpl.importProvidedPage(PageServiceImpl.java:593)  
at org.bonitasoft.engine.page.impl.PageServiceImpl.start(PageServiceImpl.java:583)  
at org.bonitasoft.engine.api.impl.transaction.StartServiceStrategy.changeState(StartServiceStrategy.java:33)  
at org.bonitasoft.engine.api.impl.transaction.SetServiceState.call(SetServiceState.java:79)  
… 22 more  
Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement  
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189)  
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)  
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3079)  
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)  
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)  
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)  
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)  
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)  
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)  
at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)  
at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1130)  
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1187)  
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)  
at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:909)  
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:418)  
… 29 more  
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4246135 \> 4194304). You can change this value on the server by setting the max\_allowed\_packet’ variable.  
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3552)  
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)  
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)  
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)  
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)  
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)  
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)  
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)  
at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:728)  
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.lang.reflect.Method.invoke(Unknown Source)  
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)  
at com.sun.proxy.$Proxy9.executeUpdate(Unknown Source)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186)  
… 43 more

2015-09-17 10:50:48.974 -0400 org.bonitasoft.console.common.server.servlet.PlatformTenantListener org.bonitasoft.console.common.server.servlet.PlatformTenantListener contextInitialized  
SEVERE: Error while initializing the default tenant  
org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously.  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:290)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:281)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:273)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:127)  
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)  
at com.sun.proxy.$Proxy10.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:4992)  
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)  
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:1862)  
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.util.concurrent.FutureTask.run(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.lang.Thread.run(Unknown Source)

2015-09-17 10:56:09.274 -0400 org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter doFilter  
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:201)  
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:45)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.isAuthorized(AuthenticationFilter.java:151)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doAuthenticationFiltering(AuthenticationFilter.java:134)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:119)  
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:501)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)  
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:408)  
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(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Unknown Source)  
Caused by: org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously.  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:290)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:281)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:273)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:127)  
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)  
at com.sun.proxy.$Proxy10.login(Unknown Source)  
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:196)  
… 32 more

2015-09-17 10:56:09.280 -0400 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[homepage] org.apache.catalina.core.StandardWrapperValve invoke  
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  
org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously.  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:290)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:281)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:273)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:127)  
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)  
at com.sun.proxy.$Proxy10.login(Unknown Source)  
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:196)  
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:45)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.isAuthorized(AuthenticationFilter.java:151)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doAuthenticationFiltering(AuthenticationFilter.java:134)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:119)  
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:501)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)  
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:408)  
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(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Unknown Source)

2015-09-17 10:56:48.270 -0400 org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter org.bonitasoft.console.common.server.sso.filter.InternalSSOFilter doFilter  
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:201)  
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:45)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.isAuthorized(AuthenticationFilter.java:151)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doAuthenticationFiltering(AuthenticationFilter.java:134)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:119)  
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:501)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)  
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:408)  
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(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Unknown Source)  
Caused by: org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously.  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:290)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:281)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:273)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:127)  
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)  
at com.sun.proxy.$Proxy10.login(Unknown Source)  
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:196)  
… 32 more

2015-09-17 10:56:48.275 -0400 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita].[homepage] org.apache.catalina.core.StandardWrapperValve invoke  
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  
org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously.  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:290)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:281)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:273)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:127)  
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)  
at com.sun.proxy.$Proxy10.login(Unknown Source)  
at org.bonitasoft.console.common.server.utils.TenantsManagementUtils.getDefaultTenantId(TenantsManagementUtils.java:196)  
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:45)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.isAuthorized(AuthenticationFilter.java:151)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doAuthenticationFiltering(AuthenticationFilter.java:134)  
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:119)  
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:501)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)  
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:408)  
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(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Unknown Source)

2015-09-17 10:57:55.228 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer unloadEngine  
INFO: Stopping Bonita Engine…  
2015-09-17 10:57:55.243 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer unloadEngine  
INFO: Stopping the services…  
2015-09-17 10:57:55.494 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer unloadEngine  
INFO: Bonita Engine stopped!

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [18 September 2015 08:18 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/2 "2015-09-18T08:18:01Z")

</div>

Looking at your logs, the DB is being created then there are some issues when trying to access it:

```
ERROR: Packet for query is too large (4246135 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.

```

Can you fist check that Bonita has created its tables in your DB?

Then, investigate this error message with your MySQL server configuration:  
[https://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html](https://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html)

---

<div class="post-metadata">

**Author:** ![dijifo](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@dijifo](https://community.ofelia.com/u/dijifo)\
**Post date:** [20 September 2015 16:54 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/3 "2015-09-20T16:54:08Z")

</div>

Hi Philippe,

yes, tables were created. what value do I use for max\_allowed\_packet if the error is:  
ERROR: Packet for query is too large (4246137 \> 4194304)

I have tried different values:  
[mysqld]  
max\_allowed\_packet=4194304

[mysqld]  
max\_allowed\_packet=34000000

but still get the error message

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [21 September 2015 15:15 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/4 "2015-09-21T15:15:50Z")

</div>

Hi,

Are you sure that your values were applied on the MySQL server?  
If so, you should get a different max value in the error message:

```
Packet for query is too large (4246135 > 4194304)

```

Also, looking at default settings in `my.ini` I have a value formatted like this:

```
max_allowed_packet = 1M

```

Try to increase yours like this:

```
max_allowed_packet = 32M

```

Let us know if this is better.

---

<div class="post-metadata">

**Author:** ![dijifo](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@dijifo](https://community.ofelia.com/u/dijifo)\
**Post date:** [21 September 2015 23:37 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/5 "2015-09-21T23:37:49Z")

</div>

Hi,

I’m running bonita and mysql in windows server. I don’t see a file named my.ini. only my-default.ini  
I add this line to the my-default.ini file  
max\_allowed\_packet = 1M  
I stop the appache server (shutdown.bat)  
I restart the Mysql56 windows service  
I start the apache server (startup.bat)

still get

ERROR: Packet for query is too large (4246137 \> 4194304). You can change this value on the server by setting the max\_allowed\_packet’ variable.  
2015-09-21 19:36:10.971 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Exception while initializing the engine: org.bonitasoft.engine.platform.StartNodeException: Platform starting failed.  
2015-09-21 19:36:10.972 -0400 org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener contextInitialized  
SEVERE: Error while initializing the Engine  
org.bonitasoft.engine.platform.StartNodeException: Platform starting failed.

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [23 September 2015 07:45 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/6 "2015-09-23T07:45:00Z")

</div>

Hi,

`my-default.ini` is not for configuring your installation: it is a copy of the default settings.

You need to locate your MySQL configuration file.  
Depending on how you installed MySQL it could be named either: `my.cnf` or `my.ini`.  
For example, if you are running XAMP, this could help: [http://stackoverflow.com/questions/4292769/what-is-the-location-of-mysql-client-my-cnf-in-xampp-for-windows](http://stackoverflow.com/questions/4292769/what-is-the-location-of-mysql-client-my-cnf-in-xampp-for-windows)

Also, please note that `1M` is the default value for `max_allowed_packet` so switch to some higher value such as `32M`.

---

<div class="post-metadata">

**Author:** ![dijifo](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@dijifo](https://community.ofelia.com/u/dijifo)\
**Post date:** [23 September 2015 12:44 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/7 "2015-09-23T12:44:14Z")

</div>

Hi:

I’m pass that “packet for query is to large” error… (according to stackoverflow link sent, it’s best to use MySQL workbench to make the MySQL configuration changes. Thanks for that link.

But now, after creating a fresh portal deploy directory, the bonitasoft database tables are created. But portal still doesn’t start. here is the bonita.log

2015-09-23 08:35:43.164 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Initializing Bonita Engine…  
2015-09-23 08:35:43.164 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Initializing Spring context…  
2015-09-23 08:35:53.899 -0400 org.hibernate.type.TypeFactory org.hibernate.type.TypeFactory$TypeScopeImpl injectSessionFactory  
WARN: HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@3fd12f70 after already scoped org.hibernate.internal.SessionFactoryImpl@3e8182cb  
2015-09-23 08:35:59.368 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Initializing platform…  
2015-09-23 08:35:59.368 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initPlatform  
INFO: Creating platform…  
2015-09-23 08:35:59.618 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
WARN: SQL Error: 1146, SQLState: 42S02  
2015-09-23 08:35:59.618 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
ERROR: Table ‘bonita.platform’ doesn’t exist  
2015-09-23 08:36:00.368 -0400 org.bonitasoft.engine.platform.impl.PlatformServiceImpl org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log  
SEVERE: THREAD\_ID=16 | HOSTNAME=Z101 | Following SQL command failed: CREATE INDEX idx\_message\_instance ON message\_instance (messageName, targetProcess, correlation1, correlation2, correlation3)  
2015-09-23 08:36:00.383 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Platform is already initialized.  
org.bonitasoft.engine.exception.CreationException: Platform Creation failed.  
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:145)  
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:186)  
at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:42)  
at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:140)  
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93)  
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:42)  
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)  
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)  
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:1862)  
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)  
at java.util.concurrent.FutureTask.run(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at java.lang.Thread.run(Unknown Source)  
Caused by: org.bonitasoft.engine.platform.exception.SPlatformCreationException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes  
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createTables(PlatformServiceImpl.java:179)  
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:129)  
… 18 more  
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes  
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)  
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)  
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)  
at java.lang.reflect.Constructor.newInstance(Unknown Source)  
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)  
at com.mysql.jdbc.Util.getInstance(Util.java:383)  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)  
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)  
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)  
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)  
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)  
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844)  
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748)  
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)  
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)  
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.doExecuteSQLThroughJDBC(PlatformServiceImpl.java:283)  
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResource(PlatformServiceImpl.java:258)  
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:199)  
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.executeSQLResources(PlatformServiceImpl.java:189)  
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createTables(PlatformServiceImpl.java:177)  
… 19 more

2015-09-23 08:36:00.383 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer startPlatform  
INFO: Starting platform…  
2015-09-23 08:36:00.383 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
WARN: SQL Error: 1146, SQLState: 42S02  
2015-09-23 08:36:00.383 -0400 org.hibernate.engine.jdbc.spi.SqlExceptionHelper org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions  
ERROR: Table ‘bonita.platform’ doesn’t exist  
2015-09-23 08:36:00.383 -0400 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine  
INFO: Exception while initializing the engine: org.bonitasoft.engine.platform.PlatformNotFoundException: Can’t start or stop platform if it is not created  
2015-09-23 08:36:00.383 -0400 org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener contextInitialized  
SEVERE: Error while initializing the Engine  
org.bonitasoft.engine.platform.PlatformNotFoundException: Can’t start or stop platform if it is not created

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [28 September 2015 07:54 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/8 "2015-09-28T07:54:49Z")

</div>

Assuming you are using Tomcat, could you please double-check that you have properly configured the DB vendor in the “Specify the database vendor” installation step:  
[http://documentation.bonitasoft.com/database-configuration-2#specdbvendor](http://documentation.bonitasoft.com/database-configuration-2#specdbvendor)

Also, please check in MySQL that the Bonita DB is using InnoDB as its storage engine and that it is set up with UTF-8 encoding.

---

<div class="post-metadata">

**Author:** ![dijifo](https://avatars.discourse-cdn.com/v4/letter/d/c2a13f/32.png) [@dijifo](https://community.ofelia.com/u/dijifo)\
**Post date:** [29 September 2015 14:50 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/9 "2015-09-29T14:50:19Z")

</div>

Yes, I’m using tomcat. I cnaged the db.vendor in setenv.bat to

# Define the RDMBS vendor use by Bonita Engine to store data

DB\_OPTS=“-Dsysprop.bonita.db.vendor=mysql”

# Define the RDMBS vendor use by Bonita Engine to store Business Data

# If you use different DB engines by tenants, please update directly bonita-tenant-community-custom.properties

BDM\_DB\_OPTS=“-Dsysprop.bonita.bdm.db.vendor=mysql”

I setup the db to use code utf-8 default. how do I check if the bonita DB is using InnoDB?

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [30 September 2015 07:58 UTC](https://community.ofelia.com/t/portal-doesnt-start-up-after-setting-up-mysql/6460/10 "2015-09-30T07:58:45Z")

</div>

To check if bonita DB is using InnoDB, you can log in to the database sever and explore it using a GUI tool such as SQL Workbench or you could run a query with a command line client:  
[http://dev.mysql.com/doc/refman/5.7/en/show-table-status.html](http://dev.mysql.com/doc/refman/5.7/en/show-table-status.html)