Here's my version:
#
# local_domains -> domains that land here
#
domainlist local_domains = ${lookup mysql{SELECT domain FROM
domains WHERE type='local' AND active='1'}{${sg{$value}{\\n}{ : }} }}
Mike
On 06/04/2025 13:19, Joan Moreau via Exim-users wrote:
Hi
I am trying to
Am 06.04.25 um 22:01 schrieb Mark Elkins via Exim-users:
In MYSQL - try:-
SELECT GROUP_CONCAT(domain SEPARATOR ':') AS domain FROM mail_domains
On 2025/04/06 21:43, Ray O'Donnell via Exim-users wrote:
I do the same thing using PostgreSQL - my lookup looks like this
(built with help from this
In MYSQL - try:-
SELECT GROUP_CONCAT(domain SEPARATOR ':') AS domain FROM mail_domains
On 2025/04/06 21:43, Ray O'Donnell via Exim-users wrote:
On 06/04/2025 13:19, Joan Moreau via Exim-users wrote:
Hi
I am trying to make my list of local domains from mysql
domainlist mylist = ${lookup mysql
On 06/04/2025 13:19, Joan Moreau via Exim-users wrote:
Hi
I am trying to make my list of local domains from mysql
domainlist mylist = ${lookup mysql{SELECT domain FROM mail_domains}}
However, if the table containts several domains (indeed..), the mylist
is not an array of domains and local ma