前提・実現したいこと
alembicでDBマイグレーションがしたい。
OS:MacOS Mojave 10.14.5
発生している問題・エラーメッセージ
https://pypi.org/project/mysqlclient/
↑に従ってmysqlclientをpipenv isntallしている際に発生。
ここのmysql_configおよびopensslの設定はしている。
brew install mysql-connector-c
を叩くと以下のエラーになる。
mysqlとmysql-connector-cは共存できないのでしょうか?
Updating Homebrew... ==> Auto-updated Homebrew! Updated 1 tap (homebrew/core). ==> Updated Formulae atomist-cli platformio Error: Cannot install mysql-connector-c because conflicting formulae are installed. mysql: because both install MySQL client libraries Please `brew unlink mysql` before continuing. Unlinking removes a formula's symlinks from /usr/local. You can link the formula again after the install finishes. You can --force this install, but the build may fail or cause obscure side effects in the resulting software.
事前にmysqlはbrew install済
この状態で、alembic upgrade headすると。
Traceback (most recent call last): File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/bin/alembic", line 10, in <module> sys.exit(main()) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/alembic/config.py", line 540, in main CommandLine(prog=prog).main(argv=argv) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/alembic/config.py", line 534, in main self.run_cmd(cfg, options) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/alembic/config.py", line 514, in run_cmd **dict((k, getattr(options, k, None)) for k in kwarg) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/alembic/command.py", line 276, in upgrade script.run_env() File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/alembic/script/base.py", line 475, in run_env util.load_python_file(self.dir, "env.py") File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/alembic/util/pyfiles.py", line 90, in load_python_file module = load_module_py(module_id, path) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/alembic/util/compat.py", line 177, in load_module_py spec.loader.exec_module(module) File "<frozen importlib._bootstrap_external>", line 728, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "alembic-db/env.py", line 75, in <module> run_migrations_online() File "alembic-db/env.py", line 60, in run_migrations_online poolclass=pool.NullPool, File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/sqlalchemy/engine/__init__.py", line 478, in engine_from_config return create_engine(url, **options) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/sqlalchemy/engine/__init__.py", line 435, in create_engine return strategy.create(*args, **kwargs) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 87, in create dbapi = dialect_cls.dbapi(**dbapi_args) File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 118, in dbapi return __import__("MySQLdb") File "/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/MySQLdb/__init__.py", line 18, in <module> from . import _mysql ImportError: dlopen(/Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so, 2): Library not loaded: /usr/local/opt/mysql-connector-c/lib/libmysqlclient.18.dylib Referenced from: /Users/kota-ishizuka/.local/share/virtualenvs/kotapypj-_J8aX8wv/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so Reason: image not found
試したこと
ここに書いている通り、brew unlink mysqlをするとinstallされるが、mysqlコマンドが打てなくなる。
補足情報(FW/ツールのバージョンなど)
Pipfileは以下の通りです。
[[source]] name = "pypi" url = "https://pypi.org/simple" verify_ssl = true [dev-packages] ipython = "==6.2.1" [packages] pandas = "*" selenium = "*" sqlalchemy = "*" pytest = "*" jupyter = "*" alembic = "*" django = "*" [requires] python_version = "3.7"
回答1件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。