no DashBoard sensor data

markg
New Member

Posts: 13
Raspberry Pi: Yes

no DashBoard sensor data Jan 14, 2022 14:45:59 GMT -8

Quote

Post by markg on Jan 14, 2022 14:45:59 GMT -8

Hello,
Summary of my issue, no weatherRack2 sensor data appearing in the dashboard, however readWeatherSensors is showing the anticipated data.

have the SD card from SwitchDoc. I am running an a RPi 4

Specifically, from DashBoard all sensors are “GRAY”… no data is appearing in the Weather Tab.
cd /home/pi/SDL_Pi_SkyWeather2/dash_app
sudo python3 index.py
192.168.86.29:8050/"  WeatherSense Sensor Status “Led’s” all are Gray=Off

Suspect:issue with mysql ?
I can open mysql using following command. Suggestions please on additional commands to validate that the proper tables are being updated would be very much appreciated! I am unfamiliar with SQL.

mysql -u root -ppassword
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 230

Here is my "Default" Jason file:
cat SkyWeather2.JSON
{"key": "value", "ProgramName": "SkyWeather2", "ConfigVersion": "001", "SWDEBUG": false, "enable_MySQL_Logging": false, "MySQL_Password": "password", "enable_WLAN_Detection": false, "PingableRouterAddress": "192.168.1.1", "mailUser": "yourusername", "mailPassword": "yourmailpassword", "notifyAddress": "you@example.com", "fromAddress": "yourfromaddress@example.com", "enableText": false, "textnotifyAddress": "yournumber@yourprovider", "runLEDs": false, "SolarMAX_Present": false, "BMP280_Altitude_Meters": "626.0", "Sunlight_Gain": "High", "USEWEATHERSTEM": false, "INTERVAL_CAM_PICS__SECONDS": "60", "STATIONKEY": "", "WeatherUnderground_Present": false, "WeatherUnderground_StationID": "KWXXXXX", "WeatherUnderground_StationKey": "YYYYYY", "USEBLYNK": false, "BLYNK_AUTH": "", "USEWSLIGHTNING": false, "USEWSAQI": false, "USEWSSKYCAM": false, "ALTWSSKYCAM": false, "DustSensorSCL": "20", "DustSensorSDA": "21", "DustSensorPowerPin": "5", "GPIO_Pin_PowerDrive_Sig1": "4", "GPIO_Pin_PowerDrive_Sig2": "4", "WATCHDOGTRIGGER": "6", "REST_Enable": false, "Camera_Night_Enable": false, "Camera_Rotation": 0, "MQTT_Enable": false, "MQTT_Server_URL": "localhost", "MQTT_Port_Number": "1883", "MQTT_Send_Seconds": "500", "English_Metric": false}

Note: readWeatherSensors.py does show my SkyWeather2 data! That is a good sign! (output reads in part):
Registered 6 out of 152 device decoding protocols [ 146-148 150-152 ]
Found Rafael Micro R820T tuner
Exact sample rate is: 250000.000414 Hz
[R82XX] PLL not locked!
Sample rate set to 250000 S/s.
Tuner gain set to Auto.
Tuned to 433.920MHz.
Allocating 15 zero-copy buffers
WeatherSense WeatherRack2 FT020T found
{"time" : "2022-01-13 21:52:52", "model" : "SwitchDoc Labs F016TH Thermo-Hygrometer", "device" : 3, "modelnumber" : 5, "channel" : 1, "battery" : "OK", "temperature_F" : 61.400, "humidity" : 64, "mic" : "CRC"}
WeatherSense Indoor T/H F016TH Found
{"time" : "2022-01-13 21:53:06", "model" : "SwitchDoc Labs FT020T AIO", "device" : 12, "id" : 0, "batterylow" : 0, "avewindspeed" : 0, "gustwindspeed" : 0, "winddirection" : 317, "cumulativerain" : 3, "temperature" : 1008, "humidity" : 66, "light" : 0, "uv" : 0, "mic" : "CRC"}

So the question is, Why am I not seeing data in the Dashboard?

Thank you.

Mark Green

