WXforum.net

Weather Software => Cumulus => Topic started by: funsutton on May 30, 2020, 12:40:03 PM

Title: What is the Mysql Database for?
Post by: funsutton on May 30, 2020, 12:40:03 PM
I got my Cumulus MX running last night on my iMac and it looks great. Like the big gauges on the console.

The wind gust readings are odd compared to my console at times, but I think I saw a post from galfert explaining that it may be interpreting the raw data a little differently.

But the big question I'm left with is what exactly the Mysql db is for. It appears that the software keeps its own logs already. Do I even need to try and get the db working? I did try and create the 'dayfile' a couple times but got a parseerror.

Also I did update my monthly/yearly/all time data with the info from my console. However the rain totals for 'This Month' and 'This Year' still read zeros on the dashboard. Not sure where else I can input data to fix that.
Title: Re: What is the Mysql Database for?
Post by: PaulMy on May 30, 2020, 02:07:02 PM
Quote
I got my Cumulus MX running last night on my iMac and it looks great. Like the big gauges on the console.
So now you are ready for www.komokaweather.com/cumulusmx/index.php


Ahhh, but... not sure how MX-UI works with a MAC.


Quote
But the big question I'm left with is what exactly the Mysql db is for. It appears that the software keeps its own logs already. Do I even need to try and get the db working?
The MySQL db would be an additional and expanded place for your data and endless ways to extract and use it.  Previously with Cumulus1 you had to use another script to import data to a db such as ImportCumulusFile.php but now this is built-in to CumulusMX.  My webhost GoDaddy provides MySQL database.  Some examples of db scripts-
http://www.komokaweather.com/mysql/top10.php
http://www.komokaweather.com/mysql/dayfile/datatables/examples/server_side/dayfile-sql.php
http://www.komokaweather.com/weather/maxmin.php (http://www.komokaweather.com/weather/maxmin.php)


Enjoy,
Paul
Title: Re: What is the Mysql Database for?
Post by: ConligWX on May 30, 2020, 02:08:12 PM
Personally it is best post on the CumulusMX forums for technical advice.

https://cumulus.hosiene.co.uk/

Plenty of gurus lurking there.

Sent from my GM1913 using Tapatalk

Title: Re: What is the Mysql Database for?
Post by: funsutton on May 31, 2020, 03:03:39 AM
Thanks Paul. Your site looks great and I think I get it now as far as the MySQL db. Let's you create your own sql scripts and reports.

Also thanks for the tip on the Cumulus forum ConligWX. I'll use that if I need it.
Title: Re: What is the Mysql Database for?
Post by: northernbrucewx on June 08, 2020, 10:34:04 PM
Quote
I got my Cumulus MX running last night on my iMac and it looks great. Like the big gauges on the console.
So now you are ready for www.komokaweather.com/cumulusmx/index.php


Ahhh, but... not sure how MX-UI works with a MAC.


Quote
But the big question I'm left with is what exactly the Mysql db is for. It appears that the software keeps its own logs already. Do I even need to try and get the db working?
The MySQL db would be an additional and expanded place for your data and endless ways to extract and use it.  Previously with Cumulus1 you had to use another script to import data to a db such as ImportCumulusFile.php but now this is built-in to CumulusMX.  My webhost GoDaddy provides MySQL database.  Some examples of db scripts-
http://www.komokaweather.com/mysql/top10.php
http://www.komokaweather.com/mysql/dayfile/datatables/examples/server_side/dayfile-sql.php
http://www.komokaweather.com/weather/maxmin.php (http://www.komokaweather.com/weather/maxmin.php)


Enjoy,
Paul

Paul, what template did you use to get the Cumulus dashboard online? I assume someone (yourself) built it in html?
Title: Re: What is the Mysql Database for?
Post by: PaulMy on June 09, 2020, 12:09:17 AM
That is a template by BCJKiwi https://cumulus.hosiene.co.uk/viewtopic.php?p=138283#p138283 (https://cumulus.hosiene.co.uk/viewtopic.php?p=138283#p138283)


Enjoy,
Paul
Title: Re: What is the Mysql Database for?
Post by: northernbrucewx on June 09, 2020, 05:26:03 PM
Thanks Paul. I use the HomeWeatherStation template, and I was considering building one similar to the CumulusMX dashboard, but this may suffice.