On Wed, Feb 25, 2009 at 8:42 AM, Mohsen Pahlevanzadeh <[email protected]> wrote: > -------------------------------------------------- > localhost:/home/mohsen# telnet 0 110 > Trying 0.0.0.0... > Connected to 0. > Escape character is '^]'. > +OK Hello there. > user postmas...@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 = 'postmas...@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. ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Courier-imap mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap
