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:
  • For unixODBC, open the file /etc/unixODBC/odbc.ini and define:
    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.