Installing Python mysqlclient package

[mschoettle]

Hello,

I am trying to evaluate the Chainguard Python base image and am trying to install the mysqlclient package.

I tried to install mariadb-dev (apk add mariadb-dev), however, when installing mysqlclient via pip install mysqlclient I get the following error:

# pip install mysqlclient
Collecting mysqlclient
  Using cached mysqlclient-2.2.4.tar.gz (90 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Installing backend dependencies ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (pyproject.toml) ... error
  error: subprocess-exited-with-error
  
  × Building wheel for mysqlclient (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [47 lines of output]
      Trying pkg-config --exists mysqlclient
      Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
      Trying pkg-config --exists mariadb
      # Options for building extension module:
        extra_compile_args: ['-I/usr/include/mysql', '-std=c99']
        extra_link_args: ['-L/usr/lib', '-lmariadb', '-lz', '-ldl', '-lm', '-lssl', '-lcrypto']
        define_macros: [('version_info', (2, 2, 4, 'final', 0)), ('__version__', '2.2.4')]
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build/lib.linux-aarch64-cpython-312
      creating build/lib.linux-aarch64-cpython-312/MySQLdb
      copying src/MySQLdb/_exceptions.py -> build/lib.linux-aarch64-cpython-312/MySQLdb
      copying src/MySQLdb/__init__.py -> build/lib.linux-aarch64-cpython-312/MySQLdb
      copying src/MySQLdb/release.py -> build/lib.linux-aarch64-cpython-312/MySQLdb
      copying src/MySQLdb/times.py -> build/lib.linux-aarch64-cpython-312/MySQLdb
      copying src/MySQLdb/cursors.py -> build/lib.linux-aarch64-cpython-312/MySQLdb
      copying src/MySQLdb/connections.py -> build/lib.linux-aarch64-cpython-312/MySQLdb
      copying src/MySQLdb/converters.py -> build/lib.linux-aarch64-cpython-312/MySQLdb
      creating build/lib.linux-aarch64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/ER.py -> build/lib.linux-aarch64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/__init__.py -> build/lib.linux-aarch64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/CR.py -> build/lib.linux-aarch64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-aarch64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/FLAG.py -> build/lib.linux-aarch64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/CLIENT.py -> build/lib.linux-aarch64-cpython-312/MySQLdb/constants
      running egg_info
      writing src/mysqlclient.egg-info/PKG-INFO
      writing dependency_links to src/mysqlclient.egg-info/dependency_links.txt
      writing top-level names to src/mysqlclient.egg-info/top_level.txt
      reading manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
      reading manifest template 'MANIFEST.in'
      adding license file 'LICENSE'
      writing manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
      copying src/MySQLdb/_mysql.c -> build/lib.linux-aarch64-cpython-312/MySQLdb
      running build_ext
      building 'MySQLdb._mysql' extension
      creating build/temp.linux-aarch64-cpython-312
      creating build/temp.linux-aarch64-cpython-312/src
      creating build/temp.linux-aarch64-cpython-312/src/MySQLdb
      aarch64-unknown-linux-gnu-gcc -fno-strict-overflow -DNDEBUG -g -O3 -Wall -O2 -Wall -fomit-frame-pointer -march=armv8-a+crc+crypto -mtune=neoverse-n1 -O2 -Wall -fomit-frame-pointer -march=armv8-a+crc+crypto -mtune=neoverse-n1 -fPIC "-Dversion_info=(2, 2, 4, 'final', 0)" -D__version__=2.2.4 -I/usr/include/python3.12 -c src/MySQLdb/_mysql.c -o build/temp.linux-aarch64-cpython-312/src/MySQLdb/_mysql.o -I/usr/include/mysql -std=c99
      src/MySQLdb/_mysql.c:29:10: fatal error: mysql.h: No such file or directory
         29 | #include "mysql.h"
            |          ^~~~~~~~~
      compilation terminated.
      error: command '/usr/bin/aarch64-unknown-linux-gnu-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 mysqlclient
Failed to build mysqlclient
ERROR: Could not build wheels for mysqlclient, which is required to install pyproject.toml-based projects

This is on Apple Silicon (arm64).

Is there anything I am missing?

[mschoettle]

With apk add build-base mariadb-dev it works on alpine.

[jonjohnsonjr]

Looks like mariadb got split into version streams but we neglected to add the right virtuals for apk add mariadb-dev to actually work, sent a PR here to correct this: #13796

[mschoettle]

Thanks! Do you know when this update will be available?

[amouat]

This should be merged and fixed. Please open an issue if there's still a problem!