Changes between Initial Version and Version 1 of IppInitialisingDatabase

Timestamp:

Nov 6, 2009, 12:08:22 PM (17 years ago)

Author:

dravg.uk.edinburgh

Comment:

First version, copied from the ROE's internal tWiki

IppInitialisingDatabase

@@ +1 @@
+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/dbadmin`
+   2. `./dbadmin init localhost ipp aloha`
+   3. `./dbadmin project localhost ipp testdb`
+
+Step 3 will require `ipp`'s password: `aloha` .
+
+-- EricTittley - 2009-11-06