[tpop3d-discuss] tpop3d + vexim
Odhiambo Washington
wash at wananchi.com
Fri, 7 Nov 2003 11:43:16 +0300
--r5Pyd7+fXNt84Ff3
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Hello users,
Having almost reached my /etc, I have decided to seek your help/advise on t=
his.
I am trying to intergrate vexim (http://silverwraith.com/vexim) version 2 (
http://silverwraith.com/vexim/download.html) with tpop3d. So far vexim has
a working config for qpopper but for me I am not willing to consider any
substitute for tpop3d so I _must_ stick with it, which also puts me in this
awkward position right now ;)
I just don't seem to be able to get a working query for tpop3d. I have come
up with the one below:
auth-mysql-pass-query: SELECT CONCAT(maildir,'/',localpart),users.crypt,use=
rs.uid,'maildir' \
FROM users,domains WHERE localpart=3D'$(local_part)=
' AND \
users.domain_id =3D domains.domain_id AND domains.do=
main=3D'$(domain)'
and it returns the following
+---------------------------------------+----------------------------------=
--+-----+---------+
| CONCAT(maildir,'/',localpart) | crypt =
| uid | maildir |
+---------------------------------------+----------------------------------=
--+-----+---------+
| /var/spool/virtual/fsck.or.ke/johndoe | $1$lA1K4pOQ$JRjr3v6fDX1rYqFVtmyiq=
/ | 69 | maildir |
+---------------------------------------+----------------------------------=
--+-----+---------+
Now this is significantly different than the equiv that I would get from th=
e vmail-sql db
query, which gives me a totally different crypt format as you can see below:
+--------------------------------------------+-----------------------------=
----------+-----------+---------+
| CONCAT(domain.path, '/', popbox.mbox_name) | password_hash =
| unix_user | maildir |
+--------------------------------------------+-----------------------------=
----------+-----------+---------+
| /var/spool/virtual/airoquip.com/admin | {md5}3c4b9bc2c06bf0dff064953=
e73f15e16 | exim | maildir |
+--------------------------------------------+-----------------------------=
----------+-----------+---------+
I have run tpop3d in debug mode with verbose output and below is what it sp=
its
out:
[root@ns2]#tpop3d -d -v -f tpop3d.conf
parse_listeners: listening on address 62.8.64.4:10110
parse_listeners: listening on address 212.49.74.4:10110
parse_listeners: listening on address 192.168.50.3:10110
tpop3d.conf: I hope you realise that use of the log-bad-passwords option is=
an invasion of privacy
get_mysql_server: now using server localhost
3 authentication drivers successfully loaded
net_loop: tpop3d version 1.5.2 successfully started
connection_sendresponse: client [8]212.49.74.4/smtp.wananchi.com: sent `+OK
<2f58e14946c8c48b135f3c7414794ba2@smtp.wananchi.com>'
listeners_post_select: client [8]212.49.74.4/smtp.wananchi.com: connected t=
o local address 212.49.74.4:10110
connection_parsecommand: client [8]212.49.74.4/smtp.wananchi.com: received =
`user johndoe@fsck.or.ke'
connection_sendresponse: client [8]212.49.74.4/smtp.wananchi.com: sent `+OK=
Tell me your password.'
connection_parsecommand: client [8]212.49.74.4/smtp.wananchi.com: received =
`pass [...]'
auth_mysql_new_user_pass: SQL query: SELECT CONCAT(maildir,'/',localpart),u=
sers.crypt,users.uid,'maildir'
FROM users,domains WHERE localpart=3D'johndoe' AND users.domain_id =3D dom=
ains.domain_id AND
domains.domain=3D'fsck.or.ke'
password: [johndoe@fsck.or.ke; johndoe@fsck.or.ke] has password type md5, b=
ut hash is of incorrect length
auth_mysql_new_user_pass: [johndoe@fsck.or.ke; johndoe@fsck.or.ke] failed l=
ogin with wrong password
connection_do: client `[8]212.49.74.4/smtp.wananchi.com': username `johndoe=
@fsck.or.ke': failing password is `sucker'
connection_sendresponse: client [8]212.49.74.4/smtp.wananchi.com: sent `-ER=
R Lies! Try again!'
connection_do: client `[8]212.49.74.4/smtp.wananchi.com': username `johndoe=
@fsck.or.ke': 1 authentication failures
connection_sendresponse: client [8]212.49.74.4/smtp.wananchi.com: sent `+OK=
Fine. Be that way.'
connections_post_select: client [8]212.49.74.4/smtp.wananchi.com: disconnec=
ted; 55/183 bytes read/written
The actual mail delivery location should be as follows:
221$ exim -C configure-Ng -bt johndoe@fsck.or.ke
johndoe@fsck.or.ke -> /var/spool/virtual/fsck.or.ke/johndoe/Maildir
transport =3D virtual_delivery
Now two things:
1. Is my query correct?
2. I am clueless at the moment ;-)
Any help??
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
--r5Pyd7+fXNt84Ff3
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
KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wMzExMDcwODQzMTZaMCMGCSqGSIb3DQEJBDEW
BBQqKAsmqRcWdMoc706GhXtfZegJMjBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4G
CCqGSIb3DQMCAgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDAN
BgkqhkiG9w0BAQEFAASCAQBLOWWc9Ap36eNepbopcUzInZT8nYJouVOIReSWScn1hsTQ1sx5
eC+MFE4e0jLYet+0vFElWhRYMAaNebraUGcsrf6K0dYViW05wtiooF2n3c7K26xzy2qrjc0I
d+ahlrQAa4ESzBAnM8uNfUD+3jcdAzwlt3lKQPAuTXni29pBXVDvHgFke2hKNVgO0oBoGCm4
YxVKZnAIsGFgmHKXqrxJX7IPTKak/uEoDU+iALTSa2LAtkvc3FoBO2M8rr8FufHB1ErudMHx
4KR7WNQ6DLPhO5Tup8n1+RpJTy68OhosLmHL/sKsdbZfWZgHdLRo8UbITeOUKlOBDDx28K5J
P0r6
--r5Pyd7+fXNt84Ff3--