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

David Mitchell dmitchell at alphalink.com.au
Tue, 27 Jul 2004 10:20:18 +1000


----- Original Message ----- 
From: "TPOP3@Globalplanets.net" <tpop3@globalplanets.net>
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 |
b.t@efbs.net
>
+-------------+------------+---------------------------------+------------+
> 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