[x-posted to unixODBC list]
Is not possible in this combination since many version updates now.
I'd like to get current AND with a working configuration.
Working tunnel: ssh u...@the.pub.ip.add -q -f -N -L 1799:192.168.243.140:1433
(Yes, tsql works, no problems with the tunnel.)
Very simple perl script:
my $DSN="Server=127.0.0.1;Port=1799;Database=THEDB;UID=THEUSER;PWD=THEPWD";
my $dbh = DBI->connect("dbi:ODBC:$DSN",'THEUSER','THEPWD');
(And that's it. 'localhost' in the DSN makes no difference.)
strace ends like:
open("/usr/lib/gconv/CP1252.so", O_RDONLY) = 4
read(4,
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p\3\0\0004\0\0\0\320"..., 512)
= 512
fstat64(4, {st_mode=S_IFREG|0755, st_size=9400, ...}) = 0
mmap2(NULL, 12316, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 4, 0) =
0xb7b3d000
mmap2(0xb7b3f000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 4, 0x1) = 0xb7b3f000
close(4) = 0
mprotect(0xb7b3f000, 4096, PROT_READ) = 0
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV +++
Following this guide:
http://www.freetds.org/userguide/odbcinionly.htm
"An ODBC-only configuration relies solely on odbc.ini for server properties."
[This is what is expected, then, right?]
Checking with this:
strace perl odbctest.pl 2>&1 |grep odbc
execve("/usr/bin/perl", ["perl", "odbctest.pl"], [/* 47 vars */]) = 0
open("odbctest.pl", O_RDONLY|O_LARGEFILE) = 3
open("/usr/lib/libodbc.so.1", O_RDONLY) = 3
open("/etc/unixODBC/odbcinst.ini", O_RDONLY) = 3
access("/etc/unixODBC/odbc.ini", F_OK) = 0
stat64("/etc/unixODBC/odbc.ini", {st_mode=S_IFREG|0644, st_size=365, ...}) = 0
open("/etc/unixODBC/odbcinst.ini", O_RDONLY) = 3
Why is it trying to open odbcinst.ini, then?
Something changed with unixODBC version > 2.2.11 which caused this, as
reverting to that old version is all that's required to get working again.
Help?
Cheers,
--
|\ /| | | ~ ~
| \/ | |---| `|` ?
| |ichael | |iggins \^ /
michael.higgins[at]evolone[dot]org
