[Build] mysqlclient fails not build on mint

[potiuk]

What OS and which version do you use?

Linux Mint 22

How did you installed mysql client library?

apt-get install libmysqlclient-de

Output from pkg-config --cflags --libs mysqlclient

-I/usr/include/mysql -L/usr/lib/x86_64-linux-gnu -lmysqlclient

How did you tried to install mysqlclient?

uv pip install mysqlclient

Output of building mysqlclient

Resolved 1 package in 0.95ms
  × Failed to build `mysqlclient==2.2.6`
  ├─▶ The build backend returned an error
  ╰─▶ Call to `setuptools.build_meta.build_wheel` failed (exit status: 1)

      [stdout]
      # Options for building extension module:
        extra_compile_args: ['-I/usr/include/mysql', '-std=c99']
        extra_link_args: ['-L/usr/lib/x86_64-linux-gnu', '-lmysqlclient', '-lz', '-lzstd', '-lssl', '-lcrypto', '-lresolv', '-lmG']
        define_macros: [('version_info', (2, 2, 6, 'final', 0)), ('__version__', '2.2.6')]
      running bdist_wheel
      running build
      running build_py
      copying src/MySQLdb/__init__.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/_exceptions.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/connections.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/converters.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/release.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/cursors.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/times.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/constants/__init__.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/CR.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/ER.py -> build/lib.linux-x86_64-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-x86_64-cpython-312/MySQLdb
      running build_ext
      building 'MySQLdb._mysql' extension
      clang -pthread -fno-strict-overflow -Wsign-compare -Wunreachable-code -DNDEBUG -g -O3 -Wall -fPIC -fPIC "-Dversion_info=(2, 2, 6, 'final', 0)" -D__version__=2.2.6 -I/home/jarek/.cache/uv/builds-v0/.tmpVhdauH/include
      -I/home/jarek/.local/share/uv/python/cpython-3.12.7-linux-x86_64-gnu/include/python3.12 -c src/MySQLdb/_mysql.c -o build/temp.linux-x86_64-cpython-312/src/MySQLdb/_mysql.o -I/usr/include/mysql -std=c99
      clang -pthread -shared -Wl,--exclude-libs,ALL -LModules/_hacl build/temp.linux-x86_64-cpython-312/src/MySQLdb/_mysql.o -L/install/lib -o build/lib.linux-x86_64-cpython-312/MySQLdb/_mysql.cpython-312-x86_64-linux-gnu.so -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lz -lzstd -lssl -lcrypto -lresolv
      -lmG

      [stderr]
      In file included from src/MySQLdb/_mysql.c:52:
      In file included from /home/jarek/.local/share/uv/python/cpython-3.12.7-linux-x86_64-gnu/include/python3.12/Python.h:12:
      /home/jarek/.local/share/uv/python/cpython-3.12.7-linux-x86_64-gnu/include/python3.12/pyconfig.h:1875:9: warning: '_POSIX_C_SOURCE' macro redefined [-Wmacro-redefined]
       1875 | #define _POSIX_C_SOURCE 200809L
            |         ^
      /usr/include/features.h:321:10: note: previous definition is here
        321 | # define _POSIX_C_SOURCE 199506L
            |          ^
      1 warning generated.
      /usr/bin/ld: cannot find -lmG: No such file or directory
      clang: error: linker command failed with exit code 1 (use -v to see invocation)
      error: command '/usr/bin/clang' failed with exit code 1

      hint: This error likely indicates that you need to install the library that provides a shared library for `mG` for `mysqlclient@2.2.6` (e.g., `libmG-dev`)

[potiuk]

The "libmG" library is nowhere to be found

[methane]

Don't you set MYSQLCLIENT_LDFLAGS env var?

[potiuk]

Thanks!

Right. Probably I installed it long time in the path and I had MYSQL_CLIENT env vars set in my startup scripts for some past configuraiton.

After I removed them it asked me to:

      Exception: Can not find valid pkg-config name.
      Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually

Which is probably what made me set the variables before.

I looked a bit and set this instead:

export PKG_CONFIG_PATH=/usr/lib/x86_64-linux-gnu/pkgconfig/

And it worked.

[potiuk]

Thanks a lot @methane !