aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorStefan Kangas <skangas@skangas.se>2010-12-17 06:31:51 +0100
committerStefan Kangas <skangas@skangas.se>2010-12-17 06:31:51 +0100
commit1cd69b7e7d73e8c352a572bf47edeb4046525430 (patch)
tree00c7f9df05b606570f2f72e708cfe7531deca450
parent93d64fe8b00503ae4b1fd709cedcf8c9575f3a71 (diff)
More work on documenting the MySQL configuration.
-rw-r--r--fripost-docs.org41
1 files changed, 38 insertions, 3 deletions
diff --git a/fripost-docs.org b/fripost-docs.org
index 2a8a361..ce33b50 100644
--- a/fripost-docs.org
+++ b/fripost-docs.org
@@ -170,11 +170,46 @@ Aptitude
** Configuring the e-mail servers
- We will be using one main mail storage server, accessible by users via IMAP. We will have two or more mail gateways that will relay e-mail to the main server over secure connections.
+ We will be using one main mail storage server, accessible by users via IMAP.
+ This server should be referred to as the main `IMAP server'. We will have two
+ or more mail gateways that will relay e-mail to the main server over secure
+ connections. These are called `smarthosts'.
- The main server will also be responsible for keeping all users in an MySQL database that will be replicated over
+ The main server will also be responsible for keeping all users in an MySQL
+ database that will be replicated using MySQL.
+
+*** Basic configuration of MySQL
+**** Installing MySQL
+ - sudo apt-get-install mysql-server
+ - generate a long (25 characters) password for the mysql root user
+
+**** Configuring the main IMAP server
+ We will use four tables `alias', `domain', `log' and `mailbox'.
+
+ // FIXME; add description of tables
+ :HIDDEN:
+mysql> show tables;
+
+mysql> describe alias;
+
+mysql> describe domain;
+
+mysql> describe log;
+
+mysql> describe mailbox;
+ :END:
+
+ - to set up the tables, use the following schema // FIXME: Add schema
+ :HIDDEN:
+
+ :END:
+
+**** Configuring the MySQL replication
+ This link looks promising:
+ http://www.howtoforge.com/mysql_database_replication
+
+ However, we will be using an SSH tunnel for this, so this needs to be described.
-*** Configuring the MySQL replication
*** Configuring the SSH tunnel between a new smarthost and the main IMAP server
Definitons: