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@??? |
\--------------------------------------------------------------------/
