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
