Konica Minolta BIZHUB C30P - Manual (Page 44)

Installing MetaConsole
page 30
Installing MSSQL Database
A simple database for storing alarm information is automatically installed with MetaConsole.
The Microsoft SQL Server 2000 database can be used by the MetaConsole server to store
alarm information.
To configure the MetaConsole server to log alarms to a MSSQL database, follow this proce-
dure:
1 From http://www.microsoft.com/sql/downloads, download the JDBC driver for SQ
Server 2000 for Windows.
2 Install the JDBC driver by executing the downloaded file. The installation program create
a lib
subdirectory that contains the jar files mssqldriver.jar, msutil.jar, and msbase.jar.
3 Copy the three jar files listed in step 2 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.
DATABASE_NAME = “MSSQL”
DATABASE_DRIVER=”com.microsoft.jdbc.sqlserver.SQLServerDriver”
CONNECTION_URL=”jdbc:microsoft:sqlserver://10.0.0.200:1433;
DatabaseName=MetaConsoleDB;SelectMethod=cursor”
USER_NAME=”root”
PASSWORD=”password”>
5 Save and close the local.xml file.
6 Make sure the database specified in the local.xml file is running and the MetaConsole da-
tabase 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 lo-
cal.xml
file.
9 Start the MetaConsole server.