Error while searching library "MySQLdb"

Hi BP,

When I called function SGSConfigure it shown the message "ModuleNotFoundError: No module named 'MySQLdb'"

Here is the below running command.

pi@SwitchDocLabs:~/SDL_Pi_SmartGardenSystem2 $ sudo python3 SGSConfigure.py

Traceback (most recent call last):
File "SGSConfigure.py", line 12, in <module>
import scanForResources
File "/home/pi/SDL_Pi_SmartGardenSystem2/scanForResources.py", line 18, in <module>
import pclogging
File "/home/pi/SDL_Pi_SmartGardenSystem2/pclogging.py", line 21, in <module>
import MySQLdb as mdb
ModuleNotFoundError: No module named 'MySQLdb'

Thanks,
Anurak

Hi,

I am getting the same error message after running an update of my Pi when I run both SGS2.py and SGSConfigure.py


I have the SQL-server running and the SmartGardenSystem database, se below.

"Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 10.3.25-MariaDB-0+deb10u1 Raspbian 10

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| SmartGardenSystem |
| information_schema |
| mysql |
| performance_schema |
+--------------------+"

When searching the web I found posts that the MySQLdb module is not supported by python3 and that pymysql is used instead.

Thankful for any advice on the matter.

Hi,

Thanks for the advice.

I had to change the pclogging.py code:
import MySQLdb as mdb to
import pymysql as mdb

Now SGS2 is up and running, but now I have issuses with the communication between wireless extender and pi. Need to look in to that.