mysql mail,集成电子邮件系统(MYSQL)

Mysql

查看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, '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 '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, 'chen@example.net', '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, 'postmaster@example.net', 'postmaster', 'chen', 'example.net', 1000, 1000, '', '/var/mail/', 'postmaster@example.net/Maildir/', 1, '200000000s,20000c', '0000-00-00 00:00:00', 0, 'Y');