[Build] Incomplete LDFLAGS for custom mysqlclient libraries - rpath is missing #656

nradchenko · 2023-10-04T12:25:47Z

nradchenko
Oct 4, 2023

What OS and which version do you use?

Ubuntu 22.04

How did you installed mysql client library?

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-5.7.42.tar.gz
cd mysql-5.7.42
cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql -DCMAKE_BUILD_TYPE=RelWithDebInfo -DINSTALL_LIBDIR=lib/x86_64-linux-gnu -DWITHOUT_SERVER=ON -DWITH_SSL=/opt/openssl  -DWITH_BOOST=boost
make
make install

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

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

How did you tried to install mysqlclient?

pip3 install --user mysqlclient==2.2.0

Output of building mysqlclient

root@cofrhxbnfn:~# rm -rf .cache/pip; pip3 install --user mysqlclient==2.2.0 --log /dev/stdout |& grep -v -e 'Found link' -e 'Skipping link'                                                                         
2023-10-04T12:23:09,181 Using pip 23.2.1 from /root/.local/lib/python3.10/site-packages/pip (python 3.10) 
2023-10-04T12:23:09,182 User install by explicit request                 
2023-10-04T12:23:09,361 Created temporary directory: /tmp/pip-build-tracker-8g5cy8br                                                                                                                                 
2023-10-04T12:23:09,361 Initialized build tracking at /tmp/pip-build-tracker-8g5cy8br                                                                                                                                
2023-10-04T12:23:09,362 Created build tracker: /tmp/pip-build-tracker-8g5cy8br                                                                                                                                       
2023-10-04T12:23:09,362 Entered build tracker: /tmp/pip-build-tracker-8g5cy8br                            
2023-10-04T12:23:09,363 Created temporary directory: /tmp/pip-install-oqw822_z                                                                                                                                       
2023-10-04T12:23:09,365 Created temporary directory: /tmp/pip-ephem-wheel-cache-f1ui4w_m                                                                                                                             
2023-10-04T12:23:09,377 1 location(s) to search for versions of mysqlclient:                                                                                                                                         
2023-10-04T12:23:09,377 * https://pypi.org/simple/mysqlclient/                                                                                                                                                       
2023-10-04T12:23:09,378 Fetching project page and analyzing links: https://pypi.org/simple/mysqlclient/                                                                                                              
2023-10-04T12:23:09,378 Getting page https://pypi.org/simple/mysqlclient/
2023-10-04T12:23:09,379 Found index url https://pypi.org/simple/
2023-10-04T12:23:09,610 Fetched page https://pypi.org/simple/mysqlclient/ as application/vnd.pypi.simple.v1+json
2023-10-04T12:23:09,681 Given no hashes to check 1 links for project 'mysqlclient': discarding no candidates
Collecting mysqlclient==2.2.0
2023-10-04T12:23:09,697 Collecting mysqlclient==2.2.0 
2023-10-04T12:23:09,698   Created temporary directory: /tmp/pip-unpack-vuti8d1n
  Downloading mysqlclient-2.2.0.tar.gz (89 kB)
