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 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 tospls/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 database
SET GLOBAL max_allowed_packet=16777216