3.4 Database Repository Configuration

Aqua Data Server uses a MySQL database as the repository for storing meta for server objects including Users, Roles, Projects, AquaScripts, Server Connections and User Files.  There are two things to be aware of when configuring the database connection:

• Connecting to the Database
• Max Packet Size

Connecting to the Database

To configure the database connection for your Aqua Data Server installation you must edit the aquadataserver.properties located in the <USER_HOME>/.aquadataserver/aquadataserver.properties directory.

This file should point to the MySQL database IP address and port you wish to use. During installation you should have created the appropriate username and password to allow Aqua Data Server to connect, as well as create the needed schema for the application.  Once Aqua Data Server is started, the clear text password identified in the property "database.password" will be encrypted and rewritten to the properties file in the property "database.password.encrypted", while the "database.password" will be removed.  To reset the password, all that is needed is to add the "database.password" again and restart the server.

Make sure the MySQL database is up and running on the IP address and port required as indicated in the aquadataserver.properties file.

Example aquadataserver.properties file :

# Repository Database Information
# Add line with 'database.password=<password>' to change password
database.host=10.168.5.211
database.name=aquadataserver
database.password.encrypted=ce263af55dfb0b1e
database.port=3306
database.username=aquadataserver

# These are connection pool settings
connection.pool.min_size=5
connection.pool.max_size=10
connection.pool.max_conn_time=1
 

Max Packet Size

If the maximum file upload size in the System Settings tab is set > 10 MB, you will need to edit MySQL's config file (my.cnf) and the following line:

max_allowed_packet = 100M <the size that you have specified in system settings>

For further information, go to http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html