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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
