FreeTDS Development Group

[Tony Esposito <Tony.Esposito AT region10.org>]

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: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] 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 <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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
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