I'm running a CF 11 multi-server setup on a Server 2012 R2 box with multiple websites that have their own IP addresses (multiple IP's). Even though each site has it's own IP address, I see all CF 11 instances using the same IP address to connect to Microsoft SQL server. Why is CF 11 behaving this way and is this configurable?
Billy, can you clarify if you understand that the connection to SQLServer from CF is defined in the CF Admin and its Datasources page? That’s where it’s configurable.
Yes Sir. Each CF instance has a data source that points to the same database server, but separate databases. It's really weird because it's not even using the default IP address of the server when the connections are made to the databases.
I guess it would be CF Java component making the JDBC or ODBC database connection, not the tomcat component that get's bound to your webserver sites. So I guess however Java is network binding is going to determine what TCP address the database connections are coming from.
It's like Coldfusion is just randomly picking one of the assigned IP addresses to use or its using the lowest IP address rather than using the default IP address of the Primary NIC.
I've used the "skipassource" trick to get our CF server's outbound traffic IP address to match the incoming IP address defined for the website in IIS - but all our websites use host headers and share one IP address, so probably not a solution for your situation.
I'm running a CF 11 multi-server setup on a Server 2012 R2 box with multiple websites that have their own IP addresses (multiple IP's). Even though each site has it's own IP address, I see all CF 11 instances using the same IP address to connect to Microsoft SQL server. Why is CF 11 behaving this way and is this configurable?
Thank you,
Billy
It's not clear, to me, where you are looking and seeing the IP address you are talking about. Are you using the SQL Server Management Studio to see which IP addresses are making connections to the SQL Server process?
I can see the IP address in SQL Management studio. You can also see the connections by running the "netstat -an" command from a command prompt. My main question is why does Coldfusion not use the default IP address on the server to make outgoing connections? It seems like its just picking one of my other IP address that I've got assigned to specific IIS web sites. It just so happens that it was using a IP address that we didn't need assigned on the server anymore, so I removed that IP address, restarted all the coldfusion services, and it used the next higher IP address.
I'm guessing it is using whatever IP address that DNS returns.
If you use ping or tracert (on the server that hosts the CF process) with the fully qualified server name (e.g. CfServer.ou.o, in other words, the directory services name, not the Web address) what IP address is displayed?
11
Replies
AdChoices