2023-10-04T12:23:10,042   Downloading mysqlclient-2.2.0.tar.gz (89 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 89.5/89.5 kB 1.2 MB/s eta 0:00:00
2023-10-04T12:23:10,143   Added mysqlclient==2.2.0 from https://files.pythonhosted.org/packages/de/9c/b176826e8994551ce826404dab97e305a4bb76c8b0a4e016fabda2901c71/mysqlclient-2.2.0.tar.gz to build tracker '/tmp/pi
p-build-tracker-8g5cy8br'                            
2023-10-04T12:23:10,146   Created temporary directory: /tmp/pip-build-env-2dd29lhw
  Installing build dependencies: started
2023-10-04T12:23:10,148   Installing build dependencies: started
2023-10-04T12:23:10,149   Running command pip subprocess to install build dependencies
2023-10-04T12:23:10,667   Using pip 23.2.1 from /root/.local/lib/python3.10/site-packages/pip (python 3.10)
2023-10-04T12:23:11,645   Collecting setuptools>=61
2023-10-04T12:23:11,646     Obtaining dependency information for setuptools>=61 from https://files.pythonhosted.org/packages/bb/26/7945080113158354380a12ce26873dd6c1ebd88d47f5bc24e2c5bb38c16a/setuptools-68.2.2-py3
-none-any.whl.metadata                               
2023-10-04T12:23:11,851     Downloading setuptools-68.2.2-py3-none-any.whl.metadata (6.3 kB)
2023-10-04T12:23:11,967   Downloading setuptools-68.2.2-py3-none-any.whl (807 kB)
2023-10-04T12:23:12,116      ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 807.9/807.9 kB 6.0 MB/s eta 0:00:00
2023-10-04T12:23:12,588   Installing collected packages: setuptools
2023-10-04T12:23:13,330   Successfully installed setuptools-68.2.2
2023-10-04T12:23:13,331   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                   
  Installing build dependencies: finished with status 'done'
2023-10-04T12:23:13,823   Installing build dependencies: finished with status 'done'
  Getting requirements to build wheel: started
2023-10-04T12:23:13,825   Getting requirements to build wheel: started
2023-10-04T12:23:13,825   Running command Getting requirements to build wheel
2023-10-04T12:23:14,178   Trying pkg-config --exists mysqlclient
2023-10-04T12:23:14,178   # Options for building extention module:
2023-10-04T12:23:14,178     extra_compile_args: ['-I/opt/mysql/include', '-std=c99']
2023-10-04T12:23:14,178     extra_link_args: ['-L/opt/mysql/lib/x86_64-linux-gnu', '-lmysqlclient']
2023-10-04T12:23:14,178     define_macros: [('version_info', (2, 2, 0, 'final', 0)), ('__version__', '2.2.0')]
2023-10-04T12:23:14,179   running egg_info
2023-10-04T12:23:14,182   writing src/mysqlclient.egg-info/PKG-INFO
2023-10-04T12:23:14,184   writing dependency_links to src/mysqlclient.egg-info/dependency_links.txt
2023-10-04T12:23:14,185   writing top-level names to src/mysqlclient.egg-info/top_level.txt
2023-10-04T12:23:14,193   reading manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
2023-10-04T12:23:14,195   reading manifest template 'MANIFEST.in'
2023-10-04T12:23:14,197   adding license file 'LICENSE'
2023-10-04T12:23:14,200   writing manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
  Getting requirements to build wheel: finished with status 'done'
2023-10-04T12:23:14,253   Getting requirements to build wheel: finished with status 'done'
  Installing backend dependencies: started
2023-10-04T12:23:14,258   Installing backend dependencies: started
2023-10-04T12:23:14,260   Running command pip subprocess to install backend dependencies
2023-10-04T12:23:14,829   Using pip 23.2.1 from /root/.local/lib/python3.10/site-packages/pip (python 3.10)
2023-10-04T12:23:15,345   Collecting wheel
2023-10-04T12:23:15,346     Obtaining dependency information for wheel from https://files.pythonhosted.org/packages/b8/8b/31273bf66016be6ad22bb7345c37ff350276cfd46e389a0c2ac5da9d9073/wheel-0.41.2-py3-none-any.whl.
metadata                                             
2023-10-04T12:23:15,558     Downloading wheel-0.41.2-py3-none-any.whl.metadata (2.2 kB)
2023-10-04T12:23:15,602   Downloading wheel-0.41.2-py3-none-any.whl (64 kB)
2023-10-04T12:23:15,660      ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 64.8/64.8 kB 1.3 MB/s eta 0:00:00
2023-10-04T12:23:16,015   Installing collected packages: wheel
2023-10-04T12:23:16,090     Creating /tmp/pip-build-env-2dd29lhw/normal/local/bin
2023-10-04T12:23:16,091     changing mode of /tmp/pip-build-env-2dd29lhw/normal/local/bin/wheel to 755
2023-10-04T12:23:16,100   Successfully installed wheel-0.41.2
2023-10-04T12:23:16,101   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                   
  Installing backend dependencies: finished with status 'done'
2023-10-04T12:23:16,196   Installing backend dependencies: finished with status 'done'
2023-10-04T12:23:16,197   Created temporary directory: /tmp/pip-modern-metadata-ltqvpngb
  Preparing metadata (pyproject.toml): started
2023-10-04T12:23:16,198   Preparing metadata (pyproject.toml): started
2023-10-04T12:23:16,198   Running command Preparing metadata (pyproject.toml)
2023-10-04T12:23:16,545   Trying pkg-config --exists mysqlclient
2023-10-04T12:23:16,545   # Options for building extention module:
2023-10-04T12:23:16,545     extra_compile_args: ['-I/opt/mysql/include', '-std=c99']
2023-10-04T12:23:16,545     extra_link_args: ['-L/opt/mysql/lib/x86_64-linux-gnu', '-lmysqlclient']
2023-10-04T12:23:16,546     define_macros: [('version_info', (2, 2, 0, 'final', 0)), ('__version__', '2.2.0')]
2023-10-04T12:23:16,546   running dist_info
2023-10-04T12:23:16,549   creating /tmp/pip-modern-metadata-ltqvpngb/mysqlclient.egg-info
2023-10-04T12:23:16,551   writing /tmp/pip-modern-metadata-ltqvpngb/mysqlclient.egg-info/PKG-INFO
2023-10-04T12:23:16,552   writing dependency_links to /tmp/pip-modern-metadata-ltqvpngb/mysqlclient.egg-info/dependency_links.txt
2023-10-04T12:23:16,553   writing top-level names to /tmp/pip-modern-metadata-ltqvpngb/mysqlclient.egg-info/top_level.txt
2023-10-04T12:23:16,554   writing manifest file '/tmp/pip-modern-metadata-ltqvpngb/mysqlclient.egg-info/SOURCES.txt'
2023-10-04T12:23:16,562   reading manifest file '/tmp/pip-modern-metadata-ltqvpngb/mysqlclient.egg-info/SOURCES.txt'
2023-10-04T12:23:16,563   reading manifest template 'MANIFEST.in'
2023-10-04T12:23:16,565   adding license file 'LICENSE'
2023-10-04T12:23:16,567   writing manifest file '/tmp/pip-modern-metadata-ltqvpngb/mysqlclient.egg-info/SOURCES.txt'
2023-10-04T12:23:16,568   creating '/tmp/pip-modern-metadata-ltqvpngb/mysqlclient-2.2.0.dist-info'
  Preparing metadata (pyproject.toml): finished with status 'done'
2023-10-04T12:23:16,615   Preparing metadata (pyproject.toml): finished with status 'done'
2023-10-04T12:23:16,617   Source in /tmp/pip-install-oqw822_z/mysqlclient_82bbf1a4b36b43f8a7d6b5972db8458b has version 2.2.0, which satisfies requirement mysqlclient==2.2.0 from https://files.pythonhosted.org/pack
ages/de/9c/b176826e8994551ce826404dab97e305a4bb76c8b0a4e016fabda2901c71/mysqlclient-2.2.0.tar.gz          
2023-10-04T12:23:16,617   Removed mysqlclient==2.2.0 from https://files.pythonhosted.org/packages/de/9c/b176826e8994551ce826404dab97e305a4bb76c8b0a4e016fabda2901c71/mysqlclient-2.2.0.tar.gz from build tracker '/tm
p/pip-build-tracker-8g5cy8br'                        
2023-10-04T12:23:16,623 Created temporary directory: /tmp/pip-unpack-twee4b23
Building wheels for collected packages: mysqlclient
2023-10-04T12:23:16,624 Building wheels for collected packages: mysqlclient
2023-10-04T12:23:16,627   Created temporary directory: /tmp/pip-wheel-ohhdcmxu
2023-10-04T12:23:16,628   Destination directory: /tmp/pip-wheel-ohhdcmxu
  Building wheel for mysqlclient (pyproject.toml): started
2023-10-04T12:23:16,629   Building wheel for mysqlclient (pyproject.toml): started
2023-10-04T12:23:16,631   Running command Building wheel for mysqlclient (pyproject.toml)
2023-10-04T12:23:16,967   Trying pkg-config --exists mysqlclient
2023-10-04T12:23:16,967   # Options for building extention module:
2023-10-04T12:23:16,967     extra_compile_args: ['-I/opt/mysql/include', '-std=c99']
2023-10-04T12:23:16,967     extra_link_args: ['-L/opt/mysql/lib/x86_64-linux-gnu', '-lmysqlclient']
2023-10-04T12:23:16,967     define_macros: [('version_info', (2, 2, 0, 'final', 0)), ('__version__', '2.2.0')]
2023-10-04T12:23:16,967   running bdist_wheel
2023-10-04T12:23:16,976   running build
2023-10-04T12:23:16,977   running build_py
2023-10-04T12:23:16,979   creating build
2023-10-04T12:23:16,979   creating build/lib.linux-x86_64-cpython-310
2023-10-04T12:23:16,980   creating build/lib.linux-x86_64-cpython-310/MySQLdb
2023-10-04T12:23:16,981   copying src/MySQLdb/cursors.py -> build/lib.linux-x86_64-cpython-310/MySQLdb
2023-10-04T12:23:16,981   copying src/MySQLdb/times.py -> build/lib.linux-x86_64-cpython-310/MySQLdb
2023-10-04T12:23:16,982   copying src/MySQLdb/release.py -> build/lib.linux-x86_64-cpython-310/MySQLdb
2023-10-04T12:23:16,983   copying src/MySQLdb/connections.py -> build/lib.linux-x86_64-cpython-310/MySQLdb 
2023-10-04T12:23:16,984   copying src/MySQLdb/converters.py -> build/lib.linux-x86_64-cpython-310/MySQLdb
2023-10-04T12:23:16,985   copying src/MySQLdb/__init__.py -> build/lib.linux-x86_64-cpython-310/MySQLdb
2023-10-04T12:23:16,985   copying src/MySQLdb/_exceptions.py -> build/lib.linux-x86_64-cpython-310/MySQLdb 
2023-10-04T12:23:16,986   creating build/lib.linux-x86_64-cpython-310/MySQLdb/constants
2023-10-04T12:23:16,987   copying src/MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-cpython-310/MySQLdb/constants
2023-10-04T12:23:16,988   copying src/MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-cpython-310/MySQLdb/constants
2023-10-04T12:23:16,988   copying src/MySQLdb/constants/ER.py -> build/lib.linux-x86_64-cpython-310/MySQLdb/constants
2023-10-04T12:23:16,989   copying src/MySQLdb/constants/CR.py -> build/lib.linux-x86_64-cpython-310/MySQLdb/constants
2023-10-04T12:23:16,990   copying src/MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-cpython-310/MySQLdb/constants
2023-10-04T12:23:16,991   copying src/MySQLdb/constants/__init__.py -> build/lib.linux-x86_64-cpython-310/MySQLdb/constants
2023-10-04T12:23:16,992   running egg_info
2023-10-04T12:23:16,993   writing src/mysqlclient.egg-info/PKG-INFO
2023-10-04T12:23:16,995   writing dependency_links to src/mysqlclient.egg-info/dependency_links.txt
2023-10-04T12:23:16,996   writing top-level names to src/mysqlclient.egg-info/top_level.txt
2023-10-04T12:23:17,000   reading manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
2023-10-04T12:23:17,001   reading manifest template 'MANIFEST.in'
2023-10-04T12:23:17,003   adding license file 'LICENSE'
2023-10-04T12:23:17,005   writing manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
2023-10-04T12:23:17,006   copying src/MySQLdb/_mysql.c -> build/lib.linux-x86_64-cpython-310/MySQLdb
2023-10-04T12:23:17,008   running build_ext
2023-10-04T12:23:17,011   building 'MySQLdb._mysql' extension
2023-10-04T12:23:17,012   creating build/temp.linux-x86_64-cpython-310
2023-10-04T12:23:17,012   creating build/temp.linux-x86_64-cpython-310/src
2023-10-04T12:23:17,013   creating build/temp.linux-x86_64-cpython-310/src/MySQLdb
2023-10-04T12:23:17,014   x86_64-linux-gnu-gcc -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O2 -Wall -g -fstack-protector-strong -Wformat -Werror=format-security -g -fwrapv -O2 -fPIC "-Dversion_info=(2, 
2, 0, 'final', 0)" -D__version__=2.2.0 -I/usr/include/python3.10 -c src/MySQLdb/_mysql.c -o build/temp.linux-x86_64-cpython-310/src/MySQLdb/_mysql.o -I/opt/mysql/include -std=c99
2023-10-04T12:23:17,105   In file included from /usr/include/python3.10/Python.h:118,
2023-10-04T12:23:17,105                    from src/MySQLdb/_mysql.c:46:
2023-10-04T12:23:17,105   /usr/include/python3.10/cpython/pytime.h:150:60: warning: ‘struct timespec’ declared inside parameter list will not be visible outside of this definition or declaration
2023-10-04T12:23:17,105     150 | PyAPI_FUNC(int) _PyTime_FromTimespec(_PyTime_t *tp, struct timespec *ts);
2023-10-04T12:23:17,106         |                                                            ^~~~~~~~
2023-10-04T12:23:17,107   /usr/include/python3.10/cpython/pytime.h:155:56: warning: ‘struct timespec’ declared inside parameter list will not be visible outside of this definition or declaration
2023-10-04T12:23:17,107     155 | PyAPI_FUNC(int) _PyTime_AsTimespec(_PyTime_t t, struct timespec *ts);
2023-10-04T12:23:17,107         |                                                        ^~~~~~~~
2023-10-04T12:23:17,974   x86_64-linux-gnu-gcc -shared -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-Bsymbolic-functions -g -fwrapv -O2 build/temp.linux-x86_64-cpython-310/src/MySQLdb/_mysql.o -L/usr/lib/x86_64-linux-gnu 
-o build/lib.linux-x86_64-cpython-310/MySQLdb/_mysql.cpython-310-x86_64-linux-gnu.so -L/opt/mysql/lib/x86_64-linux-gnu -lmysqlclient                                                                                 
2023-10-04T12:23:18,011   installing to build/bdist.linux-x86_64/wheel
2023-10-04T12:23:18,011   running install
2023-10-04T12:23:18,022   running install_lib
2023-10-04T12:23:18,024   creating build/bdist.linux-x86_64
2023-10-04T12:23:18,025   creating build/bdist.linux-x86_64/wheel
2023-10-04T12:23:18,025   creating build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,026   copying build/lib.linux-x86_64-cpython-310/MySQLdb/cursors.py -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,027   copying build/lib.linux-x86_64-cpython-310/MySQLdb/_mysql.cpython-310-x86_64-linux-gnu.so -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,028   copying build/lib.linux-x86_64-cpython-310/MySQLdb/times.py -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,029   creating build/bdist.linux-x86_64/wheel/MySQLdb/constants
2023-10-04T12:23:18,030   copying build/lib.linux-x86_64-cpython-310/MySQLdb/constants/FIELD_TYPE.py -> build/bdist.linux-x86_64/wheel/MySQLdb/constants
2023-10-04T12:23:18,030   copying build/lib.linux-x86_64-cpython-310/MySQLdb/constants/FLAG.py -> build/bdist.linux-x86_64/wheel/MySQLdb/constants
2023-10-04T12:23:18,031   copying build/lib.linux-x86_64-cpython-310/MySQLdb/constants/ER.py -> build/bdist.linux-x86_64/wheel/MySQLdb/constants
2023-10-04T12:23:18,032   copying build/lib.linux-x86_64-cpython-310/MySQLdb/constants/CR.py -> build/bdist.linux-x86_64/wheel/MySQLdb/constants
2023-10-04T12:23:18,033   copying build/lib.linux-x86_64-cpython-310/MySQLdb/constants/CLIENT.py -> build/bdist.linux-x86_64/wheel/MySQLdb/constants
2023-10-04T12:23:18,033   copying build/lib.linux-x86_64-cpython-310/MySQLdb/constants/__init__.py -> build/bdist.linux-x86_64/wheel/MySQLdb/constants
2023-10-04T12:23:18,034   copying build/lib.linux-x86_64-cpython-310/MySQLdb/release.py -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,035   copying build/lib.linux-x86_64-cpython-310/MySQLdb/connections.py -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,036   copying build/lib.linux-x86_64-cpython-310/MySQLdb/_mysql.c -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,037   copying build/lib.linux-x86_64-cpython-310/MySQLdb/converters.py -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,037   copying build/lib.linux-x86_64-cpython-310/MySQLdb/__init__.py -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,038   copying build/lib.linux-x86_64-cpython-310/MySQLdb/_exceptions.py -> build/bdist.linux-x86_64/wheel/MySQLdb
2023-10-04T12:23:18,039   running install_egg_info
2023-10-04T12:23:18,041   Copying src/mysqlclient.egg-info to build/bdist.linux-x86_64/wheel/mysqlclient-2.2.0-py3.10.egg-info
2023-10-04T12:23:18,042   running install_scripts
2023-10-04T12:23:18,075   creating build/bdist.linux-x86_64/wheel/mysqlclient-2.2.0.dist-info/WHEEL
2023-10-04T12:23:18,076   creating '/tmp/pip-wheel-ohhdcmxu/.tmp-o_con23r/mysqlclient-2.2.0-cp310-cp310-linux_x86_64.whl' and adding 'build/bdist.linux-x86_64/wheel' to it
2023-10-04T12:23:18,078   adding 'MySQLdb/__init__.py'
2023-10-04T12:23:18,079   adding 'MySQLdb/_exceptions.py'
2023-10-04T12:23:18,082   adding 'MySQLdb/_mysql.c'
2023-10-04T12:23:18,097   adding 'MySQLdb/_mysql.cpython-310-x86_64-linux-gnu.so'
2023-10-04T12:23:18,100   adding 'MySQLdb/connections.py'
2023-10-04T12:23:18,101   adding 'MySQLdb/converters.py'
2023-10-04T12:23:18,103   adding 'MySQLdb/cursors.py' 
2023-10-04T12:23:18,104   adding 'MySQLdb/release.py' 
2023-10-04T12:23:18,105   adding 'MySQLdb/times.py'
2023-10-04T12:23:18,106   adding 'MySQLdb/constants/CLIENT.py'
2023-10-04T12:23:18,107   adding 'MySQLdb/constants/CR.py'
2023-10-04T12:23:18,109   adding 'MySQLdb/constants/ER.py'
2023-10-04T12:23:18,110   adding 'MySQLdb/constants/FIELD_TYPE.py'
2023-10-04T12:23:18,111   adding 'MySQLdb/constants/FLAG.py'
2023-10-04T12:23:18,112   adding 'MySQLdb/constants/__init__.py'
2023-10-04T12:23:18,114   adding 'mysqlclient-2.2.0.dist-info/LICENSE'
2023-10-04T12:23:18,115   adding 'mysqlclient-2.2.0.dist-info/METADATA'
2023-10-04T12:23:18,115   adding 'mysqlclient-2.2.0.dist-info/WHEEL'
2023-10-04T12:23:18,116   adding 'mysqlclient-2.2.0.dist-info/top_level.txt'
2023-10-04T12:23:18,117   adding 'mysqlclient-2.2.0.dist-info/RECORD'
2023-10-04T12:23:18,118   removing build/bdist.linux-x86_64/wheel
  Building wheel for mysqlclient (pyproject.toml): finished with status 'done'
