Re: FreeTDS build on AIX - No shared objects (.so) generated?

AIX .a archives can hold 32 and 64 bit shared objects.

Try this:

comp@zebulon:/tmp/sf$ ls -l
total 5064
-rwxr-xr-x    1 comp     fjsadm      2585883 Sep 22 16:38 libtdsodbc.a
comp@zebulon:/tmp/sf$ ar -x libtdsodbc.a
comp@zebulon:/tmp/sf$ ls -l
total 10088
-rwxr-xr-x    1 comp     fjsadm      2585883 Sep 22 16:38 libtdsodbc.a
-rwxrwxr-x    1 comp     fjsadm      2567943 Sep 22 16:38 libtdsodbc.so.0


I have another problem when building 0.95 on AIX, will post another thread.

Seb

On 09/17/2015 06:09 AM, Worman, Tyler wrote:
> 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:[email protected]] On Behalf Of James K. Lowden
> Sent: Wednesday, September 16, 2015 6:32 PM
> To: [email protected]
> Subject: Re: [freetds] FreeTDS build on AIX - No shared objects (.so) generated?
>
> On Tue, 15 Sep 2015 17:39:26 +0000
> "Worman, Tyler" <[email protected]> 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
> [email protected]
> 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
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>