Mercurial > p > roundup > code

comparison doc/mysql.txt @ 1706:5a28eea9a33c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
rewrite to fix english.
author Anthony Baxter <anthonybaxter@users.sourceforge.net>
date Tue, 24 Jun 2003 07:06:12 +0000
parents 1fb2e44d02e3
children 06f5b36b201b 5c6f3da9856f
comparison
equal deleted inserted replaced
1705:1fb2e44d02e3 1706:5a28eea9a33c
1 ============= 1 =============
2 MySQL Backend 2 MySQL Backend
3 ============= 3 =============
4 4
5 This is notes about mysql backend for roundup issue tracker. 5 This notes detail the MySQL backend for the roundup issue tracker.
6 6
7 7
8 Prerequisites 8 Prerequisites
9 ============= 9 =============
10 10
11 To use MySQL as backend for storing roundup data, you should additionally 11 To use MySQL as the backend for storing roundup data, you also need
12 install: 12 to install:
13 13
14 1. MySQL RDBMS 3.23.34 or higher - http://www.mysql.com. Your MySQL 14 1. MySQL RDBMS 3.23.34 or higher - http://www.mysql.com. Your MySQL
15 installation should support Berkeley DB (BDB) tables for transaction 15 installation should support Berkeley DB (BDB) tables for transaction
16 support. 16 support.
17 2. Python interface to mysql - http://sourceforge.net/projects/mysql-python 17 2. Python MySQL interface - http://sourceforge.net/projects/mysql-python
18 18
19 19
20 How to run mysql tests? 20 Running the MySQL tests
21 ======================= 21 =======================
22 22
23 Roundup tests expect an empty database available for use. There are two ways how to 23 Roundup tests expect an empty MySQL database. Two alternate ways to provide
24 provide this: 24 this:
25 25
26 1. If you have root permissions on mysql server, you can create necessary 26 1. If you have root permissions on the MySQL server, you can create
27 database using this SQL sequence: 27 the necessary database entries using this SQL sequence:
28 28
29 CREATE DATABASE rounduptest 29 CREATE DATABASE rounduptest
30 GRANT ALL PRIVILEGES ON rounduptest TO rounduptest@localhost IDENTIFIED BY 'rounduptest' 30 GRANT ALL PRIVILEGES ON rounduptest TO rounduptest@localhost IDENTIFIED BY 'rounduptest'
31 FLUSH PRIVILEGES 31 FLUSH PRIVILEGES
32 32
33 2. If your administrator has provided you with database connection info, you 33 2. If your administrator has provided you with database connection info,
34 can modify MYSQL_* constants in test/test_db.py with corresponding 34 you can modify MYSQL_* constants in the file test/test_db.py with
35 values. 35 the correct values.
36 36
37 Note, that mysql database should not contain any tables. Tests will not dare to 37 Note that the MySQL database should not contain any tables. Tests will not
38 drop database with data. 38 drop the database with existing data.
39 39
40 40
41 Additional configuration 41 Additional configuration
42 ======================== 42 ========================
43 43
44 To initialise and use mysql database roundup' configuration file (config.py in 44 To initialise and use the MySQL database backend, roundup's configuration
45 the tracker' home directory) should be appended with the following constants: 45 file (config.py in the tracker's home directory) should have the following
46 entries:
46 47
47 MYSQL_DBHOST = 'localhost' 48 MYSQL_DBHOST = 'localhost'
48 MYSQL_DBUSER = 'rounduptest' 49 MYSQL_DBUSER = 'rounduptest'
49 MYSQL_DBPASSWORD = 'rounduptest' 50 MYSQL_DBPASSWORD = 'rounduptest'
50 MYSQL_DBNAME = 'rounduptest' 51 MYSQL_DBNAME = 'rounduptest'
51 MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, MYSQL_DBNAME ) 52 MYSQL_DATABASE = ( MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, MYSQL_DBNAME )
52 53
53 Fill first four constants with real values before running 54 Fill in the first four entries with values for your local MySQL installation
54 "roundup-admin initialise". 55 before running "roundup-admin initialise".
55
56 56
57 57
58 Andrey Lebedev <andrey@micro.lt> 58 Andrey Lebedev <andrey@micro.lt>
59 59
60 60
Roundup Issue Tracker: http://roundup-tracker.org/