pymsql - python ms sql cursor

tratando de instalar pymssql en ubuntu 12.04 usando pip

Question

Estoy tratando de instalar pymssql en ubuntu 12.04 usando pip. Este es el error que estoy recibiendo. ¡Cualquier ayuda sería muy apreciada ya que estoy completamente perdido!

Intenté googlear esto pero desafortunadamente fue en vano ...

  Downloading pymssql-2.0.0b1-dev-20130403.tar.gz (2.8Mb): 2.8Mb downloaded
  Running setup.py egg_info for package pymssql
    warning: no files found matching ''*.pyx'' under directory ''Cython/Debugger/Tests''
    warning: no files found matching ''*.pxd'' under directory ''Cython/Debugger/Tests''
    warning: no files found matching ''*.h'' under directory ''Cython/Debugger/Tests''
    warning: no files found matching ''*.pxd'' under directory ''Cython/Utility''
    Compiling module Cython.Plex.Scanners ...
    Compiling module Cython.Plex.Actions ...
    Compiling module Cython.Compiler.Lexicon ...
    Compiling module Cython.Compiler.Scanning ...
    Compiling module Cython.Compiler.Parsing ...
    Compiling module Cython.Compiler.Visitor ...
    Compiling module Cython.Compiler.FlowControl ...
    Compiling module Cython.Compiler.Code ...
    Compiling module Cython.Runtime.refnanny ...

    Installed /home/radek/build/pymssql/Cython-0.19.1-py2.7-linux-x86_64.egg
    cc -c /tmp/clock_gettimeh7sDgX.c -o tmp/clock_gettimeh7sDgX.o
    cc tmp/clock_gettimeh7sDgX.o -lrt -o a.out

    warning: no files found matching ''win32/freetds.zip''
Installing collected packages: pymssql
  Running setup.py install for pymssql
    skipping ''_mssql.c'' Cython extension (up-to-date)
    building ''_mssql'' extension
    gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -I/home/radek/build/pymssql/freetds/nix_64/include -I/usr/include/python2.7 -c _mssql.c -o build/temp.linux-x86_64-2.7/_mssql.o -Wno-parentheses-equality -DMSDBLIB
    gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -Wl,-z,relro build/temp.linux-x86_64-2.7/_mssql.o -L/home/radek/build/pymssql/freetds/nix_64/lib -lsybdb -lct -lrt -o build/lib.linux-x86_64-2.7/_mssql.so
    /usr/bin/ld: cannot find -lct
    collect2: ld returned 1 exit status
    error: command ''gcc'' failed with exit status 1
    Complete output from command /usr/bin/python -c "import setuptools;__file__=''/home/radek/build/pymssql/setup.py'';exec(compile(open(__file__).read().replace(''/r/n'', ''/n''), __file__, ''exec''))" install --single-version-externally-managed --record /tmp/pip-Et_P1_-record/install-record.txt:
    running install

running build

running build_ext

skipping ''_mssql.c'' Cython extension (up-to-date)

building ''_mssql'' extension

creating build

creating build/temp.linux-x86_64-2.7

gcc -pthread -fno-strict-aliasing -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fPIC -I/home/radek/build/pymssql/freetds/nix_64/include -I/usr/include/python2.7 -c _mssql.c -o build/temp.linux-x86_64-2.7/_mssql.o -Wno-parentheses-equality -DMSDBLIB

creating build/lib.linux-x86_64-2.7

gcc -pthread -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -Wl,-z,relro build/temp.linux-x86_64-2.7/_mssql.o -L/home/radek/build/pymssql/freetds/nix_64/lib -lsybdb -lct -lrt -o build/lib.linux-x86_64-2.7/_mssql.so

/usr/bin/ld: cannot find -lct

collect2: ld returned 1 exit status

error: command ''gcc'' failed with exit status 1

----------------------------------------
Command /usr/bin/python -c "import setuptools;__file__=''/home/radek/build/pymssql/setup.py'';exec(compile(open(__file__).read().replace(''/r/n'', ''/n''), __file__, ''exec''))" install --single-version-externally-managed --record /tmp/pip-Et_P1_-record/install-record.txt failed with error code 1

Answer 1

Además de freetds-dev, debes instalar python-dev y follow.

sudo apt-get install python-dev

O bien, de nuevo enfrentarás algún error.

Answer 2

Asegúrese de tener instalado el paquete python-dev (necesario para compilar paquetes con enlaces nativos (gracias a @ravihemnani).

Luego deberá instalar el paquete de desarrollo FreeTDS ( freetds-dev ) antes de intentar instalar pymssql con pip:

$ sudo apt-get install freetds-dev

y luego, en su virtualenv o donde quiera instalarlo:

$ pip install pymssql

Answer 3

En Mac

brew install [email protected]
brew link --force [email protected]
pip install pymssql

Answer 4

Para aquellos en OpenSuse (y sistemas operativos relacionados):

zypper in freetds-devel
pip install pymssql