On 7/12/05, Gleb Paharenko wrote: > auto_parser wrote: >> >> Would you be able to forward the following message to the mysql list. I >> keep getting bounce-backs with the following: >> >> Recipient: <mysql@lists.mysql.com> >> Reason: Mail from HELO priv-edtnes27.telusplanet.net rejected >> because it does not accept bounces. This violates RFC 821/2505/2821 >> http://www.rfc-ignorant.org/ >> >> After contacting rfc-ignorant.org, they assured me it is a mistake in >> the way mysql is implementing the RFC protocol, and that I'm not on any >> black lists.
The problem is not a blacklist. The problem is that priv-edtnes27.telusplanet.net resolves to a RFC 1918 address. Your message does not make clear which MTA gives this error, but if it is MySQL they are right to reject it. And if it isn't MySQL, you are barking up the wrong tree. >> As I can't contact the list, I can't resolve the issue. Sure you can: fix your DNS & mail setup. Public facing DNS servers should not advertise RFC 1918 addresses. MUAs/MTAs should use the correct hostname in the HELO. >> I have a request table, from which I'm pulling all records. Each >> request record has a part number, and for each requested part number, >> I'd like to query the inventory table for all matching inventory items >> for that part number, and calculate the potential value of the >> inventory. Each inventory record has 4 price fields, and it is the >> HIGHEST value of these fields used in the calculation. As you can tell >> by running the query, it is incredibly expensive. We have potentially >> millions of inventory records and 10,000+ requests, so the query is >> going to take several minutes to complete. Can you show the EXPLAIN output? Which version are you using? Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]