2023-10-04T12:23:18,163   Building wheel for mysqlclient (pyproject.toml): finished with status 'done'
  Created wheel for mysqlclient: filename=mysqlclient-2.2.0-cp310-cp310-linux_x86_64.whl size=123752 sha256=75554920578112c2612081af150fe6e28dc9fe709fa3847251c08f0c9762c181
2023-10-04T12:23:18,165   Created wheel for mysqlclient: filename=mysqlclient-2.2.0-cp310-cp310-linux_x86_64.whl size=123752 sha256=75554920578112c2612081af150fe6e28dc9fe709fa3847251c08f0c9762c181
  Stored in directory: /root/.cache/pip/wheels/a4/f8/fd/0399687c0abd03c10c975ed56c692fcd3d0fb80440b5a661f1
2023-10-04T12:23:18,165   Stored in directory: /root/.cache/pip/wheels/a4/f8/fd/0399687c0abd03c10c975ed56c692fcd3d0fb80440b5a661f1
Successfully built mysqlclient
2023-10-04T12:23:18,171 Successfully built mysqlclient
Installing collected packages: mysqlclient
2023-10-04T12:23:18,523 Installing collected packages: mysqlclient

Successfully installed mysqlclient-2.2.0
2023-10-04T12:23:18,569 Successfully installed mysqlclient-2.2.0
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
2023-10-04T12:23:18,570 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
2023-10-04T12:23:18,575 Remote version of pip: 23.2.1
2023-10-04T12:23:18,576 Local version of pip:  23.2.1
2023-10-04T12:23:18,576 Was pip installed by pip? True
2023-10-04T12:23:18,577 Removed build tracker: '/tmp/pip-build-tracker-8g5cy8br'
root@cofrhxbnfn:~# echo $?
0
root@cofrhxbnfn:~# ldd .local/lib/python3.10/site-packages/MySQLdb/_mysql.cpython-310-x86_64-linux-gnu.so
        linux-vdso.so.1 (0x00007ffe2eac4000)
        libmysqlclient.so.20 => not found
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fd4befa0000)
        /lib64/ld-linux-x86-64.so.2 (0x00007fd4bf1e0000)
