Jim Douglas writes:
From: Sam Varshavchik <[EMAIL PROTECTED]> To: [email protected] Subject: Re: [courier-users] login error Date: Mon, 02 Oct 2006 18:20:05 -0400Jim Douglas writes:This is from the log, it is definately a problem. How does this query get built? What should it return in the columns?Oct 2 11:41:58 cpe-22-22-222-222 authdaemond: SQL query: SELECT id, crypt, clear, uid, gid, home, "", "", name, "" FROM dbmail_users WHERE id = "foo"In my SASL smtp.conf I have SELECT passwd FROM dbmail_users WHERE userid = '%u' (Which authenticated successfully when I tested SASL on the server)What you have in SASL is completely irrelevant. Courier does not use SASL. README.authmysql.html explains, in detail, how MySQL needs to be set up.<< attach4 >>I am using dbmail and was thinking I could point to the dbmail database instead of creating a new one,
I have no knowledge of dbmail's schema. Courier-authlib's MYSQL support is documented in the README. You can try adapting authmysqlrc to dbmail's schema.
pgp7qUx7z0VJt.pgp
Description: PGP signature
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
