Mailserver: Unterschied zwischen den Versionen
Doc (Diskussion | Beiträge) (Seite erstellt) |
Jochen (Diskussion | Beiträge) |
||
| Zeile 4: | Zeile 4: | ||
Struktur der db: | Struktur der db: | ||
| + | (TODO Jochen) | ||
| + | |||
| + | <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 | ||
Version vom 7. April 2012, 12:39 Uhr
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
