Peter - Awesome, I really appreciate it, with the change to varchars it works properly.
-- Tim ----- Original Message ----- From: "Peter C. Norton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 11:21 AM Subject: Re: [courier-users] authpgsql problems > This came up for someone else a few weeks ago. You need varchar and not > char types for postgresql, or else it apparently pads responses with spaces > (iirc). > > Sam, can you create a separate README.postgresql.html file that at least says: > > <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" > "http://www.w3.org/TR/html4/loose.dtd";> > <html> > <head> > <title>Courier PostgreSQL authentication module</title> > <meta name="MSSmartTagsPreventParsing" content="TRUE"> > </head> > > <body text="#000000" bgcolor="#FFFFFF" link="#0000EE" vlink="#551A8B" alink="#FF0000"> > <h1>Courier PostgreSQL authentication module</h1> > > <p>Please read the README.mysqlrc.html since almost all information there > applies to postgres as well, but with postgres change the schema to: > > <pre>CREATE TABLE passwd ( > id varchar(128) DEFAULT '' NOT NULL PRIMARY KEY, > crypt varchar(128) DEFAULT '' NOT NULL, > clear varchar(128) DEFAULT '' NOT NULL, > name varchar(128) DEFAULT '' NOT NULL, > uid int(10) unsigned DEFAULT '65534' NOT NULL, > gid int(10) unsigned DEFAULT '65534' NOT NULL, > home varchar(255) DEFAULT '' NOT NULL, > maildir varchar(255) DEFAULT '' NOT NULL, > quota varchar(255) DEFAULT '' NOT NULL, > );</pre> > > <p>There is a problem with postgresql and courier where postgres will return > character fields with padding. This will interfere with > courier/authdaemon's working properly. Using varchar instead prevents this. > > </body> > </html> > > > > > > > On Thu, Feb 28, 2002 at 11:52:49PM -0500, Tim Hunter wrote: > > courier=# \d passwd > > Table "passwd" > > Attribute | Type | Modifier > > -----------+----------------+------------------------ > > id | character(128) | not null default '' > > crypt | character(128) | not null default '' > > clear | character(128) | not null default '' > > name | character(128) | not null default '' > > uid | integer | not null default 65534 > > gid | integer | not null default 65534 > > home | character(255) | not null default '' > > maildir | character(255) | not null default '' > > quota | character(255) | not null default '' > > Index: id_id > > -- > The 5 year plan: > In five years we'll make up another plan. > Or just re-use this one. > > _______________________________________________ > courier-users mailing list > [EMAIL PROTECTED] > Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users > _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
