Docker下搭建ewomail邮件服务器

ぶ会编程的狗子进阶史 / 2024-03-17 / 原文

EwoMail 开源企业邮件系统的docker镜像 https://hub.docker.com/r/bestwu/ewomail/

注意：mail.ewomail.com 换成自己的域名

可配置参数

https://blog.csdn.net/inthat/article/details/103741662

EwoMail 开源企业邮件系统的docker镜像 https://hub.docker.com/r/bestwu/ewomail/

注意：mail.ewomail.com 换成自己的域名

可配置参数

MYSQL_ROOT_PASSWORD mysql数据库root密码，默认：mysql
MYSQL_MAIL_PASSWORD mysql数据库ewomail密码，默认：123456
URL 网站链接，后面不要加/线
WEBMAIL_URL 邮件系统链接，后面不要加/线
TITLE 用户邮统标题
COPYRIGHT 邮箱管理后台网站版权
ICP 邮箱管理后台网站备案号
LANGUAGE 语言选择，默认:zh_CN

第一步：安装运行docker
安装运行容器

docker search EwoMail
docker pull bestwu/ewomail

docker run -d -h mail.ewomail.com --restart=always \
-p 25:25 \
-p 109:109 \
-p 110:110 \
-p 143:143 \
-p 465:465 \
-p 587:587 \
-p 993:993 \
-p 995:995 \
-p 80:80 \
-p 8080:8080 \
-v `pwd`/mysql/:/ewomail/mysql/data/ \
-v `pwd`/vmail/:/ewomail/mail/ \
-v `pwd`/ssl/certs/:/etc/ssl/certs/ \
-v `pwd`/ssl/private/:/etc/ssl/private/ \
-v `pwd`/rainloop:/ewomail/www/rainloop/data \
-v `pwd`/ssl/dkim/:/ewomail/dkim/ \
--name ewomail bestwu/ewomail

查看容器

docker ps
必须出现bestwu/ewomailserver容器才可以。

进入虚拟机

docker exec -it ewomail /bin/bash

修改数据库连接

如果内存超过4G请操作

将 /ewomail/mysql/etc/my-huge.cnf 替换 /ewomail/mysql/etc/my.cnf

重启mysql

service mysqld restart

ewomail故障的处理

域不允许时（子弟能够以访问路径）

修改 /ewomail/www/ewomail-admin/core/config.php

转自：blog.csdn.net/weixin_44697777/article/details/128376605

www.jianshu.com/p/9096ccdbb5cd

第二步：登录管理中心配置
参考官网http://doc.ewomail.com/docs/ewomail/changguipeizhi
使用EwoMail搭建属于自己的个人邮件服务器——超详细图文教程
参考： https://blog.csdn.net/qq_41692307/article/details/88318365

运行成功后访问
邮箱管理后台http://localhost:8080
默认用户: admin
默认密码: ewomail123
Rainloop 管理端 http://localhost/?admin
默认用户: admin
默认密码: 12345
Rainloop 用户端 http://localhost

主要修改一下内容：

后台http://localhost:8080 修改admin的密码
创建邮箱账号
Rainloop 管理端 http://localhost/?admin 修改默认密码
设置域名解析
域名DNS设置：
以万网的DNS设置为例子

记录类型    主机记录    解析线路    记录值    MX优先级    TTL值    状态(暂停/正常)    备注
TXT    @    默认    v=spf1 ip4:127.0.0.1 -all        600    正常    
TXT    dkim._domainkey    默认    这是存放DKIM的值        600    正常    
A    mail    默认    127.0.0.1        600    正常    
CNAME    smtp    默认    mail.***.***        600    正常    
CNAME    pop    默认    mail.***.***        600    正常    
CNAME    imap    默认    mail.***.***        600    正常    
MX    @    默认    mail.***.***    1    600    正常    
                            
备注：将127.0.0.1 替换成你的公网IP，mail.***.***的***.***替换成你的域名

将mail.ewomail.cn 改成你的域名

