Version: | $Revision$ |
---|
This notes detail the MySQL backend for the Roundup issue tracker.
To use MySQL as the backend for storing roundup data, you also need to install:
Roundup tests expect an empty MySQL database. Two alternate ways to provide this:
If you have root permissions on the MySQL server, you can create the necessary database entries using the follwing SQL sequence. Use mysql on the command line to enter:
CREATE DATABASE rounduptest; USE rounduptest; GRANT ALL PRIVILEGES ON rounduptest.* TO rounduptest@localhost IDENTIFIED BY 'rounduptest'; FLUSH PRIVILEGES;
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.
The MySQL database should not contain any tables. Tests will not drop the database with existing data.
If things ever get to the point where that test database is totally hosed, just:
$ su - # /etc/init.d/mysql stop # rm -rf /var/lib/mysql/rounduptest # /etc/init.d/mysql start
and all will be better (note that on some systems, mysql is spelt mysqld).