[tpop3d-discuss] tpop3 & mysql

[Chris Lightfoot]

On Tue, Sep 30, 2003 at 05:10:54AM +0800, Yuan-Chung Hsiao(ychsiao) wrote:
> -----Original Message-----
> > were there no log messages after this? I'd expect some
> > about the mailbox being opened and so forth.
> No, no log :(

hmm. That's surprising.

> > 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)'),

isn't s86101101 the 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)

-- 
``Sri Lankans urged to multiply for war.'' (BBC News headline)