3Com 3CR15600 - Enterprise Management Suite, Руководство по началу работы

Страница: 70 / 218

70 C
HAPTER
3: I
NSTALLATION AND
I
NITIAL
S
ETUP
Do not configure the external database tables and schemas. When EMS
detects a blank database, EMS will automatically create all of the
necessary tables and configure them according to your customized
needs.
5 Create user privileges for the new user account.
If a database user has not been created, MySQL creates a new user for
you when entering the command in the following example:
GRANT ALL PRIVILEGES ON <database_name> .* to
‘ <db_username> ’@ <EMS_server_hostname> ’ identified by
‘ <db_password> ’;
where <EMS_server_hostname> is the DNS lookup name for the EMS
server. If the user experiences problems connecting to the database, the
command listed above can be repeated and <EMS_server_hostname>
replaced by the EMS server IP address and netmask.
For more information on database users, see Multiple User Access for
External Databases on page 74 .
For example, 192.168.1.1/255.255.255.0 is an acceptable entry.
6 In the MySQL DB section of the server.properties file, uncomment each
section and configure according to your customized needs:
##### MySQL DB ######
DBDriver=com.mysql.jdbc.Driver
DBURL=jdbc:mysql:// <hostname> / <database_name>
DBLong=BIGINT
DBEmbeddedQuote=\\'
DBFile=C:\\mysql\\data\\EMS
DBUserName= <db_username>
DBPassword= <db_password>
Table 23 lists the fields in the MySQL DB section of the server.properties
file and gives descriptions and default values.
Table 23 MySQL DB Section of the server.properties File
Field Description
DBDriver The Java classname of the JDBC driver.
DBURL The URL used to connect to the database. Each database
vendor specifies a unique format for a URL.
DBLong The SQL data type that can contain a long (8-byte) integer.