[tpop3d-discuss] tpop3d + vexim [ARCHIVE]

[Odhiambo Washington]

--c8UbHMnQwI7BF+TB
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Chris Lightfoot <chris@ex-parrot.com> [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=3D'$(local_p=
art)' AND \
> >                        users.domain_id =3D domains.domain_id AND domain=
s.domain=3D'$(domain)'
>=20
> change users.crypt to concat('{crypt}', users.crypt);
>=20
> > password: [johndoe@fsck.or.ke; johndoe@fsck.or.ke] has password type md=
5, but hash is of incorrect length
>=20
> -- tpop3d asssumes that a password with no {...} prefix is just the MD5 h=
ash 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=3D'$(local_part)=
' \
                       AND users.domain_id =3D domains.domain_id AND domain=
s.domain=3D'$(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=20
+----------------------------------+---------------------------------------=
--+
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!" =20
						 --from a /. post

--c8UbHMnQwI7BF+TB
Content-Type: application/x-pkcs7-signature
Content-Disposition: attachment; filename="smime.p7s"
Content-Transfer-Encoding: base64

MIIIpQYJKoZIhvcNAQcCoIIIljCCCJICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
BikwggLiMIICS6ADAgECAgMK3KkwDQYJKoZIhvcNAQEEBQAwYjELMAkGA1UEBhMCWkExJTAj
BgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTAzMTAwNDA4MzU0MloXDTA0MTAwMzA4
MzU0MlowQzEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEgMB4GCSqGSIb3DQEJ
ARYRd2FzaEB3YW5hbmNoaS5jb20wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDj
LEll50c7ieFwNjBB+zKmFlkslzsR/Dl/uSuDZppsXrbF50H0rnUr5sjOUyy/I8Y/d1lEBIl9
pnCGZEZRpgnZYaEoy3epi9G2xU/UyT5sNQ3M0Oub5LtiahXCWTVQUYut7d972O3QeTXBqvJN
uUHnijthdBZ575N9n6niGrXSTJkZieIYc3TU7APlAf1c4B7n+ye62fRqceRPmYO9675wIT+V
rTLuXSlAMzOiuNMKD4fiEZ5JwxnshnOyfjpLJg78ISjl86YYhvwHMnOOQI1hfrndhi9dR4tj
xJ01UA7PReoRPEVbq/r/hHtAKj7t/nMC4J1ExEBEqTdREFjQMYffAgMBAAGjQTA/MBEGCWCG
SAGG+EIBAQQEAwIFoDAcBgNVHREEFTATgRF3YXNoQHdhbmFuY2hpLmNvbTAMBgNVHRMBAf8E
AjAAMA0GCSqGSIb3DQEBBAUAA4GBAApA1MhFESmSeJeNrNeIPOZRyZ1Zpcwy81Wyh88A0I2v
ZZamU2QRP+sbz+lwfxVdSImCZ7foOQYj9bemCrGmVhHN3uiiyWVUudD8INpH9pJmrDiWFlrZ
HzHXK1CpXrHbjnC8Qx91ibhYrqdvSWaKA7TfKadFIqe+gLgB3JHTD/JAMIIDPzCCAqigAwIB
AgIBDTANBgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4g
Q2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEo
MCYGA1UECxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhh
d3RlIFBlcnNvbmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVl
bWFpbEB0aGF3dGUuY29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjELMAkG
A1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNV
BAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3DQEB
AQUAA4GNADCBiQKBgQDEpjxVc1X7TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph8r9R
zgHU5VAKMNcCY1osiRVwjt3J8CuFWqo/cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+K/67GD4H
v0CAAmTXp6a7n2XRxSpUhQ9IBH+nttE8YQRAHmQZcmC3+wIDAQABo4GUMIGRMBIGA1UdEwEB
/wQIMAYBAf8CAQAwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybC50aGF3dGUuY29tL1Ro
YXd0ZVBlcnNvbmFsRnJlZW1haWxDQS5jcmwwCwYDVR0PBAQDAgEGMCkGA1UdEQQiMCCkHjAc
MRowGAYDVQQDExFQcml2YXRlTGFiZWwyLTEzODANBgkqhkiG9w0BAQUFAAOBgQBIjNFQg+oL
LswNo2asZw9/r6y+whehQ5aUnX9MIbj4Nh+qLZ82L8D0HFAgk3A8/a3hYWLD2ToZfoSxmRsA
xRoLgnSeJVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr394fWxghOrvbqNOUQGls1TXfjViF4gtwh
GTXeJLHTHUb/XV9lTzGCAkQwggJAAgEBMGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRo
YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG
cmVlbWFpbCBJc3N1aW5nIENBAgMK3KkwCQYFKw4DAhoFAKCBsTAYBgkqhkiG9w0BCQMxCwYJ
KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wMzExMDcxMTMzNTRaMCMGCSqGSIb3DQEJBDEW
BBTQ3oKDWuKS0eevmxzGWtFQPjE8lTBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4G
CCqGSIb3DQMCAgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDAN
BgkqhkiG9w0BAQEFAASCAQBuJ/SbiJvYkeoPyKKrQI9Y9wvntSTt7Bz4Zcekki94cGPLujnB
1yTKUa3QId4x3Ylv7mrpz8cHQHXHBtUoAJcP5ghvxRyUZ4WQNgnh/SG1UBqv0Gre77FXab73
cLs3u1yarkj0j3RcI5zfDvQZGBTzavTFFcaT6nehNF3JnkZ+lS6CD5BKCUMrzkFEzM8tTW4X
oID9zLxaLwEy2NWvkpvHlRQxu6NHvTsaAMTQDX5SNZDzarEr+wEqQEN0hss24SgeJ4Z4XaPN
gI3NVOiJpcdtn+bAyGPoW38o5uAbRsfIRTjKzqBMifCIdvM+9PTaOjt/THQNldU7gDEJKonG
V+R+

--c8UbHMnQwI7BF+TB--