org.bonitasoft.console.common.server.utils.DefaultTenantIdException

I’m try to install bonita using this manual http://documentation.bonitasoft.com/ubuntu-openjdk-tomcat-mysql

list of my tomacat7 libs:

root@bonita:/usr/share/tomcat7/lib# ls -al
total 2748
drwxr-xr-x 2 root root 4096 Nov 19 10:41 .
drwxr-xr-x 4 root root 4096 Nov 18 18:53 …
lrwxrwxrwx 1 root root 44 Apr 8 2014 annotations-api.jar → …/…/java/tomcat-annotations-api-7.0.28.jar
-rw-r–r-- 1 root root 3923 Nov 19 10:41 bonita-jboss-h2-mbean-1.0.0.jar
-rw-r–r-- 1 root root 4168 Nov 19 10:41 bonita-tomcat-h2-listener-1.0.1.jar
-rwxrwxrwx 1 root root 3416 Nov 18 19:05 bonita-tomcat-valve-6.0.35.jar
-rwxrwxrwx 1 root root 294654 Nov 18 19:05 btm-2.1.3.jar
-rwxrwxrwx 1 root root 3177 Nov 18 19:05 btm-tomcat55-lifecycle-2.1.3.jar
lrwxrwxrwx 1 root root 34 Apr 8 2014 catalina-ant.jar → …/…/java/catalina-ant-7.0.28.jar
lrwxrwxrwx 1 root root 40 Apr 8 2014 catalina-ha.jar → …/…/java/tomcat-catalina-ha-7.0.28.jar
lrwxrwxrwx 1 root root 37 Apr 8 2014 catalina.jar → …/…/java/tomcat-catalina-7.0.28.jar
lrwxrwxrwx 1 root root 37 Apr 8 2014 catalina-tribes.jar → …/…/java/catalina-tribes-7.0.28.jar
lrwxrwxrwx 1 root root 27 Apr 8 2014 commons-dbcp.jar → …/…/java/commons-dbcp.jar
lrwxrwxrwx 1 root root 27 Apr 8 2014 commons-pool.jar → …/…/java/commons-pool.jar
lrwxrwxrwx 1 root root 32 Apr 8 2014 el-api.jar → …/…/java/tomcat-el-api-2.2.jar
-rw-r–r-- 1 root root 1469903 Nov 19 10:41 h2-1.3.170.jar
lrwxrwxrwx 1 root root 38 Apr 8 2014 jasper-el.jar → …/…/java/tomcat-jasper-el-7.0.28.jar
lrwxrwxrwx 1 root root 35 Apr 8 2014 jasper.jar → …/…/java/tomcat-jasper-7.0.28.jar
lrwxrwxrwx 1 root root 33 Apr 8 2014 jsp-api.jar → …/…/java/tomcat-jsp-api-2.2.jar
-rwxrwxrwx 1 root root 15071 Nov 18 19:05 jta-1.1.jar
-rwxrwxrwx 1 root root 960374 Nov 18 18:57 mysql-connector-java-5.1.34-bin.jar
lrwxrwxrwx 1 root root 37 Apr 8 2014 servlet-api.jar → …/…/java/tomcat-servlet-api-3.0.jar
-rwxrwxrwx 1 root root 25496 Nov 18 19:05 slf4j-api-1.6.1.jar
-rw-r–r-- 1 root root 8890 Nov 19 10:41 slf4j-jdk14-1.6.1.jar
lrwxrwxrwx 1 root root 32 Apr 8 2014 tomcat-api.jar → …/…/java/tomcat-api-7.0.28.jar
lrwxrwxrwx 1 root root 35 Apr 8 2014 tomcat-coyote.jar → …/…/java/tomcat-coyote-7.0.28.jar
lrwxrwxrwx 1 root root 36 Apr 8 2014 tomcat-i18n-es.jar → …/…/java/tomcat-i18n-es-7.0.28.jar
lrwxrwxrwx 1 root root 36 Apr 8 2014 tomcat-i18n-fr.jar → …/…/java/tomcat-i18n-fr-7.0.28.jar
lrwxrwxrwx 1 root root 36 Apr 8 2014 tomcat-i18n-ja.jar → …/…/java/tomcat-i18n-ja-7.0.28.jar
lrwxrwxrwx 1 root root 33 Apr 8 2014 tomcat-util.jar → …/…/java/tomcat-util-7.0.28.jar

