Feature #7751
closeduse pymysql in sinedon instead of MySQL-python
0%
Description
MySQL-python that is used by sinedon is not supported by python 3.5+ and does not support reconnect. This change will allow us to move forward.
Updated by Anchi Cheng almost 5 years ago
pymysql can be installed with pip.
For CentOS 6 and python 2.6 use the tested compatible version.
pip install pymysql==0.7.11
For CentOS7 and python 2.7 use the current version
pip install pymysql
For Windows, download and install 2.7.16 and then from cmd.exe
cd C:\Python27\Scripts pip install pymysql
pymysql is more strict in database structure and gives error when multiple keys are assigned to indexed field.
This created Issue #7753
Updated by Anchi Cheng almost 5 years ago
d6291bcf4 handles missing column in query of a table not yet has the column. In addition, replaced error instances.
Updated by Anchi Cheng over 3 years ago
- Status changed from New to Closed
- Assignee set to Anchi Cheng
- Target version set to Appion/Leginon 3.5
works.
Please use myami-pymysql branch on linux where you must use pymysql.
Updated by Anchi Cheng over 3 years ago
We are not yet converted to use this in myami-trunk and future release. But myami-pymysql will be maintained at slightly behind myami-beta in feature.
Updated by Anchi Cheng almost 2 years ago
leginon is now fully converted to use pymysql in myami-3.6. There are still a few appion scripts using the old system.