I use the MX MySQL options to update both my dayfile, and logdata tables (using the stand built-in option) and they work just fine. I use the custom option to update my realtime table (as I have 'tweaked' it) every minute as well.
You must make sure that the public IP address of your MX server is on the 'allowed to connect to MySQL' list of your server - some servers do not allow universal direct access to MySQL.
The loooong term plan is to drive the whole website from MySQL and do away with the tag file uploads.
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 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
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 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
Dayfile.txt uploading to a web server via FTP?
Moderator: mcrossley
-
- Posts: 159
- Joined: Wed 13 May 2009 9:35 am
- Weather Station: Davis Vantage Pro 2 Wireless
- Operating System: Raspbian wheezy
- Location: Nr Ilkley, West Yorks, UK
- Contact:
Re: Dayfile.txt uploading to a web server via FTP?
Thanks Steve & Mark.
Steve, it was from the info about Custom HTTP calls on the CumulusMX internet settings option:
"Custom HTTP call - at rollover
A custom HTTP URL to be invoked just before end of day rollover - can include webtags"
and also in the Custom Upload in the CumulusMX MySQL settings:
"Custom upload - at rollover
A custom SQL command to be executed just before end of day rollover - can include webtags"
That's why I assumed it wouldn't do what I wanted it to.
Steve, it was from the info about Custom HTTP calls on the CumulusMX internet settings option:
"Custom HTTP call - at rollover
A custom HTTP URL to be invoked just before end of day rollover - can include webtags"
and also in the Custom Upload in the CumulusMX MySQL settings:
"Custom upload - at rollover
A custom SQL command to be executed just before end of day rollover - can include webtags"
That's why I assumed it wouldn't do what I wanted it to.
bigmac
Menston Weather
Menston Weather
- steve
- Cumulus Author
- Posts: 26701
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: Dayfile.txt uploading to a web server via FTP?
Those do happen just before writing dayfile.txt rather than just after, as with the 'standard' one. But they still all happen before the rest of actual rollover process, so the data will be the same. It's designed so that you get the last values of the day. If they happened after the rollover had completed, you would get the reset values, which usually aren't much use. Writing dayfile.txt is the very first part of the rollover process. for the same reason.
Steve
-
- Posts: 159
- Joined: Wed 13 May 2009 9:35 am
- Weather Station: Davis Vantage Pro 2 Wireless
- Operating System: Raspbian wheezy
- Location: Nr Ilkley, West Yorks, UK
- Contact:
Re: Dayfile.txt uploading to a web server via FTP?
Thank you for your patient explanation Steve. I've totally got the process wrapped around my neck! I understand it now so will have another go at it.
bigmac
Menston Weather
Menston Weather
- Werk_AG
- Posts: 198
- Joined: Sun 13 Jan 2013 8:04 pm
- Weather Station: WeatherDuino 4Pro
- Operating System: Windows 7
- Location: Cercal CDV - Portugal
- Contact:
Re: Dayfile.txt uploading to a web server via FTP?
Which may be a problem to all that have a dynamic IP, I think.mcrossley wrote:
You must make sure that the public IP address of your MX server is on the 'allowed to connect to MySQL' list of your server - some servers do not allow universal direct access to MySQL.
This solution posted by jank, works well and its easy to add to a cron jobAlready installed on the Raspberry PI is: curl
Syntax to upload a file to an FTP Server is:
curl -m 60 -T /path_to/source_file ftp://"FTPHOST":"FTPPORT" "FTPDIR"/ --user "FTPUSER":"FTPPASS"