[tpop3d-discuss] tpop3 & mysql

Yuan-Chung Hsiao(ychsiao) ychsiao at linux.mis.stu.edu.tw
Tue, 30 Sep 2003 05:10:54 +0800


-----Original Message-----
> were there no log messages after this? I'd expect some
> about the mailbox being opened and so forth.
No, no log :(
>
>
> secondly, what response do you get if you run the SQL
> query you specify manually against the database?
>

mysql> SELECT CONCAT('/popmail1/s86101101','$(local_part)'),
CONCAT('{MD5}mypassword', password),'nobody','bsd' FROM grad WHERE
uid='s86101101';
+-----------------------------------------------+---------------------------
---------------------+--------+-----+
| CONCAT('/popmail1/s86101101','$(local_part)') | CONCAT('{MD5}S86101101',
password)             | nobody | bsd |
+-----------------------------------------------+---------------------------
---------------------+--------+-----+
| /popmail1/s86101101$(local_part)              |
{MD5}S86101101afea976cebc6f46027300af5b868f17e | nobody | bsd |
+-----------------------------------------------+---------------------------
---------------------+--------+-----+
1 row in set (0.00 sec)