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.