FreeTDS Development Group

["Worman, Tyler" <tworman AT med.umich.edu>]

Got it working....Out of curiosity after seeing the bsqldb error and playing 
with libtool, I poked around the file structure of the 32-bit build.

In /home/tworman/freetds-0.95.19/src/odbc/.libs I found libtdsodbc.so.0

I copied this to /home/tworman/local/libs (where I installed to) as my .so 
file  and now osql and isql work perfect.
Thank you so much. Still unsure why that wasn't copied/linked on the make 
install like it did on linux. This proves to me though that my build of the 
.so from the .a file didn't work as planned.

Next is  to try the 64 bit build.

    - Tyler


-----Original Message-----
From: Worman, Tyler 
Sent: Thursday, September 17, 2015 12:10 AM
To: 'jklowden AT freetds.org'; freetds AT lists.ibiblio.org
Subject: RE: [freetds] FreeTDS build on AIX - No shared objects (.so) 
generated?

I was curious about the .a too, so I tried to direct UnixODBC to use the .a 
as the driver file but no luck. Unfortunately I'm not terribly familiar with 
AIX and our admin has been swamped, so my time with him is limited for 
questioned about the shared objects.

[01000][unixODBC][Driver Manager]Can't open lib 
'/home/tworman/local/lib/libtdsodbc.a' : file not found
[ISQL]ERROR: Could not SQLConnect

But the file is there....
bash-4.2$ file /home/tworman/local/lib/libtdsodbc.a
/home/tworman/local/lib/libtdsodbc.a: archive (big format)

This is from the .so I generated with gcc.
bash-4.2$ file libtdsodbc.so
libtdsodbc.so: executable (RISC System/6000) or object module not stripped


bash-4.2$ bsqldb
Could not load program bsqldb:
        Dependent module ../dblib/.libs/libsybdb.a(libsybdb.so.5) could not 
be loaded.
Could not load module ../dblib/.libs/libsybdb.a(libsybdb.so.5).
System error: No such file or directory

I don't understand why it's looking where it is for the file. That is in the 
bin directory under my local install path. No dblib folder exists below that. 
The libsysdb.a file is located in ../lib/

Tried bsqlodbc but it gives the same issue as osql/isql does.
bsqlodbc gives the same:
bsqlodbc: error -1: SQLConnect: SQL_ERROR: failed "[unixODBC][Driver 
Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed"

Thank you for the response. I really appreciate the help! Going to try 
Frediano's advice and see if I can't get a full set of 64 bit builds working. 
Maybe I'll have slight better luck vs the 32 bit libraries.  Results from 
32bit DBLib unit tests and the configure are below.

     - Tyler

Dblib unit tests.
env CFLAGS="-I/usr/local/include" AR_FLAGS="cru" ARFLAGS="cru" 
LD_LIBRARY_PATH=/usr/local/lib/ ./configure --with-unixodbc=/usr/local/ 
--prefix=/home/tworman/local --with-tdsver=7.0 make

Then the test results:
PASS: t0001
PASS: t0002
PASS: t0003
PASS: t0004
FAIL: t0005
PASS: t0006
PASS: t0007
PASS: t0008
PASS: t0009
PASS: t0011
PASS: t0012
FAIL: t0013
FAIL: t0014
PASS: t0015
PASS: t0016
PASS: t0017
PASS: t0018
PASS: t0019
PASS: t0020
PASS: t0021
FAIL: t0022
FAIL: t0023
FAIL: rpc
FAIL: dbmorecmds
FAIL: bcp
FAIL: thread
PASS: text_buffer
PASS: done_handling
PASS: timeout
FAIL: hang
PASS: null
PASS: null2
PASS: setnull
FAIL: numeric
PASS: pending
============================================================================
Testsuite summary for FreeTDS 0.95.19
============================================================================
# TOTAL: 35
# PASS:  24
# SKIP:  0
# XFAIL: 0
# FAIL:  11
# XPASS: 0
# ERROR: 0
============================================================================
See src/dblib/unittests/test-suite.log
============================================================================
make: The error code from the last command is 1 Stop.
make: The error code from the last command is 2.
Stop.
make: The error code from the last command is 2.
Stop.

Most of the failures in the test suite were a result of lack of permissions 
for the account I have to create tables/procedures in certain areas.

