Mailserver

Diese Seite beschreibt die Konfiguration unseres Mailservers mailgate.zerties.org

TODO: Konfiguration am Beispiel icedove mit screenshots

Struktur der db: (TODO Jochen)

--
-- Datenbank: `maildb`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `domains`
--

CREATE TABLE IF NOT EXISTS `domains` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
  `is_enabled` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
  `created_at` int(16) NOT NULL,
  `updated_at` int(16) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `domain` (`domain`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

--
-- Tabellenstruktur für Tabelle `mail_accounts`
--
CREATE TABLE IF NOT EXISTS `mail_accounts` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `local_part` varchar(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT '',
  `domain` int(16) NOT NULL,
  `forward` varchar(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
  `cc` varchar(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT '',
  `pwmd5` varchar(255) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT '',
  `is_away` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT 'no',
  `away_text` text CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL,
  `spam_check` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT 'no',
  `spam_purge` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT 'no',
  `virus_check` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT 'no',
  `is_enabled` enum('yes','no') CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT 'yes',
  `created_at` int(16) NOT NULL,
  `updated_at` int(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE_EMAIL` (`domain`,`local_part`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=581 ;

TODO: php-Skript zum Anlagen neuer Aliases