[unixODBC-support] Progress and unixODBC

Derrick fogle derrick at foundationcomputing.com
Wed Oct 20 20:54:10 BST 2004


On Oct 13, 2004, at 2:22 PM, Nick Gorham wrote:

> Use strace and send me the log I may beable to help (or then again 
> maybe not...)
> strace isql dsn 2>st.log

OK, I'm pretty flummoxed at this point. Here's my strace log:

Start output of strace file
---------------------------------------------------------------------

execve("/usr/bin/isql", ["isql", "-v", "rcms", "sysprogress", "lodac"], 
[/* 27 vars */]) = 0
uname({sys="Linux", node="train.wilsonsfitness.com", ...}) = 0
brk(0)                                  = 0x804c62c
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, 
-1, 0) = 0x40017000
open("/etc/ld.so.preload", O_RDONLY)    = -1 ENOENT (No such file or 
directory)
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=87802, ...}) = 0
old_mmap(NULL, 87802, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40018000
close(3)                                = 0
open("/usr/lib/libodbc.so.1", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320f\0"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=362673, ...}) = 0
old_mmap(NULL, 344184, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x4002e000
mprotect(0x40080000, 8312, PROT_NONE)   = 0
old_mmap(0x40080000, 12288, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED, 3, 0x51000) = 0x40080000
close(3)                                = 0
open("/usr/lib/libodbcinst.so.1", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0P.\0\000"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=76149, ...}) = 0
old_mmap(NULL, 56664, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x40083000
mprotect(0x40090000, 3416, PROT_NONE)   = 0
old_mmap(0x40090000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 
3, 0xc000) = 0x40090000
close(3)                                = 0
open("/lib/libdl.so.2", O_RDONLY)       = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0P\36\0\000"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=66041, ...}) = 0
old_mmap(NULL, 12756, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x40091000
mprotect(0x40094000, 468, PROT_NONE)    = 0
old_mmap(0x40094000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 
3, 0x2000) = 0x40094000
close(3)                                = 0
open("/usr/lib/libreadline.so.4", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p\244\0"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=182185, ...}) = 0
old_mmap(NULL, 155056, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x40095000
mprotect(0x400b6000, 19888, PROT_NONE)  = 0
old_mmap(0x400b6000, 20480, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED, 3, 0x20000) = 0x400b6000
close(3)                                = 0
open("/usr/lib/libncurses.so.5", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\260\342"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=252412, ...}) = 0
old_mmap(NULL, 264352, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x400bb000
mprotect(0x400f0000, 47264, PROT_NONE)  = 0
old_mmap(0x400f0000, 36864, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED, 3, 0x34000) = 0x400f0000
old_mmap(0x400f9000, 10400, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x400f9000
close(3)                                = 0
open("/lib/i686/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0`P\0\000"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=532444, ...}) = 0
old_mmap(NULL, 199904, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x400fc000
mprotect(0x40109000, 146656, PROT_NONE) = 0
old_mmap(0x40109000, 16384, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED, 3, 0xc000) = 0x40109000
old_mmap(0x4010d000, 130272, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4010d000
close(3)                                = 0
open("/lib/i686/libc.so.6", O_RDONLY)   = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\240\307"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=5792768, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, 
-1, 0) = 0x4012d000
old_mmap(NULL, 1293800, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x4012e000
mprotect(0x40261000, 36328, PROT_NONE)  = 0
old_mmap(0x40261000, 20480, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED, 3, 0x132000) = 0x40261000
old_mmap(0x40266000, 15848, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40266000
close(3)                                = 0
munmap(0x40018000, 87802)               = 0
modify_ldt(0x1, 0xbffed65c, 0x10)       = 0
getpid()                                = 7111
rt_sigaction(SIGRT_0, {0x40105580, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x40104880, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_2, {0x401055d0, [], 0x4000000}, NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [32], NULL, 8) = 0
_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0xbffed30c, 35, (nil), 0}) = 0
brk(0)                                  = 0x804c62c
brk(0x804c65c)                          = 0x804c65c
brk(0x804d000)                          = 0x804d000
brk(0x804f000)                          = 0x804f000
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40018000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
brk(0x8050000)                          = 0x8050000
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40018000, 4096)                = 0
getpid()                                = 7111
access("/etc/odbc.ini", F_OK)           = 0
stat64("/etc/odbc.ini", {st_mode=S_IFREG|0777, st_size=518, ...}) = 0
semget(2030289015, 1, IPC_CREAT|IPC_EXCL|0x1b6|0666) = -1 EEXIST (File 
exists)
semget(2030289015, 1, IPC_CREAT|0x1b6|0666) = 229383
shmget(2030289015, 404, IPC_CREAT|IPC_EXCL|0x1b6|0666) = -1 EEXIST 
(File exists)
shmget(2030289015, 404, 0x1b6|0666)     = 60948501
shmat(60948501, 0, 0)                   = 0x40018000
semop(229383, 0xbffea920, 2)            = 0
semop(229383, 0xbffea920, 1)            = 0
semop(229383, 0xbffead50, 2)            = 0
semop(229383, 0xbffead50, 1)            = 0
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40019000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40019000, 4096)                = 0
semop(229383, 0xbffeae20, 2)            = 0
semop(229383, 0xbffeae20, 1)            = 0
getuid32()                              = 0
socket(PF_UNIX, SOCK_STREAM, 0)         = 3
connect(3, {sin_family=AF_UNIX, path="/var/run/.nscd_socket"}, 110) = 
-1 ENOENT (No such file or directory)
close(3)                                = 0
open("/etc/nsswitch.conf", O_RDONLY)    = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=1750, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40019000
read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1750
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40019000, 4096)                = 0
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=87802, ...}) = 0
old_mmap(NULL, 87802, PROT_READ, MAP_PRIVATE, 3, 0) = 0x4026a000
close(3)                                = 0
open("/lib/libnss_files.so.2", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200 \0"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=262328, ...}) = 0
old_mmap(NULL, 42600, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x40019000
mprotect(0x40023000, 1640, PROT_NONE)   = 0
old_mmap(0x40023000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 
3, 0x9000) = 0x40023000
close(3)                                = 0
munmap(0x4026a000, 87802)               = 0
open("/etc/passwd", O_RDONLY)           = 3
fcntl64(0x3, 0x1, 0, 0x1)               = 0
fcntl64(0x3, 0x2, 0x1, 0x2)             = 0
fstat64(3, {st_mode=S_IFREG|0644, st_size=1884, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1884
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/root/.odbc.ini", O_RDONLY)       = 3
close(3)                                = 0
open("/root/.odbc.ini", O_RDONLY)       = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
close(3)                                = 0
open("/etc/odbc.ini", O_RDONLY)         = 3
fstat64(3, {st_mode=S_IFREG|0777, st_size=518, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "[ODBC Data Sources]\nrcms=Progres"..., 4096) = 518
brk(0x8051000)                          = 0x8051000
brk(0x8052000)                          = 0x8052000
brk(0x8053000)                          = 0x8053000
brk(0x8054000)                          = 0x8054000
brk(0x8055000)                          = 0x8055000
brk(0x8056000)                          = 0x8056000
brk(0x8057000)                          = 0x8057000
brk(0x8058000)                          = 0x8058000
brk(0x8059000)                          = 0x8059000
brk(0x805a000)                          = 0x805a000
brk(0x805b000)                          = 0x805b000
brk(0x805c000)                          = 0x805c000
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/etc/odbcinst.ini", O_RDONLY)     = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=432, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
read(3, "# Example driver definitinions\n#"..., 4096) = 432
read(3, "", 4096)                       = 0
close(3)                                = 0
munmap(0x40024000, 4096)                = 0
open("/usr/dlc/odbc/lib/pgpro915.so", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0@\341\0"..., 
1024) = 1024
fstat64(3, {st_mode=S_IFREG|0777, st_size=322140, ...}) = 0
old_mmap(NULL, 256172, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 
0x4026a000
mprotect(0x402a3000, 22700, PROT_NONE)  = 0
old_mmap(0x402a3000, 24576, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED, 3, 0x38000) = 0x402a3000
close(3)                                = 0
open("/etc/ld.so.cache", O_RDONLY)      = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=87802, ...}) = 0
old_mmap(NULL, 87802, PROT_READ, MAP_PRIVATE, 3, 0) = 0x402a9000
close(3)                                = 0
open("/lib/mmx/libpgmfront.so", O_RDONLY) = -1 ENOENT (No such file or 
directory)
stat64("/lib/mmx", 0xbffe9150)          = -1 ENOENT (No such file or 
directory)
open("/lib/libpgmfront.so", O_RDONLY)   = -1 ENOENT (No such file or 
directory)
stat64("/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/mmx/libpgmfront.so", O_RDONLY) = -1 ENOENT (No such file 
or directory)
stat64("/usr/lib/mmx", 0xbffe9150)      = -1 ENOENT (No such file or 
directory)
open("/usr/lib/libpgmfront.so", O_RDONLY) = -1 ENOENT (No such file or 
directory)
stat64("/usr/lib", {st_mode=S_IFDIR|0755, st_size=57344, ...}) = 0
munmap(0x402a9000, 87802)               = 0
munmap(0x4026a000, 256172)              = 0
fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 6), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 
0) = 0x40024000
write(1, "[unixODBC][Driver Manager]Can\'t "..., 149) = 149
write(2, "[ISQL]ERROR: Could not SQLConnec"..., 34[ISQL]ERROR: Could 
not SQLConnect
) = 34
semop(229383, 0xbffeae80, 2)            = 0
semop(229383, 0xbffeae80, 1)            = 0
shmdt(0x40018000)                       = 0
munmap(0x40024000, 4096)                = 0
_exit(1)                                = ?

------------------------------------------------------------
End output of strace file


There is no mmx directory on this system, and the libpgmfront.so file 
is in the same place as the pgpro915.so file that it does seem to be 
able to open up:

 > open("/usr/dlc/odbc/lib/pgpro915.so", O_RDONLY) = 3

Any help you could give would sure help :-)


-Derrick




More information about the unixODBC-support mailing list