From 1cd69b7e7d73e8c352a572bf47edeb4046525430 Mon Sep 17 00:00:00 2001 From: Stefan Kangas Date: Fri, 17 Dec 2010 06:31:51 +0100 Subject: More work on documenting the MySQL configuration. --- fripost-docs.org | 41 ++++++++++++++++++++++++++++++++++++++--- 1 file 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: -- cgit v1.2.3