红色部分请改为你的服务器IP

DKIM设置

DKIM是电子邮件验证标准，域名密钥识别邮件标准，主要是用来防止被判定为垃圾邮件。

每个域名都需要添加一个dkim的key，EwoMail默认安装后已自动添加主域名dkim，只需要设置好dkim的dns即可。

获取dkim key

执行查看代码

docker exec ewomail amavisd showkeys

若安装成功会输出以下信息：

; key#1, domain ewomail.com, /ewomail/dkim/mail.pem
dkim._domainkey.ewomail.com. 3600 TXT (
“v=DKIM1; p=”
“MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC09HcLpwcdgWtzkrZDBRBYfQo5”
“prSRyedA72wiD3vFGXLWHyy0KOXp+uwvkNzaBpvU2DDKNTTPdo1pNWtl/LkpRCVq”
“+uRG+LhZBuic0GpDJnD7HckUbwsyGktb/6g5ogScNtPWB+pegENFDl8BuFn3zDiD”
“nnGxbpj3emSxDlskzwIDAQAB”)

整理后，如上图中设置DNS

最终测试结果：测试发现只能接受邮件发送不了邮件。

问题分析：
进入容器查看，日志文件 /var/log/maillog

docker exec -it ewomail /bin/bash
1
postfix/smtp[1480]: connect to mx3.qq.com[121.51.19.150]:25: Connection timed out
发送发不出去是因为连接 qq 服务器的25端口连接不上。
分别测试本地telnet mx3.qq.com 25，腾讯云 telnet mx3.qq.com 25。
证实确实是腾讯云封杀了25端口，即使你安全组开放了所有端口（我已开放了所有端口）。。

结论：
同网上描述参考URL: https://segmentfault.com/q/1010000013935348
阿里腾讯云都默认封杀25出口!大陆地区大部分的IDC都是封禁了25口,就是为了防止滥发垃圾邮件,导致IP段被ban

# 发送邮件报错
connect to 127.0.0.1[127.0.0.1]:10024: Connection refused
错误原因：10024端口跑的服务主要用于ewomail中反垃圾反病毒作用，然而docker镜像中没有集成，所以会无法接收到邮件。

docker exec -it ewomail /bin/bash  
#进入docker里面
vi /etc/postfix/main.cf
1、注释/etc/postfix/main.cf中的（基本属于此问题）
content_filter = smtp-amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings

linux安装开源邮件服务器iredmail的方法：docker

docker run --privileged -p 80:80 -p 443:443 \
-h mail.example.com \
-e "MYSQL_ROOT_PASSWORD=password" \
-e "SOGO_WORKERS=1" \
-e "TZ=Europe/Prague" \
-e "POSTMASTER_PASSWORD={PLAIN}password" \
-e "IREDAPD_PLUGINS=['reject_null_sender', 'reject_sender_login_mismatch', 'greylisting', 'throttle', 'amavisd_wblist', 'sql_alias_access_policy']" \
-v /home/liulinqiang/iredmail/mysql:/var/lib/mysql \
-v /home/liulinqiang/iredmail/vmail:/var/vmail \
-v /home/liulinqiang/iredmail/clamav:/var/lib/clamav \
--name=iredmail lejmr/iredmail:mysql-latest

#转自

starcheng.xyz/919.html

数据库文件：

-- MySQL dump 10.13  Distrib 5.5.36, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: rainloop
-- ------------------------------------------------------
-- Server version    5.5.36

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `rainloop`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `rainloop` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `rainloop`;

--
-- Table structure for table `rainloop_ab_contacts`
--

