15/03/25 06:21:00
❰ WeeWX - Mesowx - ❰ Mesowx: DualRain - ❰ Mesowx: weewx - ❰ Mesowx: pmon - ❰ WXgraphic - ❰ Belchertown
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 rootIf 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.
| 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 06:04 | 20.7 | 18.3 | 3.1 | 31 | 7.9 | E | 5 | 6 | 98 | 1019.2 | 0 | 0 |
| 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.9 (23.9) | 2.4 (9.1) | 29 (46) | E | 0 (7) | 0 (9) | 99 | 1019.1 (1021.2) | 0 | 0 |
| 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 ° |
|||||||||
| 1741978800 (2025-03-15 06:00) | 20.8 | 18.3 | 2.8 | 30 | 8 | E | 5 | 6 | 98 | 1019.2 | 0 | 0 |
| 1741977000 (2025-03-15 05:30) | 21.2 | 19.1 | 2.9 | 30 | 8.1 | E | 3 | 4 | 98 | 1019.2 | 0 | 0 |
| 1741975200 (2025-03-15 05:00) | 21.2 | 19 | 3.1 | 30 | 8.1 | E | 4 | 4 | 98 | 1019.2 | 0 | 0 |
| 1741973400 (2025-03-15 04:30) | 20.6 | 18.4 | 3.4 | 32 | 7.8 | E | 4 | 5 | 98 | 1019.4 | 0 | 0 |
| 1741971600 (2025-03-15 04:00) | 20.1 | 18.7 | 5 | 37 | 7.2 | E | 1 | 1 | 98 | 1019.5 | 0 | 0 |
| 1741969800 (2025-03-15 03:30) | 20.3 | 19.3 | 6.1 | 40 | 7 | E | 0 | 0 | 98 | 1019.8 | 0 | 0 |
| 1741968000 (2025-03-15 03:00) | 20.3 | 19.4 | 6.5 | 41 | 6.9 | E | 1 | 1 | 98 | 1019.9 | 0 | 0 |
| 1741966200 (2025-03-15 02:30) | 20.3 | 18.6 | 6.8 | 41 | 6.8 | E | 5 | 6 | 98 | 1020.2 | 0 | 0 |
| 1741964400 (2025-03-15 02:00) | 20.3 | 18.9 | 7.4 | 43 | 6.6 | E | 4 | 5 | 98 | 1020.6 | 0 | 0 |
| 1741962600 (2025-03-15 01:30) | 20.8 | 20.2 | 8.3 | 45 | 6.5 | E | 1 | 1 | 98 | 1020.8 | 0 | 0 |
| 1741960800 (2025-03-15 01:00) | 22.3 | 21.9 | 8.7 | 42 | 7.2 | E | 1 | 1 | 98 | 1020.9 | 0 | 0 |
| 1741959000 (2025-03-15 00:30) | 23.7 | 22.9 | 8.8 | 39 | 7.9 | E | 2 | 3 | 99 | 1021 | 0 | 0 |
| 1741957200 (2025-03-15 00:00) | 24.4 | 23.4 | 8 | 35 | 8.5 | ESE | 2 | 4 | 107 | 1021.2 | 0 | 0 |
Time taken to generate page was 0.06 seconds.
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 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