According to the rfc's domain name lookups are supposed to be case insensitive. Therefore mail delivery should be case insensitive as far as the part after the "@" sign is concerned. If the rfc's don't agree someone at IETF should be alerted to the discrepency.
Curtis On Wed, 3 Mar 2004, John Hansen wrote: > Ilja, > > If you wan't RFC'ism, you should put code in the software to do the > comparison, not in the SQL, mysql is not case sensitive,. So on mysql > dbmail would not conform to the RFC in this case. > > ... John > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Ilja Booij > Sent: Wednesday, March 03, 2004 10:05 PM > To: [email protected] > Subject: Re: [Dbmail] CAP domain results in "no such user" mail bounce > > In DBMail 1.2.3 the queries were all defined in the backend driver. In > DBMail 2.0, the backend driver has become much smaller and simpler, and > most functionality has been moved to db.c, which is in use by all (read: > > both) backends. > > Anyway, your suggestions should work. > > By the way, I don't think we should lowercase the mailboxes, as RFC 3501 > takes no position on case-sensitivity of mailbox names, except for > "INBOX", which should always be case insensitive. > > Case insensitivity is limited to aliases (including domain aliases) and > usernames, I guess. > > Ilja > > John Hansen wrote: > > > I'm confused,.... aren't the sql queries defined in each backend > driver? > > > > If not, > > lower(column)=lower("value%"), and > > lower(column) like lower("value%") > > > > should do the trick. > > > > ... John > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Ilja Booij > > Sent: Wednesday, March 03, 2004 8:47 PM > > To: [email protected] > > Subject: Re: [Dbmail] CAP domain results in "no such user" mail bounce > > > > We can't use ILIKE, as it's not supported by MySQL. It's also not a > > part of SQL92, is it? I'll look for a way around this. > > > > Ilja > > > > John Hansen wrote: > > > > > >>Probably a bug from being ported to postgres, as mysql is not case > >>sensitive, but postgresql is. > >> > >>As such, all comparisons in where clauses should be cast using lower() > > > > > >>on both sides of the comparison sign. Or in the case of LIKE, use > > > > ILIKE. > > > >>Regards, > >> > >>John > >> > >>-----Original Message----- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >>Behalf Of David > >>Sent: Tuesday, February 24, 2004 9:47 AM > >>To: [email protected] > >>Subject: [Dbmail] CAP domain results in "no such user" mail bounce > >> > >> > >>I noticed that when dbmail checks for a delivery point, if the domain > >>name does not match one listed in the aliases table case for case, it > >>will bounced the mail with "so such user". Has this comparison always > > > > > >>been case sensitive? For example, if [EMAIL PROTECTED] is in the aliases > > > > > >>table and then I get a mail address to [EMAIL PROTECTED], dbmail rejects > >>it. Actually it will reject anything not spelled exactly as > >>"example.com". This is the error message generated. > >> > >>dbmail/smtp[31935]: bounce.c,bounce: sending 'no such user' bounce for > > > > > >>destination [EMAIL PROTECTED] > >> > >>Is this a postfix problem, PostgreSQL problem, or a dbmail problem? > >> > >>__________________________________ > >>Do you Yahoo!? > >>Yahoo! Mail SpamGuard - Read only the mail you want. > >>http://antispam.yahoo.com/tools > >>_______________________________________________ > >>Dbmail mailing list > >>[email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail > >>_______________________________________________ > >>Dbmail mailing list > >>[email protected] > >>https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > _______________________________________________ > > Dbmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > _______________________________________________ > > Dbmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com
