[精]搭建postfix+dovecot+ courier-authlib+sasl2+mysql邮件系统(5)

12

(精)搭建postfix+dovecot+ courier-authlib+sasl2+mysql邮件系统

PRIMARY KEY (`username`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Admins'; /*锁定表，插入记录*/

LOCK TABLES `admin` WRITE;

INSERT INTO `admin` VALUES ('admin@163.com','$1$2709f519$wlPsSKnrAqytQE.gDKCam1','2011-12-12 10:30:12','2011-12-12 10:30:12',1),('yt@yt.com','$1$90be40db$2ma9wPrTKjDylyUz3RYMa/','2011-12-12 10:37:16','2011-12-12 12:59:59',1); UNLOCK TABLES;

注意：这里的密码保存的是经过grup-md5-crypt加密后的字串，具体的使用方式如下: [root@mail ~]# grub-md5-crypt Password: Retype password: $1$iBX5Q0$kOpgUYH0bu3lrUjs/z0RZ0 如果我们想把某个用户的密码重置掉我们都可以使用此种方式将加密后的字串存到密码表中.

/*创建别名表*/

mysql> desc alias;+----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------------------+-------+ | address | varchar(255) | NO | PRI | NULL | | | goto | text | NO | | NULL | | | domain | varchar(255) | NO | MUL | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | | +----------+--------------+------+-----+---------------------+-------+ 6 rows in set (0.03 sec)

DROP TABLE IF EXISTS `alias`; CREATE TABLE `alias` (

`address` varchar(255) NOT NULL, `goto` text NOT NULL,

`domain` varchar(255) NOT NULL,

`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`address`), KEY `domain` (`domain`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Aliases'; LOCK TABLES `alias` WRITE;

/*!40000 ALTER TABLE `alias` DISABLE KEYS */;

13

(精)搭建postfix+dovecot+ courier-authlib+sasl2+mysql邮件系统

INSERT INTO `alias` VALUES ('mm@yt.com','mm@yt.com','yt.com','2011-12-12 13:00:33','2011-12-12 13:00:33',1),('mm2@yt.com','mm2@yt.com','yt.com','2011-12-12 13:01:19','2011-12-12 13:01:19',1); UNLOCK TABLES;

/*创建别名域表*/

+---------------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------------------+-------+ | alias_domain | varchar(255) | NO | PRI | NULL | | | target_domain | varchar(255) | NO | MUL | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | MUL | 1 | | +---------------+--------------+------+-----+---------------------+-------+ DROP TABLE IF EXISTS `alias_domain`;

/*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alias_domain` ( `alias_domain` varchar(255) NOT NULL, `target_domain` varchar(255) NOT NULL,

`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`alias_domain`), KEY `active` (`active`),

KEY `target_domain` (`target_domain`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Domain Aliases';

LOCK TABLES `alias_domain` WRITE; UNLOCK TABLES;

/*配置信息表 */

DROP TABLE IF EXISTS `config`; CREATE TABLE `config` (

`id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL DEFAULT '', `value` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`),

14

(精)搭建postfix+dovecot+ courier-authlib+sasl2+mysql邮件系统

UNIQUE KEY `name` (`name`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='PostfixAdmin settings';

LOCK TABLES `config` WRITE;

INSERT INTO `config` VALUES (1,'version','740'); UNLOCK TABLES;

/*域名配置表*/ mysql> desc domain;

+-------------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------- +--------------+------+-----+---------------------+-------+ | domain | varchar(255) | NO | PRI | NULL | | | description | varchar(255) | NO | | NULL | | | aliases | int(10) | NO | | 0 | | | mailboxes | int(10) | NO | | 0 | | | maxquota | bigint(20) | NO | | 0 | | | quota | bigint(20) | NO | | 0 | | | transport | varchar(255) | NO | | NULL | | | backupmx | tinyint(1) | NO | | 0 | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | modified | datetime | NO | | 0000-00-00 00:00:00 | | | active | tinyint(1) | NO | | 1 | | +-------------+--------------+------+-----+---------------------+-------+ DROP TABLE IF EXISTS `domain`; CREATE TABLE `domain` ( `domain` varchar(255) NOT NULL,

`description` varchar(255) CHARACTER SET utf8 NOT NULL, `aliases` int(10) NOT NULL DEFAULT '0', `m …… 此处隐藏：2999字，全部文档内容请下载后查看。喜欢就下载吧 ……