Jason Senior Member Posts: 482 Raspberry Pi: Yes	no DashBoard sensor data Jan 14, 2022 14:55:23 GMT -8 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by Jason on Jan 14, 2022 14:55:23 GMT -8 Pretty sure you need to enable MySQL logging. I believe the JSON key is enable_MySQL_Logging. Fire up SkyWeatherConfigure.py and change that to true and see if you start getting data. Thanks, Jason

markg New Member Posts: 13 Raspberry Pi: Yes	no DashBoard sensor data Jan 14, 2022 17:38:03 GMT -8 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by markg on Jan 14, 2022 17:38:03 GMT -8 Hello, thank you Jason. I have enabled, enable_MySQL_Logging and unfortunately same. No data. Other suggestions? Thank you. Mark

markg
New Member

Posts: 13
Raspberry Pi: Yes

no DashBoard sensor data Jan 14, 2022 20:13:56 GMT -8

Quote

Post by markg on Jan 14, 2022 20:13:56 GMT -8

Hello, I believe I have confirmed that there is no data being written to the database:

mysql -u root -ppassword

MariaDB [SkyWeather2]> SELECT * FROM WeatherData;
Empty set (0.001 sec)

I have confirmed that JSON key is enable_MySQL_Logging

Any ideas why data is not being written? Thank you.

doxidad Senior Member Posts: 272 Raspberry Pi: Yes	no DashBoard sensor data Jan 15, 2022 4:31:25 GMT -8 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by doxidad on Jan 15, 2022 4:31:25 GMT -8 Enable SWDEBUG in your JSON file with SkyWeatherConfigure. This will give us some information about what is going on. Are you executing SkyWeather2 this way? sudo python3 SkyWeather2.py

markg
New Member

Posts: 13
Raspberry Pi: Yes

no DashBoard sensor data Jan 15, 2022 12:12:07 GMT -8

Quote

Post by markg on Jan 15, 2022 12:12:07 GMT -8

Thank you for your reply. We are so close! Very exciting...

pi@sky:~/SDL_Pi_SkyWeather2 $ sudo python3 SkyWeather2.py
I get the following authentication error:

Traceback (most recent call last):
File "/home/pi/SDL_Pi_SkyWeather2/sendemail.py", line 51, in sendEmail
s.login(config.mailUser, config.mailPassword)
File "/usr/lib/python3.7/smtplib.py", line 730, in login
raise last_exception
File "/usr/lib/python3.7/smtplib.py", line 721, in login
initial_response_ok=initial_response_ok)
File "/usr/lib/python3.7/smtplib.py", line 642, in auth
raise SMTPAuthenticationError(code, resp)
smtplib.SMTPAuthenticationError: (535, b'5.7.8 Username and Password not accepted. Learn more at\n5.7.8 support.google.com/mail/?p=BadCredentials h17sm7460919pgg.73 - gsmtp')

thus the dashboard does not open when I,

Here is my JSON:
pi@sky:~/SDL_Pi_SkyWeather2 $ cat SkyWeather2.JSON
{"key": "value", "ProgramName": "SkyWeather2", "ConfigVersion": "001", "SWDEBUG": true, "enable_MySQL_Logging": true, "MySQL_Password": "password", "enable_WLAN_Detection": true, "PingableRouterAddress": "192.168.86.1", "mailUser": "yourusername", "mailPassword": "yourmailpassword", "notifyAddress": "you@example.com", "fromAddress": "yourfromaddress@example.com", "enableText": false, "textnotifyAddress": "yournumber@yourprovider", "runLEDs": false, "SolarMAX_Present": false, "BMP280_Altitude_Meters": "626.0", "Sunlight_Gain": "High", "USEWEATHERSTEM": false, "INTERVAL_CAM_PICS__SECONDS": "60", "STATIONKEY": "", "WeatherUnderground_Present": false, "WeatherUnderground_StationID": "KWXXXXX", "WeatherUnderground_StationKey": "YYYYYY", "USEBLYNK": false, "BLYNK_AUTH": "", "USEWSLIGHTNING": false, "USEWSAQI": false, "USEWSSKYCAM": false, "ALTWSSKYCAM": false, "DustSensorSCL": "20", "DustSensorSDA": "21", "DustSensorPowerPin": "5", "GPIO_Pin_PowerDrive_Sig1": "4", "GPIO_Pin_PowerDrive_Sig2": "4", "WATCHDOGTRIGGER": "6", "REST_Enable": false, "Camera_Night_Enable": false, "Camera_Rotation": 0, "MQTT_Enable": false, "MQTT_Server_URL": "localhost", "MQTT_Port_Number": "1883", "MQTT_Send_Seconds": "500", "English_Metric": false}pi@sky:

