I found the solution myself. My own mistake, of course.

I misunderstood the difference between "local domains" and "locally hosted" domains and had domain2.com (from my example below) set as a local domain, instead of a locally hosted one. I appologise if anyone burned any time unnecessarily on this problem. Things seem to work as they should now.

Joseph Pry wrote:

I'm new to the list. Please forgive me if I make a mistake.

I'm currently running Courier-MTA 0.45.4 under Gentoo Linux. I discovered, while setting Courier up to use the MySQL authentication daemon that users are not being found correctly in the database. I know I have the database connection right, and the table is correct, because I can authenticate users who belong to the same domain as the "default domain" in the MySQL settings. Users in other domains, however, don't work. Eg:

Hosted domains: domain1.com, domain2.com
DEFAULT_DOMAIN (in authmysqlrc) is domain1.com

[EMAIL PROTECTED] and [EMAIL PROTECTED] are users in the database

[EMAIL PROTECTED] works fine (250 Ok.)
[EMAIL PROTECTED] returns 550 User unknown.
[EMAIL PROTECTED] also works, though doesn't exist in the database

Naturally, any normal local user on the machine is valid for all domains.

What I'm trying to determine is if this is a known issue, and if it is fixed in 0.45.5 or not. Gentoo doesn't have an ebuild for 0.45.5 yet, and I want to make sure I don't waste my time trying to build 0.45.5 by hand (since Gentoo puts EVERYTHING in non-default places).

I haven't tried with Postgres yet but if I have no choice I suppose I can go that route. LDAP isn't an option, I'm not clued-in enough on that to make it work.

It LOOKS like the smtp daemon is only passing the user portion of the [EMAIL PROTECTED] string, instead of the whole thing, so the authmysql daemon adds @domain1.com and then does its checking. But I could be way off.

Thanks ahead of time for any help anyone can provide!

    Joseph Pry




-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Reply via email to