时间: 2021-07-31 作者:daque
c.对表的实质的少许证明.
mysql> use postfix reading table information for completion 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 | | | last_access | 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 是假造的邮箱address@domain.tld ,将被转发到goto下的结合中. goto 不妨用大略的名字,即使是当地用户名,如(root, postmaster, etc.), 大概是所有的邮箱名字,user@domain.tld。
mailbox表的实质: userid 运用者源代码 username 不妨是user.domain.tld 或 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