The MOKB MySQL Server

The principal aim to creating your own server will be to install and start the server on your machine and then to create a user account which will allow the MOKB system to log in and make changes to the database automatically.

You will also have to create the file mokb.local.config in the lib/config directory. This config file should mimic the stanford one, with the parameters altered for your server and the login information you have set up. See Configuration.

Installation

Instructions for install:

• 1.Install My SQL

• 2.Start server (command line option below, can also be started as a service)

$ mysqld --console

• 3. Create user, password and default database

$ mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* to 'mokbuser'@'localhost' IDENTIFIED
BY 'mokbpass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* to 'mokbuser'@'%' IDENTIFIED BY
'mokbpass' WITH GRANT OPTION;
mysql> CREATE DATABASE mokb;
mysql> quit;

• 4. Start over from scratch

$ mysql --user=root mysql
mysql> drop database mokb;
mysql> create database mokb;

Configuration

If you choose to install or use your own mysql databse and set up MOKB to run from this mysql server, you need to modify the config files to point to your setup. The config files are located in the calo/lib/config directory. You need to create a file called mokb.local.config with the following lines in it:

inherits=mokb.config
mokb.user=(dbuser)
mokb.pass=(dbpass)
mokb.db=(dbname)
mokb.server=(dbhost)

You need to fill in the parameters with values which correspond to your setup. See the mokb.config file for an example which connects to our server at Stanford.