[unixODBC-support] Cannot find host with InterSystems Cache 5.0.20 driver

Casey Allen Shobe casey at shobe.info
Sun Oct 4 01:11:57 BST 2009


Hi,

I'm attempting to use an InterSystems Cache 5.0.20 x86_64 driver with
unixODBC.

I believe I have the INI files configured correctly - I've tried two
different driver configs (outlined below) with the exact same results.

I've verified the unixodbc installation is working by testing a PostgreSQL
installation, but when I try to connect to a Cache (4.1.3) server, using the
exact same parameters as on a Windows VM running on the same host (which
works), I get a "Host not found" error.

Here is my odbcinst.ini:

[Cache]
Driver                  =
/home/cshobe/cache-odbc-5.0.20.6305-linuxamd64/bin/libcacheodbc.so
FileUsage               = 1
DontDLClose             = 1
UsageCount              = 1

[InterSystems]
Description             = InterSystems Cache ODBC driver
UsageCount              = 1
Driver                  = /usr/lib/odbc/libcacheodbc.so
Setup                   = /usr/lib/odbc/libcacheodbc.so
SQLLevel                = 1
FileUsage               = 0
DriverODBCVer           = 02.10
ConnectFunctions        = YYN
APILevel                = 1
DEBUG                   = 1
CPTimeout               = <not pooled>


Here is my odbc.ini:

[AvatarPM]
Driver          = InterSystems
Protocol        = TCP
Host            = 10.233.93.9
Port            = 1972
Namespace       = AVATARPM
UID             = LIVE:CSHOBE
Password        = BLAHBLAH
Description     = AvatarPM Database
Query Timeout   = 0
Static Cursors  = 0

[AvatarPM2]
Driver          = Cache
Protocol        = TCP
Host            = 10.233.93.9
Port            = 1972
Namespace       = AVATARPM
UID             = LIVE:CSHOBE
Password        = BLAHBLAH
Description     = AvatarPM Database
Query Timeout   = 1
Static Cursors  = 0
Trace           = on
TraceFile       = /tmp/cachetrace.log


Here are the results with isql:

$ isql -v AvatarPM
[S1000][unixODBC][Caché ODBC][State : S1000][Native Code 11001]
[CacheODBC.so]
Socket: Host not found
[ISQL]ERROR: Could not SQLConnect

$ isql -v AvatarPM2
[S1000][unixODBC][Caché ODBC][State : S1000][Native Code 11001]
[CacheODBC.so]
Socket: Host not found
[ISQL]ERROR: Could not SQLConnect

Yet:

$ nmap -vvv -p 1972 10.233.93.9

Starting Nmap 4.62 ( http://nmap.org ) at 2009-10-03 20:11 EDT
Initiating Ping Scan at 20:11
Scanning 10.233.93.9 [1 port]
Completed Ping Scan at 20:11, 0.00s elapsed (1 total hosts)
Initiating Parallel DNS resolution of 1 host. at 20:11
Completed Parallel DNS resolution of 1 host. at 20:11, 0.03s elapsed
DNS resolution of 1 IPs took 0.03s. Mode: Async [#: 2, OK: 0, NX: 1, DR: 0,
SF: 0, TR: 1, CN: 0]
Initiating Connect Scan at 20:11
Scanning 10.233.93.9 [1 port]
Discovered open port 1972/tcp on 10.233.93.9
Completed Connect Scan at 20:11, 0.00s elapsed (1 total ports)
Host 10.233.93.9 appears to be up ... good.
Interesting ports on 10.233.93.9:
PORT     STATE SERVICE
1972/tcp open  unknown

...and as mentioned above a Windows XP VM running on this very same machine
can connect with the same ODBC settings without any problem.

Any ideas what the problem could be?

Cheers,
-- 
Casey Allen Shobe
casey at shobe.info
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20091003/debb1fc2/attachment.html>


More information about the unixODBC-support mailing list