OK did this and State data was seen on my remote mqtt broker.
As it was at version 27.1 I did a git pull to 27.6 and now it doesnt work again.
I ran sudo mysql -u root -p SkyWeather2 < 27.3.DataBaseUpdate.sql
However this failed with the error:
pi@skyweather2:~/SDL_Pi_SkyWeather2 $ sudo mysql -u root -p SkyWeather2 < 27.3.DataBaseUpdate.sql
Enter password:
ERROR 1060 (42S21) at line 3: Duplicate column name 'SNR'
pi@skyweather2:~/SDL_Pi_SkyWeather2 $
The Skyweather console displays the following:
pi@skyweather2:~/SDL_Pi_SkyWeather2 $ sudo python3 SkyWeather2.py
./SkyWeather2.JSON File exists
using updateWebConfig
##########################################################
SkyWeather2 Weather Station Version 027.6 - SwitchDoc Labs
Program Started at:2022-05-14 19:57:51
##########################################################
Starting pigpio daemon
b''
mmal: mmal_vc_component_create: failed to create component 'vc.ril.camera' (1:ENOMEM)
mmal: mmal_component_create_core: could not create component 'vc.ril.camera' (1)
----------------------
BMP280: Present
SkyCam: Not Present
OLED: Not Present
SunAirPlus/SunControl: Not Present
SolarMAX: Not Present
DustSensor: Not Present
UseBlynk: Disabled
UseWSLIGHTNING: Disabled
UseWSAQI: Disabled
UseWSSKYCAM: Disabled
UseMySQL: Enabled
UseMQTT: Enabled
Check WLAN: Not Present
WeatherUnderground: Not Present
UseWeatherStem: Not Present
----------------------
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 i8-20020a05600c354800b003945cdd0d55sm6360818wmq.26 - gsmtp')
sendmail exception raised
-----------------
Scheduled Jobs
######
-----------------
Jobstore default:
patTheDog (trigger: interval[0:00:20], next run at: 2022-05-14 19:58:16 BST)
creating new MQTT instance
readWiredSensors (trigger: interval[0:00:30], next run at: 2022-05-14 19:58:26 BST)
tick (trigger: interval[0:01:00], next run at: 2022-05-14 19:58:56 BST)
printState (trigger: interval[0:01:00], next run at: 2022-05-14 19:58:56 BST)
publish (trigger: interval[0:01:00], next run at: 2022-05-14 19:58:56 BST)
barometricTrend (trigger: interval[0:15:00], next run at: 2022-05-14 20:12:56 BST)
writeWeatherRecord (trigger: interval[0:15:00], next run at: 2022-05-14 20:12:56 BST)
writeITWeatherRecord (trigger: interval[0:15:00], next run at: 2022-05-14 20:12:56 BST)
cleanPictures (trigger: cron[day='*', hour='3', minute='4'], next run at: 2022-05-15 03:04:00 BST)
cleanTimeLapses (trigger: cron[day='*', hour='3', minute='10'], next run at: 2022-05-15 03:10:00 BST)
buildTimeLapse (trigger: cron[day='*', hour='5', minute='30'], next run at: 2022-05-15 05:30:00 BST)
-----------------
connecting to broker
starting 433MHz scanning
######
Processing Generic data
This is the raw data: [30] Generic Remote SC226x EV1527
Processing Generic data
This is the raw data: [38] Generic temperature sensor 1
Processing Generic data
This is the raw data: [87] Generic wireless motion sensor
Job "readSensors (trigger: date[2022-05-14 19:57:56 BST], next run at: 2022-05-14 19:57:56 BST)" raised an exception
Traceback (most recent call last):
File "/usr/local/lib/python3.7/dist-packages/apscheduler/executors/base.py", line 125, in run_job
retval = job.func(*job.args, **job.kwargs)
File "/home/pi/SDL_Pi_SkyWeather2/wirelessSensors.py", line 762, in readSensors
processWeatherSenseTB(sLine)
File "/home/pi/SDL_Pi_SkyWeather2/wirelessSensors.py", line 257, in processWeatherSenseTB
state = json.loads(sLine)
File "/usr/lib/python3.7/json/__init__.py", line 348, in loads
return _default_decoder.decode(s)
File "/usr/lib/python3.7/json/decoder.py", line 340, in decode
raise JSONDecodeError("Extra data", s, end)
json.decoder.JSONDecodeError: Extra data: line 1 column 12 (char 11)
Extra data: line 1 column 12 (char 11)
File "/usr/local/lib/python3.7/dist-packages/apscheduler/executors/base.py", line 125, in run_job
retval = job.func(*job.args, **job.kwargs)
File "/home/pi/SDL_Pi_SkyWeather2/wirelessSensors.py", line 762, in readSensors
processWeatherSenseTB(sLine)
File "/home/pi/SDL_Pi_SkyWeather2/wirelessSensors.py", line 257, in processWeatherSenseTB
state = json.loads(sLine)
File "/usr/lib/python3.7/json/__init__.py", line 348, in loads
return _default_decoder.decode(s)
File "/usr/lib/python3.7/json/decoder.py", line 340, in decode
raise JSONDecodeError("Extra data", s, end)
