Sahi Documentation

Storing License Server Reports in MySQL

dangerSince Sahi Pro 8.0.0 this feature has been deprecated. Refer Sahi License Hub instead.
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 following

Create a Database

Create a database in MySQL using any MySQL client. Let us assume that the name of the database is spls

Note 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 to server.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 like
com.mysql.jdbc.PacketTooBigException: Packet for query is too large
run the following query once on your database
SET GLOBAL max_allowed_packet=16777216