Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

tests: pymssql (sql output dependency) installation fails #2539

Open
sebix opened this issue Nov 30, 2024 · 0 comments · May be fixed by #2542
Open

tests: pymssql (sql output dependency) installation fails #2539

sebix opened this issue Nov 30, 2024 · 0 comments · May be fixed by #2542
Assignees
Labels
bug Indicates an unexpected problem or unintended behavior component: tests

Comments

@sebix
Copy link
Member

sebix commented Nov 30, 2024

tests (pytest full) on Python 3.7 and 3.8 fails with:

+ pip install -r intelmq/bots/outputs/sql/REQUIREMENTS.txt
intelmq/bots/outputs/sql/REQUIREMENTS.txt
Requirement already satisfied: psycopg2-binary>=2.5.5 in /opt/hostedtoolcache/Python/3.7.17/x64/lib/python3.7/site-packages (from -r intelmq/bots/outputs/sql/REQUIREMENTS.txt (line 4)) (2.9.9)
Collecting pymssql>=2.2 (from -r intelmq/bots/outputs/sql/REQUIREMENTS.txt (line 5))
  Downloading pymssql-2.3.2.tar.gz (184 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 184.8/184.8 kB 8.9 MB/s eta 0:00:00
  Installing build dependencies: started
  Installing build dependencies: finished with status 'done'
  Getting requirements to build wheel: started
  Getting requirements to build wheel: finished with status 'done'
  Preparing metadata (pyproject.toml): started
  Preparing metadata (pyproject.toml): finished with status 'done'
Building wheels for collected packages: pymssql
  Building wheel for pymssql (pyproject.toml): started
  Building wheel for pymssql (pyproject.toml): finished with status 'error'
  error: subprocess-exited-with-error
  
  × Building wheel for pymssql (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [27 lines of output]
      prefix='/usr/local'
      setup.py: platform.system() => Linux
      setup.py: platform.architecture() => ('64bit', 'ELF')
      setup.py: platform.libc_ver() => ('glibc', '2.34')
      setup.py: include_dirs => ['/usr/local/include']
      setup.py: library_dirs => ['/usr/local/lib']
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build/lib.linux-x86_64-cpython-37
      creating build/lib.linux-x86_64-cpython-37/pymssql
      copying src/pymssql/exceptions.py -> build/lib.linux-x86_64-cpython-37/pymssql
      copying src/pymssql/__init__.py -> build/lib.linux-x86_64-cpython-37/pymssql
      running build_ext
      Compiling src/pymssql/_mssql.pyx because it changed.
      [1/1] Cythonizing src/pymssql/_mssql.pyx
      building 'pymssql._mssql' extension
      creating build/temp.linux-x86_64-cpython-37
      creating build/temp.linux-x86_64-cpython-37/src
      creating build/temp.linux-x86_64-cpython-37/src/pymssql
      gcc -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall -fPIC -I/usr/local/include -I/opt/hostedtoolcache/Python/3.7.17/x64/include/python3.7m -c src/pymssql/_mssql.c -o build/temp.linux-x86_64-cpython-37/src/pymssql/_mssql.o -DMSDBLIB
      src/pymssql/_mssql.c:1275:10: fatal error: sqlfront.h: No such file or directory
       1275 | #include "sqlfront.h"
            |          ^~~~~~~~~~~~
      compilation terminated.
      error: command '/usr/bin/gcc' failed with exit code 1
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.
  ERROR: Failed building wheel for pymssql
ERROR: Could not build wheels for pymssql, which is required to install pyproject.toml-based projects
Failed to build pymssql

Notice:  A new release of pip is available: 23.0.1 -> 24.0
Notice:  To update, run: pip install --upgrade pip

It works on 3.9 and newer. Disabling the sql output bot tests on the two older versions may be an option

@sebix sebix added bug Indicates an unexpected problem or unintended behavior component: tests labels Nov 30, 2024
@sebix sebix added this to the 3.3.2 Bugfix release milestone Nov 30, 2024
@sebix sebix self-assigned this Nov 30, 2024
sebix added a commit to sebix/intelmq that referenced this issue Nov 30, 2024
pymssql there are no wheels for 3.8, needs to be built
install a required header file
fixes certtools#2539
sebix added a commit to sebix/intelmq that referenced this issue Nov 30, 2024
pymssql there are no wheels for 3.8, needs to be built
install a required header file
fixes certtools#2539
@sebix sebix linked a pull request Nov 30, 2024 that will close this issue
sebix added a commit to sebix/intelmq that referenced this issue Dec 1, 2024
pymssql there are no wheels for 3.8, needs to be built
install required header files
fixes certtools#2539
sebix added a commit to sebix/intelmq that referenced this issue Dec 1, 2024
pymssql there are no wheels for 3.8, needs to be built
install required header files
fixes certtools#2539
sebix added a commit to sebix/intelmq that referenced this issue Dec 1, 2024
pymssql there are no wheels for 3.8, needs to be built
install required header files
fixes certtools#2539
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Indicates an unexpected problem or unintended behavior component: tests
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant