Good Day All,
We have an issue at the moment, especially since it is the holiday's, where a certain "Out of Office" message is being relayed from incorrect addresses.
The reasoning behind this is more than likely because of the email addresses concerned. An example :
info@???
info@???
info@???
....
Only one of the info@ addresses has an out of office, but when mailing any of them, you get the Out of Office message but from the original intended recipient.
Some of the configs :
mysql_autorespond:
driver = accept
condition = ${if eq{} {${lookup mysql{SELECT on_vacation \
FROM Viz.MailAddresses WHERE on_vacation = '1' \
AND localpart='$local_part' }}}{0}{1}}
no_verify
no_expn
unseen
transport = address_mysql
address_mysql:
driver = autoreply
from = "${local_part}@${domain}"
reply_to = "${local_part}@${domain}"
to = ${sender_address}
headers = "X-Script: Exim Auto Responder \nPrecedence: bulk"
return_message = false
subject = "Out of Office"
text = ${lookup mysql{SELECT vacation from Viz.MailAddresses WHERE localpart = "$local_part"}}
once = ${lookup mysql{MYSQL_D_LDOMAIN}{$value}fail}/once
once_repeat = 1w
To clarify something from the above, local_part is the info before the @ in the email addresses. Is there any quick solution or better condition matching ?
PS MySQL Table :
mysql> explain MailAddresses;
+-------------+---------------------------------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------------------------+------+-----+-------------------+-------+
| UserID | int(16) unsigned | NO | | NULL | |
| domain_id | mediumint(8) unsigned | NO | PRI | NULL | |
| localpart | varchar(192) | NO | PRI | | |
| uid | smallint(5) unsigned | NO | | 26 | |
| gid | smallint(5) unsigned | NO | | 26 | |
| smtp | varchar(255) | NO | | | |
| pop | varchar(255) | NO | | | |
| forward | varchar(255) | NO | | | |
| forward_on | tinyint(1) | NO | | 0 | |
| comment | varchar(255) | NO | | | |
| type | enum('local','alias','catch','piped') | NO | | local | |
| avscan | tinyint(1) | NO | | 0 | |
| blocklist | tinyint(1) | NO | | 0 | |
| quota | int(10) unsigned | NO | | 0 | |
| sa_tag | smallint(5) unsigned | NO | | 5 | |
| sa_refuse | smallint(5) unsigned | NO | | 10 | |
| on_vacation | tinyint(1) | NO | | 0 | |
| vacation | varchar(255) | YES | | NULL | |
| flags | varchar(16) | YES | | NULL | |
| tagline | varchar(255) | YES | | NULL | |
| CreateDate | timestamp | NO | | CURRENT_TIMESTAMP | |
+-------------+---------------------------------------+------+-----+-------------------+-------+
21 rows in set (0.00 sec)
mysql>
This e-mail and its contents are subject to the Business Connexion (Pty) Ltd. E-mail legal notice
