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
