Up: [wiki:IPPatTheROE IPP at the ROE]

= Initialising the IPP Database =

== Ensure MySQL is installed ==

IPP used !MySQL as it's database server. !MySQL is not installed by default. Check first, for:

    * `/usr/bin/mysql`
    * `/usr/bin/mysqladmin`
    * `/usr/sbin/mysqld`

If those files do not exist, submit a helpdesk ticket requesting the packages:

    * `mysql-client`
    * `mysql-server`

Upon installation, a root password will be generated and supplied to you. Note, "root" here means !MySQL administrator, not the "root" of the machine.

Note that installing !MySQL from scratch in a user-owned directory is possibly, but running the server may never succeed if the file `/etc/mysql/my.cnf` or `/etc/my.cnf` already exists, as it does by default on our Debian machines.

== Initialise the IPP Database ==

We will need the `dbadmin` tool in the IPP source directory. I don't know why it is not installed along with the rest of the IPP executables. Find it in `$SRCDIR/trunk/ippMonitor/scripts/dbadmin` .

First we will generate the user `ipp` (could be anything else) with the password `aloha`. This step will require the !MySQL root password. Horst and I have the password for eday.

Then, generate a project belonging to `ipp`. Here, I'm calling it `testdb`.

So:

   1. `cd $SRCDIR/trunk/ippMonitor/scripts`
   2. `./dbadmin init localhost ipp aloha`
   3. `./dbadmin project localhost ipp testdb`

Step 3 will require `ipp`'s password: `aloha` .

-- EricTittley - 2011-03-08