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:28:26 am
List:net.sourceforge.lists.courier-sqwebmail

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

Hi - thanks Brian, much appreciated. And almost there now. The final part I believe I'm struggling with is the MYSQL_UID_FIELD & MYSQL_GUID_FIELD - what are these? I know the comment in the authmysqlrc file it says "numerical userid of the account" / "groupid of the account" but still doesn'y make sense - what account is it referring to?

Erm, the mail account, the mailbox, call it what you will.

If I login as user "fred", the database is used: 1. to validate that I have given the correct password for fred 2. to set the home directory to change to 3. to set the Unix uid and gid for the IMAP daemon to change to

So the IMAP daemon, when running as this particular uid/gid, must have sufficient privileges to read/write/create/delete files and directories within the maildir.

Typically, in a virtual mailbox system, all your users' mailboxes would be owned by the same uid. Let's say you created the subdirectories with owner 'mail' group 'mail'. Then the uid/gid would be the numeric values for 'mail' and 'mail' (from /etc/passwd and /etc/group respectively)

Jul 26 14:45:41 wm01 sqwebmaild: foolsgold-rob: chdir(/fs/home/37/f/o/foolsgold/users/rob) failed!! Jul 26 14:45:41 wm01 sqwebmaild: error: Permission denied

OK, so you need to do

ls -ld /fs/home/37/f/o/foolsgold/users/rob ls -ld /fs/home/37/f/o/foolsgold/users ls -ld /fs/home/37/f/o/foolsgold ...etc

to check the permissions of the directories and their enclosing directories.

[root@wm01 home]# cd /fs/home/37/f/o/foolsgold/users/rob [root@wm01 rob]# ls Maildir

Yes, but you appear to be running that as 'root', which bypasses most permission checks. Use 'su' to change to your chosen mail user, then try this again. You should get the same permission error.

So I'd say it's "failed!!" & getting "Permission denied" because the UID & GID paramaters I've set are wrong, but not sure what they should be.

They should be whatever user and group you have chosen for your mailboxes.

(You weren't planning to have the IMAP daemon access all users' mailboxes as 'root' now, were you? :-)

Brian.