freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153"
- 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
-
[freetds] osql: warning: no DNS hostname found for "192.168.10.153",
Jochen Daum, 01/14/2013
-
Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153",
Frediano Ziglio, 01/14/2013
- Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153", Jochen Daum, 01/14/2013
-
Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153",
Tony Esposito, 01/15/2013
- Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153", James K. Lowden, 01/15/2013
-
Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153",
James K. Lowden, 01/14/2013
- Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153", Jochen Daum, 01/15/2013
-
Re: [freetds] osql: warning: no DNS hostname found for "192.168.10.153",
Frediano Ziglio, 01/14/2013
Archive powered by MHonArc 2.6.24.