Package installation fails after new release v2.2.0 #2

[maxsch3]

Hello.

This is the second report about this issue today. I have applied fixes from #620 but the installation still fails for RedHat/Centos based distribution (AWS docker for lambda functions - see example below). I can confirm that ubuntu-based distribution builds ok

Steps to reproduce:

1. Dockefile.test:

FROM public.ecr.aws/lambda/python:3.8

# The following code is required to install mysqlclient.
# This is required to get platform-common installed.
RUN yum install python3-devel mysql-devel pkgconfig -y

RUN pip install mysqlclient

2. Build the docker

docker build -t mysqlclient:latest -f Dockerfile.test .

This is the error I'm getting:

Step 3/3 : RUN pip install mysqlclient
 ---> Running in fbff414d2b81
Collecting mysqlclient
  Downloading mysqlclient-2.2.0.tar.gz (89 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 89.5/89.5 KB 2.3 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 'error'
  error: subprocess-exited-with-error
  
  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
  ╰─> [22 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.
      Traceback (most recent call last):
        File "/var/lang/lib/python3.8/site-packages/pip/_vendor/pep517/in_process/_in_process.py", line 363, in <module>
          main()
        File "/var/lang/lib/python3.8/site-packages/pip/_vendor/pep517/in_process/_in_process.py", line 345, in main
          json_out['return_val'] = hook(**hook_input['kwargs'])
        File "/var/lang/lib/python3.8/site-packages/pip/_vendor/pep517/in_process/_in_process.py", line 130, in get_requires_for_build_wheel
          return hook(config_settings)
        File "/tmp/pip-build-env-5_tjea0_/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 341, in get_requires_for_build_wheel
          return self._get_build_requires(config_settings, requirements=['wheel'])
        File "/tmp/pip-build-env-5_tjea0_/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 323, in _get_build_requires
          self.run_setup()
        File "/tmp/pip-build-env-5_tjea0_/overlay/lib/python3.8/site-packages/setuptools/build_meta.py", line 338, in run_setup
          exec(code, locals())
        File "<string>", line 154, in <module>
        File "<string>", line 48, in get_config_posix
        File "<string>", line 27, 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.
WARNING: You are using pip version 22.0.4; however, version 23.1.2 is available.
You should consider upgrading via the '/var/lang/bin/python3.8 -m pip install --upgrade pip' command.
The command '/bin/sh -c pip install mysqlclient' returned a non-zero code: 1

[methane]

I won't support every platform.
It's your responsibility to make pkg-config --cflags --libs mysqlclient work.

[maxsch3]

It turned out that Amazon's version of mysql-devel it is missing *.pc file required by pkgconfig. I ended up staying on 4.1.1 until this is resolved.

[methane]

When you can not use pkg-config, you should use MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS.

This is not a bug so no "fix" is planned.

[kegera]

Sounds good had this error and the solution is working.

[BwL1289]

For anyone on Darwin who installed mysql-client with brew and is on aarch64, run export PKG_CONFIG_PATH="/opt/homebrew/opt/mysql-client/lib/pkgconfig" prior to installing mysqlclient.