DROP TABLE IF EXISTS `rainloop_ab_contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_ab_contacts` (
  `id_contact` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_contact_str` varchar(128) NOT NULL DEFAULT '',
  `id_user` int(10) unsigned NOT NULL,
  `display` varchar(255) NOT NULL DEFAULT '',
  `changed` int(10) unsigned NOT NULL DEFAULT '0',
  `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `etag` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '',
  PRIMARY KEY (`id_contact`),
  KEY `id_user_rainloop_ab_contacts_index` (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_ab_contacts`
--

LOCK TABLES `rainloop_ab_contacts` WRITE;
/*!40000 ALTER TABLE `rainloop_ab_contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `rainloop_ab_contacts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainloop_ab_properties`
--

DROP TABLE IF EXISTS `rainloop_ab_properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_ab_properties` (
  `id_prop` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_contact` bigint(20) unsigned NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `prop_type` tinyint(3) unsigned NOT NULL,
  `prop_type_str` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
  `prop_value` text NOT NULL,
  `prop_value_custom` text NOT NULL,
  `prop_value_lower` text NOT NULL,
  `prop_frec` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_prop`),
  KEY `id_user_rainloop_ab_properties_index` (`id_user`),
  KEY `id_user_id_contact_rainloop_ab_properties_index` (`id_user`,`id_contact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_ab_properties`
--

LOCK TABLES `rainloop_ab_properties` WRITE;
/*!40000 ALTER TABLE `rainloop_ab_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `rainloop_ab_properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainloop_system`
--

DROP TABLE IF EXISTS `rainloop_system`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_system` (
  `sys_name` varchar(50) NOT NULL,
  `value_int` int(10) unsigned NOT NULL DEFAULT '0',
  `value_str` varchar(128) NOT NULL DEFAULT '',
  KEY `sys_name_rainloop_system_index` (`sys_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_system`
--

LOCK TABLES `rainloop_system` WRITE;
/*!40000 ALTER TABLE `rainloop_system` DISABLE KEYS */;
INSERT INTO `rainloop_system` VALUES ('mysql-ab-version_version',3,'');
/*!40000 ALTER TABLE `rainloop_system` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainloop_users`
--

DROP TABLE IF EXISTS `rainloop_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_users` (
  `id_user` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rl_email` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_user`),
  KEY `rl_email_rainloop_users_index` (`rl_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_users`
--

LOCK TABLES `rainloop_users` WRITE;
/*!40000 ALTER TABLE `rainloop_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `rainloop_users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- MySQL dump 10.13  Distrib 5.5.36, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: ewomail
-- ------------------------------------------------------
-- Server version    5.5.36

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `ewomail`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ewomail` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `ewomail`;

--
-- Table structure for table `i_admin`
--

DROP TABLE IF EXISTS `i_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_admin` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL COMMENT '账号',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `name` varchar(30) NOT NULL COMMENT '真实名称',
  `super` int(1) NOT NULL DEFAULT '0' COMMENT '是否为超级管理员',
  `gid` int(11) NOT NULL DEFAULT '0' COMMENT '管理组id',
  `active` int(1) NOT NULL DEFAULT '1' COMMENT '是否正常：1是，0否',
  `is_webmail` int(1) NOT NULL DEFAULT '0' COMMENT '是否有web控制面板权限：0否：1是',
  `ctime` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`aid`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员账号';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_admin`
--

LOCK TABLES `i_admin` WRITE;
/*!40000 ALTER TABLE `i_admin` DISABLE KEYS */;
INSERT INTO `i_admin` VALUES (1,'admin','3bb3733de472b226208307ec1e689347','admin',1,0,1,1,'2016-03-25 21:45:46');
/*!40000 ALTER TABLE `i_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_admin_group`
--

DROP TABLE IF EXISTS `i_admin_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_admin_group` (
  `gid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(30) NOT NULL COMMENT '标题',
  `auth` text,
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='管理组';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_admin_group`
--

LOCK TABLES `i_admin_group` WRITE;
/*!40000 ALTER TABLE `i_admin_group` DISABLE KEYS */;
INSERT INTO `i_admin_group` VALUES (8,'客服','a:7:{i:101;a:3:{s:4:\"view\";s:1:\"1\";s:4:\"edit\";s:1:\"1\";s:7:\"menu_id\";s:3:\"101\";}i:103;a:2:{s:4:\"view\";s:1:\"1\";s:7:\"menu_id\";s:3:\"103\";}i:105;a:2:{s:4:\"view\";s:1:\"1\";s:7:\"menu_id\";s:3:\"105\";}i:201;a:2:{s:4:\"view\";s:1:\"1\";s:7:\"menu_id\";s:3:\"201\";}i:203;a:2:{s:4:\"view\";s:1:\"1\";s:7:\"menu_id\";s:3:\"203\";}i:205;a:2:{s:4:\"view\";s:1:\"1\";s:7:\"menu_id\";s:3:\"205\";}i:206;a:2:{s:4:\"view\";s:1:\"1\";s:7:\"menu_id\";s:3:\"206\";}}');
/*!40000 ALTER TABLE `i_admin_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_admin_log`
--

DROP TABLE IF EXISTS `i_admin_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_admin_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL COMMENT '管理员账号',
  `ip` varchar(255) NOT NULL,
  `explain` text COMMENT '说明',
  `ctime` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=208 DEFAULT CHARSET=utf8 COMMENT='管理员操作日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_admin_log`
--

LOCK TABLES `i_admin_log` WRITE;
/*!40000 ALTER TABLE `i_admin_log` DISABLE KEYS */;
INSERT INTO `i_admin_log` VALUES (207,'','27.19.225.47','[操作：登陆]登录账号：admin','2024-03-17 08:51:28');
/*!40000 ALTER TABLE `i_admin_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_admin_menu`
--

DROP TABLE IF EXISTS `i_admin_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_admin_menu` (
  `menu_id` int(11) NOT NULL,
  `mark` varchar(30) NOT NULL DEFAULT '' COMMENT '备注',
  `lang` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL DEFAULT '',
  `top_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级id',
  `edit` int(1) NOT NULL DEFAULT '0' COMMENT '添加和编辑权限',
  `del` int(1) NOT NULL DEFAULT '0' COMMENT '删除权限',
  `edit_id` int(11) NOT NULL DEFAULT '0' COMMENT '关联编辑id',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`menu_id`),
  KEY `top_id` (`top_id`) USING BTREE,
  KEY `edit_id` (`edit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台菜单栏目';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_admin_menu`
--

LOCK TABLES `i_admin_menu` WRITE;
/*!40000 ALTER TABLE `i_admin_menu` DISABLE KEYS */;
INSERT INTO `i_admin_menu` VALUES (100,'邮件管理','90100','',0,0,0,0,0),(101,'邮件列表','90101','/Users',100,1,1,0,0),(102,'邮件添加','90102','/Users/edit',100,0,0,101,0),(103,'邮件域名','90103','/Domain',100,1,1,0,0),(105,'邮件系统设置','90105','/Users/config',100,1,0,0,0),(200,'系统管理','90200','',0,0,0,0,0),(201,'管理员列表','90201','/Admin',200,1,1,0,0),(202,'管理员添加','90202','/Admin/edit',200,0,0,201,0),(203,'角色列表','90203','/Group',200,1,1,0,0),(204,'角色添加','90204','/Group/edit',200,0,0,203,0),(205,'系统设置','90205','/System/config',200,1,0,0,0),(206,'操作日志','90206','/Log',200,0,1,0,0);
/*!40000 ALTER TABLE `i_admin_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_aliases`
--

DROP TABLE IF EXISTS `i_aliases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_aliases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source` varchar(100) NOT NULL,
  `destination` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `source` (`source`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮箱别名转发';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_aliases`
--

LOCK TABLES `i_aliases` WRITE;
/*!40000 ALTER TABLE `i_aliases` DISABLE KEYS */;
/*!40000 ALTER TABLE `i_aliases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_bcc_user`
--

DROP TABLE IF EXISTS `i_bcc_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_bcc_user` (
  `source` varchar(255) NOT NULL COMMENT '接收邮件的email',
  `to_email` varchar(255) NOT NULL COMMENT '目标用户的邮件',
  KEY `source` (`source`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮件转发';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_bcc_user`
--

LOCK TABLES `i_bcc_user` WRITE;
/*!40000 ALTER TABLE `i_bcc_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `i_bcc_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_domains`
--

DROP TABLE IF EXISTS `i_domains`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_domains` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `active` int(1) NOT NULL DEFAULT '0',
  `s_num` int(11) NOT NULL DEFAULT '0' COMMENT '邮件每天的发送量，0不受限制',
  `c_num` int(11) NOT NULL DEFAULT '0' COMMENT '邮件每天的接收量，0不受限制',
  `c_ip` int(11) NOT NULL DEFAULT '0' COMMENT '限制IP每天发送到邮件的数量，0不受限制',
  `g` int(11) NOT NULL DEFAULT '0' COMMENT '容量限制，单位G',
  `g_boundary` int(11) NOT NULL DEFAULT '0' COMMENT '容量达到边界发送通知(百分比)',
  `ctime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `active` (`active`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_domains`
--

LOCK TABLES `i_domains` WRITE;
/*!40000 ALTER TABLE `i_domains` DISABLE KEYS */;
INSERT INTO `i_domains` VALUES (1,'ewomail.com',1,0,0,0,0,0,'2024-03-17 00:37:07');
/*!40000 ALTER TABLE `i_domains` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_mail_config`
--

DROP TABLE IF EXISTS `i_mail_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_mail_config` (
  `name` varchar(255) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  UNIQUE KEY `key` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_mail_config`
--

LOCK TABLES `i_mail_config` WRITE;
/*!40000 ALTER TABLE `i_mail_config` DISABLE KEYS */;
INSERT INTO `i_mail_config` VALUES ('imap','imap.ewomail.com'),('mydomain','ewomail.com'),('myhostname','mail.ewomail.com'),('smtp','smtp.ewomail.com');
/*!40000 ALTER TABLE `i_mail_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_quota`
--

DROP TABLE IF EXISTS `i_quota`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_quota` (
  `email` varchar(100) NOT NULL,
  `bytes` bigint(20) NOT NULL DEFAULT '0',
  `messages` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`email`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_quota`
--

LOCK TABLES `i_quota` WRITE;
/*!40000 ALTER TABLE `i_quota` DISABLE KEYS */;
/*!40000 ALTER TABLE `i_quota` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_system_config`
--

DROP TABLE IF EXISTS `i_system_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_system_config` (
  `name` varchar(255) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统配置表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_system_config`
--

LOCK TABLES `i_system_config` WRITE;
/*!40000 ALTER TABLE `i_system_config` DISABLE KEYS */;
INSERT INTO `i_system_config` VALUES ('copyright','Copyright © 2016-2017 | ewomail.com 版权所有'),('icp','ICP证：粤ICP备**********号'),('lang','zh-cn'),('title','ewomail.com');
/*!40000 ALTER TABLE `i_system_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `i_users`
--

DROP TABLE IF EXISTS `i_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `i_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `password` varchar(106) NOT NULL,
  `email` varchar(100) NOT NULL,
  `maildir` varchar(255) NOT NULL,
  `uname` varchar(255) DEFAULT NULL COMMENT '姓名',
  `tel` varchar(255) DEFAULT NULL COMMENT '联系电话',
  `active` int(1) NOT NULL DEFAULT '1' COMMENT '是否正常：1是，0否',
  `limits` int(1) NOT NULL DEFAULT '1' COMMENT '收发限制',
  `limitg` int(1) NOT NULL DEFAULT '1' COMMENT '容量限制',
  `ctime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`) USING BTREE,
  KEY `domain_id` (`domain_id`) USING BTREE,
  KEY `active` (`active`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮箱用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `i_users`
--

LOCK TABLES `i_users` WRITE;
/*!40000 ALTER TABLE `i_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `i_users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-03-17  9:59:26