[copr] master: document how to create db (d968f78)

[Miroslav Suchý]

Repository : http://git.fedorahosted.org/cgit/copr.git

On branch  : master
>

commit d968f78351281c1e7aecab8e04e0f467aa17c61a
Author: Miroslav Suchý 
Date:   Thu Jun 20 12:04:56 2013 +0200

document how to create db
>

copr-setup.txt |   51 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 51 insertions(+), 0 deletions(-)

diff --git a/copr-setup.txt b/copr-setup.txt
index ca5703d..9047dae 100644
--- a/copr-setup.txt
+++ b/copr-setup.txt
@@ -91,5 +91,56 @@ Required pkgs:

- edit credentials in coprs_frontend/coprs/config.py
 - cd /usr/share/copr/coprs_frontend
+- configure DB first - see DB section below
+# for develop setup do:
 - ./manage.py create_db --alembic alembic.ini
+# for production setup do:
+COPRS_ENVIRON_PRODUCTION=1 ./manage.py create_db  --alembic alembic.ini

+- for developing you can run:
+  ./manage.py runserver -t <FQDN>
+  and this will load DevelopmentConfig from coprs_frontend/coprs/config.py
+
+- for production is used ProductionConfig from coprs_frontend/coprs/config.py
+
+
+DB config
+=========
+
+Copr can use either SQLite or PostgreSQL. Choose one.
+
+SQLite
+~~~~~~
+
+- yum install sqlite
+- in file coprs_frontend/coprs/config.py put:
+  SQLALCHEMY_DATABASE_URI = 'sqlite:///' + os.path.abspath(DATABASE)
+This will use sqlite db file in /usr/share/copr/data/copr.db (manage.py will create that file)
+
+PostgreSQL
+~~~~~~~~~~
+
+- yum install -y postgresql-server
+- chkconfig postgresql on
+- on Fedoras, run:
+ postgresql-setup initdb
+- everywhere else run:
+ service postgresql initdb
+
+- service postgresql start
+- su - postgres -c 'PGPASSWORD=coprpass ; createdb -E UTF8 coprdb ; yes $PGPASSWORD | createuser -P -sDR copr-fe'
+
+Configure the user to use md5 password to connect to that database. Put the lines like following to /var/lib/pgsql/data/pg_hba.conf. Avoid the common pitfall: Make sure you put them *before* those existing lines that are for all..
+
+local coprdb copr-fe md5
+host  coprdb copr-fe 127.0.0.1/8 md5
+host  coprdb copr-fe ::1/128 md5
+local coprdb postgres  ident
+
+Then reload PostgreSQL:
+ service postgresql reload
+
+and test the connection:
+
+PGPASSWORD=coprpass psql -a -U copr-fe coprdb
+PGPASSWORD=coprpass psql -a -h localhost -U copr-fe coprdb