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

Adding MySQL fields

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. 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

freddie
Posts: 2870
Joined: Wed 08 Jun 2011 11:19 am
Weather Station: Davis Vantage Pro 2 + Ecowitt
Operating System: GNU/Linux Ubuntu 24.04 LXC
Location: Alcaston, Shropshire, UK
Contact:

Re: Adding MySQL fields

Post by freddie »

mcrossley wrote: Sun 20 Nov 2022 9:11 pm I was thinking about this one, and...
Q: When at start-up?
Before station initialisation.
After station initialisation, before catch-up
After station initialisation, after catch-up, before normal running (timers start)
After normal running

In the meantime, could you use the newly added start-up task to run a MySQL command? That would be run at option one above, Before station initialisation.
(Replying with the assumption that you were addressing my static data request).
As soon as Cumulus.ini has been read. I use two "static" tables - one for site data (lat, long, altitude, station name, records began date) and one for station data (station type, log interval, realtime interval, interval graph length, daily graph length, rollover time, the various units of measurement, cumulus version and build, forum url, webcam url) - and I think all of this is available once Cumulus.ini has been read. I could use the startup task provided it will run after Cumulus.ini has been read - which I think it will as this is where the switch for the startup task is kept :)

Thanks for including this functionality - it looks useful.
Freddie
Image
Post Reply