On Solaris, FreeTDS 1.3.18 fails with iconv issue #496
-
|
Hello, On Solaris: With following ODBCINI settings: TDSDUMP shows the following error: What are we doing wrong? Is it an iconv config issue on the platform, or FreeTDS? Seb |
Beta Was this translation helpful? Give feedback.
Replies: 4 comments 8 replies
-
|
Trying to debug the code in src/tds/iconv.c: => tds_sys_iconv_option() returns -1 for UCS-2BE / UCS-2LE Seb |
Beta Was this translation helpful? Give feedback.
-
|
I would say is your iconv implementation that has some issues. I know some systems require some additional packages to be installed. I would suggest to install and use GNU libiconv. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for considering this ! |
Beta Was this translation helpful? Give feedback.
-
|
Weird, something says FreeTDS is not picking up GNU libiconv. Maybe the logs (like What's the content of |
Beta Was this translation helpful? Give feedback.
-
|
Here is the content of /usr/local/tools/64bits/libiconv/1.16 on our machine: Just in case: |
Beta Was this translation helpful? Give feedback.
-
|
Here are some parts if the configure config.log: |
Beta Was this translation helpful? Give feedback.
-
|
I don't have a Solaris machine to test (it would be helpful to have one) so I tried to reproduce with Linux and manually compiled GNU libiconv but it's working, the no system library is used. Commands were (inside a docker container) # tar xvf libiconv-1.17.tar.gz
# cd libiconv-1.17
# ./configure --prefix=$HOME/iconv
# make -j4
# make install
## inside FreeTDS directory
# ./configure --with-libiconv-prefix=$HOME/iconv --prefix=$HOME/freetds
...
checking for iconv... yes
checking for working iconv... yes
checking how to link with libiconv... /root/iconv/lib/libiconv.so -Wl,-rpath -Wl,/root/iconv/lib
checking for iconv declaration...
extern size_t iconv (iconv_t cd, char * *inbuf, size_t *inbytesleft, char * *outbuf, size_t *outbytesleft);
...
# make -j4
...
# make install
...
# ldd $HOME/freetds/lib/libtdsodbc.so.0.0.0
linux-vdso.so.1 (0x00007ffd5bdea000)
libodbcinst.so.2 => /lib/x86_64-linux-gnu/libodbcinst.so.2 (0x00007ff906d42000)
libiconv.so.2 => /root/iconv/lib/libiconv.so.2 (0x00007ff906c5a000)
libssl.so.3 => /lib/x86_64-linux-gnu/libssl.so.3 (0x00007ff906bb6000)
libcrypto.so.3 => /lib/x86_64-linux-gnu/libcrypto.so.3 (0x00007ff906774000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007ff90654c000)
libltdl.so.7 => /lib/x86_64-linux-gnu/libltdl.so.7 (0x00007ff90653f000)
/lib64/ld-linux-x86-64.so.2 (0x00007ff906dd3000)
# objdump -T $HOME/freetds/lib/libtdsodbc.so.0.0.0 | grep iconv
0000000000000000 DF *UND* 0000000000000000 Base libiconv
0000000000000000 DF *UND* 0000000000000000 Base libiconv_close
0000000000000000 DF *UND* 0000000000000000 Base libiconv_open
# ldd /root/freetds/bin/tsql
linux-vdso.so.1 (0x00007ffe18d3f000)
libiconv.so.2 => /root/iconv/lib/libiconv.so.2 (0x00007f150570d000)
libssl.so.3 => /lib/x86_64-linux-gnu/libssl.so.3 (0x00007f1505666000)
libcrypto.so.3 => /lib/x86_64-linux-gnu/libcrypto.so.3 (0x00007f1505224000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f1504ffc000)
/lib64/ld-linux-x86-64.so.2 (0x00007f1505846000)
# objdump -T /root/freetds/bin/tsql | grep iconv
0000000000000000 DF *UND* 0000000000000000 Base libiconv
0000000000000000 DF *UND* 0000000000000000 Base libiconv_close
0000000000000000 DF *UND* 0000000000000000 Base libiconv_opensome Some differences I can see
I don't understand from your logs why the provided alternative iconv is not used in your case. |
Beta Was this translation helpful? Give feedback.
-
|
I wish I could give you access to our Solaris machine but it's not possible. What means am_cv_lib_iconv=no? BTW (not sure it has an impact) the person who did the build had to patch the "libtool" file after configure: Because it was empty. |
Beta Was this translation helpful? Give feedback.
-
|
I think Sometimes libtool could be pretty weird. One things you can try is to run configure and then replace generated In Other than |
Beta Was this translation helpful? Give feedback.
-
|
I will send you directly to your personal email the output of sh -x configure ... |
Beta Was this translation helpful? Give feedback.
-
|
I think I found the problem: sh -x ./configure output revealed that it expects the iconv libs under iconv-install-dir/lib/64 or iconv-install-dir/lib/sparcv9: withval=/usr/local/tools/64bits/libiconv/1.16 But in our case, iconv libs where just under iconv-install-dir/lib ! I have created a 'sparcv9' subdir, with the shared libs inside, and now I got this in config.log: am_cv_func_iconv=yes And I could connect to SQL Server. I think the configure script should be fixed (why search in lib/64 and lib/sparcv9? Seb |
Beta Was this translation helpful? Give feedback.
-
|
Good that you found a solution. About the search it seems the M4 macro that chooses the library directories comes usually from gettext package (Ubuntu and NetBSD). Specifically the macro is |
Beta Was this translation helpful? Give feedback.
Good that you found a solution. About the search it seems the M4 macro that chooses the library directories comes usually from gettext package (Ubuntu and NetBSD). Specifically the macro is
AC_LIB_PREPARE_MULTILIBinlib-prefix.m4. m4 macros are extended and embedded inconfigurescript. Newer version would also uselibdirectory for libraries on Solaris (solib,lib/64andlib/sparcv9) while version used and packaged inwww.freetds.orgjust useslib/64andlib/sparcv9. So updatinglib-prefix.m4and repackaging (autogen.shorautoconf) should work. Not sure however where I should pick up updated relatedm4files and how to override system files.