Mailserver: Unterschied zwischen den Versionen
Doc (Diskussion | Beiträge) (Seite erstellt) |
Doc (Diskussion | Beiträge) (Screenshots IMAP-Config icedove beigefügt) |
||
| (Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
| − | + | = Diese Seite beschreibt die Konfiguration unseres Mailservers mailgate.zerties.org = | |
| − | + | '''Konfiguration am Beispiel icedove mit screenshots''' | |
| − | + | Es benutzt vermutlich niemand mehr POP3- daher hab ich mal meine IMAP-Konfig eingestellt: | |
| − | ( | + | [[Datei:Posteingang.png]] |
| + | |||
| + | [[Datei:Postausgang.png]] | ||
| + | |||
| + | |||
| + | '''Struktur der db:''' | ||
| + | |||
| + | <pre> | ||
| + | -- | ||
| + | -- 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 ; | ||
| + | </pre> | ||
TODO: php-Skript zum Anlagen neuer Aliases | TODO: php-Skript zum Anlagen neuer Aliases | ||
Aktuelle Version vom 7. April 2012, 15:44 Uhr
Diese Seite beschreibt die Konfiguration unseres Mailservers mailgate.zerties.org
Konfiguration am Beispiel icedove mit screenshots
Es benutzt vermutlich niemand mehr POP3- daher hab ich mal meine IMAP-Konfig eingestellt:
Struktur der db:
--
-- 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
