Configure MySQL database

Before you can begin, you must set up your MySQL database with the required information (that is, database name, port number, the user name to use and the password, and so forth.

For xCat MySQL, open the file /etc/xcat/cfgloc and define:

Mysql:dbname=<user_defined_database>;host=<mgmtnode>;port=<port>\userid\pw

For unixODBC, open the file /etc/unixODBC/odbc.ini and define:

[user_defined_database]
Description = MySQL database
Driver      = MySQL
SERVER      =
USER        = root
PASSWORD    = root
PORT        = 3306	
DATABASE    = user_defined_database

Note: If no xCat database is configured, LSF will use the DSN (Data Sources Name) “easdb” in /etc/unixODBC/odbc.ini as the default database for energy aware scheduling features.