欧美日韩精品在线,国内精品久久久久久久久,一级毛片恃级毛片直播,清纯唯美亚洲综合欧美色

構(gòu)建反病毒反垃圾郵件系統(tǒng)(二)_Mail服務(wù)器教程

編輯Tag賺U幣
教程Tag:暫無Tag,歡迎添加,賺取U幣!
  3、與MySQL結(jié)合的配置及數(shù)據(jù)表結(jié)構(gòu)

  注意:配置mysql相關(guān)部分要寫127.0.0.1而不要寫localhost,如果使用localhost,postfix會嘗試socket連接。debian的postfix使用socket連接好像有問題。mysql不能使用skip-networking選項,要使用--bind-address=127.0.0.1讓它監(jiān)聽在127.0.0.1。(非常感謝Martin List-Petersen指點)

  還有要注意的是如果是自己編譯的mysql,建議在啟動的時候加上--socket=/var/run/mysqld/mysqld.sock參數(shù),因為pam-mysql又需要使用這個socket。如果你的apache+php是自己編譯的話,php又需要重新編譯,配置的時候需要加上--with-mysql-sock=/var/run/mysqld/mysqld.sock參數(shù)。

  是不是比較煩?這不過是個開始。

  MySQL的數(shù)據(jù)表:

  CREATE TABLE alias (
  id int(11) unsigned NOT NULL auto_increment,
  alias varchar(128) NOT NULL default '',
  destination varchar(128) NOT NULL default '',
  PRIMARY KEY (id)
  ) TYPE=MyISAM;

  CREATE TABLE relocated (
  id int(11) unsigned NOT NULL auto_increment,
  email varchar(128) NOT NULL default '',
  destination varchar(128) NOT NULL default '',
  PRIMARY KEY (id)
  ) TYPE=MyISAM;

  CREATE TABLE transport (
  id int(11) unsigned NOT NULL auto_increment,
  domain varchar(128) NOT NULL default '',
  destination varchar(128) NOT NULL default '',
  PRIMARY KEY (id),
  UNIQUE KEY domain (domain)
  ) TYPE=MyISAM;

  CREATE TABLE users (
  id int(11) unsigned NOT NULL auto_increment,
  email varchar(128) NOT NULL default '',
  clear varchar(128) NOT NULL default '',
  name tinytext NOT NULL,
  uid int(11) unsigned NOT NULL default '1011',
  gid int(11) unsigned NOT NULL default '1011',
  homedir tinytext NOT NULL,
  maildir tinytext NOT NULL,
  quota tinytext NOT NULL,
  postfix enum('Y','N') NOT NULL default 'Y',
  PRIMARY KEY (id),
  UNIQUE KEY email (email)
  ) TYPE=MyISAM;

  CREATE TABLE virtual (
  id int(11) unsigned NOT NULL auto_increment,
  email varchar(128) NOT NULL default '',
  destination varchar(128) NOT NULL default '',
  PRIMARY KEY (id)
  ) TYPE=MyISAM;

  /etc/postfix目錄下各mysql配置文件:

  mysql-aliases.cf

  user = mysql-postfix-user
  password = mysql-postfix-pass
  dbname = postfix
  table = alias
  select_field = destination
  where_field = alias
  hosts = 127.0.0.1

  mysql-relocated.cf

  user = mysql-postfix-user
  password = mysql-postfix-pass
  dbname = postfix
  table = relocated
  select_field = destination
  where_field = email
  hosts = 127.0.0.1

  mysql-transport.cf

  user = mysql-postfix-user
  password = mysql-postfix-pass
  dbname = postfix
  table = transport
  select_field = destination
  where_field = domain
  hosts = 127.0.0.1

來源:網(wǎng)絡(luò)搜集//所屬分類:Mail服務(wù)器教程/更新時間:2013-04-15
相關(guān)Mail服務(wù)器教程