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>
+

Roundup Issue Tracker: http://roundup-tracker.org/