root / docs / scale / i-db.rst @ 36fea6f9
History | View | Annotate | Download (1.9 kB)
1 | 6928da52 | Dimitris Aragiorgis | .. _i-db: |
---|---|---|---|
2 | 6928da52 | Dimitris Aragiorgis | |
3 | 6928da52 | Dimitris Aragiorgis | Synnefo |
4 | 6928da52 | Dimitris Aragiorgis | ------- |
5 | 6928da52 | Dimitris Aragiorgis | |
6 | 6928da52 | Dimitris Aragiorgis | :ref:`synnefo <i-synnefo>` || |
7 | 6928da52 | Dimitris Aragiorgis | :ref:`ns <i-ns>` || |
8 | 6928da52 | Dimitris Aragiorgis | :ref:`apt <i-apt>` || |
9 | 6928da52 | Dimitris Aragiorgis | :ref:`mq <i-mq>` || |
10 | 6928da52 | Dimitris Aragiorgis | db || |
11 | 6928da52 | Dimitris Aragiorgis | :ref:`gunicorn <i-gunicorn>` || |
12 | 6928da52 | Dimitris Aragiorgis | :ref:`apache <i-apache>` || |
13 | 6928da52 | Dimitris Aragiorgis | :ref:`webproject <i-webproject>` || |
14 | 6928da52 | Dimitris Aragiorgis | :ref:`astakos <i-astakos>` || |
15 | 6928da52 | Dimitris Aragiorgis | :ref:`cms <i-cms>` || |
16 | 6928da52 | Dimitris Aragiorgis | :ref:`pithos <i-pithos>` || |
17 | 6928da52 | Dimitris Aragiorgis | :ref:`cyclades <i-cyclades>` || |
18 | 6928da52 | Dimitris Aragiorgis | :ref:`kamaki <i-kamaki>` || |
19 | 6928da52 | Dimitris Aragiorgis | :ref:`backends <i-backends>` |
20 | 6928da52 | Dimitris Aragiorgis | |
21 | 6928da52 | Dimitris Aragiorgis | Database Setup |
22 | 6928da52 | Dimitris Aragiorgis | ++++++++++++++ |
23 | 6928da52 | Dimitris Aragiorgis | |
24 | 6928da52 | Dimitris Aragiorgis | The following apply to ``db`` node. For the rest of the sections we will |
25 | 6928da52 | Dimitris Aragiorgis | refer to its IP as ``db.example.com`` . |
26 | 6928da52 | Dimitris Aragiorgis | |
27 | 6928da52 | Dimitris Aragiorgis | First install progresql: |
28 | 6928da52 | Dimitris Aragiorgis | |
29 | 6928da52 | Dimitris Aragiorgis | .. code-block:: console |
30 | 6928da52 | Dimitris Aragiorgis | |
31 | 6928da52 | Dimitris Aragiorgis | # apt-get install postgresql |
32 | 6928da52 | Dimitris Aragiorgis | |
33 | 6928da52 | Dimitris Aragiorgis | We create a database called ``snf_apps``, that will host all django |
34 | 6928da52 | Dimitris Aragiorgis | apps related tables. We also create the user ``synnefo`` and grant him all |
35 | 6928da52 | Dimitris Aragiorgis | privileges on the database. We do this by running: |
36 | 6928da52 | Dimitris Aragiorgis | |
37 | 6928da52 | Dimitris Aragiorgis | .. code-block:: console |
38 | 6928da52 | Dimitris Aragiorgis | |
39 | 6928da52 | Dimitris Aragiorgis | # su - postgres |
40 | 6928da52 | Dimitris Aragiorgis | postgres:~$ psql |
41 | 6928da52 | Dimitris Aragiorgis | postgres=# CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; |
42 | 6928da52 | Dimitris Aragiorgis | postgres=# CREATE USER synnefo WITH PASSWORD 'example_passw0rd'; |
43 | 6928da52 | Dimitris Aragiorgis | postgres=# GRANT ALL PRIVILEGES ON DATABASE snf_apps TO synnefo; |
44 | 6928da52 | Dimitris Aragiorgis | |
45 | e5d8df8c | Constantinos Venetsanopoulos | We also create the database ``snf_pithos`` needed by the Pithos backend and |
46 | 6928da52 | Dimitris Aragiorgis | grant the ``synnefo`` user all privileges on the database. |
47 | 6928da52 | Dimitris Aragiorgis | |
48 | 6928da52 | Dimitris Aragiorgis | .. code-block:: console |
49 | 6928da52 | Dimitris Aragiorgis | |
50 | 6928da52 | Dimitris Aragiorgis | postgres=# CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; |
51 | 6928da52 | Dimitris Aragiorgis | postgres=# GRANT ALL PRIVILEGES ON DATABASE snf_pithos TO synnefo; |
52 | 6928da52 | Dimitris Aragiorgis | |
53 | 6928da52 | Dimitris Aragiorgis | Configure the database to listen to all network interfaces. You can do this by |
54 | 6928da52 | Dimitris Aragiorgis | editting the file `/etc/postgresql/8.4/main/postgresql.conf` with: |
55 | 6928da52 | Dimitris Aragiorgis | |
56 | 6928da52 | Dimitris Aragiorgis | | ``listen_addresses = '*'`` |
57 | 6928da52 | Dimitris Aragiorgis | |
58 | 6928da52 | Dimitris Aragiorgis | Furthermore, edit `/etc/postgresql/8.4/main/pg_hba.conf` to allow the nodes |
59 | 6928da52 | Dimitris Aragiorgis | to connect to the database. Add the following line: |
60 | 6928da52 | Dimitris Aragiorgis | |
61 | 6928da52 | Dimitris Aragiorgis | | ``host all all 4.3.2.0/24 md5`` |
62 | 6928da52 | Dimitris Aragiorgis | |
63 | 6928da52 | Dimitris Aragiorgis | .. code-block:: console |
64 | 6928da52 | Dimitris Aragiorgis | |
65 | 6928da52 | Dimitris Aragiorgis | # /etc/init.d/postgresql restart |
66 | 81b92b0f | Dimitris Aragiorgis | |
67 | 81b92b0f | Dimitris Aragiorgis | |
68 | 81b92b0f | Dimitris Aragiorgis | Test your Setup: |
69 | 81b92b0f | Dimitris Aragiorgis | ++++++++++++++++ |