Differences

This shows you the differences between two versions of the page.

--- setup:mx [2013/07/31 13:06] – maildroprc update root
+++ setup:mx [2013/07/31 13:16] (current) – [MySQL] root
@@ Line 6: / Line 6: @@
 ==== MySQL ====
+Create a database with a user with appropriate rights
+Then go into that database and execute this:
+<code>
+CREATE TABLE IF NOT EXISTS `domains` (
+  `domain` varchar(50) NOT NULL,
+  PRIMARY KEY (`domain`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+CREATE TABLE IF NOT EXISTS `forwardings` (
+  `source` varchar(80) NOT NULL,
+  `destination` text NOT NULL,
+  PRIMARY KEY (`source`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+CREATE TABLE IF NOT EXISTS `transport` (
+  `domain` varchar(128) NOT NULL DEFAULT '',
+  `transport` varchar(128) NOT NULL DEFAULT '',
+  UNIQUE KEY `domain` (`domain`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+CREATE TABLE IF NOT EXISTS `users` (
+  `email` varchar(80) NOT NULL,
+  `password` varchar(20) NOT NULL,
+  `quota` bigint(20) DEFAULT '10485760',
+  PRIMARY KEY (`email`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+</code>
+In the table **domains**, add each domain you want to manage on your server.
+In the table **forwardings**, add each email value pair that you want to redirect, no account is needed on the server.
+In the table **transport**, add transport directives for each domain you want to configure. For locally hosted domains, add **:** in the transport column.
+In the table **users**, add an entry for each managed user you want to give a mailbox. Quota is expressed in bytes, and don't forget to use the **ENCRYPT** function to store the user password.
 ==== Setup milters ====