7 messages in net.sourceforge.lists.courier-sqwebmailRe: [sqwebmail] unable to login using...
FromSent OnAttachments
Julian GrunnellJul 25, 2007 3:11 am 
Brian CandlerJul 25, 2007 12:40 pm 
Julian GrunnellJul 26, 2007 7:01 am 
Brian CandlerJul 26, 2007 7:28 am 
Brian CandlerJul 26, 2007 7:39 am 
Julian GrunnellJul 27, 2007 1:05 am 
Brian CandlerJul 27, 2007 4:32 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [sqwebmail] unable to login using mysql authenticationActions...
From:Brian Candler (B.Ca@pobox.com)
Date:Jul 26, 2007 7:39:54 am
List:net.sourceforge.lists.courier-sqwebmail

On Thu, Jul 26, 2007 at 03:02:14PM +0100, Julian Grunnell wrote:

Jul 26 14:45:41 wm01 authdaemond: SQL query: SELECT username, "", password, 8, 12, home, "", "", "", "" FROM mailboxes WHERE username = "foolsgold-rob" Jul 26 14:45:41 wm01 authdaemond: authmysql: sysusername=<null>, sysuserid=8, sysgroupid=12, homedir=/fs/home/37/f/o/foolsgold/users/rob, address=foolsgold-rob, fullname=<null>, maildir=<null>, quota=<null>, options=<null>

OK, so you've chosen uid 8, gid 12. So now you have normal Unix permissions to sort out.

You could try this:

chown -R 8:12 /fs/home/37/f/o/foolsgold/users/rob chmod 700 /fs/home/37/f/o/foolsgold/users/rob

The enclosing directories could be owned by root:root mode 755 (which allows everyone to wander down them), or could be owned by mail mode 700 (which keeps out other users, but allows courier to create directories higher up in the tree if mysql had wrong data in it).

Setting up a suitable permissions model is something you need to design, and it's part of normal Unix administration, not specific to courier.

Regards,

Brian.