安装pymssql报错 Running setup.py install for pymssql ... error

安装pymssql报错 Running setup.py install for pymssql ... error

# pip2.7 install pymssql      

Collecting pymssql

  Using cached https://files.pythonhosted.org/packages/4c/c8/5ad36d8d3c304ab4f310c89d0593ab7b6229568dd8e9cde927311b2f0c00/pymssql-2.1.3.tar.gz

Installing collected packages: pymssql

  Running setup.py install for pymssql ... error

    Complete output from command /usr/local/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-install-Ha5vcf/pymssql/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-record-7HvtV4/install-record.txt --single-version-externally-managed --compile:

    setup.py: platform.system() => 'Linux'

    setup.py: platform.architecture() => ('64bit', 'ELF')

    setup.py: platform.linux_distribution() => ('CentOS', '6.9', 'Final')

    setup.py: platform.libc_ver() => ('glibc', '2.3')

    setup.py: Not using bundled FreeTDS

    setup.py: include_dirs = ['/usr/local/include']

    setup.py: library_dirs = ['/usr/local/lib']

    running install

    running build

    running build_ext

    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:266:22: fatal error: sqlfront.h: No such file or directory

     #include "sqlfront.h"

                          ^

    compilation terminated.

    error: command 'gcc' failed with exit status 1

    

    ----------------------------------------

Command "/usr/local/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-install-Ha5vcf/pymssql/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-record-7HvtV4/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /tmp/pip-install-Ha5vcf/pymssql/

 

 

执行：

# export PYMSSQL_BUILD_WITH_BUNDLED_FREETDS=1

# pip2.7 install pymssql      

Collecting pymssql

  Using cached https://files.pythonhosted.org/packages/4c/c8/5ad36d8d3c304ab4f310c89d0593ab7b6229568dd8e9cde927311b2f0c00/pymssql-2.1.3.tar.gz

Installing collected packages: pymssql

  Running setup.py install for pymssql ... done

Successfully installed pymssql-2.1.3