Could someone please help me? I’ve recently retired and decided to further my skills in making projects by building her indoors a weather station. All has gone swimmingly thus far - hardware is operational and data being read. I use a raspberry pi to capture the data and then its put into a sql database using MariaDB.
I’ve now reached the point where I need to display the data in a meaningful format that the missus can understand.
Node-red seems the obvious choice and I’ve had no problem displaying current data using MQTT. Now I wish to display historical data. Easy, I thought. Connect to my database using the MySQL node and pull in the data as needed. But no, it don’t work. ER_NOT_SUPPORTED_AUTH_MODE. Client does not support auth protocol requested by server. Consider upgrading MariaDB client.
I’ve read loads on this but what little hair I have left is gradually being pulled out to extinction,
Please could some nice people explain to me in simple terms how I can get around this problem and restore my wife’s faith in me.
I’m using a Pi 3, running mariadb 10.1.37 on Raspbian 9.0.
Grafana is generally recognised as the best tool for showing historical data. It can read data from a mysql db but you might also like to consider switching to Influx, which is optimised for time series data and has built in features for reducing the sample rate for old data as well purging it.
It will work nicely if you create a new user in MariaDB (better if you use MySQL workbench) and configure this user in the node dialog config window, like shown below (using your nickname as the user)
I think it is due to the mysql node library still not supporting the latest server version8 default auth method - see this open issue https://github.com/mysqljs/mysql/pull/1962 (plus the many linked sub issues)
Can't answer your question but can you show me how you did the process of capturing data using raspberry pi and putting it into MariaDB? I have an Arduino that needs to be connected to Raspberry Pi and that is where the data is going to come from.
This thread is two years old, and a lot has changed in that time, and also your question is different to the one originally asked. Therefore it would be better if you started a new thread to ask your question.
When you ask it please make sure you explain which bit of the problem you are having trouble with, getting the data into node red from the Arduino or saving it in MariaDB. Also tell us a bit about the data. It may be worth saying why you are using MariaDB.
I will close this thread now.
