I just ran into something similar (with respect to DNS) yesterday. We host our sites in-house, but the DNS was hosted elsewhere. Their DNS servers went down yesterday morning. As a result, any page that ran a query using a SQL Server Datasource (where the server was specified in the CF admin as an IP address) failed with a connection timeout to the database.
After doing some rooting around and asking a few people, we discovered that the DB driver does a reverse DNS lookup when establishing a connection. Since the DNS servers were down, the lookup failed and the connection timed out -- even though the IP address specified for the SQL Server was an internal/non-public address! The solution was to put an entry in the "hosts" file on the CF server for our SQL Server, and then change the DSN in the CF admin to use the hostname instead of the IP address. (our hosts file was in WINNT\System32\drivers\etc\) Really, really bizarre if you ask me. But things have worked fine since we added the "Hosts" entry -- even when we purposely blanked out the DNS servers from the NIC settings of the server. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Purtell Sent: Wednesday, May 12, 2004 9:42 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Yipes - CF server inaccessible Except that, when I log into the CF administrator on that server, I'm using a local IP address. But I'll check the DNS again just so I can cover all the bases. Keith Purtell, Web/Network Administrator VantageMed Corporation (Kansas City office) CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jason Nokes Sent: Wednesday, May 12, 2004 9:12 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Yipes - CF server inaccessible Have you checked to see if your internal DNS server is up and running? Sounds like it is something else besides your web box. Jason Nokes, Director of Internet Development DistributorCentral, LLC UPIC: DC 888-516-7401 http://www.distributorcentral.com [EMAIL PROTECTED] Find out why more Distributors are using DistributorCentral than ASI or SAGE! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Purtell Sent: Wednesday, May 12, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Yipes - CF server inaccessible Importance: High We had an overnight power failure and now our CF5 intranet is inaccessible no matter what. When I go into our server room and log in I can't reach the administrative page, and just get "cannot find server" IE errors. (But I can reach the IIS admin web page; IIS is running fine.) All CF and WWW services are up and running. Can browse to the Web from this machine, so I know our connection to the outside world is OK. Nothing specific in the event logs. Tried rebooting the machine several times. Management is already asking when it will be fixed. I've never had this happen before. Any tips! Keith Purtell, Web/Network Administrator VantageMed Corporation (Kansas City office) Voice: (816) 801-5200 Fax: (816) 880-4776 (800) 525-1101 CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
