search

Altinity / clickhouse-mysql-data-reader

utility to read mysql data
MIT License
368 stars 94 forks source link

Can't call datareader as an app? Install option not working... #191

Closed sv3t0sl4v closed 3 years ago

sv3t0sl4v commented 3 years ago

Hi!

It seems I can't run data reader as a server.

which clickhouse-mysql /usr/local/bin/clickhouse-mysql

/usr/local/bin/clickhouse-mysql --install Traceback (most recent call last): File "/usr/local/bin/clickhouse-mysql", line 5, in from clickhouse_mysql import main File "/usr/local/lib/python3.8/dist-packages/clickhouse_mysql/init.py", line 4, in from .main import Main File "/usr/local/lib/python3.8/dist-packages/clickhouse_mysql/main.py", line 21, in from clickhouse_mysql.config import Config File "/usr/local/lib/python3.8/dist-packages/clickhouse_mysql/config.py", line 4, in from clickhouse_mysql.reader.mysqlreader import MySQLReader File "/usr/local/lib/python3.8/dist-packages/clickhouse_mysql/reader/mysqlreader.py", line 8, in from pymysqlreplication import BinLogStreamReader File "/usr/local/lib/python3.8/dist-packages/pymysqlreplication/init.py", line 23, in from .binlogstream import BinLogStreamReader File "/usr/local/lib/python3.8/dist-packages/pymysqlreplication/binlogstream.py", line 9, in from pymysql.util import int2byte ModuleNotFoundError: No module named 'pymysql.util'

Ideas how to solve? OS - Ubuntu 20.04.2, MySQL 5.7. Thanks!

sv3t0sl4v commented 3 years ago

Solved by installing older version of pymysql with pip3 install "PyMySQL==0.9.3"