5,838
edits
Cumulus.ini: Difference between revisions
m
→Database: added
m (→Database: added) |
|||
| Line 665: | Line 665: | ||
** If rollover time is midnight, then rolls over at midnight local time, regardless of whether DST is in operation or not | ** If rollover time is midnight, then rolls over at midnight local time, regardless of whether DST is in operation or not | ||
** If MX would do [[MX_Basic_info#MX_End_of_Day_Process|an end of day process]] when the time (on Weather Station if it provides time) reaches 9 a.m. local standard/winter time, then it waits until 10 a.m. local time while DST is in effect | ** If MX would do [[MX_Basic_info#MX_End_of_Day_Process|an end of day process]] when the time (on Weather Station if it provides time) reaches 9 a.m. local standard/winter time, then it waits until 10 a.m. local time while DST is in effect | ||
|} | |||
==Database== | |||
* Available from beta MX. | |||
* File Section is [MySQL] | |||
{| class="wikitable" border="1" | |||
|- | |||
!style="width:30px" | Parameter Line Entry | |||
!style="width:100px" | Shown on Settings page? | |||
!style="width:100px" | MX Section | |||
!style="width:60px" | Label on Settings page | |||
!style="width:20px" | Default | |||
!style="width:600px" | Description | |||
|- | |||
| CustomMySqlMinutesCommandString= | |||
| only if "Custom Minutes Enabled" | |||
| MySQL Settings → Monthly log file upload | |||
| SQL command | |||
| (blank) | |||
| SQL to be obeyed at the interval defined in "CustomMySqlMinutesIntervalIndex" | |||
|- | |||
| CustomMySqlMinutesIntervalIndex=6 | |||
| only if "Custom Minutes Enabled" | |||
| MySQL Settings → Monthly log file upload | |||
| Interval | |||
| 6 = 10 minutes | |||
| Time between custom SQL uploads: | |||
* 0 = 1 minute | |||
* 1 = 2 minutes | |||
* 2 = 3 minutes | |||
* 3 = 4 minutes | |||
* 4 = 5 minutes | |||
* 5 = 6 minutes | |||
* 6 = 10 minutes | |||
* 7 = 12 minutes | |||
* 8 = 20 minutes | |||
* 9 = 30 minutes | |||
* 10 = 1 hour (60 minutes) | |||
|- | |||
| CustomMySqlMinutesEnabled=0 | |||
| (always) | |||
| MySQL Settings | |||
| Custom Minutes Enabled | |||
| Not ticked (shown as 0 in Cumulus.ini) | |||
| Enable the optional functionality to run SQL at a selected interval in minutes | |||
|- | |||
| CustomMySqlSecondsCommandString= | |||
| only if "Custom Seconds Enabled" | |||
| MySQL Settings → Monthly log file upload | |||
| SQL command | |||
| (blank) | |||
| SQL to be obeyed at the interval defined in "CustomMySqlSecondsInterval" | |||
|- | |||
| CustomMySqlSecondsInterval=10 | |||
| only if "Custom Seconds Enabled" | |||
| MySQL Settings → Monthly log file upload | |||
| Interval | |||
| 10 (seconds) | |||
| Time between custom SQL uploads | |||
|- | |||
| CustomMySqlSecondsEnabled=0 | |||
| (always) | |||
| MySQL Settings | |||
| Custom Minutes Enabled | |||
| Not ticked (shown as 0 in Cumulus.ini) | |||
| Enable the optional functionality to run SQL at a selected interval in seconds | |||
|- | |||
| Database= | |||
| when section opened | |||
| MySQL Settings → Server Details | |||
| Database name | |||
| (blank) | |||
| The name given to the database that includes the table(s) you want to update | |||
|- | |||
| DayfileMySqlEnabled=0 | |||
| (always) | |||
| MySQL Settings | |||
| Dayfile Enabled | |||
| Not ticked (shown as 0 in Cumulus.ini) | |||
| Enable the automatic upload to the table named in "DayfileTable" within the database named in "Database" | |||
|- | |||
| DayfileTable=Dayfile | |||
| when "Dayfile Enabled" is ticked and the next section is opened | |||
| | |||
| MySQL Settings → Dayfile.txt upload | |||
| Table name | |||
| Dayfile | |||
| Enables you to choose the name for the database table to be updated when "DayfileMySqlEnabled" is ticked | |||
|- | |||
| Host= | |||
| when section opened | |||
| MySQL Settings → Server Details | |||
| Host name | |||
| (blank) | |||
| Enter the database server name or Internet Protocol address | |||
|- | |||
| MonthlyMySqlEnabled=0 | |||
| (always) | |||
| MySQL Settings | |||
| Monthly Log Enabled | |||
| Not ticked (shown as 0 in Cumulus.ini) | |||
| Enable the automatic upload to the table named in "MonthlyTable" within the database named in "Database" | |||
|- | |||
| MonthlyTable=Monthly | |||
| Enables you to choose the name for the database table to be updated when "MonthlyMySqlEnabled" is ticked | |||
|- | |||
| Pass= | |||
| when section opened | |||
| MySQL Settings → Server Details | |||
| (blank) | |||
| Enter the password needed to access the database server specified in "Host" | |||
|- | |||
| Port=3306 | |||
| when section opened | |||
| MySQL Settings → Server Details | |||
| Port | |||
| 3306 | |||
| Enter the port used to access the database server | |||
|- | |||
| RealtimeMySql1MinLimit=0 | |||
| When section opened | |||
| MySQL Settings → Raltime.txt upload | |||
| Limit real time table inserts to once a minute | |||
| Not ticked (shown as 0 in Cumulus.ini) | |||
| Enable the optional functionality to limit database uploads, if your real time interval has been set to less than 60 seconds | |||
|- | |||
| RealtimeMySqlEnabled=0 | |||
| (always) | |||
| MySQL Settings | |||
| Realtime enabled | |||
| Not ticked (shown as 0 in Cumulus.ini) | |||
| Enable the automatic upload to the table named in "RealtimeTable" within the database named in "Database" | |||
|- | |||
| RealtimeRetention= | |||
| When section opened | |||
| MySQL Settings → Raltime.txt upload | |||
| '''Data Retention value''' and '''Data Retention unit''' | |||
| "7" and "Days" | |||
| The value field will take any number, the unit field is a dropdown: | |||
* Seconds | |||
* Minutes | |||
* Hours | |||
* Days | |||
* Weeks | |||
* Months | |||
Taken together, these determine the period for which rows are kept in the table named in "RealtimeTable", any row older than this specification will be deleted as part of the automatic SQL | |||
|- | |||
| RealtimeTable=Realtime | |||
| When section opened | |||
| MySQL Settings → Raltime.txt upload | |||
| Table name | |||
| Realtime | |||
| Enables you to choose the name for the database table to be updated when "RealtimeMySqlEnabled" is ticked | |||
|- | |||
| User= | |||
| when section opened | |||
| MySQL Settings → Server Details | |||
| (blank) | |||
| Enter the username associated with "Pass" | |||
|} | |} | ||
| Line 695: | Line 856: | ||
| This adds extra information about transfers from MX, and all the internal MX processes. | | This adds extra information about transfers from MX, and all the internal MX processes. | ||
|} | |} | ||
== Location== | == Location== | ||