5,838
edits
Category:Cumulus MX: Difference between revisions
→MySQL settings
| Line 262: | Line 262: | ||
=== MySQL settings === | === MySQL settings === | ||
This is new | Cumulus MX includes functionality not in Cumulus 1, and this is one example of a new feature. It was developed from [[ImportCumulusFile|this script]] for Cumulus 1. | ||
'''Mandatory section''' | |||
* Server Details - expand this drop down as it is used for essential information for any access to database | |||
*# Enter your host name or a IPv4 address for your web server. If you host your own server, it might be something like 127.0.0.1. It is the same as you enter for host in the "internet settings" screen. | |||
*# Enter the port for communicating with database server e.g. 33106. | |||
*# Enter the User Name for updating your database. | |||
*# Enter the password for updating your database. | |||
*# Enter the name of the database that holds the tables you wish to update | |||
'''Optional Sections''' | |||
The remaining 6 drop-down sections are optional, you choose which you want to use, they appear on the screen in a different order to how I explain them below. | |||
*Dayfile.txt upload | |||
** This feature is to upload the line added to this log file at the end of the day, into a new row in a database table | |||
** The database table is created, if it does not already exist using the following SQL | |||
<pre>CREATE TABLE Dayfile (LogDate date NOT NULL ,HighWindGust decimal(4,1) NOT NULL,HWindGBear varchar(3) NOT NULL,THWindG varchar(5) NOT NULL,MinTemp decimal(5,1) NOT NULL,TMinTemp varchar(5) NOT NULL,MaxTemp decimal(5,1) NOT NULL,TMaxTemp varchar(5) NOT NULL,MinPress decimal(6,1) NOT NULL,TMinPress varchar(5) NOT NULL,MaxPress decimal(6,1) NOT NULL,TMaxPress varchar(5) NOT NULL,MaxRainRate decimal(4,1) NOT NULL,TMaxRR varchar(5) NOT NULL,TotRainFall decimal(6,1) NOT NULL,AvgTemp decimal(4,1) NOT NULL,TotWindRun decimal(5,1) NOT NULL,HighAvgWSpeed decimal(3,1),THAvgWSpeed varchar(5),LowHum decimal(4,0),TLowHum varchar(5),HighHum decimal(4,0),THighHum varchar(5),TotalEvap decimal(5,1),HoursSun decimal(3,1),HighHeatInd decimal(4,1),THighHeatInd varchar(5),HighAppTemp decimal(4,1),THighAppTemp varchar(5),LowAppTemp decimal(4,1),TLowAppTemp varchar(5),HighHourRain decimal(4,1),THighHourRain varchar(5),LowWindChill decimal(4,1),TLowWindChill varchar(5),HighDewPoint decimal(4,1),THighDewPoint varchar(5),LowDewPoint decimal(4,1),TLowDewPoint varchar(5),DomWindDir varchar(3),HeatDegDays decimal(4,1),CoolDegDays decimal(4,1),HighSolarRad decimal(5,1),THighSolarRad varchar(5),HighUV decimal(3,1),THighUV varchar(5),HWindGBearSym varchar(3),DomWindDirSym varchar(3),PRIMARY KEY(LogDate)) COMMENT = "Dayfile from Cumulus"</pre> | |||
*There are just 2 items on the settings menu: | |||
*# A tick box that you tick if you want the schema shown above to be used to store lines from [[dayfile.txt]] in a database table | |||
*# A text box where you can change the default table name to one that suits you better. Do not leave this blank, SQL requires a table name. | |||
*Monthly log file upload | |||
** This feature allows you to upload the file that Cumulus creates each month to log measurements on a regular basis, it has just two items: | |||
*# A tick box, where you tick if you want a standard table structure to be used to reflect the fields in the [[Monthly_log_files|detailed log file]] | |||
*# A text box where you can change the default table name to one that suits you better. Do not leave this blank, SQL requires a table name. | |||
** If the table does not exist it will be created, before the new row is added | |||
** If the table already has rows, the upload just creates a new row | |||
* Realtime.txt upload | |||
** This feature allows you to upload the file that Cumulus recreates on the most frequent basis. | |||
*There are 3 items for this option: | |||
*# A tick box to enable this very frequent upload | |||
*# A text box where you can change the default table name | |||
*# A text box where you enter a retention string in format '''retainVal=NNN retainUnit=XXXX''' where NNN is a number from 1 to 3 digits long, and XXX is a time unit like "days" | |||
*Custom upload - seconds interval | |||
** This feature allows you to specify your own SQL for an upload to be repeated every NN seconds. There are 3 items: | |||
*# A tick box to enable or disable this upload (so you can leave the SQL recorded, but stop running it when you like. | |||
*# The SQL you want to run, it should include INSERT IGNORE (or REPLACE or UPDATE) to insert a row, the name of the table, the columns to be updated and the values you include in your SQL are expressed as web tags. | |||
*# The number of seconds between runs, the default is 10, but if your weather station updates less frequently, maybe you will choose 40 or 60 as the interval. | |||
=== Alarms === | === Alarms === | ||