= Required stuff =

CHANGE_THIS_PATH is equal to new third level domain url or folder that containing it

= Dependencies =

See RT #19985

= Virtualhost =

See 00-apache_site_avaible_rules.

= Database =

postgres-9.1 is ok. We need:
 * user 'ubuntu-it-chiedi'
 * db 'ubuntu-it-chiedi'

= Deploy =

1) svn co http://svn.osqa.net/svnroot/osqa/trunk
2) Put svn into /srv/CHANGE_THIS_PATH/www/osqa/ (important: don't rename the osqa folder)
3) rename osqa.wsgi.dist into osqa.wsgi, then change path into this.
4) rename settings_local.py.dist in settings_local.py and apply some changes:
 a) change db settings **
 b) change the app url
 c) timezone in Europe/Rome
 d) languages in IT
 e) DJANGO_VERSION = 1.3
 f) DISABLED_MODULES add 'mysqlfulltxt', 'localauth' 'sphinxfullsearch'
 g) CACHE_BACKEND = 'memcached://<server-address>:<port>/ with the correct path.
5) python manage.py syncdb --all (no create super user)
6) python manage.py migrate forum --fake
8) python manage.py makemessages -l it


** Note: an example of settings_local.py with right database settings (line 27): http://bazaar.launchpad.net/~ubuntu-it-ask/ubuntu-it-ask/trunk/view/head:/settings_local.py


= Permission =

sudo chown -R www-data:www-data osqa
sudo chmod -R g+w /srv/CHANGE_THIS_PATH/www/osqa/forum/upfiles
sudo chmod -R g+w /srv/CHANGE_THIS_PATH/www/osqa/log

= Import customs settings =

Put 00-forum_keyvalue.sql into osqa database:

1) psql -U ubuntu-it-chiedi ubuntu-it-chiedi -W < forum_keyvalue.sql
2) python /srv/CHANGE_THIS_PATH/www/osqa/manage.py syncdb

(if you need a dump of this table, please use: pg_dump ubuntu-it-chiedi --clean -O -t forum_keyvalue -f forum_keyvalue.sql -U ubuntu-it-chiedi -W )

= Configure pgfulltext =

1) cd forum_modules/pgfulltext
2) psql -U ubuntu-it-chiedi ubuntu-it-chiedi -W < pg_fts_install.sql
3) python /src/CHANGE_THIS_PATH/www/osqa/manage.py syncdb

= Other =

We can perform other changes, if needed, using bzr with no access on
calcium in the next step.

= End =

Now OSQA should be up and running.
