{"id":1161,"date":"2020-09-07T22:24:23","date_gmt":"2020-09-07T13:24:23","guid":{"rendered":"https:\/\/dalomo.net\/blog\/?p=1161"},"modified":"2020-09-12T13:59:08","modified_gmt":"2020-09-12T04:59:08","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%9f%e3%82%b5%e3%82%a4%e3%83%88%e3%82%92%e4%bd%9c%e3%82%8a%e3%81%9f%e3%81%84%e2%91%a6-python%e3%81%a7mariadb","status":"publish","type":"post","link":"https:\/\/dalomo.net\/blog\/2020\/09\/07\/1161\/","title":{"rendered":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3063\u305f\u30b5\u30a4\u30c8\u3092\u4f5c\u308a\u305f\u3044\u2466 Python\u3067MariaDB\u3078\u30c7\u30fc\u30bf\u66f4\u65b0\uff5c\u6e96\u5099\u7de8"},"content":{"rendered":"

MariaDB Connector\/Python<\/h1>\n

\u30b9\u30af\u30ec\u30a4\u30d4\u30f3\u30b0\u3067Python\u3092\u4f7f\u3063\u305f\u306e\u3067\u3001\u305d\u306e\u307e\u307e\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092DB\u306b\u66f4\u65b0\u3057\u305f\u3044\u306a\u30fc\u3068\u601d\u3063\u305f\u3002\u63a2\u3057\u305f\u3089\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u3042\u308b\u307f\u305f\u3044\u3002\u306a\u3093\u304b\u65e5\u672c\u8a9e\u306e\u60c5\u5831\u304c\u5c11\u306a\u3044\u6c17\u304c\u3059\u308b\u3051\u3069\u306a\u3093\u3067\u3060\u308d\u3002<\/p>\n

https:\/\/mariadb.com\/ja\/resources\/blog\/how-to-connect-python-programs-to-mariadb\/<\/a><\/p>\n

https:\/\/pypi.org\/project\/mariadb\/<\/a><\/p>\n

https:\/\/mariadb-corporation.github.io\/mariadb-connector-python\/<\/a><\/p>\n

\u6e96\u5099<\/h2>\n
$ pip install mariadb<\/code><\/pre>\n
\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u2026\u30a8\u30e9\u30fc\u51fa\u305f\u3002<\/p>\n
ERROR: Command errored out with exit status 1:\r\n     command: \/usr\/local\/bin\/python3.8 -c 'import sys, setuptools, tokenize; sys.argv[0] = '\"'\"'\/tmp\/pip-install-e_qwrg9i\/mariadb\/setup.py'\"'\"'; __file__='\"'\"'\/tmp\/pip-install-e_qwrg9i\/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-pe46t1ak\r\n         cwd: \/tmp\/pip-install-e_qwrg9i\/mariadb\/\r\n    Complete output (12 lines):\r\n    \/bin\/sh: mariadb_config: command not found\r\n    Traceback (most recent call last):\r\n      File \"\", line 1, in \r\n      File \"\/tmp\/pip-install-e_qwrg9i\/mariadb\/setup.py\", line 26, in \r\n        cfg = get_config(options)\r\n      File \"\/tmp\/pip-install-e_qwrg9i\/mariadb\/mariadb_posix.py\", line 51, in get_config\r\n        cc_version = mariadb_config(config_prg, \"cc_version\")\r\n      File \"\/tmp\/pip-install-e_qwrg9i\/mariadb\/mariadb_posix.py\", line 28, in mariadb_config\r\n        raise EnvironmentError(\r\n    OSError: mariadb_config not found.\r\n    Please make sure, that MariaDB Connector\/C is installed on your system, edit the configuration file 'site.cfg' and set the 'mariadb_config'\r\n    option, which should point to the mariadb_config utility.\r\n    ----------------------------------------\r\nERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.<\/code><\/pre>\n
mariadb_config\u304c\u7121\u3044\uff1f\u3053\u3063\u304b\u3089\u3044\u308d\u3044\u308d\u8abf\u3079\u305f\u3051\u3069\u4f55\u304c\u52b9\u3044\u305f\u304b\u5206\u304b\u3089\u3093\u3002<\/p>\n
MariaDB\u3092\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8<\/h3>\n
https:\/\/mariadb.com\/kb\/en\/upgrading-from-mariadb-55-to-mariadb-100\/<\/a><\/p>\n
https:\/\/qiita.com\/egnr-in-6matroom\/items\/6dbb684ff03a228947bd<\/a><\/p>\n
https:\/\/mariadb.com\/kb\/en\/mariadb-package-repository-setup-and-usage\/<\/a><\/p>\n
$ curl -sS https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup | sudo bash\r\n[info] Repository file successfully written to \/etc\/yum.repos.d\/mariadb.repo\r\n[info] Adding trusted package signing keys...\r\n[info] Successfully added trusted package signing keys<\/code><\/pre>\n
\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u767b\u9332\u3002<\/p>\n
$ sudo systemctl stop mariadb\r\n$ sudo yum update mariadb-server<\/code><\/pre>\n
\u6b62\u3081\u3066\u30a2\u30d7\u30c7\u3002<\/p>\n
$ sudo yum remove MariaDB-server<\/code><\/pre>\n
\u306a\u3093\u304b\u3053\u308c\u3084\u3063\u3066\u304b\u3089\u306e\u65b9\u304c\u3044\u3044\u3089\u3057\u3044\u304c\u3084\u3063\u3066\u306a\u3044\u3002<\/p>\n
$ sudo systemctl start mariadb<\/code><\/pre>\n
\u8d77\u52d5<\/p>\n
$ mysql -u root -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 3\r\nServer version: 10.5.5-MariaDB MariaDB Server<\/code><\/pre>\n
\u3067\u304d\u305f\u3063\u307d\u3044\u30025.5\u219210.5\u306b\u306a\u3063\u305f\u3002<\/p>\n
mariadb-connector-c<\/h3>\n
https:\/\/stackoverflow.com\/questions\/62584959\/python-mariadb-pip-install-failed-missing-mariadb-config<\/a><\/p>\n
https:\/\/github.com\/mariadb-corporation\/mariadb-connector-c\/wiki\/prerequisites<\/a><\/p>\n
gcc --version\r\ngcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39)<\/code><\/pre>\n
gcc\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d<\/p>\n
$ yum install cmake<\/code><\/pre>\n
cmake\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n
yum install curl<\/code><\/pre>\n
curl\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n
\u3093\uff1f\u3053\u308c\u3063\u3066\u30bd\u30fc\u30b9\u304b\u3089\u30d3\u30eb\u30c9\u3059\u308b\u611f\u3058\uff1f\u3084\u3079\u3047\u5206\u304b\u3089\u3093\u3002<\/p>\n
https:\/\/stackoverflow.com\/questions\/51603067\/installing-connector-c-for-mariadb<\/a><\/p>\n
sudo yum install MariaDB-devel<\/code><\/pre>\n
\u3053\u3063\u3061\u3002\u3067\u3082\u8272\u3005\u3084\u3063\u305f\u3051\u3069error: command ‘gcc’ failed with exit status 1\u3066\u3044\u3046\u306e\u304c\u51fa\u3066\u7d50\u5c40pip3 install mariadb\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u3093\u3002<\/p>\n
\u540c\u3058\u30da\u30fc\u30b8\u306e<\/p>\n
sudo yum -y install git gcc openssl-devel make cmake\r\ngit clone https:\/\/github.com\/MariaDB\/mariadb-connector-c.git\r\nmkdir build && cd build\r\ncmake ..\/mariadb-connector-c\/ -DCMAKE_INSTALL_PREFIX=\/usr\r\nmake\r\nsudo make install<\/code><\/pre>\n
\u4e00\u884c\u305a\u3064\u3084\u308b\u3002\u3067\u3082\u3063\u304b\u3044<\/p>\n
pip3 install mariadb\r\nCollecting mariadb\r\n  Using cached mariadb-1.0.1.tar.gz (65 kB)\r\nUsing legacy 'setup.py install' for mariadb, since package 'wheel' is not installed.\r\nInstalling collected packages: mariadb\r\n    Running setup.py install for mariadb ... done\r\nSuccessfully installed mariadb-1.0.1<\/code><\/pre>\n
\u3044\u3051\u305f\u2026\uff1f<\/p>\n
\u8a66\u3059<\/h3>\n
create database test;<\/code><\/pre>\n
\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u3063\u3068\u304f\u3002Basic usage\u306b\u3042\u308b<\/p>\n
# Import MariaDB Connector\/Python module\r\nimport mariadb\r\n\r\n# Establish a connection\r\nconnection= mariadb.connect(user=\"myuser\", database=\"test\", host=\"localhost\")\r\n\r\ncursor= connection.cursor()\r\n\r\n# Create a database table\r\ncursor.execute(\"DROP TABLE IF EXISTS mytest\")\r\ncursor.execute(\"CREATE TABLE mytest(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,\"\r\n               \"first_name VARCHAR(100), last_name VARCHAR(100))\")\r\n\r\n\r\n# Populate table with some data\r\ncursor.execute(\"INSERT INTO mytest(first_name, last_name) VALUES (?,?)\",\r\n               (\"Robert\", \"Redford\"))\r\n\r\n# retrieve data\r\ncursor.execute(\"SELECT id, first_name, last_name FROM mytest\")\r\n\r\n# print content\r\nrow= cursor.fetchone()\r\nprint(*row, sep='\\t')\r\n\r\n# free resources\r\ncursor.close()\r\nconnection.close()<\/code><\/pre>\n
\u3060\u3051\u3069\u3001<\/p>\n
#\u3053\u3053\u306b\r\nconnection= mariadb.connect(user=\"myuser\", database=\"test\", host=\"localhost\")<\/code> #\u30d1\u30b9\u30ef\u30fc\u30c9\u5165\u308c\u305f connection= mariadb.connect(user=\"myuser\",password=\"password\", database=\"test\", host=\"localhost\")<\/code><\/pre>\n
\u3058\u3083\u30fc\u5b9f\u884c<\/p>\n
python3 dbtest.py\r\nTraceback (most recent call last):\r\n  File \"dbtest.py\", line 2, in \r\n    import mariadb\r\n  File \"\/usr\/local\/lib\/python3.8\/site-packages\/mariadb\/__init__.py\", line 7, in \r\n    from ._mariadb import (\r\nImportError: libmariadb.so.3: cannot open shared object file: No such file or directory<\/code><\/pre>\n
\u307e\u305f\u30a8\u30e9\u30fc\u304b\u3088\u304a\u304a\u304a\u304a\u2026\u3002\u75b2\u308c\u3066\u304d\u3061\u3083\u3063\u305f\u2026\u3002\u3069\u3046\u3084\u3089\u30d1\u30b9\u304c\u901a\u3063\u3066\u306a\u3044\u305f\u3081\u306b\u8d77\u304d\u308b\u30a8\u30e9\u30fc\u3089\u3057\u3044\u3002<\/p>\n
ImportError: libmariadb.so.3: cannot open shared object file: No such file or directory<\/h4>\n
$ sudo find \/ -name libmariadb.so.3\r\n\/root\/build\/libmariadb\/libmariadb.so.3\r\n\/usr\/lib\/mariadb\/libmariadb.so.3<\/code><\/pre>\n
\u63a2\u3059\u3068\u898b\u3064\u304b\u308b\u3002<\/p>\n
$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:\/usr\/lib\/mariadb<\/code><\/pre>\n
\u3053\u3046\u3002\u3067\u3082\u3063\u304b\u3044<\/p>\n
$ python3 \/home\/dalomo\/shogi\/dbtest.py<\/code><\/pre>\n
\u7d50\u679c<\/p>\n
Traceback (most recent call last):\r\n  File \"\/home\/dalomo\/shogi\/dbtest.py\", line 5, in \r\n    connection= mariadb.connect(user=\"\",password=\"\", database=\"test\", host=\"localhost\")\r\nmariadb.OperationalError: Can't connect to local MySQL server through socket '\/tmp\/mysql.sock' (2)<\/code><\/pre>\n
\u3061\u3087\u3063\u3068\u9032\u3093\u3060\uff01\u3051\u3069\u3001\u307e\u305f\u30a8\u30e9\u30fc\u3060\u2026\u3002\u3053\u308c\u306f\u3061\u3087\u3063\u3068\u7f6e\u3044\u3068\u3044\u3066\u3001\u3055\u3063\u304d\u306e\u30d1\u30b9\u306e\u901a\u3057\u65b9\u306f\u4e00\u6642\u7684\u306a\u3082\u306e\u3089\u3057\u3044\u3002\u306e\u3067\u6c38\u7d9a\u7684\u306b\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n
https:\/\/qiita.com\/Esfahan\/items\/0064d845ca6faf7f3d47<\/a><\/p>\n
\u3053\u3053\u898b\u306a\u304c\u3089<\/p>\n
$ ldconfig -p | grep maria\r\n        libmariadbd.so.19 (libc6,x86-64) => \/lib64\/libmariadbd.so.19\r\n        libmariadbd.so (libc6,x86-64) => \/lib64\/libmariadbd.so<\/code><\/pre>\n
\u78ba\u8a8d\u3057\u3066\u307f\u305f\u3051\u3069\u7121\u3044\u3002\u305d\u3057\u305f\u3089<\/p>\n
$ vi \/etc\/ld.so.conf.d\/mariadb-3.1.9.conf<\/code><\/pre>\n
\u3067<\/p>\n
\/usr\/lib\/mariadb<\/code><\/pre>\n
\u3092\u65b0\u898f\u306b\u66f8\u3044\u3066\u4fdd\u5b58\u3002<\/p>\n
$ ldconfig<\/code><\/pre>\n
\u66f4\u65b0\u3057\u3066\u78ba\u8a8d\u3057\u3066\u307f\u308b\u3002<\/p>\n
$ ldconfig -p | grep maria\r\n        libmariadbd.so.19 (libc6,x86-64) => \/lib64\/libmariadbd.so.19\r\n        libmariadbd.so (libc6,x86-64) => \/lib64\/libmariadbd.so\r\n        libmariadb.so.3 (libc6,x86-64) => \/usr\/lib\/mariadb\/libmariadb.so.3\r\n        libmariadb.so (libc6,x86-64) => \/usr\/lib\/mariadb\/libmariadb.so<\/code><\/pre>\n
\u3088\u3055\u3052\u3002<\/p>\n
mariadb.OperationalError: Can't connect to local MySQL server through socket '\/tmp\/mysql.sock' (2)<\/code><\/pre>\n
\u305d\u3057\u305f\u3089\u3053\u306e\u30a8\u30e9\u30fc\u3092\u3069\u3046\u306b\u304b\u3057\u305f\u3044\u3002<\/p>\n
mariadb.OperationalError: Can’t connect to local MySQL server through socket ‘\/tmp\/mysql.sock’ (2)<\/h4>\n
\u306a\u3093\u304b<\/p>\n
http:\/\/www.hi-ho.ne.jp\/tsumiki\/book_sup2.html<\/a><\/p>\n
\u30bd\u30b1\u30c3\u30c8\u304c\u7121\u3044\u3002\u3082\u3057\u304f\u306fpython\u304c\u4f7f\u304a\u3046\u3068\u3057\u3066\u308b\u30bd\u30b1\u30c3\u30c8\u3068DB\u304c\u4f7f\u3063\u3066\u308b\u30bd\u30b1\u30c3\u30c8\u304c\u4e00\u81f4\u3057\u3066\u306a\u3044\u3002\u307f\u305f\u3044\u306a\u3002MariaDB\u304c\u4f7f\u3063\u3066\u308b\u30bd\u30b1\u30c3\u30c8\u3092\u8abf\u3079\u308b\u3002<\/p>\n
$ mariadb_config --socket\r\n\/tmp\/mysql.sock<\/code><\/pre>\n
\u3048\u30fc\u3001\u305d\u3046\u306a\u306e\uff1f\u3093\u30fcDB\u304c\u4f7f\u3063\u3066\u308b\u30bd\u30b1\u30c3\u30c8\u3092\u5909\u66f4\u3059\u308b\u306e\u306f\u306a\u3093\u304b\u6016\u3044\u306a\u3002\u3061\u3087\u3063\u3068\u8abf\u3079\u308b\u3068<\/p>\n
https:\/\/stackoverflow.com\/questions\/16325607\/cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock<\/a><\/p>\n
\u3053\u3053\u306b<\/p>\n
\n