search

gilestrolab / ethoscope

a platform from monitoring animal behaviour in real time from a raspberry pi
http://lab.gilest.ro/ethoscope/
GNU General Public License v3.0
17 stars 25 forks source link

Ethoscope cannot connect to mariadb server with new connector update (8.0.30) #177

Closed ggilestro closed 1 year ago

ggilestro commented 1 year ago

New images (2022) sport a new version of python-mysql-connector (8.0.30). This means the syntax to connect to mariadb databases is now different (as per here). This makes the SQLwriter fail miserably.

pepelisu commented 1 year ago

commit 3475e8ee485f5b6892aaff4a752661b4a0ba7cf0 uses import from ethoscope src. In my installation, the module ethoscope is not instalelled by default in the node. That means that in a normal installed node, the ethoscope module does not exist and the importing is falling:

Oct 17 10:12:33 node python[289212]:   File "/opt/ethoscope-node/node_src/ethoscope_node/utils/mysql_backup.py", line 9, in <module>
Oct 17 10:12:33 node python[289212]:     from ethoscope.utils.io import SQL_CHARSET
Oct 17 10:12:33 node python[289212]: ModuleNotFoundError: No module named 'ethoscope'
ggilestro commented 1 year ago

Sorry about that. I believe (I hope) that in the default node installation (the one that comes with the liveCD) the ethoscope libraries are properly installed. If not, this can be done easily with the following command:

cd /opt/ethoscope-node/src
sudo python setup.py develop