Author Topic: What is the Mysql Database for?  (Read 437 times)

0 Members and 1 Guest are viewing this topic.

Offline funsutton

  • Senior Member
  • **
  • Posts: 90
    • Weather Underground
What is the Mysql Database for?
« 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.

Offline PaulMy

  • Forecaster
  • *****
  • Posts: 4674
    • KomokaWeather
Re: What is the Mysql Database for?
« Reply #1 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


Enjoy,
Paul

Offline ConligWX

  • Forecaster
  • *****
  • Posts: 608
  • #conligwx
    • conligwx.org
Re: What is the Mysql Database for?
« Reply #2 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

Regards Simon
Davis Vantage Pro2 Plus Daytime FARS WeatherLink Live CumulusMX Saratoga Templates


Offline funsutton

  • Senior Member
  • **
  • Posts: 90
    • Weather Underground
Re: What is the Mysql Database for?
« Reply #3 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.

Offline northernbrucewx

  • Member
  • *
  • Posts: 8
    • Northern Bruce Weather
Re: What is the Mysql Database for?
« Reply #4 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


Enjoy,
Paul

Paul, what template did you use to get the Cumulus dashboard online? I assume someone (yourself) built it in html?

Offline PaulMy

  • Forecaster
  • *****
  • Posts: 4674
    • KomokaWeather
Re: What is the Mysql Database for?
« Reply #5 on: June 09, 2020, 12:09:17 AM »
That is a template by BCJKiwi https://cumulus.hosiene.co.uk/viewtopic.php?p=138283#p138283


Enjoy,
Paul

Offline northernbrucewx

  • Member
  • *
  • Posts: 8
    • Northern Bruce Weather
Re: What is the Mysql Database for?
« Reply #6 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.