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 :

[email protected]
[email protected]
[email protected]
....

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
-- 
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/

Reply via email to