[exim] Re: domainlist from mysql

2025-04-07 Thread Mike Tubby G8TIC via Exim-users
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

[exim] Re: domainlist from mysql

2025-04-07 Thread Cyborg via Exim-users
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

[exim] Re: domainlist from mysql

2025-04-06 Thread 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: 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

[exim] Re: domainlist from mysql

2025-04-06 Thread Ray O'Donnell via Exim-users
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