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-clientmysql-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:
cd $SRCDIR/trunk/ippMonitor/scripts./dbadmin init localhost ipp aloha./dbadmin project localhost ipp testdb
Step 3 will require ipp's password: aloha .
-- EricTittley - 2011-03-08