tomcat7 starting error log:

INFO: Platform is already initialized.
org.bonitasoft.engine.exception.CreationException: Platform Creation failed.
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:169)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:210)
at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:43)
at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:142)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4790)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5284)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.bonitasoft.engine.platform.SPlatformCreationException: Unable to create platform tables : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR,
filename VARCHAR(255) NOT NULL,
value_ LONGVARBINARY NOT NULL,
’ at line 4
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:151)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:152)
… 18 more
Caused by: org.bonitasoft.engine.services.SPersistenceException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR,
filename VARCHAR(255) NOT NULL,
value_ LONGVARBINARY NOT NULL,
’ at line 4
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughJDBC(AbstractHibernatePersistenceService.java:858)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:812)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:251)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.createStructure(AbstractDBPersistenceService.java:183)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:142)
… 19 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR,
filename VARCHAR(255) NOT NULL,
value_ LONGVARBINARY NOT NULL,
’ at line 4
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:265)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:265)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughJDBC(AbstractHibernatePersistenceService.java:845)
… 23 more

Nov 20, 2014 12:11:47 PM org.bonitasoft.engine.EngineInitializer initializeEngine
INFO: Starting platform…
Nov 20, 2014 12:11:47 PM org.bonitasoft.engine.EngineInitializer startPlatform
INFO: Starting platform…
Nov 20, 2014 12:11:47 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1146, SQLState: 42S02
Nov 20, 2014 12:11:47 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Table ‘bonita.platform’ doesn’t exist
Nov 20, 2014 12:11:47 PM org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl afterTransaction
INFO: HHH000106: Forcing container resource cleanup on transaction completion
Nov 20, 2014 12:11:47 PM 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
Nov 20, 2014 12:11:47 PM 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
at org.bonitasoft.engine.PlatformTenantManager.updatePlatform(PlatformTenantManager.java:51)
at org.bonitasoft.engine.PlatformTenantManager.startPlatform(PlatformTenantManager.java:61)
at org.bonitasoft.engine.EngineInitializer.startPlatform(EngineInitializer.java:149)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:102)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4790)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5284)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

Nov 20, 2014 12:11:47 PM 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:292)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:281)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy5.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:4790)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5284)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

Nov 20, 2014 12:11:47 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /var/lib/tomcat7/webapps/ROOT
Nov 20, 2014 12:11:47 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
Nov 20, 2014 12:11:47 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 15055 ms

Can you check that on the running server the JVM system property sysprop.bonita.db.vendor is set to mysql? (you can use JVisualVM or JConsole).

Also note that, as the first startup failed, you should clean up the Bonita home folder as it becomes out of sync compare to database content: Bonita home has been initialized whereas database as not been initialized due to data source configuration issue (or any connection / configuration issue).

Easy way to do the cleanup is simply to remove Bonita home folder and replace it with a clean one. Remember that if you set the db.vendor property in <bonita.home>\server\platform\conf\bonita-platform.properties file you should set it again.

If you don’t want to go with the “delete” and “replace” solution, you can remove the following folder under bonita.home:

  • client/tenants
  • server/tenants
  • server/platform/tmp
  • server/platform/work

The documentation is not complete regarding setenv.sh - you need to include the DB_OPTS variable in CATALINA_OPTS:

open /usr/share/tomcat7/bin/setenv.sh and change the line starting with 'CATALINA_OPTS= ’ to this:

CATALINA_OPTS=“${CATALINA_OPTS} ${BONITA_HOME} ${BTM_OPTS} ${DB_OPTS} -Dfile.encoding=UTF-8 -Xshare:auto -Xms1024m -Xmx1024m -XX:MaxPermSize=256m -XX:+HeapDumpOnOutOfMemoryError”

