Re: [courier-users] IMAP proxy

--===============0678674776==
Content-Type: multipart/signed; boundary="nextPart1233071.4uWZrOGDg0";
protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart1233071.4uWZrOGDg0
Content-Type: text/plain;
charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi Sam.

Am Freitag, 15. Februar 2008 schrieb Sam Varshavchik:
> > *************************** 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=3Dmilch.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

Tanks a lot, that seemed to be the problem.


> 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.

I created a database view to get my fields. That's just to keep courier con=
fig=20
simple.

This view inserts empty fields on-the-fly, they are not stored anywhere.

cu, Bernd

=2D-=20
Homer Simpson an der Bank: Mein Name ist Mr. Burns.
Lautsprecher: Und wie ist ihr Vorname?
Homer: Das hab ich vergessen!

--nextPart1233071.4uWZrOGDg0
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.7 (GNU/Linux)

iQIVAwUAR7U5QQ0b18vi86Q/AQL+FQ//WeJAsW45PeOSmUI3ZjuDUAwsv00tEm/h
CHlTtQLpNhr5huj2ftalaGAxAVvk8LQ3BousCkcTnZQk/xe45tgxYRl7HiemuNP0
o64otIkGZGPOdbvECKb+5QlvoJlWbmfYq3WQsM5y2F325dIzQr 9kufCk5AbuPyAb
n1nQlzwPiO+NVqh2V2ohZLd8u/E3htIKe3d7INkg+enEeZ/bmjLuai0rL9BFJ7dV
3UuTZiAK2pX84ndxE8XabekdqjUtlq5M0UTDUUCtZ3DLNxM84h QOIf+zm4wGPTbW
X+u8yJZAQs3+4qTgH+fN/eDptE7Nn7Ee0P/ADOVaPgosQxbjIFlL1IgFqGezci6n
j8TIPorv7Ktgu0tNB7z13aZNHpLxpLfoNFkcJ77VZJRSbGsZxO ydg30nTRi0Dp8U
JsHBiL3zfuibqSENJvAD4sNwg6kcCUTRgh3r4+T+baw0YlfQ1Z 80c/nUpvC3LhEF
49rLJHYdZMGDVqqH88YyYvbfOejoerklAofsYW/1IZEpPFsIn/KMNKTUIddIZ5bM
PjEEJfx5YFtw4rOEk0OAwnDp3USPZ67/64zZnXA8sFp4T9IS4H1uSSgMgupUaeXH
OPvvd9jsgvHYHhEbgUMlbqKKN2OFBIcCZzoGr8xG4o10csMawR wIjazDv9974yjq
otSUuofilP4=
=IIUV
-----END PGP SIGNATURE-----

--nextPart1233071.4uWZrOGDg0--


--===============0678674776==
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/
--===============0678674776==
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

--===============0678674776==--