[Exim] followup to the partial-mysql question

Top Pagina
Delete this message
Reply to this message
Auteur: Tom Bell
Datum:  
Aan: exim-users
Onderwerp: [Exim] followup to the partial-mysql question
Howdy again,
            Thanx go to Philip, Mark & John.


Ultimately I fixed it with the suggestion from Mark which at the time I
was too ingnorant to realise would solve my problems.

My sql table now contains

+------------+-------+
| Host       | User  |

+------------+-------+
|%.spam.com  | *     |
+------------+-------+


instead of previously having *.spam.com. And now the query looks like
this.

sender_reject_recipients = @@mysql;select user from reject_users
where '${key}' like host;

And this matches all subdomains of spam.com and with out having to use the
regex pattern matching within mysql.

Thanx again for all the help guys.

Tom Bell