=============
MySQL Backend
=============

This notes detail the MySQL backend for the roundup issue tracker.


Prerequisites
=============

To use MySQL as the backend for storing roundup data, you also need 
to install:

    1. MySQL RDBMS 3.23.34 or higher - http://www.mysql.com. Your MySQL
       installation should support Berkeley DB (BDB) tables for transaction
       support.
    2. Python MySQL interface - http://sourceforge.net/projects/mysql-python


Running the MySQL tests
=======================

Roundup tests expect an empty MySQL database. Two alternate ways to provide 
this:

    1. If you have root permissions on the MySQL server, you can create 
       the necessary database entries using this SQL sequence:

       CREATE DATABASE rounduptest
       GRANT ALL PRIVILEGES ON rounduptest TO rounduptest@localhost IDENTIFIED BY 'rounduptest'
       FLUSH PRIVILEGES

    2. If your administrator has provided you with database connection info, 
       you can modify MYSQL_* constants in the file test/test_db.py with 
       the correct values.

Note that the MySQL database should not contain any tables. Tests will not 
drop the database with existing data.


Additional configuration
========================

To initialise and use the MySQL database backend, roundup's configuration 
file (config.py in the tracker's home directory) should have the following
entries:

    MYSQL_DBHOST = 'localhost'
    MYSQL_DBUSER = 'rounduptest'
    MYSQL_DBPASSWORD = 'rounduptest'
    MYSQL_DBNAME = 'rounduptest'
    MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, MYSQL_DBNAME )

Fill in the first four entries with values for your local MySQL installation 
before running "roundup-admin initialise". 


    Andrey Lebedev <andrey@micro.lt>


 vim: et tw=80