Re: No Route To Host Issue

Jeff,

On Fri, Aug 15, 2003 at 09:24:25AM -0700, Jeff Hicks wrote:

> I am running freeTDS-0.61.2 with Apache-2.0.47, PHP-4.3.2, on a RH9
> server.  I am trying to do a simple test connection to the Sybase
> server listed in the freetds.conf.  It appears to be having some
> kind of issue with the IP address.

I'm new to the list, but also running RH9 and freetds-0.61-2.i386.rpm
against an MS SQL Server back end...

> Starting log file for FreeTDS 0.61.2 with debug level 99.
> 2003-08-14 23:27:07.787897 iconv will convert client-side data to the ""
> character set
> 2003-08-14 23:27:07.788750 Connecting addr 192.138.151.39 port 4444 with
> TDS version 5.0

> This is what I get in the Apache error_log:
> src/tds/login.c: tds_connect: 192.138.151.39:4444: No route to host

Per the advice in the FreeTDS Use Guide, you need to isolate this
rather more, I think. See http://www.freetds.org/support.  The link to
Chapter 7 of the User Guide on that page is broken, it should be to

  http://www.freetds.org/userguide/c2374.htm

Here are my suggested questions to work towards resolving this:

Q1. Can you telnet from the RH9 machine to that host on port 4444?

Q2. Can you use tsql to connect from RH9 to that SQL server?

Q3. Can you use SQSH to connect from RH9 to that SQL Server?

Q4. What are the contents of your /etc/freetds.conf file?

> After many hours of looking on the message boards I haven't come across
> anyone else having this issue.  Am I missing something simple here?

To me, this feels like a routing/firewalling issue, not a freetds one.

I hope this helps,

Jonathan
-- 
Jonathan Marsden <jonathan@xxxxxxxxxxxxxxx>
Making electronic communications reliable for Christian missions worldwide