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

Catchup Custom MySQL

From Cumulus MX version 3 build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since, and has recently released Cumulus MX version 4. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
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

Catchup Custom MySQL

Post by BrunswickWeather »

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?
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

Post by BrunswickWeather »

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
You do not have the required permissions to view the files attached to this post.
User avatar
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

Post by mcrossley »

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

Post by BrunswickWeather »

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.
User avatar
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

Post by mcrossley »

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!
Post Reply