root@cofrhxbnfn:~#

nradchenko · 2023-10-04T12:42:49Z

nradchenko
Oct 4, 2023
Author

From my experience, pkg-config usually lists library names and their locations with --libs, and it's up to the installation scripts to set other necessary options to make the linking succeed. E.g. if you tell PHP, Python, etc configure script to pick up libraries like libcurl or libssl from non-standard locations (/usr, /usr/local) with pkg-config, they would be detected and configured properly despite not having -Wl,-rpath,... or so in their pkg-config pc files.

Looks like mysqlclient installer should examine library directories received from pkg-config and setup rpath when needed.

3 replies

nradchenko Oct 4, 2023
Author

Also see: #496 (comment)

methane Oct 4, 2023
Maintainer

and it's up to the installation scripts to set other necessary options to make the linking succeed.

Installation scripts doesn't know enough information for runtime (dynamic) linking.

E.g. if you tell PHP, Python, etc configure script to pick up libraries like libcurl or libssl from non-standard locations (/usr, /usr/local) with pkg-config, they would be detected and configured properly despite not having -Wl,-rpath,... or so in their pkg-config pc files.

Please tell me link that they automatically detect & configure rpath.

As far as I know, only example is --with-openssl-rpath=auto option in Python. But its default is no -- do not set rpath.

  --with-openssl-rpath=[DIR|auto|no]
                          Set runtime library directory (rpath) for OpenSSL
                          libraries, no (default): don't set rpath, auto:
                          auto-detect rpath from --with-openssl and
                          pkg-config, DIR: set an explicit rpath