Output of the configure above:
checking for a BSD-compatible install... ./install-sh -c checking whether 
build environment is sane... yes checking for a thread-safe mkdir -p... 
./install-sh -c -d checking for gawk... no checking for mawk... no checking 
for nawk... nawk checking whether make sets $(MAKE)... yes checking whether 
make supports nested variables... yes checking whether make supports nested 
variables... (cached) yes checking for gawk... (cached) nawk checking for 
grep that handles long lines and -e... /usr/bin/grep checking whether ln -s 
works... yes checking for ranlib... ranlib checking for a sed that does not 
truncate output... /usr/bin/sed checking build system type... 
powerpc-ibm-aix7.1.0.0 checking host system type... powerpc-ibm-aix7.1.0.0 
checking for style of include used by make... GNU checking for gcc... gcc 
checking whether the C compiler works... yes checking for C compiler default 
output file name... a.out checking for suffix of executables... 
checking whether we are cross compiling... no checking for suffix of object 
files... o checking whether we are using the GNU C compiler... yes checking 
whether gcc accepts -g... yes checking for gcc option to accept ISO C89... 
none needed checking whether gcc understands -c and -o together... yes 
checking dependency style of gcc... gcc3 checking how to run the C 
preprocessor... gcc -E checking for egrep... /usr/bin/grep -E checking for 
ANSI C header files... yes checking for sys/types.h... yes checking for 
sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes 
checking for memory.h... yes checking for strings.h... yes checking for 
inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes 
checking minix/config.h usability... no checking minix/config.h presence... 
no checking for minix/config.h... no checking whether it is safe to define 
__EXTENSIONS__... yes checking for special C compiler options needed for 
large files... no checking for _FILE_OFFSET_BITS value needed for large 
files... unknown checking for _LARGE_FILES value needed for large files... 1 
checking for gcc... (cached) gcc checking whether we are using the GNU C 
compiler... (cached) yes checking whether gcc accepts -g... (cached) yes 
checking for gcc option to accept ISO C89... (cached) none needed checking 
whether gcc understands -c and -o together... (cached) yes checking 
dependency style of gcc... (cached) gcc3 checking how to run the C 
preprocessor... gcc -E checking for inline... inline checking how to print 
strings... print -r checking for a sed that does not truncate output... 
(cached) /usr/bin/sed checking for fgrep... /usr/bin/grep -F checking for ld 
used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... 
no checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B 
checking the name lister (/usr/bin/nm -B) interface... BSD nm checking the 
maximum length of command line arguments... 786432 checking whether the shell 
understands some XSI constructs... yes checking whether the shell understands 
"+="... no checking how to convert powerpc-ibm-aix7.1.0.0 file names to 
powerpc-ibm-aix7.1.0.0 format... func_convert_file_noop checking how to 
convert powerpc-ibm-aix7.1.0.0 file names to toolchain format... 
func_convert_file_noop checking for /usr/bin/ld option to reload object 
files... -r checking for objdump... objdump checking how to recognize 
dependent libraries... pass_all checking for dlltool... dlltool checking how 
to associate runtime and link libraries... print -r -- checking for ar... ar 
checking for archiver @FILE support... no checking for strip... strip 
checking for ranlib... (cached) ranlib checking command to parse /usr/bin/nm 
-B output from gcc object... ok checking for sysroot... no checking for mt... 
mt checking if mt is a manifest tool... no checking for dlfcn.h... yes 
checking for objdir... .libs checking if gcc supports -fno-rtti 
-fno-exceptions... no checking for gcc option to produce PIC...  -DPIC 
checking if gcc PIC flag  -DPIC works... yes checking if gcc static flag 
-static works... no checking if gcc supports -c -o file.o... yes checking if 
gcc supports -c -o file.o... (cached) yes checking whether the gcc linker 
(/usr/bin/ld) supports shared libraries... yes checking dynamic linker 
characteristics... aix7.1.0.0 ld.so checking how to hardcode library paths 
into programs... immediate checking whether stripping libraries is 
possible... no checking if libtool supports shared libraries... yes checking 
whether to build shared libraries... yes checking whether to build static 
libraries... no checking for library containing dlopen... none required 
checking for dlerror... yes checking for shl_load... no checking for shl_load 
in -ldld... no checking for dld_link in -ldld... no checking for windres... 
no checking for ld used by GCC... /usr/bin/ld checking if the linker 
(/usr/bin/ld) is GNU ld... no checking for shared library run path origin... 
done checking for iconv... yes checking how to link with libiconv... 
/home/tworman/local/lib/libiconv.a
checking for iconv declaration... 
         extern size_t iconv (iconv_t cd, char * *inbuf, size_t *inbytesleft, 
char * *outbuf, size_t *outbytesleft); checking for doxygen... no checking 
for odbc_config... odbc_config checking for pkg-config... no checking for 
library containing socket... none required checking for library containing 
gethostbyname... none required checking for library containing tgetent... 
-lcurses checking for readline in -lreadline... yes checking for 
rl_on_new_line... yes checking for rl_reset_line_state... yes checking for 
the pthreads library -lpthreads... yes checking for joinable pthread 
attribute... PTHREAD_CREATE_JOINABLE checking if more special flags are 
required for pthreads... -D_THREAD_SAFE checking for library containing 
pthread_condattr_setclock... none required checking for 
pthread_condattr_setclock... yes checking for ANSI C header files... (cached) 
yes checking whether time.h and sys/time.h may both be included... yes 
checking whether struct tm is in sys/time.h or time.h... time.h checking for 
struct tm.tm_zone... no checking whether tzname is declared... yes checking 
for tzname... yes checking for struct tm.__tm_zone... no checking errno.h 
usability... yes checking errno.h presence... yes checking for errno.h... yes 
checking libgen.h usability... yes checking libgen.h presence... yes checking 
for libgen.h... yes checking limits.h usability... yes checking limits.h 
presence... yes checking for limits.h... yes checking locale.h usability... 
yes checking locale.h presence... yes checking for locale.h... yes checking 
poll.h usability... yes checking poll.h presence... yes checking for 
poll.h... yes checking readpassphrase.h usability... no checking 
readpassphrase.h presence... no checking for readpassphrase.h... no checking 
signal.h usability... yes checking signal.h presence... yes checking for 
signal.h... yes checking stddef.h usability... yes checking stddef.h 
presence... yes checking for stddef.h... yes checking sys/param.h 
usability... yes checking sys/param.h presence... yes checking for 
sys/param.h... yes checking sys/select.h usability... yes checking 
sys/select.h presence... yes checking for sys/select.h... yes checking for 
sys/stat.h... (cached) yes checking sys/time.h usability... yes checking 
sys/time.h presence... yes checking for sys/time.h... yes checking for 
sys/types.h... (cached) yes checking sys/resource.h usability... yes checking 
sys/resource.h presence... yes checking for sys/resource.h... yes checking 
sys/wait.h usability... yes checking sys/wait.h presence... yes checking for 
sys/wait.h... yes checking for unistd.h... (cached) yes checking netdb.h 
usability... yes checking netdb.h presence... yes checking for netdb.h... yes 
checking wchar.h usability... yes checking wchar.h presence... yes checking 
for wchar.h... yes checking for inttypes.h... (cached) yes checking 
winsock2.h usability... no checking winsock2.h presence... no checking for 
winsock2.h... no checking localcharset.h usability... yes checking 
localcharset.h presence... yes checking for localcharset.h... yes checking 
valgrind/memcheck.h usability... no checking valgrind/memcheck.h presence... 
no checking for valgrind/memcheck.h... no checking malloc.h usability... yes 
checking malloc.h presence... yes checking for malloc.h... yes checking 
dirent.h usability... yes checking dirent.h presence... yes checking for 
dirent.h... yes checking for windows.h... no checking for sql.h... yes 
checking for odbcss.h... yes checking arpa/inet.h usability... yes checking 
arpa/inet.h presence... yes checking for arpa/inet.h... yes checking 
langinfo.h usability... yes checking langinfo.h presence... yes checking for 
langinfo.h... yes checking for netdb.h... (cached) yes checking netinet/in.h 
usability... yes checking netinet/in.h presence... yes checking for 
netinet/in.h... yes checking netinet/tcp.h usability... yes checking 
netinet/tcp.h presence... yes checking for netinet/tcp.h... yes checking 
roken.h usability... no checking roken.h presence... no checking for 
roken.h... no checking com_err.h usability... no checking com_err.h 
presence... no checking for com_err.h... no checking paths.h usability... yes 
checking paths.h presence... yes checking for paths.h... yes checking 
sys/ioctl.h usability... yes checking sys/ioctl.h presence... yes checking 
for sys/ioctl.h... yes checking sys/socket.h usability... yes checking 
sys/socket.h presence... yes checking for sys/socket.h... yes checking 
whether INADDR_NONE is defined... yes checking size of char... 1 checking 
size of short... 2 checking size of long... 4 checking size of int... 4 
checking size of float... 4 checking size of double... 8 checking size of 
long double... 16 checking size of long long... 8 checking size of __int64... 
0 checking size of void *... 4 checking size of wchar_t... 2 checking is 
FIONBIO defined... yes checking for socklen_t... yes checking whether getopt 
has optreset support... no checking whether byte ordering is bigendian... yes 
checking for an ANSI C-conforming const... yes checking whether we can use 
-static-libgcc... sed: Cannot find or open file conftest.c.
no
checking whether we can use -Wl,-static-libgcc... sed: Cannot find or open 
file conftest.c.
no
checking whether memset(0) sets pointers to NULL... yes checking for 
_atoi64... no checking for vsnprintf... yes checking for _vsnprintf... no 
checking for _vscprintf... no checking for gettimeofday... yes checking for 
nl_langinfo... yes checking for locale_charset... no checking for setenv... 
yes checking for putenv... yes checking for getuid... yes checking for 
getpwuid... yes checking for getpwuid_r... yes checking for fstat... yes 
checking for alarm... yes checking for fork... yes checking for gethrtime... 
no checking for localtime_r... yes checking for setitimer... yes checking for 
_lseeki64... no checking for _telli64... no checking for _fseeki64... no 
checking for _ftelli64... no checking for setrlimit... yes checking for 
pthread_cond_timedwait... yes checking for _lock_file... no checking for 
_unlock_file... no checking for usleep... yes checking for nanosleep... yes 
checking for readdir_r... yes checking for inet_ntoa_r... yes checking for 
getipnodebyaddr... yes checking for getipnodebyname... yes checking for 
getaddrinfo... yes checking for inet_ntop... yes checking for gethostname... 
yes checking for poll... yes checking for socketpair... yes checking for 
asprintf... no checking for vasprintf... no checking for strtok_r... yes 
checking for readpassphrase... no checking for strlcpy... no checking for 
strlcat... no checking for basename... yes checking for getopt... yes 
checking for strsep... yes checking for _LARGEFILE_SOURCE value needed for 
large files... no checking for library containing clock_gettime... none 
required checking if clock_gettime support CLOCK_MONOTONIC... yes checking 
whether malloc_options variable is present... no checking compile-time 
options looking for installed odbc driver manager checking for 
SQLGetPrivateProfileString in -lodbcinst... yes checking for SQLSETPOSIROW... 
yes checking for SQLROWSETSIZE... yes checking for SQLROWOFFSET... yes 
checking size of SQLWCHAR... 2 checking if openssl is wanted... no checking 
threadsafety... enabled checking for which type of gethostbyname_r... three 
checking for which type of getservbyname_r... four checking for which type of 
gethostbyaddr_r... five checking for which type of getpwuid_r... five 
checking for which type of localtime_r... struct
configure: debug enabled
checking CFLAGS for gcc -Wdeclaration-after-statement... 
-Wdeclaration-after-statement done checking that generated files are newer 
than configure... done
configure: creating ./config.status
config.status: creating include/freetds/version.h
config.status: creating include/tds_sysdep_public.h
config.status: creating Makefile
config.status: creating include/Makefile
config.status: creating include/freetds/Makefile
config.status: creating doc/Makefile
config.status: creating samples/Makefile
config.status: creating src/Makefile
config.status: creating src/tds/Makefile
config.status: creating src/tds/unittests/Makefile
config.status: creating src/dblib/Makefile
config.status: creating src/dblib/unittests/Makefile
config.status: creating src/ctlib/Makefile
config.status: creating src/ctlib/unittests/Makefile
config.status: creating src/replacements/Makefile
config.status: creating src/replacements/unittests/Makefile
config.status: creating src/server/Makefile
config.status: creating src/pool/Makefile
config.status: creating src/odbc/Makefile
config.status: creating src/odbc/unittests/Makefile
config.status: creating src/apps/Makefile
config.status: creating src/apps/fisql/Makefile
config.status: creating freetds.spec
config.status: creating win32/Makefile
config.status: creating win32/config.h
config.status: creating win32/version.rc
config.status: creating win32/freetds.nsh
config.status: creating vms/Makefile
config.status: creating doc/freebcp.1
config.status: creating doc/tsql.1
config.status: creating doc/osql.1
config.status: creating doc/bsqldb.1
config.status: creating doc/bsqlodbc.1
config.status: creating doc/defncopy.1
config.status: creating doc/datacopy.1
config.status: creating doc/fisql.1
config.status: creating doc/freetds.conf.5
config.status: creating include/config.h
config.status: executing depfiles commands
config.status: executing libtool commands

-----Original Message-----
From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James 
K. Lowden
Sent: Wednesday, September 16, 2015 6:32 PM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] FreeTDS build on AIX - No shared objects (.so) 
generated?

On Tue, 15 Sep 2015 17:39:26 +0000
"Worman, Tyler" <tworman AT med.umich.edu> wrote:

> Trying to build FreeTDS (stable .95.19) on AIX 7100-03-05-1524.
> The .so files don't generate. Browsed online and tried a few suggested 
> fixes for similar problems but no luck so far. Generated my own .so 
> files from the .a that builds but it doesn't seem to work.
> Any advice? 

If memory serves, .a in AIX *is* a dynamic library.  I don't believe AIX 
follows the .so convention.  If you're not sure, what does file(1) tell you?  

As Frediano said, tsql doesn't use the shared libraries.  The simplest test 
is to run the unit tests for dblib, or run bsqldb.  

HTH.  

--jkl

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
**********************************************************
Electronic Mail is not secure, may not be read every day, and should not be 
used for urgent or sensitive issues