RE: back-sql with PostgreSQL on FreeBSD

["Pierangelo Masarati" <ando@sys-net.it>]

>
> Here is stack backtrace I obtained following guideline in the link you
> sent me.

Perhaps you didn't follow it as carefully as you should :),
because you used a stripped binary; you should try with
a non-stripped binary compiled with -g.  Anyway, ths is
enough to see that the error occurs inside unixODBC
during backend startup.

>
> #0  0x283cb70f in sendto () from /lib/libc.so.5
> No symbol table info available.
> #1  0x2836af41 in _sendto () from /usr/lib/libc_r.so.5
> No symbol table info available.
> #2  0x28418f34 in send () from /lib/libc.so.5
> No symbol table info available.
> #3  0x28657b0b in SOCK_flush_output () from
> /usr/local/lib/libodbcpsql.so
> No symbol table info available.
> #4  0x286573e8 in SOCK_Destructor () from
> /usr/local/lib/libodbcpsql.so
> No symbol table info available.
> #5  0x28640045 in CC_cleanup () from /usr/local/lib/libodbcpsql.so No
> symbol table info available.
> #6  0x2863faa6 in SQLDisconnect () from /usr/local/lib/libodbcpsql.so No
> symbol table info available.
> #7  0x2818c7b5 in SQLDisconnect () from /usr/local/lib/libodbc.so.1 No
> symbol table info available.
> #8  0x080b6396 in backsql_close_db_conn ()
> No symbol table info available.
> #9  0x080b6ee8 in backsql_free_db_conn ()
> No symbol table info available.
> #10 0x080aea26 in backsql_db_open ()
> No symbol table info available.
> #11 0x08065f90 in backend_startup ()
> No symbol table info available.
> #12 0x0807ccfb in slap_startup ()
> No symbol table info available.
> #13 0x0804e9c3 in main ()
> No symbol table info available.
> #14 0x0804df22 in _start ()
> No symbol table info available.

I think you should definitely try some other odbc library, or at least
another version.  I wouln't go into detail debugging it, unless anyone
with more experience in odbc internals can tell me if the call sequence in
back-sql is correct.

p.

-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it