Re: Problem with unixODBC and PostgreSQL

On 01/22/2015 08:35 AM, Julie Reier wrote:
> Hi. I am hoping that someone can advise me on an issue I am having with
> connecting to a postgresql DB via unixODBC.
>
> I am using an ubuntu VM to test the configuration. Here’s what I did:
>
>  1. Installed unixODBC
>  2. Installed odbc-postgresql
>  3. Configured odbc drivers and data sources.
>
> I am able to connect to the database via the psql command. However, osql
> is failing. Here’s the output:
>
> rnduser@rnduser-VirtualBox:~$ osql -S rndredshift6 -U readonly -P *******
>
> 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
>     reading /home/rnduser/.odbc.ini
> [rndredshift6] found in /home/rnduser/.odbc.ini
> found this section:
>     [rndredshift6]
>     Driver        = PostgreSQL
>     Description        = data source for rndredshift
>     Server        = 10.191.4.97
>     Port        = 5439
>     Database        = prod
>
> looking for driver for DSN [rndredshift6] in /home/rnduser/.odbc.ini
>    found driver line: "    Driver        = PostgreSQL"
>    driver "PostgreSQL" found for [rndredshift6] in .odbc.ini
> found driver named "PostgreSQL"
> "PostgreSQL" is not an executable file
> looking for entry named [PostgreSQL] in /etc/odbcinst.ini
>    found driver line: "    Driver        = /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so"
>    found driver /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so for [PostgreSQL] in odbcinst.ini
> /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so is an executable file
> "Server" found, not using freetds.conf
> Server is "10.191.4.97"
> looking up hostname for ip address 10.191.4.97
> osql: warning: no DNS hostname found for "10.191.4.97"
> Usage: host [-aCdlriTwv] [-c class] [-N ndots] [-t type] [-W time]
>              [-R number] [-m flag] hostname [server]
>         -a is equivalent to -v -t ANY
>         -c specifies query class for non-IN data
>         -C compares SOA records on authoritative nameservers
>         -d is equivalent to -v
>         -l lists all hosts in a domain, using AXFR
>         -i IP6.INT reverse lookups
>         -N changes the number of dots allowed before root lookup is done
>         -r disables recursive processing
>         -R specifies number of retries for UDP packets
>         -s a SERVFAIL response should stop query
>         -t specifies the query type
>         -T enables TCP/IP mode
>         -v enables verbose output
>         -w specifies to wait forever for a reply
>         -W specifies how long to wait for a reply
>         -4 use IPv4 query transport only
>         -6 use IPv6 query transport only
>         -m set memory debugging flag (trace|record|usage)
> osql: no IP address found for ""
> rnduser@rnduser-VirtualBox:~$
>
> Telnet to 10.191.4.97 on port 5439 works.
>
> Any ideas of what’s going on here?

looking up hostname for ip address 10.191.4.97
osql: warning: no DNS hostname found for "10.191.4.97"

Looks like osql is trying to do a reverse DNS lookup and fails to find a
hostname. Not sure why that is a problem, but this looks to be a FreeTDS
issue. You will probably find the answer faster here:

http://lists.ibiblio.org/mailman/listinfo/freetds

>
> Thanks,
>
> Julie
>
> *This email is intended only for the use of the individual(s) to whom it
> is addressed. If you have received this communication in error, please
> immediately notify the sender and delete the original email.*


--
Adrian Klaver
adrian.klaver@aklaver.com