Synnefo¶
synnefo || ns || apt || mq || db || gunicorn || apache || webproject || astakos || cms || pithos || cyclades || kamaki || backends
Database Setup¶
The following apply to db node. For the rest of the sections we will
refer to its IP as db.example.com .
First install progresql:
# apt-get install postgresql
We create a database called snf_apps, that will host all django
apps related tables. We also create the user synnefo and grant him all
privileges on the database. We do this by running:
# su - postgres
postgres:~$ psql
postgres=# CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0;
postgres=# CREATE USER synnefo WITH PASSWORD 'example_passw0rd';
postgres=# GRANT ALL PRIVILEGES ON DATABASE snf_apps TO synnefo;
We also create the database snf_pithos needed by the Pithos backend and
grant the synnefo user all privileges on the database.
postgres=# CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0;
postgres=# GRANT ALL PRIVILEGES ON DATABASE snf_pithos TO synnefo;
Configure the database to listen to all network interfaces. You can do this by editting the file /etc/postgresql/8.4/main/postgresql.conf with:
listen_addresses = '*'Furthermore, edit /etc/postgresql/8.4/main/pg_hba.conf to allow the nodes to connect to the database. Add the following line:
host all all 4.3.2.0/24 md5# /etc/init.d/postgresql restart