pymssql.so: undefined symbol: __fread_chk about pymssql

[GoogleCodeExporter]

I have resolved the issue.

change FREETDS in setup.py as below

if osp.exists(FREETDS):
        FREETDS = "/usr/local/freetds/"

Original comment by [email protected] on 8 Jun 2013 at 8:16

[GoogleCodeExporter]

my operation system is suse 10.1 x86_64
so i recompile the freetsd

export CFLAGS='-fPIC'
./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib  
--enable-static

Original comment by [email protected] on 8 Jun 2013 at 8:20

[GoogleCodeExporter]

Original comment by [email protected] on 7 Aug 2013 at 6:14

• Added labels: FreeTDSbundlingrelated

[GoogleCodeExporter]

Thanks for the issue report!

By any chance, have you tried to reproduce this on a newer Linux distro? 

Suse 10.1 is fairly old. 

Original comment by [email protected] on 16 Aug 2013 at 12:00

[GoogleCodeExporter]

I just added a commit that fixes this issue for me on SUSE 10.1:

https://code.google.com/p/pymssql/source/detail?r=196557e92d5c9db1d26621236a94dc
6481babae1

changeset:   355:196557e92d5c
tag:         tip
user:        Marc Abramowitz <[email protected]>
date:        Mon Sep 02 09:31:05 2013 -0700
files:       setup.py
description:
 issue 71  ('"undefined symbol: __vasprintf_chk" on some CentOS, RedHat because
of precompiled FreeTDS Linux library')

setup.py: Don't try to use bundled FreeTDS if the system's libc doesn't have a
__vasprintf_chk symbol

If the system's libc doesn't have a __vasprintf_chk symbol, then linking with 
the bundled FreeTDS library is destined to fail, so in this case we don't try 
to link with the bundled FreeTDS. The user is responsible for installing an 
appropriate FreeTDS library.

Here's what I get now with this change:

marca@linux-u176:~/dev/hg-repos/pymssql> python setup.py build_ext -i
setup.py: platform.system() => 'Linux'
setup.py: platform.architecture() => ('64bit', 'ELF')
setup.py: platform.linux_distribution() => ('SUSE LINUX ', '10.1', 'X86-64')
setup.py: platform.libc_ver() => ('glibc', '2.3')
setup.py: libc_has_vasprintf_chk = False
setup.py: libc doesn't have __vasprintf_chk - not going to use bundled FreeTDS
setup.py: Not using bundled FreeTDS
setup.py: include_dirs = ['/usr/local/include']
setup.py: library_dirs = ['/usr/local/lib']
running build_ext
cythoning _mssql.pyx to _mssql.c
building '_mssql' extension
creating build
creating build/temp.linux-x86_64-2.7
gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall
-Wstrict-prototypes -fPIC -I/usr/local/include -I/usr/local/include/python2.7
-c _mssql.c -o build/temp.linux-x86_64-2.7/_mssql.o -DMSDBLIB
_mssql.c:314:22: error: sqlfront.h: No such file or directory
...

At this point, one could install FreeTDS and then pymssql will build.

Can other folks verify?

Original comment by [email protected] on 2 Sep 2013 at 6:04

• Changed state: Fixed