我正在尝试将垃圾邮件移动到垃圾邮件文件夹中,并自动使用procmailrc文件。现在,我已经在mysql中使用虚拟邮件、存储邮箱设置等运行后缀:
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual-aliases.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual-domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual-mailboxes.cf
virtual_minimum_uid = 1111
virtual_uid_maps = static:1111
virtual_gid_maps = static:1111
virtual_mailbox_base = /home/vmail我还以启用虚拟传输的形式获得了procmail:
virtual_transport = procmail
procmail_destination_recipient_limit = 1main.cf:
procmail unix - n n - - pipe flags=DRXhuq user=vmail
argv=/usr/bin/procmail -m E_SENDER=$sender E_RECIPIENT=$recipient ER_USER=$user ER_DOMAIN=$domain ER_DETAIL=$extension NEXTHOP=$nexthop /etc/procmail.d/default.rc现在,在/etc/procmail.d/default.rc中,我想将邮件路由到/home/vmail/[DOMAIN]/[USERNAME],其中用户名不是$recipient或$user值,而是存储在数据库中的另一个值。我是否可以从数据库中获得该名称以获取邮件,这样它就可以正确地路由邮件?
+----------+--------------+------+-----+---------------------------------------------------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------------------------------------------------------------------+-------+
| domain | varchar(255) | NO | PRI | NULL | |
| email | varchar(255) | NO | PRI | NULL | |
| user | varchar(255) | NO | | NULL | |
| password | varchar(255) | NO | | {CRYPT}$2y$05$M93Wk.20E31Let6AsWvjx.5eEfsw3ZM1jpha/XkPq6O5PPaiDgc/6 | |
| location | varchar(255) | NO | | NULL | |
| quota | bigint | NO | | 10000000000 | |
| enabled | tinyint | NO | | 0 | |
+----------+--------------+------+-----+---------------------------------------------------------------------+-------+邮件被传递到/home/vmail/DOMAIN/user,其中用户是一个自定义用户名,不需要与电子邮件相同。
SELECT * FROM [table] WHERE user = 'xyz';
+-----------+----------------------+------+---------------------------------------------------------------------+----------------+-------------+---------+
| domain | email | user | password | location | quota | enabled |
+-----------+----------------------+------+---------------------------------------------------------------------+----------------+-------------+---------+
| exam.ple | mymail | xyz | password | exam.ple/xyz/ | 50000000000 | 1 |发布于 2022-09-26 11:37:31
如果我能够正确地猜出您想问的是什么,您将需要对每个传入的电子邮件消息运行一个SQL查询。这听起来相当沉重,但不难做到。
在/etc/procmailrc中,类似这样的内容(很明显,我不得不猜测一下您的片段是如何组合在一起的,并对查询SQL数据库的实际命令进行伪编码):
loc=`sql "select concat(domain, '/', user) from [table] where email = '$ER_USER';"`
DEFAULT=/home/vmail/$loc将其编译到单独的后缀映射(每次数据库更改时都会更新)可能是一个更可伸缩的解决方案。
https://serverfault.com/questions/1111515
复制相似问题