mysql sasl_postfix-mysql-sasl-courier-httpd

courier-authlib dovecot postfix postdrop extmail mysql

系统版本6.7

软件版本 httpd-2.2.15-47.el6.centos postfix-3.1.0 extman-1.1 extmail-1.2 mysql 5.6.30 dovecot-2.0.9-19.el6_7.2.x86_64

yum -y remove boost-*

yum -y remove mysql

yum -y install wget gcc gcc-c++ ncurses-devel cmake make perl

可以有dns需要的可自行配置，需要的可以找我，还得写配置

新建mysql组以及用户

groupadd mysql

useradd -M -s /sbin/nologin -r -g mysql mysql

好像得要有boost源码编译mysql 14-61行 安装过的可直接忽略

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/mysql/data \

-DSYSCONFDIR=/usr/local/mysql/ \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DWITH_BOOST=/files/boost \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DDOWNLOAD_BOOST=1 \

-DENABLED_LOCAL_INFILE=1 \

-DEXTRA_CHARSETS=all

安装完之后可能会报有四个选项错误，这是5.7的配置错误可以忽略

make && make install

mv /etc/my.cnf{,.bak}

cp support-files/my-default.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld on

mkdir -p /mysql/data

chown -R mysql:mysql /mysql/data

5.6

scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mysql/data -u mysql

5.7

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/mysql/data

问题

[root@localhost MySQL]# /etc/rc.d/init.d/mysql status

MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]

解决方

查看日志

cat /mysql/data/xiong.err

160513 00:19:41 mysqld_safe mysqld from pid file /mysql/data/xiong.pid ended

chown -R mysql:mysql /usr/local/mysql/

touch /etc/profile.d/mysqld.sh

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile.d/mysqld.sh

source /etc/profile.d/mysqld.sh

安装组工具包以及软件包

yum -y groupinstall "Development tools" "Desktop Platform Development" "Server Platform Development"

yum -y install httpd perl-DBD-MySQL courier-authlib dovecot

首先一定要加入emos源否则authlib软件会安装失败

vim /etc/yum.repo.d/emos.repo

[EMOS]

name=EMOS

baseurl=file:///mnt此处Yum仓库按自己要想的来，都可以

enabled=1

gpgcheck=0

卸载postfix软件

yum -y remove postfix

删除系统用户postfix此步一定要操作否则extmail最后发送邮件会出现系统配置错误

groupdel postfix

groupadd -g 2000 postfix

useradd -g 2000 -u 2000 -s /sbin/nologin -M postfix

groupadd -g 2001 postdrop

userdel -r postdrop

useradd -g 2001 -u 2001 -s /sbin/nologin -M postdrop

因为删除了系统用户需要将postfix原先自带文件增加权限，否则启动时会失败

chown postfix -R /var/lib/postfix/

chown postfix -R /var/spool/postfix/

增加库文件否则make postfix 会失败

echo "/usr/local/mysql/lib" >> //etc/ld.so.conf.d/mysqld.conf

我的版本是postfix-3.1.0 ，系统版本64位的需要更改/usr/lib64，我的mysql是源码编的指定头文件跟库文件位置

make makefiles 'CCARGS=-DHAS_MYSQL -I/usr/local/mysql/include -DUSE_SASL_AUTH -DUSE_CYRUS_SASL -I/usr/include/sasl -DUSE_TLS' 'AUXLIBS=-L/usr/local/mysql/lib -lmysqlclient -lz -lm -L/usr/lib64/sasl2 -lsasl2 -lssl -lcrypto'

make -j 2 && make install

生成/etc/init.d/postfix脚本 下载位置 链接：http://pan.baidu.com/s/1hrSpPDM 密码：tieu

chmod +x /etc/init.d/postfix

chkconfig postfix --add

chkconfig postfix on

postconf "smtputf8_enable = no"

编辑authdaemonrc文件更改配置方式只为myql

vim /etc/authlib/authdaemonrc

Euthmodulelist="authuserdb authpam authpgsql authldap authmysql authcustom authpipe"

