Ubuntu Server最佳方案09.pdfVIP

第9 章 最佳邮件服务器方案 9.1 安装所有相关软件 9.1.1 安装服务器软件 $ sudo apt-get install postfix-mysql mysql-server dovecot-pop3d dovecot-imapd amav isd-new libclass-dbi-mysql-perl New password for the MySQL root user: -- 输入密码 Repeat password for the MySQL root user: -- 再次输入密码 Create directories for web-based administration? -- 选择No General type of mail configuration: -- 选择 Internet Site System mail name: -- 输入DNS 全名（） SSL certificate required -- 选择Ok Web server to reconfigure automatically: -- 选择apache2 9.1.2 安装内容过滤软件 $ sudo apt-get install SpamAssassin clamav-daemon razor pyzor cpio arj zoo nomarch lzop cabextract pax lha unrar 9.1.3 安装其他软件 $ sudo apt-get install squirrelmail squirrelmail-locales php5-imap $ sudo apt-get install openssl $ sudo apt-get install phpmyadmin telnet mutt mailx 最佳方案 9.2 为Postfix 准备数据库 9.2.1 创建数据库maildb $ mysql -uroot -p mysql create database maildb; mysql GRANT SELECT, INSERT, UPDATE, DELETE ON maildb.* TO mailadmin@localhost IDENTIFIED BY mailadminPassword; mysql GRANT SELECT, INSERT, UPDATE, DELETE ON maildb.* TO mailadmin@localhost. localdomain IDENTIFIED BY mailadminPassword; mysql FLUSH PRIVILEGES; 9.2.2 为数据库maildb 创建数据表 mysql use maildb; 1．创建虚拟域表virtual_domains mysql CREATE TABLE `virtual_domains` ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL ) TYPE=MyISAM; mysql INSERT INTO virtual_domains (name) VALUES (), (); 2 ．创建虚拟用户表virtual_users mysql CREATE TABLE `virtual_users` ( id int (11) NOT NULL AUTO_INCREMENT PRIMARY KEY, domain_id INT(11) NOT NULL, user VARCHAR(40) NOT NULL, password VARCHAR(32) NOT NULL, quota INT(10) DEFAULT 102400, CONSTRAINT UNIQUE_EMAIL UNIQUE (domain_id,user), FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE ) TYPE=MyISAM; mysql INSERT INTO virtual_users (domain_id, user, password, quota) 142 第9 章