I don't think automatically detect&set rpath is de-facto standard.
If you don't use standard places, you shoudn't expect all libraries works well without any manual configuration.

methane Oct 4, 2023
Maintainer

I tried to:

install openssl, xz (lzma), and sqlite3 with Homebrew (linuxbrew)
set PKG_CONFIG_PATH
build python

Python doesn't set any rpath automatically. They just use -L and -l options as pkg-config. And ld link to system libraries instead of linuxbrew libraries.

$ export PKG_CONFIG_PATH=/home/linuxbrew/.linuxbrew/lib/pkgconfig

$ pkg-config --libs --cflags liblzma
-I/home/linuxbrew/.linuxbrew/Cellar/xz/5.4.4/include -L/home/linuxbrew/.linuxbrew/Cellar/xz/5.4.4/lib -llzma

$ pkg-config --libs --cflags sqlite3
-I/home/linuxbrew/.linuxbrew/opt/sqlite/include -L/home/linuxbrew/.linuxbrew/opt/sqlite/lib -lsqlite3

$ pkg-config --libs --cflags openssl
-I/home/linuxbrew/.linuxbrew/Cellar/openssl@3/3.1.3/include -L/home/linuxbrew/.linuxbrew/Cellar/openssl@3/3.1.3/lib -lssl -lcrypto

