Installation Mysql Database Bonita BPM platform

Q&A
1

Hi,
Following the official documentation and new to ubuntu / MySQL / Bonita I wish to setup a Bonita BPM platform.
I downloaded the Tomcat-bundle and I wish to setup MySQL Database.

But when looking at the official documentation, the Database must be configured, (it is writed literaly everywhere) there is no informations / guide for MySQL database.

Here is the only thing they say for MySQL :
*MySQL
Maximum packet size

MySQL defines a maximum packet size on the server side. The default value for this setting is appropriate for most standard use cases. However, you need to increase the packet size if you see the following error: Error: 1153 SQLSTATE: 08S01 (ER_NET_PACKET_TOO_LARGE) Message: Got a packet bigger than ‘max_allowed_packet’ bytes

You need to update the file my.ini (for Windows) or my.cnf (for Linux) to avoid the ER_NET_PACKET_TOO_LARGE problem. Look for max_allowed_packet setting and increase the value.

For more information, see the MySQL website.
Surrogate characters not supported

MySQL does not support surrogate characters. If you want to use surrogate characters in your processes, you need to use another type of database.*
**
So what should I do ??? There is no informations about creating a DATABASE, a TABLE, and other things, without database I can’t connect Tomcat to MySQL.

Moreover I couldn’t find a way to install MySQL 5.5.27 so I did install the latest version, is this a problem ?**

2

A year back, I got bonita to work with mysql.
This video might help
link

My point is, bonita will work with mysql. I did it once…

3

Really?

You did read this

Platform: http://documentation.bonitasoft.com/?page=BonitaBPM_platform_setup

and this for Database:

http://documentation.bonitasoft.com/?page=database-configuration

Regarding the version of MySQL, you can use the latest version, it does work, see my answer to your other post.

I’ve already written to Bonitasoft to rewrite the installation documentation as it does seem to go all over the place, but it does work,

regards
Seán

PS: As this reply offers an answer your question, and if you like it, please Mark UP and/or as Resolved.

4

Hi,
Thank you for answering.

I finaly used the latest MySQL version and it works ! Their version was to hard to find / install.

Really?

You did read this

Platform: Bonita Documentation | Bonita Documentation

and this for Database:
Bonita Documentation | Bonita Documentation

Yes I did read all the documentation, and I was not wrong.
There is closely nothing on this page : Bonita Documentation | Bonita Documentation
for MySQL compare to others database !
Now looking at the platform, I did a different way.
I did look at database.properties file and verifiy what it required. Works for now.