[
https://issues.apache.org/jira/browse/AIRFLOW-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16198293#comment-16198293
]
Gauri K commented on AIRFLOW-1693:
----------------------------------
When I used MYSQL 5.7, it is working fine. Is there a recommended mysql version
for the MYSQL backend?
> airflow initdb throws errors
> ----------------------------
>
> Key: AIRFLOW-1693
> URL: https://issues.apache.org/jira/browse/AIRFLOW-1693
> Project: Apache Airflow
> Issue Type: Bug
> Components: configuration, db
> Affects Versions: 1.8.0
> Environment: Mac OS, Python 3.6
> Reporter: Gauri K
> Priority: Blocker
> Labels: newbie
>
> I am having installation problems. The log for `airflow initdb` are
> Traceback (most recent call last):
> File "/Users/gauripradeep/ENVS/scheduler/bin/airflow", line 17, in <module>
> from airflow import configuration
> File
> "/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/airflow/__init__.py",
> line 30, in <module>
> from airflow import settings
> File
> "/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/airflow/settings.py",
> line 159, in <module>
> configure_orm()
> File
> "/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/airflow/settings.py",
> line 147, in configure_orm
> engine = create_engine(SQL_ALCHEMY_CONN, **engine_args)
> File
> "/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/sqlalchemy/engine/__init__.py",
> line 391, in create_engine
> return strategy.create(*args, **kwargs)
> File
> "/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/sqlalchemy/engine/strategies.py",
> line 80, in create
> dbapi = dialect_cls.dbapi(**dbapi_args)
> File
> "/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/sqlalchemy/dialects/mysql/mysqldb.py",
> line 110, in dbapi
> return __import__('MySQLdb')
> File
> "/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/MySQLdb/__init__.py",
> line 19, in <module>
> import _mysql
> ImportError:
> dlopen(/Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/_mysql.cpython-36m-darwin.so,
> 2): Library not loaded: /usr/local/opt/mysql/lib/libmysqlclient.20.dylib
> Referenced from:
> /Users/gauripradeep/ENVS/scheduler/lib/python3.6/site-packages/_mysql.cpython-36m-darwin.so
> Reason: image not found
> Other commands and dependencies
> pip3 install mysqlclient
> and pip3 install mysql-connector-python-rf
> pip3 install airflow[mysql]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
