diff options
author | Martin Krafft <madduck@madduck.net> | 2010-01-31 03:03:10 +0100 |
---|---|---|
committer | Jeremy Kerr <jk@ozlabs.org> | 2010-08-10 11:49:35 +0800 |
commit | ef3b7b60bbfbcd7b61e3a04797d110ee19fc4506 (patch) | |
tree | 49000cc74fa5ab8477eb9b3bf69817d861452eb4 /docs | |
parent | 3811b235306eb4e11f325edf3b2878dc10c5d7a9 (diff) | |
download | patchwork-ef3b7b60bbfbcd7b61e3a04797d110ee19fc4506.tar patchwork-ef3b7b60bbfbcd7b61e3a04797d110ee19fc4506.tar.gz |
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>
Diffstat (limited to 'docs')
-rw-r--r-- | docs/INSTALL | 27 |
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 |