在 Slackware ...

nullTao | 净空无道 | Blog

在 Slackware 下全部从源代码安装邮件服务器：四、Webmail 和管理端 Tue, Jul 21. 2009

1、系统需求说明

Extman 登录时的验证码需要 libXpm 的支持，统计图表需要 RRDtool 和 Perl 的 GD 模块的支持，Extman 还需要 Perl 的 Unix::Syslog 模块支持，mailgraph_ext 需要 Perl 的 File::Tail 模块支持。可以使用 /home/www/extsuite/extmail/tools/pkg_stats.sh 来查看还缺少什么模块。

2、添加数据库

使用 phpMyAdmin 或者其他的 MySQL 客户端，在 postfix 表中增加如下的表和初始管理员记录：

  1. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  2.  
  3. CREATE TABLE IF NOT EXISTS `alias` (
  4.   `address` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  5.   `goto` TEXT COLLATE utf8_unicode_ci NOT NULL,
  6.   `domain` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  7.   `createdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  8.   `active` TINYINT(1) NOT NULL DEFAULT '1',
  9.   PRIMARY KEY (`address`),
  10.   KEY `address` (`address`)
  11. ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ExtMail - Virtual Aliases';
  12.  
  13. CREATE TABLE IF NOT EXISTS `alias_domain` (
  14.   `alias_domain` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  15.   `target_domain` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  16.   `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  17.   `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  18.   `active` TINYINT(1) NOT NULL DEFAULT '1',
  19.   PRIMARY KEY (`alias_domain`),
  20.   KEY `active` (`active`),
  21.   KEY `target_domain` (`target_domain`)
  22. ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Postfix Admin - Domain Aliases';
  23.  
  24. CREATE TABLE IF NOT EXISTS `domain` (
  25.   `domain` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  26.   `description` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  27.   `hashdirpath` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  28.   `maxalias` INT(10) NOT NULL DEFAULT '0',
  29.   `maxusers` INT(10) NOT NULL DEFAULT '0',
  30.   `maxquota` VARCHAR(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  31.   `maxnetdiskquota` VARCHAR(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  32.   `transport` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  33.   `can_signup` TINYINT(1) NOT NULL DEFAULT '0',
  34.   `default_quota` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  35.   `default_netdiskquota` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  36.   `default_expire` VARCHAR(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  37.   `disablesmtpd` SMALLINT(1) DEFAULT NULL,
  38.   `disablesmtp` SMALLINT(1) DEFAULT NULL,
  39.   `disablewebmail` SMALLINT(1) DEFAULT NULL,
  40.   `disablenetdisk` SMALLINT(1) DEFAULT NULL,
  41.   `disableimap` SMALLINT(1) DEFAULT NULL,
  42.   `disablepop3` SMALLINT(1) DEFAULT NULL,
  43.   `createdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  44.   `expiredate` DATE NOT NULL DEFAULT '0000-00-00',
  45.   `active` TINYINT(1) NOT NULL DEFAULT '1',
  46.   PRIMARY KEY (`domain`),
  47.   KEY `domain` (`domain`)
  48. ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ExtMail - Virtual Domains';
  49.  
  50. CREATE TABLE IF NOT EXISTS `domain_manager` (
  51.   `username` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  52.   `domain` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  53.   `createdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  54.   `active` TINYINT(1) NOT NULL DEFAULT '1',
  55.   KEY `username` (`username`)
  56. ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Ext/Webman - Domain Admins';
  57.  
  58. CREATE TABLE IF NOT EXISTS `mailbox` (
  59.   `username` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  60.   `uid` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  61.   `password` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  62.   `clearpwd` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  63.   `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  64.   `mailhost` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  65.   `maildir` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  66.   `homedir` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  67.   `quota` VARCHAR(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  68.   `netdiskquota` VARCHAR(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  69.   `domain` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  70.   `uidnumber` INT(6) NOT NULL DEFAULT '1000',
  71.   `gidnumber` INT(6) NOT NULL DEFAULT '1000',
  72.   `createdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  73.   `expiredate` DATE NOT NULL DEFAULT '0000-00-00',
  74.   `active` SMALLINT(1) NOT NULL DEFAULT '1',
  75.   `disablepwdchange` SMALLINT(1) DEFAULT NULL,
  76.   `disablesmtpd` SMALLINT(1) DEFAULT NULL,
  77.   `disablesmtp` SMALLINT(1) DEFAULT NULL,
  78.   `disablewebmail` SMALLINT(1) DEFAULT NULL,
  79.   `disablenetdisk` SMALLINT(1) DEFAULT NULL,
  80.   `disableimap` SMALLINT(1) DEFAULT NULL,
  81.   `disablepop3` SMALLINT(1) DEFAULT NULL,
  82.   `question` TEXT COLLATE utf8_unicode_ci NOT NULL,
  83.   `answer` TEXT COLLATE utf8_unicode_ci NOT NULL,
  84.   PRIMARY KEY (`username`),
  85.   KEY `username` (`username`)
  86. ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ExtMail - Virtual Mailboxes';
  87.  
  88. CREATE TABLE IF NOT EXISTS `manager` (
  89.   `username` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  90.   `password` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  91.   `type` VARCHAR(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'postmaster',
  92.   `uid` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  93.   `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  94.   `question` TEXT COLLATE utf8_unicode_ci NOT NULL,
  95.   `answer` TEXT COLLATE utf8_unicode_ci NOT NULL,
  96.   `disablepwdchange` SMALLINT(1) DEFAULT NULL,
  97.   `createdate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  98.   `expiredate` DATE NOT NULL DEFAULT '0000-00-00',
  99.   `active` TINYINT(1) NOT NULL DEFAULT '1',
  100.   PRIMARY KEY (`username`),
  101.   KEY `username` (`username`)
  102. ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Ext/Webman - Admin Accounts';
  103.  
  104. INSERT INTO `manager` (`username`, `password`, `type`, `uid`, `name`, `question`, `answer`, `disablepwdchange`, `createdate`, `expiredate`, `active`) VALUES
  105. ('postmaster@domain.ltd', '$1$BrT9qxfB$Ha81Mb5YVV6rNKNN5jmtj1', 'admin', 'root', 'Super User', 'my question', 'my answer', 0, '2007-02-14 15:10:04', '2010-11-08', 1);

创建的初始管理员用户名是 postmaster@domain.ltd，初始密码是 extmail*123*，下面会用到。

3、安装 Extman/Extmail

  1. mkdir /home/www/extsuite
  2. tar -zxvf extmail-1.1.0.tar.gz  -C /home/www/
  3. tar -zxvf extman-1.0.0.tar.gz -C /home/www/
  4. ln -s /home/www/extman-1.0.0/ /home/www/extsuite/extman
  5. ln -s /home/www/extmail-1.1.0/ /home/www/extsuite/extmail
  6. chown vmail:vmail /home/www/ -R

4、配置 Apache 的虚拟主机

修改 /home/httpd/conf/extra/httpd-vhosts.conf，增加如下指令：

  1. <VirtualHost *:80>
  2.     ServerAdmin support@domain.ltd
  3.     DocumentRoot "/home/www/extsuite/extmail/html"
  4.     ServerName mail.domain.ltd
  5.     ServerAlias domain.ltd
  6.     ErrorLog "logs/ext-error_log"
  7.     CustomLog "logs/ext-access_log" "common"
  8.     ScriptAlias /extman/cgi/ /home/www/extsuite/extman/cgi/
  9.     Alias /extman/ /home/www/extsuite/extman/html/
  10.     ScriptAlias /extmail/cgi/ /home/www/extsuite/extmail/cgi/
  11.     Alias /extmail/ /home/www/extsuite/extmail/html/
  12. </VirtualHost>

5、安装 RRDtool

将 rrdtool-1.3.8.tar.gz 解压后，请参阅 doc/rrdbuild.txt 的指令安装 RRDtool 的依赖包和 RRDTool，注意首先执行下面的指令：

  1. export INSTALL_DIR=/usr/local/rrdtool-1.3.8
  2. export PKG_CONFIG_PATH=${INSTALL_DIR}/lib/pkgconfig
  3. export PATH=$INSTALL_DIR/bin:$PATH

否则后面可能提示找不到依赖的库。

最后一步安装 rrdtool-1.3.8 包的时候，在 make install 后，执行：

  1. make site-perl-instal
  2. cp /lib/perl/5.10.0/i486-linux-thread-multi/RRDs.pm /usr/lib/perl5/site_perl/5.10.0/i486-linux-thread-multi/
  3. cp /lib/perl/5.10.0/i486-linux-thread-multi/auto/* /usr/lib/perl5/site_perl/5.10.0/i486-linux-thread-multi/auto/ -R

安装 RRDtool 的 Perl 支持。

6、配置 Extman/Extmail

6.1、extman/webman.cf

编辑 /home/www/extsuite/extman/webman.cf，找到如下行：

  1. SYS_CONFIG = /var/www/extsuite/extman/
  2. SYS_LANGDIR = /var/www/extsuite/extman/lang
  3. SYS_TEMPLDIR = /var/www/extsuite/extman/html
  4. SYS_MAILDIR_BASE = /home/domains
  5. # SYS_LANG = en_US
  6. SYS_GROUPMAIL_SENDER = postmaster@extmail.org
  7. SYS_MYSQL_USER = webman
  8. SYS_MYSQL_PASS = webman
  9. SYS_MYSQL_DB = extmail
  10. SYS_MYSQL_SOCKET = /var/lib/mysql/mysql.sock

对应修改为如下：

  1. SYS_CONFIG = /home/www/extsuite/extman/
  2. SYS_LANGDIR = /home/www/extsuite/extman/lang
  3. SYS_TEMPLDIR = /home/www/extsuite/extman/html
  4. SYS_MAILDIR_BASE = /home/mailbox
  5. SYS_LANG = zh_CN
  6. SYS_GROUPMAIL_SENDER = postmaster@domain.ltd
  7. SYS_MYSQL_USER = postfix
  8. SYS_MYSQL_PASS = postfix_user_password
  9. SYS_MYSQL_DB = postfix
  10. SYS_MYSQL_SOCKET = /tmp/mysql.sock

6.2、extmail/webmail.cf

将 /home/www/extsuite/extmail/webmail.cf.default 在同目录复制为 webmail.cf，然后找到如下行：

  1. SYS_CONFIG = /var/www/extsuite/extmail/
  2. SYS_LANGDIR = /var/www/extsuite/extmail/lang
  3. SYS_TEMPLDIR = /var/www/extsuite/extmail/html
  4. SYS_SPAM_REPORT_TYPE = dspam
  5. SYS_USER_LANG = en_US
  6. SYS_MAILDIR_BASE = /home/domains
  7. SYS_MYSQL_USER = db_user
  8. SYS_MYSQL_PASS = db_pass
  9. SYS_MYSQL_DB = extmail
  10. SYS_MYSQL_SOCKET = /var/lib/mysql/mysql.sock
  11. SYS_AUTHLIB_SOCKET = /var/spool/authdaemon/socket
  12. SYS_G_ABOOK_FILE_PATH = /var/www/extsuite/extmail/globabook.cf

对应修改为如下：

  1. SYS_CONFIG = /home/www/extsuite/extmail/
  2. SYS_LANGDIR = /home/www/extsuite/extmail/lang
  3. SYS_TEMPLDIR = /home/www/extsuite/extmail/html
  4. SYS_SPAM_REPORT_TYPE = spamassassin
  5. SYS_USER_LANG = zh_CN
  6. SYS_MAILDIR_BASE = /home/mailbox
  7. SYS_MYSQL_USER = postfix
  8. SYS_MYSQL_PASS = 42R854
  9. SYS_MYSQL_DB = postfix
  10. SYS_MYSQL_SOCKET = /tmp/mysql.sock
  11. SYS_AUTHLIB_SOCKET = /home/courier/authlib/var/spool/authdaemon/socket
  12. SYS_G_ABOOK_FILE_PATH = /home/www/extsuite/extmail/globabook.cf

7、其他配置

修改 /home/www/extsuite/extman/addon/mailgraph_ext/mailgraph-init 和 /home/www/extsuite/extman/addon/mailgraph_ext/qmonitor-init，分别找到：

  1. MAILGRAPH_PL=/usr/local/mailgraph_ext/mailgraph_ext.pl
  2. MAILGRAPH_PL=/usr/local/mailgraph_ext/qmonitor.pl

相应的修改为：

  1. MAILGRAPH_PL=/home/www/extsuite/extman/addon/mailgraph_ext/mailgraph_ext.pl
  2. MAILGRAPH_PL=/home/www/extsuite/extman/addon/mailgraph_ext/qmonitor.pl

初始化日志统计图所需要的目录：

  1. /home/www/extsuite/extman/addon/mailgraph_ext/queue_mkrrd.sh
Posted by Wei Geng in TechniquE Comments: (0) Trackbacks: (0)
Defined tags for this entry: , , , ,
Related entries by tags:
WAMP crashes easily those days: Some notes on PHP configuration
在 Slackware 下全部从源代码安装邮件服务器
Install LILO to MBR on CCISS device
在 Slackware 下全部从源代码安装邮件服务器：五、启动并且测试服务
在 Slackware 下全部从源代码安装邮件服务器：三、系统配置
Random Entry: [JAVA] JasperReport 在 Linux 下面报 X11 的错误
< 在 Slackware 下全部从源代码安装邮件服务器：三、系统配置 | 在 Slackware 下全部从源代码安装邮件服务器：五、启动并且测试服务 >

Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)

No comments


Add Comment

You can use [geshi lang=lang_name [,ln={y|n}]][/geshi] tags to embed source code snippets.
Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

Gravatar/Pavatar author images supported.