[tpop3d-discuss] tpop3 & mysql

[Adam Jackson]

>auth_mysql_new_user_pass: SQL query: SELECT CONCAT(popbox,'s86101101'),
CONCAT('{md5}', password),'nobody','bsd' FROM grad WHERE uid='s86101101'

This looks like your selecting the directory popboxs86101101, use
CONCAT(/popbox/,'s86101101')

>On Tue, Sep 30, 2003 at 04:56:07AM +0800, Yuan-Chung Hsiao(ychsiao)
wrote:
> root@graduate [/usr/local/etc/rc.d] (4:54) tpop3d -v -f 
> /usr/local/etc/tpop3d.conf root@graduate [/usr/local/etc/rc.d] (4:55) 
> tail -f /var/log/maillog Sep 30 04:50:43 graduate tpop3d[97083]: 
> net_loop: tpop3d version 1.5.2 successfully started
> Sep 30 04:54:27 graduate tpop3d[97083]: net_loop: terminating on
signal 2
> Sep 30 04:54:59 graduate tpop3d[97087]: TCP Wrappers support enabled,
using
> daemon name `tpop3d'
> Sep 30 04:54:59 graduate tpop3d[97087]: listener_new:
> gethostbyaddr(0.0.0.0): cannot resolve name
> Sep 30 04:54:59 graduate tpop3d[97087]: listener_new: 0.0.0.0:110:
cannot
> obtain domain suffix for this address
> Sep 30 04:54:59 graduate tpop3d[97087]: listener_new: 0.0.0.0:110:
using
> fallback domain suffix `graduate.stu.edu.tw'
> Sep 30 04:54:59 graduate tpop3d[97087]: parse_listeners: listening on
> address 0.0.0.0:110
> Sep 30 04:54:59 graduate tpop3d[97087]: /usr/local/etc/tpop3d.conf:
> specifying append-domain and strip-domain does not make much sense
> Sep 30 04:54:59 graduate tpop3d[97087]: 1 authentication drivers
> successfully loaded
> Sep 30 04:54:59 graduate tpop3d[97087]: net_loop: tpop3d version 1.5.2
> successfully started
> Sep 30 04:55:27 graduate tpop3d[97087]: listeners_post_select: client
> [6]127.0.0.1/graduate.stu.edu.tw: connected to local address
127.0.0.1:110
> Sep 30 04:55:39 graduate tpop3d[97087]: authcontext_new_user_pass:
began
> session for `s86101101' with mysql; uid 65534, gid 6
> Sep 30 04:55:39 graduate tpop3d[97087]: fork_child:
[6]s86101101(127.0.0.1):
> began session for `s86101101' with mysql; child PID is 97093
>
>were there no log messages after this? I'd expect some
>about the mailbox being opened and so forth.
>
>
>secondly, what response do you get if you run the SQL
>query you specify manually against the database?
>