-----Original Message-----
From: Brian Candler [mailto:B.Ca...@pobox.com]
Sent: 26 July 2007 15:40
To: Julian Grunnell
Cc: cour...@lists.sourceforge.net
Subject: Re: [sqwebmail] unable to login using mysql authentication
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,
Hi Brian - again, many thanks. Now I understand the UID / GID it makes
sense, as a quick test I amended these variables to be that of root and
bingo I logged in with access to the mailbox. The UID & GID of the current
and new servers refer to different system users. So I'll amend them to be
the same user throughout.
The next thing I've noticed is logging into the current system and using
"Create Message" gives me a drop down box of "From" addresses, eg.
rob@domain1, rob@domain2, rob@domain3 etc. And this ties up with a file
found in "/fs/home/37/f/o/foolsgold/users/rob/Maildir/domain_list.txt".
But logging in via the new server and creating a message I don't get this
drop down menu and the from address defaults to one of the addresses listed
in the file above.
I've had a google around and don't anything about "domain_list.txt" and am
wondering if this is something that the previous sys admin added in as a
feature or whether this is something else I need to tweak on the new server.
Julian.
7 messages in net.sourceforge.lists.courier-sqwebmailRe: [sqwebmail] unable to login using...
