summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMartin Krafft <madduck@madduck.net>2010-01-31 03:03:10 +0100
committerJeremy Kerr <jk@ozlabs.org>2010-08-10 11:49:35 +0800
commitef3b7b60bbfbcd7b61e3a04797d110ee19fc4506 (patch)
tree49000cc74fa5ab8477eb9b3bf69817d861452eb4
parent3811b235306eb4e11f325edf3b2878dc10c5d7a9 (diff)
downloadpatchwork-ef3b7b60bbfbcd7b61e3a04797d110ee19fc4506.tar.bz2
patchwork-ef3b7b60bbfbcd7b61e3a04797d110ee19fc4506.tar.xz
docs: Document password-based pgsql login
As an alternative to ident-based authentication for PostgreSQL, one can use password-based authentication. This patch adds the alternative to the docs. Signed-off-by: martin f. krafft <madduck@madduck.net> Signed-off-by: Jeremy Kerr <jk@ozlabs.org>
-rw-r--r--docs/INSTALL27
1 files changed, 24 insertions, 3 deletions
diff --git a/docs/INSTALL b/docs/INSTALL
index 0ed2cea..7a32434 100644
--- a/docs/INSTALL
+++ b/docs/INSTALL
@@ -29,7 +29,10 @@ in brackets):
user that your mail server runs as). On Ubuntu these are
www-data and nobody, respectively.
- For PostgreSQL
+ As an alternative, you can use password-based login and a single database
+ account. This is described further down.
+
+ For PostgreSQL (ident-based)
$ createdb patchwork
$ createuser www-data
@@ -39,7 +42,23 @@ in brackets):
will only be accessible for processes running as the same username.
This means that no passwords need to be set.
- For MySQL:
+ For PostgreSQL (password-based)
+
+ $ createuser -PE patchwork
+ $ createdb -O patchwork patchwork
+
+ Once that is done, you need to tell Django about the new Database
+ settings, using local_settings.py (see below) to override the defaults
+ in settings.py:
+
+ DATABASE_ENGINE = 'postgresql_psycopg2'
+ DATABASE_NAME = 'patchwork'
+ DATABASE_USER = 'patchwork'
+ DATABASE_PASSWORD = 'my_secret_password
+ DATABASE_HOST = 'localhost'
+ DATABASE_PORT = ''
+
+ For MySQL:
$ mysql
> CREATE DATABASE 'patchwork';
> CREATE USER 'www-data'@'localhost' IDENTIFIED BY '<password>';
@@ -119,7 +138,9 @@ in brackets):
cd apps/
PYTHONPATH=../lib/python ./manage.py syncdb
- And add privileges for your mail and web users:
+ And add privileges for your mail and web users. This is only needed if
+ you use the ident-based approach. If you use password-based database
+ authentication, you can skip this step.
Postgresql:
psql -f lib/sql/grant-all.postgres.sql patchwork