[tpop3d-discuss] tpop3d + vexim

[Odhiambo Washington]

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