How to set up an DPM server with a mysql backend

================================================

The DPM server is run by the dpmmgr user. This user requires a copy of

the host certificate files:

  cp -p /etc/grid-security/hostcert.pem /etc/grid-security/dpmmgr/dpmcert.pem

  cp -p /etc/grid-security/hostkey.pem /etc/grid-security/dpmmgr/dpmkey.pem

  chown dpmmgr:dpmmgr /etc/grid-security/dpmmgr/dpm*

Create the DPM database on the mysql server:

  mysql -u root < /usr/share/dpm/create_dpm_tables_mysql.sql

Select a username and password for this mysql database table. Replace

<user> and <password> in the commands below with your choice, also

replace <hostname> with the hostname of the DPM server:

  mysql -u root

  mysql> use mysql

  mysql> grant all on dpm_db.* to <user>@localhost identified by '<password>';

  mysql> grant all on dpm_db.* to <user>@<hostname> identified by '<password>';

  mysql> quit

Let the DPM server know about the account information and make sure

only the dpmmgr user can read this information:

  touch /etc/DPMCONFIG

  chmod 600 /etc/DPMCONFIG

  chown dpmmgr:dpmmgr /etc/DPMCONFIG

  echo <user>/<password>@<dbserver>/<dbname> > /etc/DPMCONFIG

If the /<dbname> part is omitted the database "dpm_db" will be used.

If you have a firewall, open the DPM server port (5015).

Once the configuration is completed, start the DPM server:

  service dpm start

If you want to start the service automatically at boot time:

  chkconfig --add dpm