Re: [exim] Logging to SysLog just some events

Jakob Hirsch <jh@???> schrieb:

> There are possibilities to work around this:
>
> - instead of "fail" at the end of your server_condition, use "${lookup
> your_db {INSERT INTO ... ON DUPLICATE KEY UPDATE...} {no}{no}}". You can
> put that into a macro to use it nicely with multiple auth types.

This is VERY interesting!

I'll try it...

Just a little question: I have these authenticators:

# PLAIN-Authentication
fixed_plain:
driver = plaintext
public_name = PLAIN
server_prompts = "Enter Username and Password:"
server_condition = ${lookup mysql{SELECT passwd FROM account WHERE
accountname='$2' AND virtual = 'f'} {${if eq{$value}{$3}{yes}{no}}}{no}}
server_set_id = $2

# LOGIN-Authentication
fixed_login:
driver = plaintext
public_name = LOGIN
server_condition = ${lookup mysql{SELECT passwd FROM account WHERE
accountname='$1' AND virtual = 'f'} {${if eq{$value}{$2}{yes}{no}}}{no}}
server_set_id = $1
server_prompts = "Username:: : Password::"

# CRAM-MD5-Authentication
cram:
driver = cram_md5
public_name = CRAM-MD5
server_secret = ${lookup mysql{SELECT passwd FROM account WHERE
accountname='$1' AND virtual = 'f'}{$value}fail}
server_set_id = $1

# SPA/NTLM-Authentication
spa:
driver = spa
public_name = NTLM
server_password = ${lookup mysql{SELECT passwd FROM account WHERE
accountname='$1' AND virtual = 'f'}{$value}fail}

How you see, I have the "fail" just on server_password/server_secret by cram
and spa.
By plain and login I have return a "no". Can I modify this "no" with the
lookup, too?

Thanks
Luca Bertoncello
(lucabert@???)