Reading data from mariadb sql database on Pi Zero W

7 views (last 30 days)
Okay, here it goes. I'm kinda nervous about asking for help. I have a Pi Zero that collects data from a esp32 and its BME680 air quality sensor. I went though a randomnerdtutorials tutorial (https://randomnerdtutorials.com/esp32-esp8266-raspberry-pi-lamp-server/) to set up the database on the Pi zero. After some editing to get the database to also record the air quality, it works in spite of being presented with a huge 'pink screen' saying there is some kind of error and also an option to ignore. I've been ignoring it and it's been recording samples every 3 seconds just fine for the past 6 days. (I don't think the pink error is my problem though).
So I've got this mass of data and after taking my second signals class, I would like to analyze the data and maybe display it. It looked like you need the 'database toolbox' to import from sql databases. So, I bought the toolbox and tried to use it. I doesn't seem to connect. I think it has to do with the driver. When I downloaded the MySql jconnect package and installed it, I thought it was going to work. It didn't. After multiple searches coming up empty (I think i just don't know how to describe my problem). I asked a couple people on Fiverr and one guy wants $60 just to show me how to connect the database. That's kinda high for something that could be covered by Mathworks support. Could someone point me in the right direction?
Here are some screenshots that might be helpful?
  2 Comments
Natalia Diakova
Natalia Diakova on 18 Jun 2021
I understand that you are trying to use Database toolbox for connection to MariaDB. Since MariaDB is not in the list on https://www.mathworks.com/products/database/driver-installation.html please search for an appropriate JDBC driver from your database provider. I would suggest to use appropriate version of MariaDB Connector depending on Java version installed: https://mariadb.com/kb/en/about-mariadb-connector-j/
luke hoskam
luke hoskam on 9 Jul 2021
I apologize for the delayed response, school started back up and I was busy with classes. Thank you for the link to the drivers.
I tried using both of the linked MariaDB Java Connector's and it didn't connect. Maybe there something else wrong with my setup.
I just don't have time to work on this right now. I appreciate you replying though.
thank you,
luke

Sign in to comment.

Answers (0)

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!