$ ./configure --prefix=$HOME/local/python-dev && make -j8 && make install
...
ccache gcc -pipe -shared      Modules/_lzmamodule.o -L/home/linuxbrew/.linuxbrew/Cellar/xz/5.4.4/lib -llzma  -o Modules/_lzma.cpython-312-x86_64-linux-gnu.so
ccache gcc -pipe -shared      Modules/_sqlite/blob.o Modules/_sqlite/connection.o Modules/_sqlite/cursor.o Modules/_sqlite/microprotocols.o Modules/_sqlite/module.o Modules/_sqlite/prepare_protocol.o Modules/_sqlite/row.o Modules/_sqlite/statement.o Modules/_sqlite/util.o -L/home/linuxbrew/.linuxbrew/opt/sqlite/lib -lsqlite3  -o Modules/_sqlite3.cpython-312-x86_64-linux-gnu.so
ccache gcc -pipe -shared      Modules/_ssl.o -L/home/linuxbrew/.linuxbrew/Cellar/openssl@3/3.1.3/lib  -lssl -lcrypto  -o Modules/_ssl.cpython-312-x86_64-linux-gnu.so

$ cd /home/methane/local/python-dev/lib/python3.12/lib-dynload

$ ldd _sqlite3.cpython-312-x86_64-linux-gnu.so
	linux-vdso.so.1 (0x00007fffce4e8000)
	libsqlite3.so.0 => /lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007fe1123eb000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fe1121c3000)
	libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fe1120dc000)
	/lib64/ld-linux-x86-64.so.2 (0x00007fe112563000)

