1.查看MYSQL是否已经安装

[root@linuxas3 src]# rpm -qa |grep MySQL
MySQL-Max-4.0.18-0
MySQL-client-4.0.18-0
MySQL-bench-4.0.18-0
MySQL-shared-compat-4.0.18-0
MySQL-server-4.0.18-0
MySQL-embedded-4.0.18-0
MySQL-devel-4.0.18-0
perl-DBD-MySQL-2.1021-3
MySQL-shared-4.0.18-0

postfix 数据库脚本
CREATE DATABASE mail;

GRANT ALL ON mail.* TO mail@localhost IDENTIFIED BY "liuxuehua";

FLUSH PRIVILEGES;


USE mail;



# Database mail running on localhost 

# phpMyAdmin SQL Dump

# version 2.5.6

# http://www.phpmyadmin.net

#

# Host: localhost

# Generation Time: Apr 21, 2004 at 03:00 PM

# Server version: 4.0.18

# PHP Version: 4.3.2

# 

# Database : `mail`

# 



# --------------------------------------------------------
 

2.pam_mysql-0.5



tar zxvf pam_mysql-0.5.tar.gz

cd pam_mysql

make

cp pam_mysql.so /lib/security

cd ..

rm -rf pam_mysql 



3.Cyrus-SASL安装配置

SASL (Simple Authentication Security Layer)简单认证安全层,在这里有功能主要是用于SMTP认证。



首先查看系统是否已经安装了cyrus-sasl



[root@linuxas3 src]# rpm -qa |grep cyrus-sasl

cyrus-sasl-plain-2.1.15-3

cyrus-sasl-md5-2.1.15-3

cyrus-sasl-2.1.15-3

cyrus-sasl-gssapi-2.1.15-3

cyrus-sasl-devel-2.1.15-3

[root@linuxas3 src]#
#

# Table structure for table `postfix_aliases`

#



DROP TABLE IF EXISTS `postfix_aliases`;

CREATE TABLE `postfix_aliases` (

  `id` int(32) unsigned NOT NULL auto_increment,

  `alias` varchar(255) NOT NULL default '',

  `rcpt` varchar(255) NOT NULL default '',

  `domain` varchar(255) NOT NULL default '',

  `create_date` datetime NOT NULL default '0000-00-00 00:00:00',

  `change_date` datetime NOT NULL default '0000-00-00 00:00:00',

  `active` tinyint(4) NOT NULL default '1',

  PRIMARY KEY  (`id`),

  UNIQUE KEY `aliases_unique` (`id`,`alias`),

  KEY `aliases_index` (`id`,`alias`)

) TYPE=MyISAM AUTO_INCREMENT=9 ;



#

# Dumping data for table `postfix_aliases`

#



INSERT INTO `postfix_aliases` VALUES (3, 'root@example.net', 'postmaster@example.net', 'example.net', '2003-06-26 14:58:46', '2003-06-26 14:58:46', 1);

INSERT INTO `postfix_aliases` VALUES (8, 'postfix@example.net', 'postmaster@example.net', 'example.net', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1);



# --------------------------------------------------------



#

# Table structure for table `postfix_forward`

#



DROP TABLE IF EXISTS `postfix_forward`;

CREATE TABLE `postfix_forward` (

  `id` int(32) unsigned NOT NULL auto_increment,

  `username` varchar(50) NOT NULL default '',

  `domain` varchar(40) NOT NULL default '',

  `forward_addr` text NOT NULL,

  PRIMARY KEY  (`id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;



#

# Dumping data for table `postfix_forward`

#



# --------------------------------------------------------



#

# Table structure for table `postfix_transport`

#



DROP TABLE IF EXISTS `postfix_transport`;

CREATE TABLE `postfix_transport` (

  `id` int(32) unsigned NOT NULL auto_increment,

  `domain` varchar(128) NOT NULL default 'example.net',

  `transport` enum('local:','virtual:','maildrop:') NOT NULL default 'virtual:',

  `description` varchar(255) NOT NULL default '',

  `begin_date` datetime NOT NULL default '0000-00-00 00:00:00',

  `end_date` datetime NOT NULL default '0000-00-00 00:00:00',

  `active` tinyint(4) NOT NULL default '1',

  PRIMARY KEY  (`id`),

  UNIQUE KEY `transport_unique` (`domain`),

  KEY `transport_index` (`id`,`domain`)

) TYPE=MyISAM AUTO_INCREMENT=3 ;



#

# Dumping data for table `postfix_transport`

#

INSERT INTO `postfix_transport` VALUES (1, 'example.net', 'virtual:', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1);



# --------------------------------------------------------

#

# Table structure for table `postfix_users`

#

CREATE TABLE `postfix_users` (

  `id` int(32) unsigned NOT NULL auto_increment,

  `user` varchar(50) NOT NULL default '',

  `name` varchar(60) NOT NULL default '',

  `passwd` varchar(128) NOT NULL default '',

  `domain` varchar(50) NOT NULL default 'example.net',

  `uid` smallint(5) unsigned NOT NULL default '1010',

  `gid` smallint(5) unsigned NOT NULL default '1010',

  `clearpw` varchar(20) binary NOT NULL default '',

  `home` varchar(100) NOT NULL default '/home/mail/',

  `maildir` varchar(150) NOT NULL default '',

  `imapok` tinyint(3) unsigned NOT NULL default '1',

  `quota` varchar(100) NOT NULL default '200000000s,20000c',

  `create_date` datetime NOT NULL default '0000-00-00 00:00:00',

  `last_access` int(10) unsigned NOT NULL default '0',

  `status` varchar(5) NOT NULL default 'Y',

  PRIMARY KEY  (`id`),

  UNIQUE KEY `mailbox_unique` (`id`,`name`),

  KEY `mailbox_index` (`id`,`name`)

) TYPE=MyISAM AUTO_INCREMENT=16 ;



#

# Dumping data for table `postfix_users`

#

INSERT INTO `postfix_users` VALUES (1, 'chen@example.net', 'chen', 'wPRiQTO$ZXvopyWE2/DNkKTAuXPtM.', 'example.net', 1000, 1000, 'liuxuehua', '/home/mail/', 'example.net/chen/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y');

INSERT INTO `postfix_users` VALUES (2, 'postmaster@example.net', 'postmaster', 'wPRiQTO$ZXvopyWE2/DNkKTAuXPtM.', 'example.net', 1000, 1000, 'liuxuehua', '/home/mail/', 'postmaster/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y'); 

INSERT INTO `postfix_users` VALUES (3, 'liu@example.net', 'liu', 'wPRiQTO$ZXvopyWE2/DNkKTAuXPtM.', 'example.net', 1000, 1000, 'liuxuehua', '/home/mail/', 'liu/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y');