我正在使用Linux Ubuntu 18.04和python3。我正在尝试在maria- db和我的python脚本之间建立连接。因此,我必须安装mariadb软件包。 我已经安装了:
sudo apt install mariadb-server
但是当我尝试:
pip install mariadb
我收到以下错误:
Collecting mariadb Using cached mariadb-1.0.0.tar.gz (78 kB) ERROR: Command errored out with exit status 1: command: /home/niklas/Desktop/Stuff/venv/bin/python -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pycharm-packaging/mariadb/setup.py'"'"'; __file__='"'"'/tmp/pycharm-packaging/mariadb/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-wfnscxnz cwd: /tmp/pycharm-packaging/mariadb/ Complete output (12 lines): /bin/sh: 1: mariadb_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pycharm-packaging/mariadb/setup.py", line 26, in <module> cfg = get_config(options) File "/tmp/pycharm-packaging/mariadb/mariadb_posix.py", line 49, in get_config cc_version = mariadb_config(config_prg, "cc_version") File "/tmp/pycharm-packaging/mariadb/mariadb_posix.py", line 27, in mariadb_config "mariadb_config not found.\nPlease make sure, that MariaDB Connector/C is installed on your system, edit the configuration file 'site.cfg' and set the 'mariadb_config'\noption, which should point to the mariadb_config utility.") OSError: mariadb_config not found. Please make sure, that MariaDB Connector/C is installed on your system, edit the configuration file 'site.cfg' and set the 'mariadb_config' option, which should point to the mariadb_config utility. ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
有谁能够帮我 ?
编辑:
现在,我已经可以连接到服务器,但不能使用te mariadb软件包。(https://linuxhint.com/connect_mariadb_pymysql/)
要安装mariadb python模块,您必须安装最新版本的MariaDB Connector / C,最低要求版本为3.1.5,afaik Ubuntu 18.04的版本为3.0.3。
MariaDB Connector / C下载页面上提供了用于仿生的Connector / C的实际版本 。
如果要将其安装在特殊目录中,请确保PATH和LD_LIBRARY_PATH指向bin和lib目录。
我还建议使用最新版本的MariaDB Server,尤其是在MariaDB Server <10.2上,非常快的executemany()方法会慢得多。