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

Question related to this issue... Why is osql even bothering to do a reverse DNS lookup of an IP address?  If you do not use or have DNS this is going to fail yet it does not help me determine if my FreeTDS or ODBC is configured correctly.  Please explain the usefulness of this -- or at least make it a command-line option to enable or not..
Thanks.


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
Sent: Monday, January 14, 2013 6:20 PM
To: FreeTDS Development Group
Subject: Re: [freetds] 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
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2890 / Virus Database: 2637/6025 - Release Date: 01/11/13