Mercurial > p > roundup > code
changeset 2595:7b2ea468381a maint-0.7
merge from HEAD
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Tue, 20 Jul 2004 04:47:45 +0000 |
| parents | 9e1c4c932323 |
| children | 070e7989d801 |
| files | doc/installation.txt doc/mysql.txt doc/postgresql.txt |
| diffstat | 3 files changed, 29 insertions(+), 14 deletions(-) [+] |
line wrap: on
line diff
--- a/doc/installation.txt Tue Jul 20 02:10:43 2004 +0000 +++ b/doc/installation.txt Tue Jul 20 04:47:45 2004 +0000 @@ -476,6 +476,12 @@ write to the database, and any new files created in the database will be owned by the group. +If you're using the mysql or postgresql backend then you'll need to ensure +that the tracker user has appropriate permissions to create/modify the +database. If you're using roundup.cgi, the apache user needs permissions +to modify the database. Alternatively, explicitly specify a database login +in ``POSTRGRESQL_DATABASE`` or ``MYSQL_DATABASE`` in ``config.py``. + An alternative to the above is to create a new user who has the sole responsibility of running roundup. This user:
--- a/doc/mysql.txt Tue Jul 20 02:10:43 2004 +0000 +++ b/doc/mysql.txt Tue Jul 20 04:47:45 2004 +0000 @@ -53,8 +53,8 @@ ======================== 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:: +file (``config.py`` in the tracker's home directory) should have the following +entries (substituting real values of course):: MYSQL_DBHOST = 'localhost' MYSQL_DBUSER = 'rounduptest' @@ -64,9 +64,9 @@ MYSQL_DBNAME ) Fill in the first four entries with values for your local MySQL installation -before running "roundup-admin initialise". Use the commands in the `Running the -MySQL tests` to set up a database if you have privilege, or ask your local -administrator if not. +before running "roundup-admin initialise". Use the commands in the +`Running the MySQL tests`_ to set up a database if you have privilege, or +ask your local administrator if not. Showing MySQL who's boss @@ -82,3 +82,4 @@ and all will be better (note that on some systems, ``mysql`` is spelt ``mysqld``). +
--- a/doc/postgresql.txt Tue Jul 20 02:10:43 2004 +0000 +++ b/doc/postgresql.txt Tue Jul 20 04:47:45 2004 +0000 @@ -33,13 +33,15 @@ ======================== To initialise and use PostgreSQL database roundup's configuration file -(config.py in the tracker's home directory) should be appended with the -following constants (substituting real values, obviously):: +(``config.py`` in the tracker's home directory) should be ammended with +the following constants (substituting real values, obviously):: POSTGRESQL_DATABASE = {'database': 'rounduptest'} -if not local, or a different user is to be used, then more information may -be supplied:: +Note that it's usually a good idea to explicitly specify the user which is +to be used access the database too, to avoid permissions problems. If +postgresql is not local, or a different user is to be used, then more +information may be supplied:: POSTGRESQL_DATABASE = { 'host': 'localhost', 'port': 5432, @@ -50,10 +52,16 @@ Also note that you can leave some values out of ``POSTGRESQL_DATABASE``: 'host' and 'port' are not necessary when connecting to a local database and 'password' -is optional if postgres trusts local connections. The user specified in -``user`` must have rights to create a new database and to -connect to the "template1" database, used while initializing roundup. +is optional if postgres trusts local connections. + +The user specified in ``user`` must have rights to create a new database +and to connect to the "template1" database, used while initializing roundup. + + - Have fun with psycopg, - Federico Di Gregorio <fog@initd.org> +Credit +====== +The postgresql backend was originally submitted by Federico Di Gregorio +<fog@initd.org> +
