Re: [exim] Exim authenticator recursive MySQL lookup

Góra strony
Delete this message
Reply to this message
Autor: Giuliano Gavazzi
Data:  
Dla: Exim-USERS
Temat: Re: [exim] Exim authenticator recursive MySQL lookup
At 7:30 pm -0400 2004/11/26, Axel aghi Hollanda wrote:
>Hi, Peter
>
> My very basic authentication driver looks like this:

[...]
> This works fine. What I want to do now is:
>
>    If possible, before server_condition just like "local_parts"
>variable within "accept router driver":

>
>    some_var = mysql; select id from users where user =
>'${quote_mysql:$local_part:$1}'

>
>     Then, inside my server_condition:

>
>     match {${extract {id}  {$some_var_data} {$value} {0}} {SOME_ID}

>
>     Did it get any better? I think now it's more easy than do
>recursive lookups inside server_condition.


please don't top post and, above all, trim your replies (currently
and for a few days I am on dialup and thanks to this too common
behaviour I find it difficult to check my work email).

Now to your question: cannot you just do everything on the server
side? I am referring to stored procedures. If mysql does not support
stored procedures, then use Postgres.

g