Re: [Exim] SMTP AUTH

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: marte
Ημερομηνία:  
Προς: Antony Gelberg
Υ/ο: exim-users
Αντικείμενο: Re: [Exim] SMTP AUTH
My way (auth with MySQL) - hope it will help anyone:

Queries:
MYSQL_Q_AUTHUSR = SELECT user FROM MYSQL_AUTHTABLE WHERE boxname='$2'
MYSQL_Q_AUTHPWD = SELECT boxname FROM MYSQL_AUTHTABLE WHERE boxname='$2' AND boxpwd=encrypt('$3',boxpwd)

Authenticator:
fixed_plain:
driver = plaintext
public_name = PLAIN
server_condition = ${lookup mysql{MYSQL_Q_AUTHPWD}{1}fail}
server_set_id = ${lookup mysql {MYSQL_Q_AUTHUSR}{$value}}

(I don't know if there is any pssibility to do cram-auth with encrypted passes)

My SQL-Table looks like:

`boxname` varchar(7) NOT NULL default '',
`boxpwd` varchar(20) NOT NULL default '',
`user` varchar(12) NOT NULL default '',
`ts_created` int(11) NOT NULL default '0',
KEY `id` (`boxname`)

So every user can have several boxes - but in exim logfile you can see the username,
not the boxname; Passes are stored Mysql-encrypted.

I'd be very glad if anybody could explain me if there is any way to do cram-auth
this way.

Martin
--
/--------------------------------------------------------------------\
| Martin Tettke                 | Tel.:   + 49 - 30 - 742 22 94      |
| Schillerstr. 78B              | FAX :   + 49 - 30 - 743 768 47     |
| 12305 Berlin                  | EMAIL:  marte@???        |

\--------------------------------------------------------------------/