Navigation:  Setting up a Database, Table and Users > MySQL Administrator >

Setting up the Database

Creating the Database

Creating the database is quite easy. First select Catalogs in the left pane

And then right-click into the lower left rectangle (Schemata) that will show the mysql and the test databases (schemas). From the drop-down menu select Create New Schema to create a new database for EventSentry:

The newly added EventSentry database will now show up in the list:

and we are ready to create the tables, indexes and users with the wizard.

Setting up the tables, indexes and views for EventSentry

Starting with version 2.50, the web reports of EventSentry require several tables to be setup. Unlike earlier versions where you had to setup the tables manually, EventSentry now ships with a Database Setup Wizard that will create all tables, indexes and users automatically for you.

To setup the tables you will first have to create a system DSN and then run the database setup wizard.

1. Installing the ODBC drivers

If you haven't already downloaded and installed the ODBC drivers, then you will need to do this now. Please see Download & Installation for more information.

2. Creating a system DSN

Navigate to Start -> Programs -> Administrative Tools and select the Data Sources (ODBC). Click on the System DSN tab and then click on Add. On the next screen, select the MySQL ODBC 3.51 Driver from the bottom of the list.

After clicking finish you should be presented with the ODBC setup dialog. Make sure that you enter all information correctly in this dialog and then click the Test button:

3. Running the Database Setup Wizard

If you installed EventSentry with database support, then you will find the Database Setup Wizard in Start -> Programs -> EventSentry. Run this wizard and follow the instructions. The wizard will ask you for the system DSN pointing to the database and the initial password for the eventsentry_svc and eventsentry_web user accounts.