Skip to Content.
Sympa Menu

freetds - Re: [freetds] tds7_get_instance_port timed out

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Gregor at HostGIS <gregor AT hostgis.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] tds7_get_instance_port timed out
  • Date: Sat, 20 Mar 2010 09:28:15 -0700

The connection string might be confusing PHP. Where I work we connect to SQL
server from Ubuntu and have configured all of our connection names in our
FreeTDS conf file.

Yeah, I tried that too ad got the same results:

Configure this:

[ec2test]
host = ec2-174-129-135-45.compute-1.amazonaws.com
port = 1433
tds version = 8.0
instance = SQLSERVER

Try this:

$db = mssql_connect('ec2test', 'user', 'pass');

Get this:

(net.c:836):tds7_get_instance_port(174.129.135.45, SQLSERVER)
(net.c:905):tds7_get_instance_port: timed out on try 0 of 16


My build instructions for our setup are here

Looks pretty standard, though in my case, I used PHP's --with-mssql flag when configuring, rather than building an extension. Given the issues I've had with other DB drivers having different defines that my own PHP, and generating symbol errors, I thought this the best route.

Can you explain what tds7_get_instance_port() does exactly, or how I'd trace out what TCP port it's trying to connect? Port 1433 is open but other ports are not, so if it's trying to connect to some other port for this specific instance it may be blocked there.

--
HostGIS, Open Source solutions for the global GIS community
Greg Allensworth - SysAdmin, Programmer, GIS Person, Security
Network+ Server+ A+ Security+ Linux+
PHP PostgreSQL MySQL DHTML/JavaScript/AJAX

"No one cares if you can back up — only if you can recover."




Archive powered by MHonArc 2.6.24.

Top of Page