tim wrote:
> I have scoured the mailing list and the documentation on the web but I
> still can't get it to go. To start with I wanted to simply get the local
> domains to be read from a table so I did this.
>
> hide pgsql_servers = localhost/dbmail/dbmail/dbmail
> domainlist local_domains = ${lookup pgsql{select domain from
> local_domains}{$value}fail}
Which is wrong.
The last line should state (no tested):
domainlist local_domains = pgsql;select domain from domains \
where domain=$domain
> This is just plain old cut and paste from my digging around on the web so I
> don't really understand the syntax of the second line but it does not work.
The syntax is very well documented in the exim spec.
> It gives me the "lowest numbered MX record points to local host" error
> which I understand is because the lookup is failing. There is no entry in
> the paniclog. If I hard code the local hosts then it's OK.
>
> Is there a decent explanation of database lookups anywhere? The
> documentation is sparse to say the least. What am I doing wrong here?
The documentation is not sparse. Go read it. Database lookups work
mostly in the same way as, say, cdb lookups. RTFM.
--
Kirill Miazine
mailto:km@krot.org
http://km.krot.org/
