Re: [Courier-imap] auth in mysql

[Todd L. <tl...@iv...>]

On Wed, Feb 25, 2009 at 8:42 AM, Mohsen Pahlevanzadeh
<mo...@pa...> wrote:
> --------------------------------------------------
> localhost:/home/mohsen# telnet 0 110
> Trying 0.0.0.0...
> Connected to 0.
> Escape character is '^]'.
> +OK Hello there.
> user postmaster@mohsenjan
> ------------------------
> Feb 25 19:17:20 localhost authdaemond: SQL query: SELECT pw_name,
> pw_passwd, pw_clear_passwd, pw_uid, pw_gid, pw_dir , "", "", "", "" FROM
> vpopmail WHERE pw_name = 'postmaster@mohsenjan'
> Feb 25 19:17:20 localhost authdaemond: zero rows returned
> -----------------------------------------------
> My question:
> How i tell to courier to pw_name is just is my username from email?.It
> doesn't contain domain name

The easiest thing to do is just not use the domain name when you connect.

> I have attached my /etc/courier/authmysqlrc file.

If you insist on using the domain name, then you'll want to use the
MYSQL_WHERE_CLAUSE portion of the authmysqlrc to override the WHERE
portion of the query.  You'll probably want something like:
pw_name = $(local_part)

Totally untested and not used by me.  Good luck.
-- 
Regards...      Todd
All truth passes through three stages. First, it is ridiculed. Second,
it is violently opposed. Third, it is accepted as being self-evident.