Hmm. Never heard of this. How could I test it, that is, to see what the remote_host ip would be?
Main Topics
Browse All TopicsWe have a dozen or so extra class c ip addresses. When using cffeed, we want to avoid excessive rss calls, possibly getting locked out for a day by anyone who thinks we're going over their rss feed limit per ip address.
We already cache all feeds for 60 minutes, a bit too long I think but we wanted to be safe. We plan on offering massive amounts of news via rss. So, we're trying to think ahead.
We can use different windows 2003 r2 servers, each running cf8 standard, rotating a separate cffeed code, using the same database. I know how to do this. They'd all be using different ips. But that would mean calling the same database on the same machine, I think, and we'd like to keep the sql 2000 servers set up as they are, running on local 127.0.0.1. And there's always that problem with the error, "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
So, this is why I'm first seeing if there is any way to, on the fly, force the random changing of the ip address, as seen by the server on the rsslink. I know this is a long shot but thought I'd take a stab.
If there is no way to force a different ip then maybe someone would like to help me solve the problem of using the same database across different boxes, each having their own sql server as local.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
To test I used this code at the top of the url I used in the cfhttp call but only got the server ip address.
So, looks like that won't work. Maybe I should forget this method and try the other idea I mentioned in my question, which is to just call a cffeed module from one of our other sql server which also has cf8 installed. That way I can use different ips.
But I'd need help from someone with the error "Not associated with a trusted SQL Server connection" part of my question, then I might be to award some points for this one. the other sql servers are set for local on 127.0.0.1. How can I login from a different machine so I can use just one database for all four sql servers?
When you have your SQL Server authentication set to "Windows Only", you may receive this error message. Your best bet is to create a user login within SQL server and create a datasource that points to that server using those newly-created login credentials. See this Microsoft KB for more information:
http://support.microsoft.c
Hi,
I can't figure out how that would work. remote_host CGI variable is set at the server end by the cgi processor routines by doing a reverse DNS on the client IP address. There is nothing that can be passed in the http request envelope that is likley to affect that result.
There is a report here \that confirms what I suspect: http://forums.adobe.com/th
It is possible (I suppose) that the cgi variables could be set when the client application is running on the same host as the server, in which case the web server environment of the destination would be accessible to the client....
In order to acheive what you want to do, you need to either change the way that cfhttp works or translate the source address at a firewall application under your control.
Changing the binding IP address of cfhttp can be done, but (my recollection suggests) that this requires a restart of the coldfusion application service, which is probably not what you want to do. Your best bet would be to use a router that can support scheduled configuration changes to translate the source address of your web server ona rotating basis through the selected IP addresses. Mikrotik RouterOS (www.mikrotik.com) is one system that can do that kind of thing relatively easily (and cheaply).
Cheers, Mike.
Business Accounts
Answer for Membership
by: Dain_AndersonPosted on 2009-08-25 at 09:25:25ID: 25179275
You can manually set the CGI.REMOTE_HOST variable to any IP value you want (see snippet), but this may not be the value read by those sites. Most sites will likely read CGI.REMOTE_ADDR, which cannot be modified in ColdFusion.
Select allOpen in new window