Up: 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