在Fedora上创建自身的电子邮件网络服务器(2)

mysql use postfix
Reading table pletion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql show tables;
+-------------------+
| Tables_in_postfix |
+-------------------+
| alias |
| domain |
| mailbox |
+-------------------+
3 rows in set (0.00 sec)

mysql desc alias;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| username | varchar(255) | | PRI | | |
| goto | text | | | | |
| domain | varchar(255) | | | | |
+----------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql desc domain;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| domain | varchar(255) | | PRI | | |
| description | varchar(255) | | | | |
+-------------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql desc mailbox;
+--------------------+----------------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+----------------------+------+-----+------------+-------+
| userid | varchar(20) binary | | | | |
| username | varchar(255) | | PRI | | |
| password | varchar(255) | | | | |
| home | varchar(255) | | | | |
| maildir | varchar(255) | | | | |
| name | varchar(255) | | | | |
| uid | smallint(5) unsigned | | | 12345 | |
| gid | smallint(5) unsigned | | | 12345 | |
| quota | varchar(255) | | | | |
| domain | varchar(255) | | | | |
| create_date | date | | | 0000-00-00 | |
| create_time | time | | | 00:00:00 | |
| change_date | date | | | 0000-00-00 | |
| change_time | time | | | 00:00:00 | |
| ess | int(10) unsigned | | | 0 | |
| passwd_lastchanged | int(10) unsigned | | | 0 | |
| status | tinyint(4) | | MUL | 1 | |
+--------------------+----------------------+------+-----+------------+-------+
17 rows in set (0.00 sec)

mysql
domain表的表述:
domain 随意的domain.
description 一般是2种 "local:" 用以当地的 or "virtual:" 用以是虚似的.

alias表的表述:
username ,将被分享到goto下的联接中.
goto 能够用简易的姓名,假如是当地客户名,如(root, postmaster, etc.), 或是是全部的电子邮箱姓名,。

Mailbox表的內容:
Userid 应用者编号
username 能够是user.domain.tld 或
password 在mysql选用encrypt('password') 键入.
name 应用着的真正名字。
uid 虚似客户真实身份uid
gid 组的gid
home "/usr/local/virtual/". Maildirs务必在此文件目录下。
domain 这栏能够不必,但是些手机软件必须他。
maildir 是全部详细地址,务必带”/”末尾。
Quota 电子邮箱的室内空间或信息内容量的限定。
status 0 为严禁。"MYSQL_WHERE_CLAUSE= status" .

三、pam-mysql的编译程序

tar pam-mysql-5.0.tar.gz
make cp pam_mysql.so /lib/security



扫描二维码分享到微信