Installation

The installation of the iMonDB consist of two separate elements: the database structure on the one hand, and the software tools that interact with this database on the other hand.

Software dependencies

To install or run the various iMonDB components, the following software dependencies are required:

• A MySQL database. For example, the MySQL Community Server is freely downloadable here. MySQL v5.7 is recommended, MySQL v8 and above are currently not supported.
• Java Runtime Environment version 8 (or higher), freely downloadable here.
• Microsoft Visual C++ 2012 Redistributable (x86), freely downloadable here.

Database

To create the iMonDB database schema, a suitable MySQL server needs to be available. The MySQL server can either be present locally, or on an internal server. For help installing a MySQL server, please check the official documentation or contact your local IT help desk. The following instructions assume that a MySQL server is available and you have sufficient access rights to create a new database schema.

For user user with password password, use the following commands create the iMonDB database schema and tables. The iMonDB table creation script is available here. In order for this script to work, the database name has to be iMonDB. If you want to use another name for your iMonDB database, please edit the table creation script accordingly.

shell> mysql -u <username> -p<password>
mysql> CREATE DATABASE iMonDB;
mysql> quit
shell> mysql -u <username> -p<password> iMonDB < CreateDB.sql

Additionally, a specific user can be created to be used for the iMonDB (for example if you don't want to / are unable to use the root user). The following example creates a user with username imondb and password imondb for a MySQL server running on the localhost, and grants it the required privileges on the iMonDB database.

CREATE USER 'imondb'@'localhost' IDENTIFIED BY 'imondb';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `iMonDB`.* TO  'imondb'@'localhost' IDENTIFIED BY 'imondb';

iMonDB tools

The iMonDB tools are packaged as runnable jar archives. The only requirement to run them is to have a suitable Java version (version 8) installed. Additionally, the iMonDB Collector requires the Microsoft Visual C++ 2012 Redistributable (x86) to be installed in order to be able to extract the instrument parameters from Thermo raw files.