This may not be possible!
I have a custom MySQL uploading every 10mins which includes extra sensors but also normal data like outside temp.
"INSERT IGNORE INTO extralogssensors (Dateold, Time, date, Month ,FourthTemp , FourthHumidty , Temp , Humidty , Extraintemp , Extrainhum , InTemp , InHum , SoilMoisture1 , SoilMoisture2 , SoilMoisture3) VALUES ('<#date > <#timehhmmss >','<#timehhmmss >','<#metdate >','<#year>-<#month>',<#ExtraTemp1>,<#ExtraHum1>,<#temp>,<#hum>,<#ExtraTemp2>,<#ExtraHum2>,<#intemp>,<#inhum>,<#SoilMoisture1>,<#SoilMoisture2> ,<#SoilMoisture3>);"
The PC is often shutdown overnight so all the data for this time is not uploaded into the MySQL at startup.
The Extralog txt files are updated with data from overnight. e.g. ExtraLog202501.txt
Within the MySQL settings page I have set the custom upload at startup, this would only load one entry?
Is there a solution or am I missing a setting I should set?
Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080
Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080
Catchup Custom MySQL
Moderator: mcrossley
-
BrunswickWeather
- Posts: 87
- Joined: Fri 11 Mar 2011 2:04 am
- Weather Station: Ecowitt GW1103
- Operating System: windows 11 Pro/Raspberry pi 4
- Location: Brunswick Australia
-
BrunswickWeather
- Posts: 87
- Joined: Fri 11 Mar 2011 2:04 am
- Weather Station: Ecowitt GW1103
- Operating System: windows 11 Pro/Raspberry pi 4
- Location: Brunswick Australia
Re: Catchup Custom MySQL
Attached Diags file from this morning. The custom startup wasn't set then
After setting the startup it causes an error. Also attached a later diag file show the startup error
After setting the startup it causes an error. Also attached a later diag file show the startup error
You do not have the required permissions to view the files attached to this post.
- mcrossley
- Posts: 14384
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Catchup Custom MySQL
It's not possible at present, the main station is "caught up" but extra sensors are not.
-
BrunswickWeather
- Posts: 87
- Joined: Fri 11 Mar 2011 2:04 am
- Weather Station: Ecowitt GW1103
- Operating System: windows 11 Pro/Raspberry pi 4
- Location: Brunswick Australia
Re: Catchup Custom MySQL
Thanks Mark
Decided to leave my Mini pc on 24/7. (NucBox_M2Pro)
Checking power usage it appears to use only 0.03kw per hour at 22c per kw/hr. So for about 10hrs extra per day its not expensive.
Decided to leave my Mini pc on 24/7. (NucBox_M2Pro)
Checking power usage it appears to use only 0.03kw per hour at 22c per kw/hr. So for about 10hrs extra per day its not expensive.
- mcrossley
- Posts: 14384
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Catchup Custom MySQL
I figured the same, I run "lots" of Raspberry Pis, and few other IoT devices. In total they cost less the price of half a cup coffee per year, a small price to pay to support the hobbies!