Python MariaDB pip 安装失败,缺少 mariadb_config

2022-01-15 00:00:00 python python-3.x pip sql mariadb

问题描述

我正在使用 Linux Ubuntu 18.04 和 python 3.我正在尝试在 maria-db 和我的 python 脚本之间建立连接.因此我必须安装mariadb包.
我已经安装了:

I am using Linux Ubuntu 18.04 and python 3. I am trying to build a connection between a maria-db and my python scripts. Therefore I have to install the mariadb package.
I have already installed:

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('"'"'
'"'"', '"'"'
'"'"');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.
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.")
    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.

谁能帮帮我?

我现在已经能够连接到服务器,但不能使用 mariadb 包.(https://linuxhint.com/connect_mariadb_pymysql/)

I have now been able to connect to the server but not with te mariadb package. (https://linuxhint.com/connect_mariadb_pymysql/)


解决方案

要安装mariadb python 模块,您必须安装最新版本的MariaDB Connector/C,最低要求版本为3.1.5,afaik Ubuntu 18.04 有3.0.3.

To install mariadb python module, you have to install a recent version of MariaDB Connector/C, minimum required version is 3.1.5, afaik Ubuntu 18.04 has 3.0.3.

上提供了用于仿生的 Connector/C 的实际版本MariaDB 连接器/C 下载页面.

如果要将其安装在特殊目录中,请确保 PATH 和 LD_LIBRARY_PATH 指向 bin 和 lib 目录.

If you want to install it in a special directory, make sure that the PATH and LD_LIBRARY_PATH point to bin and lib directories.

我还建议使用最新版本的 MariaDB Server,尤其是非常快的 executemany() 方法在 MariaDB Server 上会慢得多

10.2.

I also recommend to use a recent version of MariaDB Server, especially the very fast executemany() method will be much slower on MariaDB Server < 10.2.

相关文章