MessMate Farm, Vic, Australia

01/12/24 17:35: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
°
2024-12-01 17:04 22 19.7 11 50 6.2 WNW 14 16 2841006.9 0 0

Historical Observations for the date of 2024-12-01

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
°
2024-12-01          13.9 (25.1) 13.4 (25.1) 10.1 (14.9) 44 (93) W 0 (23) 0 (31) 2681004.2 (1007.5) 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
°
1733032800  (2024-12-01 17:00) 22 19.5 10.9 49 6.3 W 14 17 2761007 0 0
1733031000  (2024-12-01 16:30) 22 19.7 11 50 6.2 WNW 14 17 2871007 0 0
1733029200  (2024-12-01 16:00) 21.6 19.1 11 51 6 WNW 15 18 2881007.1 0 0
1733027400  (2024-12-01 15:30) 20.6 18.2 11.9 58 5 WNW 15 19 2871007.2 0 0
1733025600  (2024-12-01 15:00) 19.5 17.3 12.2 63 4.2 WNW 15 19 2931007.2 0 0
1733023800  (2024-12-01 14:30) 18.2 17.1 13.2 73 2.9 WNW 11 15 2971007.3 0 0
1733022000  (2024-12-01 14:00) 20.8 18.2 10.8 53 5.6 WNW 15 20 2961007 0 0
1733020200  (2024-12-01 13:30) 21.5 20.1 11.2 52 5.8 NW 9 13 3051006.7 0 0
1733018400  (2024-12-01 13:00) 23.3 22.3 11.4 47 6.8 NW 7 12 3171006.6 0 0
1733016600  (2024-12-01 12:30) 23.4 22.8 12.6 51 6.3 NW 7 11 3061006.8 0 0
1733014800  (2024-12-01 12:00) 19.3 18.3 12.5 65 3.9 WNW 9 13 3021007 0 0
1733013000  (2024-12-01 11:30) 18.8 17.4 12 65 3.9 WNW 11 15 2991007 0 0
1733011200  (2024-12-01 11:00) 18.5 17.8 12.4 68 3.5 WNW 7 10 3011007.1 0 0
1733009400  (2024-12-01 10:30) 17.8 17.1 12.2 70 3.2 NW 7 10 3041007.1 0 0
1733007600  (2024-12-01 10:00) 17.4 17.2 12.3 72 2.9 WNW 5 8 3031006.9 0 0
1733005800  (2024-12-01 09:30) 17.8 18.1 13.2 75 2.7 WNW 4 6 2971006.8 0 0
1733004000  (2024-12-01 09:00) 17.2 17.6 13.3 78 2.3 W 3 6 2761006.7 3.2 3.2
1733002200  (2024-12-01 08:30) 16 16.3 12.9 81 1.9 SW 3 6 2181006.4 3.2 3.2
1733000400  (2024-12-01 08:00) 15.8 15.7 12.8 82 1.8 SSW 5 7 2051006 3.2 3.2
1732998600  (2024-12-01 07:30) 15.5 15.5 12.6 83 1.7 NW 4 6 3171005.9 3.2 3.2
1732996800  (2024-12-01 07:00) 14.9 14.9 12.5 86 1.4 W 4 7 2621005.7 3.2 3.2
1732995000  (2024-12-01 06:30) 14.6 14.6 12.7 88 1.2 NNW 4 6 3271005.6 3.2 3.2
1732993200  (2024-12-01 06:00) 14.4 14.7 12.7 89 1 NNW 3 4 3291005.5 3.2 3.2
1732991400  (2024-12-01 05:30) 14.2 14.5 12.6 90 1 NNW 3 5 3291005.2 3.2 3.2
1732989600  (2024-12-01 05:00) 14.3 14.5 12.8 91 0.9 S 3 6 1821005.1 3.2 3.2
1732987800  (2024-12-01 04:30) 14.2 14.3 12.8 91 0.8 SSW 4 6 1991004.8 3.2 3.2
1732986000  (2024-12-01 04:00) 14.1 14.3 12.6 91 0.8 W 3 5 2791004.5 3.2 3.2
1732984200  (2024-12-01 03:30) 14.3 14.4 12.8 91 0.9 NE 4 6 371004.4 2.9 3.2
1732982400  (2024-12-01 03:00) 14.7 14.8 13.3 91 0.9 W 5 7 2691004.3 2.9 3.2
1732980600  (2024-12-01 02:30) 14.9 14.8 13.6 92 0.8 NNW 7 8 3351004.3 2.9 3.2
1732978800  (2024-12-01 02:00) 15.1 15.5 13.7 91 0.9 S 4 6 1921004.6 2.9 3.2
1732977000  (2024-12-01 01:30) 15.3 15.5 13.7 90 0.9 SSE 5 6 1531004.6 2.9 3.2
1732975200  (2024-12-01 01:00) 15.9 16.8 14.3 91 1 WSW 3 4 2471004.6 2.9 3.2
1732973400  (2024-12-01 00:30) 16 16.9 14.6 91 0.9 WSW 3 5 2471004.9 2.9 3.2
1732971600  (2024-12-01 00:00) 16.1 16.6 14.7 92 0.8 WSW 5 6 2471005.2 2.9 3.2

Time taken to generate page was 0.09 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