Thanks for the reply, but no change in screen output and no records in WeatherData
1) yes, database was setup before I ran SkyWeather.py with results above (executed WeatherPiStructure.sql, tables created, but no records in WeatherData table). I'm very familiar with SQL language on mariadb.
- How else do I turn on debug?
2) in conflocal file, I have parameter "SWDEBUG = True", I'm guessing that is how to turn-on debug in SkyWeather.py
3) in conflocal file, I have parameter "enable_MySQL_Logging = True, MySQL_Password = matches my own password I verified works within mariadb.
4) Curiously, mysql -u root -p fails unless I place sudo in front "mysql -u root -p" . . . then ok
Your MariaDB connection id is 38
Server version: 10.3.27-MariaDB-0+deb10u1 Raspbian 10
My entire conflocal.py file below
#
#
# configuration file - contains customization for SkyWeather system
#
# it is a good idea to copy this file into a file called "conflocal.py" and edit that instead of this one. This file is wiped out if you update SkyWeather.
SWDEBUG = True
SWVERSION = "000" # set in SkyWeather.py
import uuid
# printing the value of unique MAC
# address using uuid and getnode() function
MACADDRESS = hex(uuid.getnode())
mailUser = "Don"
mailPassword = "yourmailpassword"
notifyAddress ="
[email protected]"
fromAddress = "
[email protected]"
enableText = False
textnotifyAddress = "yourphonenumber@yourprovider"
#MySQL Logging and Password Information
enable_MySQL_Logging = True
MySQL_Password = my unique password that works with mysql
# modify this IP to enable WLAN operating detection - search for WLAN_check in SkyWeather.py
enable_WLAN_Detection = False
PingableRouterAddress = "192.168.1.1"
# LED configuration (on use on a Raspberry Pi 3B+)
runLEDs = False
# WXLink and SolarMAX configuration
SolarMAX_Present = False
Dual_MAX_WXLink = False
# SolarMAX_Type = "LEAD" for SolarMAX Lead Acid
# SolarMAX_Type = "LIPO" for SolarMAX LiPo
SolarMAX_Type = ""
# WeatherSTEM configuration
USEWEATHERSTEM = False
INTERVAL_CAM_PICS__SECONDS = 60
STATIONMAC = MACADDRESS
STATIONKEY="XXXXYYYY"
STATIONHARDWARE=""
# WeatherUnderground Station
WeatherUnderground_Present = False
WeatherUnderground_StationID = "KWXXXXX"
WeatherUnderground_StationKey = "YYYYYYY"
############
# Blynk configuration
############
USEBLYNK = False
BLYNK_AUTH = 'xxxxx'
BLYNK_URL = 'http://blynk-cloud.com/'
############
# AS3935 Lightning Configuration
############
# format: [NoiseFLoor, Indoor, TuneCap, DisturberDetection, WatchDogThreshold, SpikeDetection]
AS3935_Lightning_Config = [2,1,3,0,3,3]
# for barometeric pressure - needed to calculate sealevel equivalent - set your weatherstation elevation here
BMP280_Altitude_Meters = 328.0
# device present global variables
Camera_Present = False
TCA9545_I2CMux_Present = True
SunAirPlus_Present = False
AS3935_Present = False
DS3231_Present = False
BMP280_Present = False
BME680_Present = True
HDC1080_Present = False
SHT30_Present = False
AM2315_Present = False
ADS1015_Present = True
ADS1115_Present = False
OLED_Present = False
OLED_Originally_Present = False
WXLink_Present = False
Sunlight_Present = False
TSL2591_Present = False
DustSensor_Present = False
# set Sunlight High Gain (indoors - 1) or Low Gain (outdoors - 0)
Sunlight_Gain = 0
# if the WXLink has stopped transmitting, == False
WXLink_Data_Fresh = False
WXLink_LastMessageID = 0
# Pin definitions
pixelPin = 21
DustSensorPin = 19
DustSensorPowerPin = 26
#WeatherRack
anemometerPin = 20
rainPin = 13
SHT30GSPIN = 6
AM2315GSPIN = 6
# for fan
GPIO_Pin_PowerDrive_Sig1 = 5
GPIO_Pin_PowerDrive_Sig2 = 5 # To avoid stepping on GPIO 6
WATCHDOGTRIGGER = 4