Re: [courier-users] IMAP proxy

This is a MIME GnuPG-signed message. If you see this text, it means that
your E-mail or Usenet software does not support MIME signed messages.
The Internet standard for MIME PGP messages, RFC 2015, was published in 1996.
To open this message correctly you will need to install E-mail or Usenet
software that supports modern Internet standards.

--===============0981966954==
Content-Type: multipart/signed;
boundary="=_mimegpg-commodore.email-scan.com-2650-1203034924-0001";
micalg=pgp-sha1; protocol="application/pgp-signature"

This is a MIME GnuPG-signed message. If you see this text, it means that
your E-mail or Usenet software does not support MIME signed messages.
The Internet standard for MIME PGP messages, RFC 2015, was published in 1996.
To open this message correctly you will need to install E-mail or Usenet
software that supports modern Internet standards.

--=_mimegpg-commodore.email-scan.com-2650-1203034924-0001
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Bernd Wurst writes:

> My authmysql config is like that:
>
> MYSQL_SELECT_CLAUSE SELECT \
> * FROM courier_mailaccounts \
> WHERE '$(service)' IN ('imap', 'pop3', 'esmtp', 'login') \
> AND account='$(local_part)@$(domain)';
>
>
> An example query result looks like that:
>
> mysql> select * from courier_mailaccounts where
> account='hannotest-1@schokokeks.org'\G
>
> *************************** 1. row ***************************
> account: hannotest-1@schokokeks.org
> cryptpass: $1$SJC8YTBv$Zb1sxQiIxp04ngdabR.Fa0
> clearpass: NULL
> uid: 1306
> gid: 100
> homedir: /home/hannotest
> maildir: /home/hannotest/milchtest
> a:
> b: 0
> c:
> options: mailhost=milch.schokokeks.org
> 1 row in set (0.01 sec)

I think you have an extra field in there. From authmysql, the field order
must be exactly as follows:

username, cryptpw, clearpw, uid, gid, home, maildir, quota, fullname, options

You should avoid using "SELECT *", and explicitly enumerate your fields. You
do not need to pollute your table schema with unused fields, you can just
put a literal empty string in the SELECT field list, for the unused fields.



--=_mimegpg-commodore.email-scan.com-2650-1203034924-0001
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQBHtNssx9p3GYHlUOIRAh8/AJ0Rut2fcSY9xcz6eBXdc7HEKrp/AgCfftjr
Xk+RcO8AHCQ4BtQvWIj1gHw=
=+ajK
-----END PGP SIGNATURE-----

--=_mimegpg-commodore.email-scan.com-2650-1203034924-0001--


--===============0981966954==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
--===============0981966954==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/.../courier-users

--===============0981966954==--