Postfix + Mysql + pam_mysql-0.5 + Cyrus-SASL + Courier POP and IMAP + Maildrop + AMaViS + McAfee uvscan for linux + SpamAssassin + ...
[root@linuxas3 root]# uname -a Linux linuxas3.9812.net 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003 i686 i686 i386 GNU/Linux [root@linuxas3 root]# |
查看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 [root@linuxas3 src]# |
postfix 数据库脚本
# Database postfix 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 : `postfix` # # -------------------------------------------------------- # # 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, '[email protected]', '[email protected]', 'example.net', '2003-06-26 14:58:46', '2003-06-26 14:58:46', 1); INSERT INTO `postfix_aliases` VALUES (8, '[email protected]', '[email protected]', '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 '9812.net', `uid` smallint(5) unsigned NOT NULL default '1000', `gid` smallint(5) unsigned NOT NULL default '1000', `clearpw` varchar(20) binary NOT NULL default '', `home` varchar(100) NOT NULL default '/var/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, '[email protected]', 'chen', 'chen', 'example.net', 1000, 1000, '', '/var/mail/', 'example.net/chen/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y'); INSERT INTO `postfix_users` VALUES (2, '[email protected]', 'postmaster', 'chen', 'example.net', 1000, 1000, '', '/var/mail/', '[email protected]/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y'); |