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
• Uploading Large Files

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
 

Uploading Large Files

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 do the following:

1. Set max_allowed_packet to the size specified in system settings

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

2. Set innodb_log_file_size to be 10 times larger than the value specified for max_allowed_packet

innodb_log_file_size = 1000M <10 times larger the value specified in max_allowed_packet>

The MySQL 5.6 bug report explains:

As a result of the redo log "BLOB" write limit introduced for MySQL 5.6, "innodb_log_file_size" should be set to a value greater than 10 times the largest "BLOB" data size found in the rows of your tables. Failing to do so could result in "Row size too large" errors. No action is required if your "innodb_log_file_size" setting is already 10 times the largest "BLOB" data size or your tables contain no "BLOB" data.