Hi all,
I am setting up a fresh courier install on a gentoo box.
I'm finding that I'm getting "450 service temporarily unavailable"
whenever I try to send mail to the local domain. Evidently this is
because something is amiss with the authmysql back end (I am using
'authpam authmysql' in authdaemon). Running authenumerate returns only
the authpam entries, and none from my mysql table.
Now, I've turned on logging in mysql, and apparently authdaemon is making
a database connection, but not sending any query at all. What gives?
I believe the problem is related to using the custom queries, which I am
employing. According to the comments in the authmysqlrc, specifying
these queries should override all of the earlier individual table/column-
related settings in the file. Indeed, if I comment out the
MYSQL_*_CLAUSE lines and fill out valid details in the preceding table/
column lines, authdaemon makes queries to mysql and authenumerate returns
results.
My conclusion is that something is broken with custom queries. I realise
the comments say "(EXPERIMENTAL)", but the text goes on to suggest that
they at least KIND OF work. What is the real deal here? Are they known
to NOT work at all?
For reference my config lines are as follows:
MYSQL_SELECT_CLAUSE SELECT mailboxes.account, mailboxes.cryptpass,
mailboxes.clearpass AS clearpw, usersites.uid, usersites.uid AS gid,
CONCAT('/home/',usersites.user) AS home,
IF('$(service)'='courier',mailboxes.defaultdelivery,mailboxes.maildir) AS
defaultdelivery_maildir, NULL AS quota, mailboxes.name, '' AS options
FROM mailboxes LEFT JOIN usersites ON mailboxes.user=usersites.user WHERE
mailboxes.account='$(local_part)@$(domain)'
MYSQL_ENUMERATE_CLAUSE SELECT mailboxes.account, usersites.uid,
usersites.uid AS gid, CONCAT('/home/',usersites.user) AS home,
mailboxes.maildir FROM mailboxes LEFT JOIN usersites ON
mailboxes.user=usersites.user
MYSQL_CHPASS_CLAUSE UPDATE mailboxes SET clearpass='$(newpass)',
cryptpass='$(newpass_crypt)' WHERE account='$(local_port)@$(domain)'
Help appreciated.
Thanks,
-ben
--
Ben Kennedy, chief magician
zygoat creative technical services
613-228-3392 | 1-866-466-4628
http://www.zygoat.ca
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
