MessMate Farm, Vic, Australia

15/03/25 08:31:00

❰ WeeWX  - Mesowx  - ❰ Mesowx: DualRain  - ❰ Mesowx: weewx  - ❰ Mesowx: pmon  - ❰ WXgraphic  - ❰ Belchertown

Use the following to select a date for archived records Date style can be either 01-Feb-2018 or 01-02-2018 ( DD-MM-YYYY )
Choose the date:

The database config file has gone missing!     That shouldn't happen unless you've been changing your configuration files

We initially use a php default for include files of /usr/share/php, but this doesn't seem to suit all webservers or installations.

As of version 0.7.1, /usr/share/php will be created if it's found to be missing.

Check that the directory /usr/share/php does actually exist, if it doesn't then create it - and report this scripts failure.

Check that its read | write permissions are suitable - 0755, owned by root

The file should have been accessable as
/usr/share/php/wxobs_weatherpi.inc
We can use include_path in wxobs/skin.conf to change that.
The include file will be regenerated on weewx's next report run, (unless you're using the undocumented feature - view the source Luke.) Or when report_timing allows.

If the problem persists, consider changing its location as wxobs/skin.conf will accept
include_path = /new_path/your_choice
where the path and name can be anything allowable by php, readable by the webserver, and preferably secure.

If you are using the [Remote] section - where the sqlite database and wxobs files are viewable from a remote server then the include file will be transferred into the dest_directory that is specified. Populating dest_directory allow the remote transfer to be considered.

If all else fails, report the problem as an issue - to its github site, or contact me directly.
There are also Wiki notes that may help for this, and setting up remote servers.

Latest Observations

Date     Time Out Temp
°C
App Temp
°C
Dew Point
°C
Humidity
%
delta‐T
°C
Wind Pressure
hPa
Total Rain
(since 9 a.m.)
mm
Total Hail
(since 9 a.m.)
mm
Direction
compass
Speed
km/h
Gust
km/h
Direction
°
2025-03-15 08:04 21.8 19.9 3.3 30 8.3 E 2 4 981019.9 0 0


Using todays date.

Historical Observations for the date of 2025-03-15

Stats for the day : Min (Max), or Averages for Direction

Date          Out Temp
°C
App Temp
°C
Dew Point
°C
Humidity
%
Wind Pressure
hPa
Total Rain
(since 9 a.m.)
mm
Total Hail
(since 9 a.m.)
mm
Direction
compass
Speed
km/h
Gust
km/h
Direction
°
2025-03-15          19.8 (24.5) 17.8 (23.9) 2 (9.1) 28 (46) E 0 (7) 0 (9) 991019 (1021.2) 0 0

Periodic Stats (average values)

Date     Time Out Temp
°C
App Temp
°C
Dew Point
°C
Humidity
%
delta‐T
°C
Wind Pressure
hPa
Total Rain
(since 9 a.m.)
mm
Total Hail
(since 9 a.m.)
mm
Direction
compass
Speed
km/h
Gust
km/h
Direction
°
1741986000  (2025-03-15 08:00) 21.7 19.7 3.1 29 8.3 E 3 4 981019.8 0 0
1741984200  (2025-03-15 07:30) 21.2 19.1 2.7 29 8.1 E 3 3 981019.6 0 0
1741982400  (2025-03-15 07:00) 20.4 18.2 2.5 31 7.8 E 3 4 981019.2 0 0
1741980600  (2025-03-15 06:30) 20.5 18.1 2.4 30 7.9 E 4 5 981019.1 0 0
1741978800  (2025-03-15 06:00) 20.7 18.3 2.9 31 7.9 E 5 5 981019.2 0 0
1741977000  (2025-03-15 05:30) 21.2 19.1 2.9 30 8.1 E 3 4 981019.2 0 0
1741975200  (2025-03-15 05:00) 21.2 19 3.1 30 8.1 E 4 4 981019.2 0 0
1741973400  (2025-03-15 04:30) 20.6 18.4 3.4 32 7.8 E 4 5 981019.4 0 0
1741971600  (2025-03-15 04:00) 20.1 18.7 5 37 7.2 E 1 1 981019.5 0 0
1741969800  (2025-03-15 03:30) 20.3 19.3 6.1 40 7 E 0 0 981019.8 0 0
1741968000  (2025-03-15 03:00) 20.3 19.4 6.5 41 6.9 E 1 1 981019.9 0 0
1741966200  (2025-03-15 02:30) 20.3 18.6 6.8 41 6.8 E 5 6 981020.2 0 0
1741964400  (2025-03-15 02:00) 20.3 18.9 7.4 43 6.6 E 4 5 981020.6 0 0
1741962600  (2025-03-15 01:30) 20.8 20.2 8.3 45 6.5 E 1 1 981020.8 0 0
1741960800  (2025-03-15 01:00) 22.3 21.9 8.7 42 7.2 E 1 1 981020.9 0 0
1741959000  (2025-03-15 00:30) 23.7 22.9 8.8 39 7.9 E 2 3 991021 0 0
1741957200  (2025-03-15 00:00) 24.4 23.4 8 35 8.5 ESE 2 4 1071021.2 0 0

Time taken to generate page was 0.06 seconds.


SELECT:

SELECT dateTime, rain, rainrate, hail, hailrate FROM archive WHERE dateTime BETWEEN 1666900980 AND 1666901940;
SELECT dateTime, hail FROM archive WHERE hail > 0 AND dateTime BETWEEN 1667426400 AND 1667430000;
SELECT dateTime, rain, rainrate, sum(hail), hailrate FROM archive WHERE dateTime BETWEEN 1667432400 AND 1667434440;
SELECT dateTime, rain, rainrate, hail, raincount1, raincount3, raincount4 FROM archive WHERE dateTime BETWEEN 1667446740 AND 1667447770;
SELECT dateTime, sum(rain), rainrate, hail, raincount1, raincount3, raincount4 FROM archive WHERE dateTime BETWEEN 1667446740 AND 1667447770;
SELECT datetime, rain, hail FROM archive ORDER BY dateTime DESC LIMIT 1;
SELECT hail FROM archive WHERE dateTime = 1667059560 AND hail > 0;


UPDATE:

UPDATE archive SET rain=0, rainrate=0 WHERE datetime BETWEEN 1667059560 AND 1667091300;
UPDATE archive SET rain=1.016, rainrate=0 WHERE datetime BETWEEN 1611873540 AND 1611892800 AND hail=1.016;
UPDATE archive SET rain=0.254 WHERE datetime = 1666901040;

      # supply a date, get an epoch time.

      date -d "11-june-2017 21:00:00" +'%s'
      # 1497178800

      date -d now +'%s'
      # 1667447728

      date +"%s"
      # returns the CURRENT epoch time, ie:- now!

      date -d @1407198071
      # Tue  5 Aug 10:21:11 AEST 2014

    

This extension is available at github as weewx-wxobs : This is version 0.8.1