authmodulelist="authmysql"

Euthmodulelistorig="authuserdb authpam authpgsql authldap authmysql authcustom authpipe"

authmodulelistorig="authmysql"

#daemons=5

daemons=10进程为10

连接mysql配置文件，用户跟密码按自己指定的来我的是默认的extmail

egrep -v "^#|^[[:space:]]|^$" /etc/authlib/authmysqlrc

MYSQL_SERVERlocalhost

MYSQL_USERNAMEextmial

MYSQL_PASSWORDextmail

MYSQL_PORT3306端口号

MYSQL_OPT0

MYSQL_DATABASEextmail

MYSQL_USER_TABLEmailbox文件目录

MYSQL_CRYPT_PWFIELDpassword

MYSQL_UID_FIELD2000用户组ID号上头创建的用户

MYSQL_GID_FIELD2000

MYSQL_LOGIN_FIELDusername

MYSQL_HOME_FIELDconcat('var/mailbox/',homedir)连接目录

MYSQL_NAME_FIELDname

MYSQL_MAILDIR_FIELDconcat('/var/mailbox/',maildir)

MYSQL_SOCKET /usr/local/mysql/mysql.sock此处一定要注意指定自己的mysql.sock文件

配置完成之后记得启动用服务并将authlib加入开机启动项

service courier-authlib restart

chkconfig courier-authlib on

创建authlib指定的目录，上面指什么这里创建什么目录

mkdir -pv /var/mailbox

chown -R postfix /var/mailbox/

指定sasl2认证方式

vim /usr/lib64/sasl2/smtpd.conf

pwcheck_method: authdaemond

mech_list: PLAIN LOGIN

authdaemond_path:/var/spool/authdaemon/socket

这里修改为：sasl所支持的认证方式

vim /etc/postfix/main.cf

inet_interfaces = all监听地址一定要改为all本地也行

############################CYRUS-SASL############################

broken_sasl_auth_clients = yes

smtpd_recipient_restrictions=permit_mynetworks,permit_sasl_authenticated,reject_invalid_hostname,reject_non_fqdn_hostname,reject_unknown_sender_domain,reject_non_fqdn_sender,reject_non_fqdn_recipient,reject_unknown_recipient_domain,reject_unauth_pipelining,reject_unauth_destination

smtpd_sasl_auth_enable = yes

smtpd_sasl_local_domain = $myhostname

smtpd_sasl_security_options = noanonymous

smtpd_sasl_application_name = smtpd

smtpd_banner = Welcome to our $myhostname ESMTP,Warning: Version not Available!

########################Virtual Mailbox Settings########################这里是extmil配置

virtual_mailbox_base = /var/mailbox

virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf

virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf

virtual_alias_domains =

virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf

virtual_uid_maps = static:2000

virtual_gid_maps = static:2000

virtual_transport = virtual

##########################QUOTA Settings########################配额可取消

message_size_limit = 14336000

virtual_mailbox_limit = 20971520

这里很关键、一定要注意双引号以及自动创建模式，否则导入extmail.sql文件会出错

vim /usr/local/mysql/my.cnf

sql_mode="NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES"

sql-mode="NO_AUTO_CREATE_USER"

[root@xiong docs]# service mysqld restart

改完一定要重启再导入extmail.sql

进入数据库中导入我的是5.6.30版本

source /tmp/extman-1.1/docs/extmail.sql;创建用户并授权，mysql不熟这是百度的

GRANT ALL PRIVILEGES ON extmail.* TO extmail@localhost IDENTIFIED BY 'extmail';

GRANT ALL PRIVILEGES ON extmail.* TO extmail@127.0.0.1 IDENTIFIED BY 'extmail';

将extman ，mysql_虚拟用户复制到postfix目录下、这文件都是main.cf定义的不要少复制、否则也会报错

[root@xiong docs]# cp /tmp/extman-1.1/docs/mysql_virtual_* /etc/postfix/

