Re: [Exim] perl and mysql in domain list

Etusivu
Poista viesti
Vastaa
Lähettäjä: robert rotman
Päiväys:  
Vastaanottaja: Alex Petrov
Kopio: exim-users
Aihe: Re: [Exim] perl and mysql in domain list

You can make a script that fetching data from mysql generating
a dbm or somthing like that.

I've the same problem but i work with mysql in this pattern too.
and its working well:)

i will suggest (in opposit to Phillip;) to query directly from mysql
if the system has no havy load.


robert


On Tue, 6 Jun 2000, Alex Petrov wrote:

>
> i store host_reject list in mysql database.
>
> host_reject=mysql; select host from hostrejecttable where host='$key'
>
> my concern is that when mysql query fails for any reason exim fails smtp
> connection. i can't afford my mail system to depend so heavily on
> avialability of mysql server. i am looking for a solution where mysql query
> failure would be equivalent to SELECT returning no match.
>
> I know that exim manual explains this problem and warns against using mysql
> lookups in critical parts of config. but i was hoping that someone has found
> a workaround.
>
> i am thinking of replacing direct mysql query with a perl wrapper script so
> that the script could screen lookup errors. but i can't figure out what
> would be the right syntax to make the script be called from within
> host_reject domain list.
>
> Thank you,
> --
>
>    Alex Petrov

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


---
di. robert rotman                                   inode.graz
phone -> ++43-(0)316 813141       ++43-(0)316 818600/15 <- fax
rotman@???                      http://www.graz.inode.at/
--
this letter was written on recycled bytes used by deleted mail.