Docker下搭建ewomail郵件伺服器

ぶ会编程發表於2024-03-17
DockerAI伺服器

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

第二步：登入管理中心 配置
參考官網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設定為例子


將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

linux安裝開源郵件伺服器iredmail的方法：docker

linux安裝開源郵件伺服器iredmail的方法：docker
參考URL: https://www.cnblogs.com/shengulong/p/9133466.html

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

#轉自

www.cnblogs.com/SZLLQ2000/p/14765460.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

相關文章