Sahi Pro - Storing License Server Reports in MySQL
By default License Server stores its reports in a H2 database which is bundled in License Server. To store License Server reports in a MySQL database do the followingCreate a Database
Create a database in MySQL using any MySQL client. Let us assume that the name of the database is splsNote that minimum mysql version required is
5.6.4
Creating Tables
The tables will be created automatically, once License Server is restarted after performing the following steps. There is no need to run the db script manually.Add MySQL Driver Jars to Sahi Classpath
Download the MySQL Connector/J pack,extract and copy mysql-connector-java-x.x.x-bin.jar to
spls/extlib
folder.Note that minimum mysql java connector version required is
5.1.8
Point License Server to use the MySQL Database
Add the following toserver.properties
in spls/userdata/config
folder# Specifies database type.
# The inbuilt options are "mysql", "mssql", "oracle" and "h2"
# Change jdbc parameters accordingly
db.type=mysql
#JDBC parameters for mysql database
db.driver_name=com.mysql.jdbc.Driver
db.jdbc_url=jdbc:mysql://127.0.0.1/spls?allowMultiQueries=true&sessionVariables=sql_mode=NO_BACKSLASH_ESCAPES&zeroDateTimeBehavior=convertToNull
db.user_name=root
db.password=
Change the user_name, password and database name as required.
Restart and Run
Restart License Server. This will create the required tables in the database.Trouble-shooting
If you see an error likecom.mysql.jdbc.PacketTooBigException: Packet for query is too large
run the following query once on your databaseSET GLOBAL max_allowed_packet=16777216