Mercurial > p > roundup > code

comparison doc/mysql.txt @ 1839:06f5b36b201b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix a couple of failures in mysql backend unit tests. Fix the mysql backend docs Note requirement of MySQL version 4.0+ with InnoDB or BDB mysql backend
author Richard Jones <richard@users.sourceforge.net>
date Tue, 07 Oct 2003 08:52:12 +0000
parents 5a28eea9a33c
children 2b0ab61db194
comparison
equal deleted inserted replaced
1838:532f51a2c741 1839:06f5b36b201b
1 ============= 1 =============
2 MySQL Backend 2 MySQL Backend
3 ============= 3 =============
4 4
5 This notes detail the MySQL backend for the roundup issue tracker. 5 :version: $Revision: 1.5 $
6
7 This notes detail the MySQL backend for the Roundup issue tracker.
6 8
7 9
8 Prerequisites 10 Prerequisites
9 ============= 11 =============
10 12
11 To use MySQL as the backend for storing roundup data, you also need 13 To use MySQL as the backend for storing roundup data, you also need
12 to install: 14 to install:
13 15
14 1. MySQL RDBMS 3.23.34 or higher - http://www.mysql.com. Your MySQL 16 1. MySQL RDBMS 4.0 or higher - http://www.mysql.com. Your MySQL
15 installation should support Berkeley DB (BDB) tables for transaction 17 installation MUST support InnoDB tables (or Berkeley DB (BDB) tables
16 support. 18 if you have no other choice)
17 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python 19 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python
18 20
19 21
20 Running the MySQL tests 22 Running the MySQL tests
21 ======================= 23 =======================
22 24
23 Roundup tests expect an empty MySQL database. Two alternate ways to provide 25 Roundup tests expect an empty MySQL database. Two alternate ways to provide
24 this: 26 this:
25 27
26 1. If you have root permissions on the MySQL server, you can create 28 1. If you have root permissions on the MySQL server, you can create
27 the necessary database entries using this SQL sequence: 29 the necessary database entries using the follwing SQL sequence. Use
30 ``mysql`` on the command line to enter::
28 31
29 CREATE DATABASE rounduptest 32 CREATE DATABASE rounduptest;
30 GRANT ALL PRIVILEGES ON rounduptest TO rounduptest@localhost IDENTIFIED BY 'rounduptest' 33 USE rounduptest;
31 FLUSH PRIVILEGES 34 GRANT ALL PRIVILEGES ON rounduptest.* TO rounduptest@localhost
35 IDENTIFIED BY 'rounduptest';
36 FLUSH PRIVILEGES;
32 37
33 2. If your administrator has provided you with database connection info, 38 2. If your administrator has provided you with database connection info,
34 you can modify MYSQL_* constants in the file test/test_db.py with 39 you can modify MYSQL_* constants in the file test/test_db.py with
35 the correct values. 40 the correct values.
36 41
37 Note that the MySQL database should not contain any tables. Tests will not 42 Note that the MySQL database should not contain any tables. Tests will not
38 drop the database with existing data. 43 drop the database with existing data.
39 44
40 45
41 Additional configuration 46 Additional configuration
42 ======================== 47 ========================
43 48
44 To initialise and use the MySQL database backend, roundup's configuration 49 To initialise and use the MySQL database backend, roundup's configuration
45 file (config.py in the tracker's home directory) should have the following 50 file (config.py in the tracker's home directory) should have the following
46 entries: 51 entries::
47 52
48 MYSQL_DBHOST = 'localhost' 53 MYSQL_DBHOST = 'localhost'
49 MYSQL_DBUSER = 'rounduptest' 54 MYSQL_DBUSER = 'rounduptest'
50 MYSQL_DBPASSWORD = 'rounduptest' 55 MYSQL_DBPASSWORD = 'rounduptest'
51 MYSQL_DBNAME = 'rounduptest' 56 MYSQL_DBNAME = 'rounduptest'
52 MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, MYSQL_DBNAME ) 57 MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD,
58 MYSQL_DBNAME )
53 59
54 Fill in the first four entries with values for your local MySQL installation 60 Fill in the first four entries with values for your local MySQL installation
55 before running "roundup-admin initialise". 61 before running "roundup-admin initialise". Use the commands in the `Running the
62 MySQL tests` to set up a database if you have privilege, or ask your local
63 administrator if not.
56 64
57
58 Andrey Lebedev <andrey@micro.lt>
59
60
61 vim: et tw=80
Roundup Issue Tracker: http://roundup-tracker.org/