synnefo || ns || apt || mq || db || gunicorn || apache || webproject || astakos || qh || cms || pithos || cyclades || kamaki || backends
The following apply to astakos, pithos, cyclades and cms nodes.
First install:
# apt-get install python-psycopg2
# apt-get install snf-webproject
In /etc/synnefo/snf-webproject.conf add:
from synnefo.lib.db.pooled_psycopg2 import monkey_patch_psycopg2
monkey_patch_psycopg2()
from synnefo.lib.db.psyco_gevent import make_psycopg_green
make_psycopg_green()
DATABASES = {
'default': {
# 'postgresql_psycopg2', 'postgresql','mysql', 'sqlite3' or 'oracle'
'ENGINE': 'postgresql_psycopg2',
'OPTIONS': {'synnefo_poolsize': 8},
# ATTENTION: This *must* be the absolute path if using sqlite3.
# See: http://docs.djangoproject.com/en/dev/ref/settings/#name
'NAME': 'snf_apps',
'USER': 'synnefo', # Not used with sqlite3.
'PASSWORD': 'examle_passw0rd', # Not used with sqlite3.
# Set to empty string for localhost. Not used with sqlite3.
'HOST': 'db.example.com',
# Set to empty string for default. Not used with sqlite3.
'PORT': '5432',
}
}
USE_X_FORWARDED_HOST = True
SECRET_KEY = 'sy6)mw6a7x%n)-example_secret_key#zzk4jo6f2=uqu!1o%)'
SESSION_COOKIE_DOMAIN = "example.com"
All the above enables pooling (of connections) and greenlet context.