Hello!!!
I use Exim 4.20+ Dbmail1.1 + Mysql
i add
login:
driver = plaintext
public_name = LOGIN
server_prompts = "Username:: : Password::"
server_condition = ${lookup mysql{SELECT user_idnr FROM users WHERE \
userid = '${quote_mysql:$1}' AND passwd = \
'${quote_mysql:$2}'}{1}fail}
server_set_id = $1
server_advertise_condition = ${if eq{$tls_cipher}{}{no}{yes}}
And test:
telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.ru.
Escape character is '^]'.
220-Welcome on My Mail Server!
220-This system does not accept Unsolicited Commercial Email
220-and will blacklist offenders via our spam processor.
220-Have a nice day!
220-
220 mydomain.ru ESMTP
ehlo localhost
250-mydomain.ru Hello localhost.ru [127.0.0.1]
250-SIZE 5242880
250-PIPELINING
250-AUTH PLAIN CRAM-MD5
250 HELP
I dont see auth login!!!!!!
after change in maillog file i see:
Oct 14 10:30:13 mydomain exim[39465]: 2003-10-14 10:30:13 SMTP protocol
error in "auth login" H=localhost.ru (localhost) [127.0.0.1] login
authentication mechanism not supported
question: how you create dbmail base???
Senks!
Dgonny.
> On Mon, Oct 13, 2003 at 08:54:48PM +0400, [EMAIL PROTECTED] wrote:
> > Hello!!!
> > I use exim and MySQL.....
> > If need, i send my exim.conf file!
>
> I haven't tested all of these, but it should get you started.
> This is for exim 4. I'm not sure if authenticators changed much from exim 3
> though.
>
> begin authenticators
>
> plain:
> driver = plaintext
> public_name = PLAIN
> server_condition = ${lookup mysql{SELECT user_idnr FROM users WHERE userid
> = '${quote_mysql:$2}' AND passwd =
> '${quote_mysql:$3}'}{1}fail}
> server_set_id = $2
> server_advertise_condition = ${if eq{$tls_cipher}{}{no}{yes}}
>
> login:
> driver = plaintext
> public_name = LOGIN
> server_prompts = "Username:: : Password::"
> server_condition = ${lookup mysql{SELECT user_idnr FROM users WHERE userid
> = '${quote_mysql:$1}' AND passwd =
> '${quote_mysql:$2}'}{1}fail}
> server_set_id = $1
> server_advertise_condition = ${if eq{$tls_cipher}{}{no}{yes}}
>
> cram_md5:
> driver = cram_md5
> public_name = CRAM-MD5
> server_secret = ${lookup mysql{SELECT passwd FROM users WHERE userid =
> '${quote_mysql:$1}'}{$value}fail}
> server_set_id = $1
>
> spa:
> driver = spa
> public_name = NTLM
> server_password = ${lookup mysql{SELECT passwd FROM users WHERE userid =
> '${quote_mysql:$1}'}{$value}fail}
>
> _______________________________________________
> Dbmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
