Re: [tpop3d-discuss]MySQL and dots before the @ sign

[David Mitchell]

----- Original Message ----- 
From: "address@hidden" <address@hidden>
Sent: Tuesday, July 27, 2004 6:24 AM

*snip*
> auth-mysql-enable: true
> auth-mysql-mail-group: postfix
> auth-mysql-database: database
> auth-mysql-username: username
> auth-mysql-password: password
>
>
> This is the select statement:
>
> mysql> select * from popbox where domain_name="efbs.net" and
> local_part="b.t";
>
+-------------+------------+---------------------------------+------------+
> | domain_name | local_part |password_hash                    | mbox_name
|
>
+-------------+------------+---------------------------------+------------+
> | efbs.net    | b.t        |598d4c200461b81522a3328565c25f7c |
address@hidden
>
+-------------+------------+---------------------------------+------------+
> 1 row in set (0.00 sec)
*snip*

Looks OK, but what do you have set for the auth-mysql-pass-query option in
the conf file? Your problem may be quoting in the SELECT statement - MySQL
will interpret WHERE local_part=b.t and WHERE local_part="b.t" differently.
I use single quotes in mine (WHERE USERNAME='$(user)') but I think double
quotes are interpreted the same way by MySQL.

Cheers,
Dave