[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[tpop3d-discuss] tpop3d + vexim
From: |
Odhiambo Washington |
Subject: |
[tpop3d-discuss] tpop3d + vexim |
Date: |
Fri, 7 Nov 2003 11:43:16 +0300 |
User-agent: |
Mutt/1.5.4i |
Hello users,
Having almost reached my /etc, I have decided to seek your help/advise on this.
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,users.uid,'maildir' \
FROM users,domains WHERE localpart='$(local_part)' AND \
users.domain_id = domains.domain_id AND
domains.domain='$(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 the
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}3c4b9bc2c06bf0dff064953e73f15e16 | exim | maildir |
+--------------------------------------------+---------------------------------------+-----------+---------+
I have run tpop3d in debug mode with verbose output and below is what it spits
out:
address@hidden -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
<address@hidden>'
listeners_post_select: client [8]212.49.74.4/smtp.wananchi.com: connected to
local address 212.49.74.4:10110
connection_parsecommand: client [8]212.49.74.4/smtp.wananchi.com: received
`user address@hidden'
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),users.crypt,users.uid,'maildir'
FROM users,domains WHERE localpart='johndoe' AND users.domain_id =
domains.domain_id AND
domains.domain='fsck.or.ke'
password: address@hidden; address@hidden has password type md5, but hash is of
incorrect length
auth_mysql_new_user_pass: address@hidden; address@hidden failed login with
wrong password
connection_do: client `[8]212.49.74.4/smtp.wananchi.com': username
address@hidden': failing password is `sucker'
connection_sendresponse: client [8]212.49.74.4/smtp.wananchi.com: sent `-ERR
Lies! Try again!'
connection_do: client `[8]212.49.74.4/smtp.wananchi.com': username
address@hidden': 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: disconnected;
55/183 bytes read/written
The actual mail delivery location should be as follows:
221$ exim -C configure-Ng -bt address@hidden
address@hidden -> /var/spool/virtual/fsck.or.ke/johndoe/Maildir
transport = virtual_delivery
Now two things:
1. Is my query correct?
2. I am clueless at the moment ;-)
Any help??
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
- [tpop3d-discuss] tpop3d + vexim,
Odhiambo Washington <=