Then according to all the books that I've read, domain/host names are not supposed to be case sensitive.
http://www.yahoo.com = HTTP://WWW.YAHOO.COM for example: [EMAIL PROTECTED] curtis]$ host -t mx MAINELINESYS.COM MAINELINESYS.COM mail is handled by 5 mail.MAINELINESYS.COM. [EMAIL PROTECTED] curtis]$ host -t mx mainelinesys.com mainelinesys.com mail is handled by 5 mail.mainelinesys.com. [EMAIL PROTECTED] curtis]$ host MAIL.MAINELINESYS.COM MAIL.MAINELINESYS.COM has address 216.204.154.12 [EMAIL PROTECTED] curtis]$ host mail.MAINELINESYS.COM mail.MAINELINESYS.COM has address 216.204.154.12 [EMAIL PROTECTED] curtis]$ host mail.mainelinesys.com mail.mainelinesys.com has address 216.204.154.12 dbmail shouldn't care about the case sensitivity of the host/domain name if it wants to comply with the rfc's. usernames are at the pleasure of the developer. On *nix systems that use straight user acounts, usernames are case sensitive: [EMAIL PROTECTED] <> [EMAIL PROTECTED] However, [EMAIL PROTECTED] = [EMAIL PROTECTED] even on a *nix system. On systems that don't use *nix shell accounts, the username case sensitivity is up to the developer. Exchange Server (I only use it as an example, I'm not endorsing it.) doesn't care on the username side. Curtis On Wed, 3 Mar 2004, Ilja Booij wrote: > I've changed it to be case-insensitive in the case of name (username, > alias). As far as I see, there's no disagreement between the rfc's. > > Ilja > > Curtis Maurand wrote: > > > 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 > >> > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com