I suppose it goes without saying, but port 8050 is not available due to the authentication error.

pi@sky:~/bin $ nping 127.0.0.1 -p 8050

Starting Nping 0.7.70 ( nmap.org/nping ) at 2022-01-15 12:05 PST
SENT (0.0031s) Starting TCP Handshake > 127.0.0.1:8050
RCVD (0.0032s) Possible TCP RST received from 127.0.0.1:8050 --> Connection refused

BTW, apologies for not having mysql skills! But I'm learning :-)

Last Edit: Jan 15, 2022 12:19:52 GMT -8 by markg: additional info

doxidad
Senior Member

Posts: 272
Raspberry Pi: Yes

no DashBoard sensor data Jan 15, 2022 14:26:23 GMT -8

Quote

Post by doxidad on Jan 15, 2022 14:26:23 GMT -8

You do not have a email address/password set up. Also the module sendemail.py expect you to use gmail.

It is trying to send the startup message to 'yourusername' with a password of 'yourmailpassword' through the gmail gateway 'smtp.gmail.com'

If you have a gmail account - setup the username and password in SkyWeatherConfigure. If you don't have a gmail address but some other mail service you can enter the username/password for that account and then edit the sendemail.py module and modify the the line

s = smtplib.SMTP("smtp.gmail.com", 587)

Appropriately.

If you don't have any email service you would need comment out any line in SkyWeather2.py that starts with

sendemail.sendEmail(

Also, the dash_app gets almost all of it's data from the mysql database. So, if SkyWeather2 is not executing, the database is not getting updated. Note that the database is only updated every 15 minutes.

markg
New Member

Posts: 13
Raspberry Pi: Yes

no DashBoard sensor data Jan 16, 2022 9:42:31 GMT -8 Jason likes this

Quote

Post by markg on Jan 16, 2022 9:42:31 GMT -8

Summary: fixed. Thank you!
Here were the two keys to fixing my 'no data' symptom
1. enable_MySQL_Logging
2. setup gmail email/password

Note that the first email from your skyweather will generate a email that states, "A suspicious application was blocked from accessing your account".
The fix here is to select the gmail security feature to "Allow Less Secure Apps: ON".

Finally, here are a few helpful mysql commands I used during the troubleshooting this issue that others with no SQL knowledge (like me) might find helpful.
mysql -u root -ppassword
show databases;
use [database];
show tables;
describe [tablesname];
SELECT * FROM [tablename];
exit;

Last Edit: Jan 16, 2022 9:50:12 GMT -8 by markg

Jason Senior Member Posts: 482 Raspberry Pi: Yes	no DashBoard sensor data Jan 16, 2022 13:29:07 GMT -8 SDL likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by Jason on Jan 16, 2022 13:29:07 GMT -8 Glad it's working! Jason

Post by markg on Jan 14, 2022 14:45:59 GMT -8

Post by Jason on Jan 14, 2022 14:55:23 GMT -8

Post by markg on Jan 14, 2022 17:38:03 GMT -8

Post by markg on Jan 14, 2022 20:13:56 GMT -8

Post by doxidad on Jan 15, 2022 4:31:25 GMT -8

Post by markg on Jan 15, 2022 12:12:07 GMT -8

Post by doxidad on Jan 15, 2022 14:26:23 GMT -8

Post by markg on Jan 16, 2022 9:42:31 GMT -8

Post by Jason on Jan 16, 2022 13:29:07 GMT -8

Quick Reply