Re: osql: warning: no DNS hostname found for "192.168.10.153"

2013/1/14 Jochen Daum <[email protected]>:
> 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