Thread: Three posts and no response 8--(

I know there must be somebody out there who can help me this,I need help
with getting psqlodbc working on Solaris 2.6..when I try to run the .so
file I get the following error:

/opt/ISLIodbc/2.11/bin/qetestlib: fatal: relocation error: file
/usr/local/pgsql/lib/libpsqlodbc.so: symbol shutdown: referenced symbol
not found 

And when I run ldd -r I get the following:
> ldd -r /usr/local/pgsql/lib/libpsqlodbc.so
warning: ldd: /usr/local/pgsql/lib/libpsqlodbc.so: is not executable       symbol not found: __ctype
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strlen
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strncmp
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: malloc
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: memset
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strcpy
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strcat
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strtok
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: free
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strstr
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: atoi
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: sprintf
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: realloc
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strcmp
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: tolower
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: .div
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strdup
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strncpy
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: time
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: .umul
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: localtime
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: sscanf
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strncasecmp
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: atof
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: atol
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: memcpy
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strchr
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strcasecmp
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: pow
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: getuid
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: getpwuid
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: getpid
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: fopen
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: setbuf
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: vfprintf
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: .rem
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: strrchr
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: shutdown
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: close
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: inet_addr
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: gethostbyname
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: socket
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: connect
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: send
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: recv
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: fclose
(/usr/local/pgsql/lib/libpsqlodbc.so)       symbol not found: fgets
(/usr/local/pgsql/lib/libpsqlodbc.so)

Does anybody have any ideas?? TIA, Daren 

Daren Sefcik <daren@partnersdata.com> writes:
> I know there must be somebody out there who can help me this,I need help
> with getting psqlodbc working on Solaris 2.6..when I try to run the .so
> file I get the following error:

> /opt/ISLIodbc/2.11/bin/qetestlib: fatal: relocation error: file
> /usr/local/pgsql/lib/libpsqlodbc.so: symbol shutdown: referenced symbol
> not found 

This looks like libpsqlodbc.so hasn't been linked to libc.so properly.

Unfortunately, every flavor of Unix seems to have different ideas about
how shared libs should be built :-(, and I have no idea what the magic
incantation may be on Solaris.  A lot of Unixes require "-lc" to be
mentioned when linking a shlib that makes use of libc.  You might
check whether that's happening when libpsqlodbc is built.

Which version of Postgres are you using, anyway, and which port
(solaris_i386 or solaris_sparc)?
        regards, tom lane