There's a comment explainig hot to to this in authpgsql ... but, to
avoid bigger problems .. I am connecting to 127.0.0.1 ....
extracted from authpgsql
# To connect to a socket, delete PGSQL_HOST, and put the socket filename
# into PGSQL_PORT
I didn't tested it yet ....
if you make authpgsql work, please contact me ...
Thanks
[]'s
On Sun, 2002-01-06 at 03:31, Peter C. Norton wrote:
> The only advice I can offer is that I couldn't figure out how to get
> authdaemon to use the local socket, and had to have postgres listening on
> localhost. Have you tried doing that?
>
> -Peter
>
> On Sun, Jan 06, 2002 at 02:55:55AM -0200, [EMAIL PROTECTED] wrote:
> > Hi to all,
> >
> > I'm trying to put courier to work with PostgreSQL authentication ... but .. I got
>"LOGIN FAILED" message ... :o/..
> >
> > I configured authdaemon to use authpgsql, configured authpgsqlrc, created user and
>database for it, and executed this sql to create it's table :
> >
> > create table passwd (
> > id varchar(128) not null unique,
> > crypt char(128) not null,
> > name varchar(128) null,
> > uid int4 default '1' not null,
> > gid int4 default '1' not null,
> > home char(255) default '/home/mail' not null,
> > quota char(255) null);
> > and inserted a record using this line :
> >
> > insert into passwd values('[EMAIL PROTECTED]','XXXXXXX','Theo Cabrerizo Diem'
> > ,'1','1','/home/mail/diem.home/diem',null);
> >
> > Where XXXXXXX is the output of userdbpw with my password.
> >
> > First of all, I didn't found how can I debug why courier gave me login failed ...
>I've set debug level to 9 in postgres conf .. and the query that courier is executing
>is :
> > Jan 6 02:06:02 zion postgres[1975]: [12] DEBUG: query: SELECT id, '', crypt,
>uid, gid, home, '', '', name FROM passwd WHERE id = '[EMAIL PROTECTED]'
> >
> > If I set authdaemon to use authuserdb instead of authpgsql, and create a userdb
>file with same args used on postgres, everthing works :o/
> >
> > Did I make any mistakes ? .... please help ....
> >
> > please reply me to [EMAIL PROTECTED] too .. because my account dedicated to courier
>mailing list have 1198 messages .. :o) <need to delete them>
> >
> > Thanks !!!!
> >
> > []'s
> >
> > Theo Cabrerizo Diem
> >
> > _______________________________________________
> > courier-users mailing list
> > [EMAIL PROTECTED]
> > Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
>
> --
> 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