Of course yo need to make sure you have defined DB_OPTS before CATALINA_OPTS

Sorry, I’m not familiar with java. How can I check sysprop.bonita.db.vendor ?

root@bonita:~# jinfo 16989
Attaching to process ID 16989, please wait…
Debugger attached successfully.
Server compiler detected.
JVM version is 24.72-b04
Java System Properties:

java.runtime.name = Java™ SE Runtime Environment
java.vm.version = 24.72-b04
sun.boot.library.path = /usr/lib/jvm/java-7-oracle/jre/lib/amd64
shared.loader = /var/lib/tomcat7/shared/classes,/var/lib/tomcat7/shared/*.jar
btm.root = /opt/bonita/btm
java.vendor.url = http://java.oracle.com/
java.vm.vendor = Oracle Corporation
path.separator = :
file.encoding.pkg = sun.io
java.vm.name = Java HotSpot™ 64-Bit Server VM
java.util.logging.config.file = /var/lib/tomcat7/conf/logging.properties
tomcat.util.buf.StringCache.byte.enabled = true
sun.os.patch.level = unknown
sun.java.launcher = SUN_STANDARD
user.country = US
user.dir = /var/lib/tomcat7
java.vm.specification.name = Java Virtual Machine Specification
java.runtime.version = 1.7.0_72-b14
java.awt.graphicsenv = sun.awt.X11GraphicsEnvironment
os.arch = amd64
java.endorsed.dirs = /usr/share/tomcat7/endorsed
line.separator =

java.io.tmpdir = /tmp/tomcat7-tomcat7-tmp
java.vm.specification.vendor = Oracle Corporation
java.util.logging.manager = org.apache.juli.ClassLoaderLogManager
java.naming.factory.url.pkgs = org.apache.naming
os.name = Linux
sun.jnu.encoding = UTF-8
java.library.path = /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
tomcat.util.scan.DefaultJarScanner.jarsToSkip = bootstrap.jar,commons-daemon.jar,tomcat-juli.jar,annotations-api.jar,el-api.jar,jsp-api.jar,servlet-api.jar,catalina.jar,catalina-ant.jar,catalina-ha.jar,catalina-tribes.jar,jasper.jar,jasper-el.jar,ecj-.jar,tomcat-api.jar,tomcat-util.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-jni.jar,tomcat-spdy.jar,tomcat-i18n-en.jar,tomcat-i18n-es.jar,tomcat-i18n-fr.jar,tomcat-i18n-ja.jar,tomcat-juli-adapters.jar,catalina-jmx-remote.jar,catalina-ws.jar,tomcat-jdbc.jar,commons-beanutils.jar,commons-codec*.jar,commons-collections*.jar,commons-dbcp*.jar,commons-digester*.jar,commons-fileupload*.jar,commons-httpclient*.jar,commons-io*.jar,commons-lang*.jar,commons-logging*.jar,commons-math*.jar,commons-pool*.jar,jstl.jar,geronimo-spec-jaxrpc*.jar,wsdl4j*.jar,ant.jar,ant-junit*.jar,aspectj*.jar,jmx.jar,h2*.jar,hibernate*.jar,httpclient*.jar,jmx-tools.jar,jta*.jar,log4j*.jar,mail*.jar,slf4j*.jar,xercesImpl.jar,xmlParserAPIs.jar,xml-apis.jar,dnsns.jar,ldapsec.jar,localedata.jar,sunjce_provider.jar,sunmscapi.jar,sunpkcs11.jar,jhall.jar,tools.jar,sunec.jar,zipfs.jar,apple_provider.jar,AppleScriptEngine.jar,CoreAudio.jar,dns_sd.jar,j3daudio.jar,j3dcore.jar,j3dutils.jar,jai_core.jar,jai_codec.jar,mlibwrapper_jai.jar,MRJToolkit.jar,vecmath.jar,junit.jar,junit-.jar,ant-launcher.jar
java.class.version = 51.0
java.specification.name = Java Platform API Specification
sun.management.compiler = HotSpot 64-Bit Tiered Compilers
os.version = 3.2.0-4-amd64
user.home = /usr/share/tomcat7
user.timezone = Europe/Kiev
catalina.useNaming = true
java.awt.printerjob = sun.print.PSPrinterJob
file.encoding = UTF-8
java.specification.version = 1.7
catalina.home = /usr/share/tomcat7
user.name = tomcat7
java.class.path = /usr/share/tomcat7/bin/bootstrap.jar:/usr/share/tomcat7/bin/tomcat-juli.jar
java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory
package.definition = sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
java.vm.specification.version = 1.7
sun.arch.data.model = 64
sun.java.command = org.apache.catalina.startup.Bootstrap start
java.home = /usr/lib/jvm/java-7-oracle/jre
user.language = en
java.specification.vendor = Oracle Corporation
awt.toolkit = sun.awt.X11.XToolkit
java.vm.info = mixed mode
db.vendor = ${sysprop.bonita.db.vendor:h2}
java.version = 1.7.0_72
java.ext.dirs = /usr/lib/jvm/java-7-oracle/jre/lib/ext:/usr/java/packages/lib/ext
sun.boot.class.path = /usr/lib/jvm/java-7-oracle/jre/lib/resources.jar:/usr/lib/jvm/java-7-oracle/jre/lib/rt.jar:/usr/lib/jvm/java-7-oracle/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-7-oracle/jre/lib/jsse.jar:/usr/lib/jvm/java-7-oracle/jre/lib/jce.jar:/usr/lib/jvm/java-7-oracle/jre/lib/charsets.jar:/usr/lib/jvm/java-7-oracle/jre/lib/jfr.jar:/usr/lib/jvm/java-7-oracle/jre/classes
java.awt.headless = true
server.loader = /var/lib/tomcat7/server/classes,/var/lib/tomcat7/server/
.jar
java.vendor = Oracle Corporation
catalina.base = /var/lib/tomcat7
file.separator = /
java.vendor.url.bug = http://bugreport.sun.com/bugreport/
common.loader = ${catalina.base}/lib,${catalina.base}/lib/.jar,${catalina.home}/lib,${catalina.home}/lib/.jar,/var/lib/tomcat7/common/classes,/var/lib/tomcat7/common/*.jar
bonita.home = /opt/bonita/bonita_home-6.3.8
sun.io.unicode.encoding = UnicodeLittle
sun.font.fontmanager = sun.awt.X11FontManager
sun.cpu.endian = little
bitronix.tm.configuration = /opt/bonita/btm/conf/bitronix-config.properties
package.access = sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
sun.cpu.isalist =

VM Flags:

-Djava.util.logging.config.file=/var/lib/tomcat7/conf/logging.properties -Djava.awt.headless=true -Xmx128m -XX:+UseConcMarkSweepGC -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Dbonita.home=/opt/bonita/bonita_home-6.3.8 -Dbtm.root=/opt/bonita/btm -Dbitronix.tm.configuration=/opt/bonita/btm/conf/bitronix-config.properties -Dfile.encoding=UTF-8 -Xshare:auto -Xms1024m -Xmx1024m -XX:MaxPermSize=256m -XX:+HeapDumpOnOutOfMemoryError -Djava.endorsed.dirs=/usr/share/tomcat7/endorsed -Dcatalina.base=/var/lib/tomcat7 -Dcatalina.home=/usr/share/tomcat7 -Djava.io.tmpdir=/tmp/tomcat7-tomcat7-tmp

So, I changed <bonita.home>\server\platform\conf\bonita-platform.properties to mysql and it’s works!
Thanks

Thanks a lot for your feedback. I update the script example on version 6.3 documentation page in order to include the DB_OPTS

Note that documentation page for version 6.4 has been fully rewrite and now use the setenv.sh provided in deploy bundle.

thanks - that was fast!