[Vmail-discuss] smtp auth again

[Litzler Mihaly]

Final working version:

vmail_plain:
        driver = plaintext
        public_name = PLAIN
        server_prompts = :
        server_condition = ${if and{ {!eq {$2}{}} {!eq {$3}{}} {eq
{1}{${lookup mysql{select count(*) from popbox where
concat(local_part,'@',domain_name) =   '$2' and
password_hash=concat("\{plaintext\}", "$2")}}}}}{yes}{no}}

vmail_cram:
        driver = cram_md5
        public_name = CRAM-MD5
        server_secret = ${lookup mysql{select substring(password_hash,11)
from popbox where concat(local_part,'@',domain_name) = '$1'}
{$value}fail }
        server_set_id = $1

vmail_login:
        driver = plaintext
        public_name = LOGIN
        server_prompts = "Username:: : Password::"
        server_condition = ${if eq {1}{${lookup mysql{select count(*) from
popbox where concat(local_part,'@',domain_name) = '$1' and
password_hash=concat("\{plaintext\}", "$2")}}}{yes}{no}}
        server_set_id = $1



Thank you so much!

Mihaly