vim /etc/dovecot/conf.d/auth-sql.conf.ext

行前加入该行 mail_location = maildir:/var/mailbox/%d/%n/Maildir

vim /etc/dovecot/dovecot-sql.conf.ext 该文件需跟auth-sql.conf中定义一致

driver = mysqlhost注意一定s改成mysql.sock指定的不要直接复制否则会有错误

connect = host=/usr/local/mysql/mysql.sock dbname=extmail user=extmail password=extmail

default_pass_scheme = CRYPT

password_query = SELECT username AS user,password AS password FROM mailbox WHERE username = '%u'

user_query = SELECT maildir, uidnumber AS uid, gidnumber AS gid FROM mailbox WHERE username = '%u'

安装extmail

tar zxvf extmail-1.2.tar.gz

mkdir -pv /var/www/extsuite

mv extmail-1.2 /var/www/extsuite/extmail

cp /var/www/extsuite/extmail/webmail.cf.default /var/www/extsuite/extmail/webmail.cf

vim /var/www/extsuite/extmail/webmail.cf

SYS_USER_LANG = en_US

语言选项，可改作：

SYS_USER_LANG = zh_CN

SYS_MAILDIR_BASE = /home/domains

此处即为您在前文所设置的用户邮件的存放目录，可改作：

SYS_MAILDIR_BASE = /var/mailbox

SYS_MYSQL_USER = db_user

SYS_MYSQL_PASS = db_pass

以上两句句用来设置连接数据库服务器所使用用户名、密码和邮件服务器用到的数据库，这里修改为：

SYS_MYSQL_USER = extmail

SYS_MYSQL_PASS = extmail

vim /etc/httpd/conf/httpd.conf

User postfix

Group postfix

ServerAdmin adminmail.xiong.com

DocumentRoot /var/www/extsuite/extmail/html

ScriptAlias /extmail/cgi /var/www/extsuite/extmail/cgi

Alias /extmail /var/www/extsuite/extmail/html/

extmail将会用到perl的Unix::syslogd功能，您可以去http://search.cpan.org搜索下载原码包进行安装。

tar zxvf Unix-Syslog-0.100.tar.gz

cd Unix-Syslog-0.100

perl Makefile.PL

make

make install

启动apache服务

service httpd restart

安装extman下载路径www.extmail.org

tar zxvf extman-1.1.tar.gz

[root@xiong tmp]# mv extman-1.1 /var/www/extsuite/extman

cd /var/www/extsuite/extman

[root@xiong extman]# cp webman.cf.default webman.cf

vim webman.cf

SYS_MAILDIR_BASE = /home/domains

此处即为您在前文所设置的用户邮件的存放目录，可改作：

SYS_MAILDIR_BASE = /var/mailbox

SYS_DEFAULT_UID = 1000

SYS_DEFAULT_GID = 1000

此两处后面设定的ID号需更改为前而创建的postfix用户和postfix组的id号，本文使用的是2525，因此，上述两项需要修改为：

SYS_DEFAULT_UID = 2525

SYS_DEFAULT_GID = 2525

SYS_MYSQL_USER = webman

SYS_MYSQL_PASS = webman

修改为：

SYS_MYSQL_USER = extmail

SYS_MYSQL_PASS = extmail

SYS_MYSQL_SOCKET = /var/lib/mysql/mysql.sock 修改为：SYS_MYSQL_SOCKET = /tmp/mysql.sock

[root@xiong extman]# vim /etc/httpd/conf/httpd.conf

添加到虚拟网站中

ScriptAlias /extman/cgi /var/www/extsuite/extman/cgi

Alias /extman /var/www/extsuite/extman/html

创建其运行时所需的临时目录，并修改其相应的权限：

#mkdir -pv /tmp/extman

#chown postfix.postfix /tmp/extman

vim /var/www/extsuite/extman/webman.cf

不启用验证码

SYS_CAPTCHA_ON = 1 为 SYS_CAPTCHA_ON = 0

最后图形日志没有开启，还得修改，这样就可以直接使用