Import of pymssql on Centos fails to find libsydbd.so.5 about pymssql

[GoogleCodeExporter]

I am in Red Hat Enterprise Linux (RHEL 5.4)
and I have both python2.4 and python2.6

here were what I done:

0] yum install python26

1] yum install freetds

2] python2.6 ez_setup.py

3] easy_install-2.6 cython

4] easy_install-2.6 pymssql 
   I got -> 
   Downloading http://pymssql.googlecode.com/files/pymssql-1.9.908.win32.zip
Processing pymssql-1.9.908.win32.zip
error: Couldn't find a setup script in 
/tmp/easy_install-s3UIdY/pymssql-1.9.908.win32.zip
   <-

5] easy_install-2.6 http://pymssql.googlecode.com/files/pymssql-1.9.908.tar.gz
   I got ->
   gcc: _mssql.c: No such file or directory
gcc: no input files
error: Setup script exited with error: command 'gcc' failed with exit status 1
   <-

6] wget http://pymssql.googlecode.com/files/pymssql-1.9.908.tar.gz

7] tar zxvf pymssql* && cd pymssql*

8] python2.6 setup.py build
   I got ->
   /root/for-python/pymssql-1.9.908/_mssql.pyx:1286:26: undeclared name not builtin: strlen
building '_mssql' extension
gcc -pthread -fno-strict-aliasing -DNDEBUG -O2 -g -pipe -Wall 
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector 
--param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic 
-fasynchronous-unwind-tables -D_GNU_SOURCE -fPIC -fwrapv -fPIC 
-I/usr/local/include -I/usr/local/include/freetds -I/usr/include 
-I/usr/include/freetds -I/usr/include/freetds_mssql 
-I/usr/local/freetds/include -I/usr/pkg/freetds/include 
-I/usr/include/python2.6 -c _mssql.c -o build/temp.linux-i686-2.6/_mssql.o 
-DMSDBLIB
_mssql.c:1:2: error: #error Do not use this file, it is the result of a failed 
Cython compilation.
error: command 'gcc' failed with exit status 1
   <-

I almost crying :-(

I did not have /usr/local/include/freetds /usr/include /usr/include/freetds 
/usr/include/freetds_mssql /usr/local/freetds/include /usr/pkg/freetds/include

and I hadn't found anything like freetds_mssql  ....

what's wrong ??

please help :-(

Original comment by [email protected] on 26 Nov 2010 at 7:24

[GoogleCodeExporter]

Original comment by [email protected] on 8 Mar 2011 at 3:35

• Added labels: PyMssql-2.x

[GoogleCodeExporter]

I had this exact same issue

0] yum install python26

1] yum install freetds freetds-devel

2] python2.6 ez_setup.py

3] easy_install-2.6 cython

4] yum install mercurial (if you don't already have it)

5] Download latest subversion of pymssql 
    # hg clone https://pymssql.googlecode.com/hg/ pymssql

6] cd pymssql; python26 setup.py build

7] python26 setup.py install


5] pymssql

Original comment by [email protected] on 4 May 2011 at 2:55

[GoogleCodeExporter]

I guess, the first question is, where is the file:

libsybdb.so.5

on these systems?  Also, this will eventually be a mute point as we are 
planning on bundling FreeTDS w/ future versions of pymssql.  However, we are 
not there yet.

Original comment by [email protected] on 4 May 2011 at 3:40

[GoogleCodeExporter]

I have same issue. I found my libsybdb.so.5 in /usr/local/lib and create 
symlink in /usr/lib, rerun ldconfig and all fixed :)

#find / -type f -name libsybdb.so.5
/usr/local/lib/libsybdb.so.5
#ln -s /usr/local/lib/libsybdb.so.5 /usr/lib/libsybdb.so.5 
#ldconfig

Original comment by [email protected] on 26 Oct 2011 at 3:50

[GoogleCodeExporter]

FreeTDS is now bundled.  That should resolve this issue (but unfortunately 
creates other issues on CentOS).

Original comment by [email protected] on 8 Mar 2012 at 2:58

• Changed state: Fixed