CentOS 7でmysqlclientをpip3でインストールしようとしたときに、互換性の問題が発生することがあります。特に、mysqlclientのバージョン2.0.2がCentOS 7と互換性がないため、インストールに失敗することがあります。この問題を解決するための方法を以下に説明します。
以下のようなエラーが発生する場合があります：
pip3 install mysqlclient
Collecting mysqlclient
Using cached mysqlclient-2.2.4.tar.gz (90 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... error
error: subprocess-exited-with-error
× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> [27 lines of output]
Trying pkg-config --exists mysqlclient
Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
Trying pkg-config --exists mariadb
Command 'pkg-config --exists mariadb' returned non-zero exit status 1.
Trying pkg-config --exists libmariadb
Command 'pkg-config --exists libmariadb' returned non-zero exit status 1.
Traceback (most recent call last):
File "/usr/local/lib/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 353, in <module>
main()
File "/usr/local/lib/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main
json_out['return_val'] = hook(**hook_input['kwargs'])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 118, in get_requires_for_build_wheel
return hook(config_settings)
^^^^^^^^^^^^^^^^^^^^^
File "/tmp/pip-build-env-3i_ec6o7/overlay/lib/python3.11/site-packages/setuptools/build_meta.py", line 325, in get_requires_for_build_wheel
return self._get_build_requires(config_settings, requirements=['wheel'])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/tmp/pip-build-env-3i_ec6o7/overlay/lib/python3.11/site-packages/setuptools/build_meta.py", line 295, in _get_build_requires
self.run_setup()
File "/tmp/pip-build-env-3i_ec6o7/overlay/lib/python3.11/site-packages/setuptools/build_meta.py", line 311, in run_setup
exec(code, locals())
File "<string>", line 155, in <module>
File "<string>", line 49, in get_config_posix
File "<string>", line 28, in find_package_name
Exception: Can not find valid pkg-config name.
Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually
[end of output]
note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error
× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> See above for output.
note: This error originates from a subprocess, and is likely not a problem with pip.
方法1: CFLAGS環境変数を設定してからインストールする
CFLAGS環境変数の設定
まず、CFLAGS環境変数を設定します。これにより、コンパイラが適切な標準を使用するように指示します。
export CFLAGS="-std=c99"
mysqlclientのインストール
CFLAGSを設定した後で、mysqlclientを再インストールします。
pip3 install mysqlclient
結果：
pip3 install mysqlclient
Collecting mysqlclient==2.2.4
Downloading mysqlclient-2.2.4.tar.gz (90 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 90/90 kB 526.4 kB/s eta 0:00:00
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) ... done
...
Successfully built mysqlclient
Installing collected packages: mysqlclient
Successfully installed mysqlclient-2.2.4
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
方法2: mysqlclientの古いバージョン（2.0.1）をインストールする
mysqlclientのバージョン2.0.1をインストール
最新バージョンではなく、互換性のあるバージョン2.0.1をインストールします。
pip3 install mysqlclient==2.0.1
結果：
Building wheels for collected packages: mysqlclient Building wheel for mysqlclient (pyproject.toml) ... done Created wheel for mysqlclient: filename=mysqlclient-2.0.1-cp311-cp311-linux_x86_64.whl size=99155 sha256=2ca7f0039e4aecce198e3980da64bfd7a7152882c4a11715cd435cac8479c803 Stored in directory: /root/.cache/pip/wheels/03/23/0e/db44c43d8e8291c2c5769c7c611ad4581d29cc73e6b60db5f5 Successfully built mysqlclient Installing collected packages: mysqlclient Successfully installed mysqlclient-2.0.1