$ ldd _lzma.cpython-312-x86_64-linux-gnu.so
	linux-vdso.so.1 (0x00007fffdaf94000)
	liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007fdab9996000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fdab976e000)
	/lib64/ld-linux-x86-64.so.2 (0x00007fdab99d8000)

$ ldd _ssl.cpython-312-x86_64-linux-gnu.so
	linux-vdso.so.1 (0x00007ffd34915000)
	libssl.so.3 => /lib/x86_64-linux-gnu/libssl.so.3 (0x00007fc396ecf000)
	libcrypto.so.3 => /lib/x86_64-linux-gnu/libcrypto.so.3 (0x00007fc396a8d000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fc396865000)
	/lib64/ld-linux-x86-64.so.2 (0x00007fc396fb6000)

Have you confirmed your experience before saying "mysqlclient installer should..."?

methane · 2023-10-04T14:14:57Z

methane
Oct 4, 2023
Maintainer

Anyway, I can't do and maintain such script.
It is up to you that setting rpath.

0 replies

Navigation Menu

Uh oh!

[Build] Incomplete LDFLAGS for custom mysqlclient libraries - rpath is missing #656

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 2 comments 3 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Uh oh!

[Build] Incomplete LDFLAGS for custom mysqlclient libraries - rpath is missing #656

Uh oh!

Uh oh!

nradchenko Oct 4, 2023

What OS and which version do you use?

How did you installed mysql client library?

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

How did you tried to install mysqlclient?

Output of building mysqlclient

Replies: 2 comments · 3 replies

Uh oh!

nradchenko Oct 4, 2023 Author

Uh oh!

nradchenko Oct 4, 2023 Author

Uh oh!

methane Oct 4, 2023 Maintainer

Uh oh!

methane Oct 4, 2023 Maintainer

Uh oh!

methane Oct 4, 2023 Maintainer

nradchenko
Oct 4, 2023

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

Replies: 2 comments 3 replies

nradchenko
Oct 4, 2023
Author

nradchenko Oct 4, 2023
Author

methane Oct 4, 2023
Maintainer

methane Oct 4, 2023
Maintainer

methane
Oct 4, 2023
Maintainer