Konica Minolta BIZHUB C30P - Manual (Page 45)

MetaConsole 2.3 including PageScope EMS Plug-Ins
page 31
Installing MySQL Database
A simple database for storing alarm information is automatically installed with MetaConsole.
The MySQL database can be used by the MetaConsole server to store alarm information.
To configure the MetaConsole server to log alarms to a MySQL database, follow this proce-
dure:
1 From http://www.mysql.com, download MySQL Connector/J.
2 Extract the mysql-connector-java-version#.jar file, and rename it mysql.jar.
3 Copy mysql.jar into the MetaConsole/lib directory.
4 Modify the local.xml file so that the MetaConsole tables can be configured in the data-
base. The example below shows the contents of the dataStore element in the local.xml
file. Modify the data shown in bold italics to connect to your MSSQL server.
<dataStore>
DATABASE_NAME = “MySQL”
DATABASE_DRIVER=”org.gjt.mm.mysql.Driver”
CONNECTION_URL=” jdbc:mysql://10.0.0.207/ks”
USER_NAME=”root”
PASSWORD=”password”>
</dataStore>
5 Save and close the local.xml file.
6 Make sure that the database specified in the local.xml file is running and that the Meta-
Console database has been created.
7 Execute the runcreator file in the MetaConsole directory. This program creates the tables
in your MetaConsole database.
8 Modify the configuration.txt file (located in the MetaConsole directory) to indicate the
alarm database. Chapter 2 explains the configuration.txt file. The database parameter
values entered in the configuration.txt file should be the same as those entered in the
local.xml
file.
9 Start the MetaConsole server.