Sorry if this message was sent 2 times ....
Hi !
I think I found the answer for this problem .... and maybe require a
modification in authpgsql code ....
I used char type to store passwords ... to avoid records swapping when
user changes it's passord to one with greater lenght of previous one ...
BUT .. in char type, the password is padded with spaces after data until
reaches the size of field ... and seems that authpgsql don't strip those
spaces ...
Unfornatuly I still didn't learned to code in C to submit a patch ...
but hope that this helps ...
Thanks to Peter C. Norton and Sam Varshavchik for help !!! :o)
[]'s
> On Sun, 2002-01-06 at 02:55, [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
> >
>
>
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
