RE: [Exim] Exim & PostgreSQL 2 :)

Oh and then use the variable like this

local_domains =     machine.example.com : \
            localhost : \
            pgsql;PGSQL_LOCAL_MAILALIAS

-----Original Message-----
From: Andy Hedges
Sent: 08 March 2002 16:50
To: 'Sander Smeenk'; exim-users@???
Subject: RE: [Exim] Exim & PostgreSQL 2 :)


I found that Exim didn't like it when more than one row was returned thus I
do this

PGSQL_LOCAL_DOMAINS    = SELECT DISTINCT domainName FROM mailalias WHERE
domainName='${lc::$key}'

All works peachy and seems to scale well too.

Andy

-----Original Message-----
From: Sander Smeenk [mailto:ssmeenk@freshdot.net]
Sent: 08 March 2002 16:16
To: exim-users@???
Subject: [Exim] Exim & PostgreSQL 2 :)


Hi,

$version = "Exim 3.35";

I have read through the archives but could still not fix my problem, and
I think I might be wanting to do something that can't be done this way.

I want my 'local_domains' and 'relay_hosts' to get their values from my
postgresql database. So what I tried is this:

    hide pgsql_servers = localhost/dbname/user/password

The database exists and the specified user is the owner and has access.
Then I did:

    local_domains = $lookup{pgsql{select domain from
localdomains}{$value}fail}

I could not see exim connecting with the database, though :(
I also tried these:

    local_domains = $lookup{pgsql{select domain from localdomains}{$value}}
    local_domains = $lookup{pgsql{select domain from localdomains}}
    local_domains = pgsql{select domain from localdomains}{$value}
    local_domains = pgsql{select domain from localdomains}

But none seem to work :(

I'm sure I compiled exim with pgsql lookup methods, but I am not sure if
I can use these methods in the local_domains and relay_domains
directives. This test-setup runs from inetd, so exim gets restarted each
time I connect.

Help? :)

Regards,
Sander.

--
| How do you write zero in Roman numerals?
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D

--

## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at http://www.exim.org/ ##