Skip to Content.
Sympa Menu

freetds - Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153"

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153"
  • Date: Tue, 15 Jan 2013 00:19:42 +0000

2013/1/14 Jochen Daum <jd AT automatem.co.nz>:
> Hi,
>
> I had to reinstall freetds and compiled it from the latest on
> gitorius, 0.91 branch
>
> When I do:
>
> TDSDUMPCONFIG=stderr TDSDUMP=stderr osql -S Freshco -U sa -P pass, I get:
>
> checking shared odbc libraries linked to isql for default directories...
> strings: '': No such file
> trying /tmp/sql ... no
> trying /tmp/sql ... no
> trying /etc ... OK
> checking odbc.ini files
> cannot read "/home/jochen/.odbc.ini"
> reading /etc/odbc.ini
> [Freshco] found in /etc/odbc.ini
> found this section:
> [Freshco]
> Driver=FreeTDS
> ServerName=freshco
> Database=ExportInformationSystem
> Port=1433
> tds_version=7.1
> looking for driver for DSN [Freshco] in /etc/odbc.ini
> found driver line: " Driver=FreeTDS"
> driver "FreeTDS" found for [Freshco] in odbc.ini
> found driver named "FreeTDS"
> "FreeTDS" is not an executable file
> looking for entry named [FreeTDS] in /etc/odbcinst.ini
> found driver line: " Driver = /usr/local/lib/libtdsodbc.so"
> found driver /usr/local/lib/libtdsodbc.so for [FreeTDS] in odbcinst.ini
> /usr/local/lib/libtdsodbc.so is an executable file
> Using ODBC-Combined strategy
> DSN [Freshco] has servername "freshco" (from /etc/odbc.ini)
> cannot read "/home/jochen/.freetds.conf"
> /usr/local/etc/freetds.conf is a readable file
> looking for [freshco] in /usr/local/etc/freetds.conf
> found this section:
> [freshco]
> host = 192.168.10.153
> ;host = vm
> port = 1433
> tds version = 7.1
> looking up hostname for ip address 192.168.10.153
> osql: warning: no DNS hostname found for "192.168.10.153"
> Usage: host [-aCdlriTwv] [-c class] [-N ndots] [-t type] [-W time]
> [-R number] [-m flag] hostname [server]
>
>
> I have also added
> 192.168.10.153 vm
> to /etc/hosts, but it cannot be resolved either
>
> Any idea, why I can't use an IP address here?
>

FreeTDS have no problem with ip here. Unless you need Kerberos I see
no problems.

> P.S: When there is no space either side of the = on the host line, I
> get "no host line found"
>

Writing portable shell scripts is REALLY hard! James wrote it using
awk which personally I never didn't learn that much (perhaps cause I
learned Perl too early :) )

> Kind Regards,
>
> Jochen

I see no bad configuration, we'll try to fix the problems but you can use it.
Next step is isql (or whatever your DM use).

Regards,
Frediano




Archive powered by MHonArc 2.6.24.

Top of Page