[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss] tpop3d + vexim [ARCHIVE]
From: |
Odhiambo Washington |
Subject: |
Re: [tpop3d-discuss] tpop3d + vexim [ARCHIVE] |
Date: |
Fri, 7 Nov 2003 14:33:54 +0300 |
User-agent: |
Mutt/1.5.4i |
* 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