Hi Sam. Am Freitag, 15. Februar 2008 schrieb Sam Varshavchik: > > *************************** 1. row *************************** > > account: [EMAIL PROTECTED] > > 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
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 config simple. This view inserts empty fields on-the-fly, they are not stored anywhere. cu, Bernd -- Homer Simpson an der Bank: Mein Name ist Mr. Burns. Lautsprecher: Und wie ist ihr Vorname? Homer: Das hab ich vergessen!
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------- 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/
_______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
