haiyun.me - Mail

Mail - 海运的博客

Haiyun.me Spined HTML

Mail - 海运的博客 海运的博客 首页 关于 分析网站 文章归档 参考手册 在线工具 常用命令 Postfix和Dovecot配置Mysql虚拟用户 发布时间：March 26, 2014 // 分类：Mail // No Comments 安装：yum install dovecot-mysql新建数据库：CREATE DATABASE mailserver; GRANT SELECT ON mailserver.* TO 'mailuser'@'127.0.0.1' IDENTIFIED BY 'mailuserpass'; FLUSH PRIVILEGES; USE mailserver; #虚拟域表 CREATE TABLE `virtual_domains` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; #虚拟用户表 CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL auto_increment, `domain_id` int(11) NOT NULL, `password` varchar(106) NOT NULL, `email` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; #虚拟用户别名 CREATE TABLE `virtual_aliases` ( `id` int(11) NOT NULL auto_increment, `domain_id` int(11) NOT NULL, `source` varchar(100) NOT NULL, `destination` varchar(100) NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY (domain_id) REFERENCES virtual_domains(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 添加测试数据： INSERT INTO `mailserver`.`virtual_domains` (`name`) VALUES ('haiyun.me'); INSERT INTO `mailserver`.`virtual_users` (`domain_id`, `password` , `email`) VALUES ('1', ENCRYPT('password', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))), 'user@haiyun.me'); INSERT INTO `mailserver`.`virtual_aliases` (`domain_id`, `source`, `destination`) VALUES ('1', 'alias@haiyun.me', 'user@haiyun.me');Postfix添加以下配置：virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf #使用dovecot lmtp交付虚拟域邮件，省却postfix配置用户邮件目录及权限问题 virtual_transport = lmtp:unix:private/dovecot-lmtp #使用dovecot验证，后面dovecot配置 smtpd_sasl_type = dovecot smtpd_sasl_path = private/auth smtpd_sasl_auth_enable = yes smtpd_recipient_restrictions = permit_sasl_authenticated, permit_mynetworks, reject_unauth_destination配置Postfix支持Mysql查询表：#虚拟域 /etc/postfix/mysql-virtual-mailbox-domains.cf user = mailuser password = mailuserpass hosts = 127.0.0.1 dbname = mailserver query = SELECT 1 FROM virtual_domains WHERE name='%s' #虚拟用户 /etc/postfix/mysql-virtual-mailbox-maps.cf user = mailuser password = mailuserpass hosts = 127.0.0.1 dbname = mailserver query = SELECT 1 FROM virtual_users WHERE email='%s' #虚拟别名 /etc/postfix/mysql-virtual-alias-maps.cf user = mailuser password = mailuserpass hosts = 127.0.0.1 dbname = mailserver query = SELECT destination FROM virtual_aliases WHERE source='%s'测试查询：postmap -q haiyun.me mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf postmap -q user@haiyun.me mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf postmap -q alias@haiyun.me mysql:/etc/postfix/mysql-virtual-alias-maps.cfDovecot配置：/etc/dovecot/conf.d/10-mail.conf mail_location = maildir:/var/mail/vhosts/%d/%n /etc/dovecot/conf.d/10-auth.conf auth_verbose = yes # 认证详细日志 auth_debug = yes # 认证debug disable_plaintext_auth = no #开启明文验证 auth_mechanisms = plain login #支持验证方法 #!include auth-system.conf.ext #取消默认系统验证 !include auth-sql.conf.ext #使用mysql验证 /etc/dovecot/conf.d/auth-sql.conf.ext #用户验证 passdb { suburbanite = sql args = /etc/dovecot/dovecot-sql.conf.ext } #用户邮箱目录 %d为domain，%n为user userdb { suburbanite = static args = uid=vmail gid=vmail home=/var/mail/vhosts/%d/%n } /etc/dovecot/dovecot-sql.conf.ext suburbanite = mysql connect = host=127.0.0.1 dbname=mailserver user=mailuser password=mailuserpass default_pass_scheme = SHA512-CRYPT password_query = SELECT email as user, password FROM virtual_users WHERE email='%u'; /etc/dovecot/conf.d/10-master.conf #lmtp服务，postfix通过lmtp交付邮件 service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { mode = 0600 user = postfix group = postfix } } #验证服务，postfix也通过此验证用户 service auth { unix_listener /var/spool/postfix/private/auth { mode = 0666 user = postfix group = postfix } unix_listener auth-userdb { mode = 0600 user = vmail #group = } user = dovecot } service auth-worker { user = vmail }新建用户用以访问邮件目录数据：useradd -M -u 5000 vmail -d /var/mail -s /sbin/nologin chown -R vmail:vmail /var/mail/参考：https://library.linode.com/email/postfix/postfix2.9.6-dovecot2.0.19-mysql 此内容被密码保护 发布时间：November 22, 2013 // 分类：Mail // No Comments 请输入密码访问 此内容被密码保护 发布时间：November 21, 2013 // 分类：Mail // No Comments 请输入密码访问 此内容被密码保护 发布时间：November 20, 2013 // 分类：Mail // No Comments 请输入密码访问 此内容被密码保护 发布时间：November 16, 2013 // 分类：Mail // No Comments 请输入密码访问 1234» 分类 Apache (13)Nginx (42)PHP (83)IIS (8)Mail (17)DNS (14)Cacti (14)Squid (5)Nagios (4)Puppet (7)CentOS (13)Iptables (23)RADIUS (3)OpenWrt (40)DD-WRT (1)VMware (9)网站程序 (3)备份存储 (11)常用软件 (20)日记分析 (10)Linux基础 (18)欧诺代理 (2)Linux服务 (18)系统监控 (4)流量监控 (7)虚拟化 (28)伪静态 (2)LVM (3)Shell (18)高可用 (2)数据库 (16)FreeBSD (3)网络安全 (25)Windows (35)网络工具 (22)控制面板 (3)系统调优 (10)Cisco (3)VPN (5)ROS (20)Vim (14)KMS (4)PXE (2)Mac (1)Git (1)PE (1)LNS (2)Xshell (7)Firefox (13)Cygwin (4)OpenSSL (9)Sandboxie (3)StrokesPlus (1)AutoHotKey (4)Total Commander (2)WordPress (3)iMacros (6)Typecho (2)Ollydbg (1)Photoshop (1)正则 (3)Debian (3)Python (8)NoSQL (6)消息队列 (4)JS (7)Tmux (3)GO (7)HHVM (2)算法 (1)Docker (2) 最新文章 centos repo管理使用centos/debian自动通过网络远程安装系统配置脚本使用kickstart安装ubuntuCentos/linux ipv4优先BT/utorrent连接加密及标志IPXE网络引导通过kickstart和preseed自动安装centos/ubuntu/debian系统ubuntu 通过ppa源安装最新版qbittorrentinitrd.img解压与打包libtorrent提高上传速度qq smtp 465/587端口区别 最近回复 404NTF: 交叉编译的作用是? 404NTF: 请教一下 CGO_ENABLED=0 GOOS=darwin GOARCH=amd64 go ... 小智: 安利个PHP开发以太坊区块链的教程： http://xc.hubwiz.com/course/... 陈浩南: 您好，您教程中的 dev.openwrt.org.cn 现在似乎不可用了。请问现在应该在哪里下... 斑马斑马: 怎么查看虚拟机CPU 内存使用情况 zzg: http://downloads.openwrt.org.cn/PandoraBox/rali... xiongrui: 看图 傻狍子: filebrowser好像和这功能一样？ https://github.com/filebro... 陶国文: 想看看能不能安装 傻狍子: 服务端设置了用户名密码认证的话，在openwrt的openvpn客户端的配置文件当中该如何更改... Copyright © 2011 海运的博客 / 文章归档 / Archives Rss / Comments Rss / Powered By Typecho 页面执行耗时:0.0405秒。-->