Re: [tpop3d-discuss] tpop3d + vexim [ARCHIVE]

[Odhiambo Washington]

* Chris Lightfoot <address@hidden> [20031107 12:03]: wrote:
> On Fri, Nov 07, 2003 at 11:43:16AM +0300, Odhiambo Washington wrote:
> > auth-mysql-pass-query: SELECT 
> > CONCAT(maildir,'/',localpart),users.crypt,users.uid,'maildir' \
> >                        FROM users,domains WHERE  localpart='$(local_part)' 
> > AND \
> >                        users.domain_id = domains.domain_id AND 
> > domains.domain='$(domain)'
> 
> change users.crypt to concat('{crypt}', users.crypt);
> 
> > password: address@hidden; address@hidden has password type md5, but hash is 
> > of incorrect length
> 
> -- tpop3d asssumes that a password with no {...} prefix is just the MD5 hash 
> of a password.


Hello Chris


Thank you so much. With the new vexim (vexim2) the following query will
authenticate users against their md5-type passwords:

auth-mysql-pass-query: SELECT CONCAT(maildir,'/',localpart,'/Maildir'), \
                       CONCAT('{crypt}', users.crypt),users.uid,'maildir' \
                       FROM users,domains WHERE  localpart='$(local_part)' \
                       AND users.domain_id = domains.domain_id AND 
domains.domain='$(domain)'


vexim2 also has the cleartext passwords in a column called 'clear' so
those using APOP (I know nothing about it) could perhaps use that
in the auth-mysql-apop-query.

Basically, tpop3d has just become another POP3 server for vexim.

Thanks a million!




        cheers
       - wash 
+----------------------------------+-----------------------------------------+
Odhiambo Washington                     . WANANCHI ONLINE LTD (Nairobi, KE)  |
<wash at wananchi dot com>              . 1ere Etage, Loita Hse, Loita St.,  |
GSM: (+254) 722 743 223                 . # 10286, 00100 NAIROBI             |
GSM: (+254) 733 744 121                 . (+254) 020 313 985 - 9             |
+---------------------------------+------------------------------------------+
"Oh My God! They killed init! You Bastards!"  
                                                 --from a /. post

smime.p7s
Description: S/MIME cryptographic signature