Authorized access.

Current date/time: 2021-07-17 16:41:10

api called by http

update U: 1626554463

update SW: meteobridge

update T: 30.2

update TMX: 31.1

update TMN: 27.4

update H: 70

update P: 1014.5

update W: 3.1

update G: 5.4

update B: 164

update R: 0.0

update RR: 0.0

update S: 107.0

update UV: 1.0

update TIN: 31.0

update HIN: 64

update T1: 28.5

update H1: 74

update T2: 29.3

update H2: 70

update T3: 29.3

update H3: 66

update T4: 26.8

update H4: 78

update T5: 31.3

update H5: 63

Begin of common part of api script

Start handling live data

Checking if extra sensors should be logged

Extra sensors data to save in db: TIN, HIN, UV, T1, H1, T2, H2, T3, H3, T4, H4

add live data: D: 23.9

add live data: DTime: 1626554337

add live data: A: 35.4

add live data: ATime: 1626554337

calculated D: 24.1

calculated A: 35.5

Save meteotemplateLive.txt: {"U":1626554463,"SW":"meteobridge","T":30.2,"TMX":31.1,"TMN":27.4,"H":70,"P":1014.5,"W":3.1,"G":5.4,"B":164,"R":0,"RR":0,"S":107,"UV":1,"TIN":31,"HIN":64,"T1":28.5,"H1":74,"T2":29.3,"H2":70,"T3":29.3,"H3":66,"T4":26.8,"H4":78,"T5":31.3,"H5":63,"UTime":1626554470,"SWTime":1626554470,"TTime":1626554470,"TMXTime":1626554470,"TMNTime":1626554470,"HTime":1626554470,"PTime":1626554470,"WTime":1626554470,"GTime":1626554470,"BTime":1626554470,"RTime":1626554470,"RRTime":1626554470,"STime":1626554470,"UVTime":1626554470,"TINTime":1626554470,"HINTime":1626554470,"T1Time":1626554470,"H1Time":1626554470,"T2Time":1626554470,"H2Time":1626554470,"T3Time":1626554470,"H3Time":1626554470,"T4Time":1626554470,"H4Time":1626554470,"T5Time":1626554470,"H5Time":1626554470,"D":24.1,"DTime":1626554470,"A":35.5,"ATime":1626554470}

Start data parsing

Parsing date; Server time: 2021-07-17 16:41:10

Validating date: 1626554463 (2021-07-17 16:41:03)

Date is valid; difference with server time is -7 s

Parsing temperature

Temperature: 30.2 C

Database units: F

Temperature converted to: 86.36 F

Checking temperature is between limits specified in template Main settings.

Minimum temperature limit: -100 F

Maximum temperature limit: 120 F

Temperature is OK and within the allowed limits

Parsing maximum temperature

Max Temperature: 31.1 C

Database units: F

Temperature converted to: 87.98 F

Checking max temperature is between limits specified in template Main settings.

Minimum temperature limit: -100 F

Maximum temperature limit: 120 F

Max Temperature is OK and within the allowed limits

Parsing minimum temperature

Min Temperature: 27.4 C

Database units: F

Temperature converted to: 81.32 F

Checking min temperature is between limits specified in template Main settings.

Minimum temperature limit: -100 F

Maximum temperature limit: 120 F

Min Temperature is OK and within the allowed limits

Parsing humidity

Humidity: 70 percent

Checking humidity is between limits specified in template Main settings.

Minimum humidity limit: 0 %

Maximum humidity limit: 100 %

Humidity is OK and within the allowed limits

Parsing wind speed

Wind speed: 3.1 kmh

Database wind speed units: mph

Wind speed  converted to: 1.9262501 mph

Checking wind speed is between limits specified in template Main settings.

Minimum wind speed limit: 0 mph

Maximum wind speed limit: 125 mph

Wind speed is OK and within the allowed limits

Parsing wind gust

Wind gust: 5.4 kmh

Database wind units: mph

Wind gust  converted to: 3.3554034 mph

Checking wind gust is between limits specified in template Main settings.

Minimum wind gust limit: 0 mph

Maximum wind gust limit: 125 mph

Wind gust is OK and within the allowed limits

Parsing wind direction

Wind direction: 164 degrees

Wind direction is OK and within the allowed limits

Parsing daily cumulative precipitation

Precipitation: 0.0 mm

Database precipitation units: in

Precipitation  converted to: 0 in

Checking precipitation is between limits specified in template Main settings.

Minimum precipitation limit: 0 in

Maximum precipitation limit: 12 in

Precipitation is OK and within the allowed limits

Parsing rain rate

Rain rate: 0.0 mm/h

Database rain units: in/h

Rain rate  converted to: 0 in/h

Checking rain rate is between limits specified in template Main settings.

Minimum rain rate limit: 0 in/h

Maximum rain rate limit: 48 in/h

Rain rate is OK and within the allowed limits

Parsing solar radiation

Solar radiation: 107.0 w/m2

Checking solar radiation is between limits specified in template Main settings.

Minimum solar radiation limit: 0 W/m2

Maximum solar radiation limit: 2000 W/m2

Solar radiation is OK and within the allowed limits

Now parsing extra sensors.

Sensor indoor temperature raw value: 31.0 deg C

Limits for this sensor: 1 to 50

Sensor data within acceptable limits.

Sensor indoor humidity raw value: 64 %

Limits for this sensor: 0.01 to 100

Sensor data within acceptable limits.

Sensor UV raw value: 1.0 

Limits for this sensor: 0 to 20

Sensor data within acceptable limits.

Sensor extra temperature sensor 1 raw value: 28.5 deg C

Limits for this sensor: -60 to 60

Sensor data within acceptable limits.

Sensor extra humidity sensor 1 raw value: 74 %

Limits for this sensor: 0.01 to 100

Sensor data within acceptable limits.

Sensor extra temperature sensor 2 raw value: 29.3 deg C

Limits for this sensor: -60 to 60

Sensor data within acceptable limits.

Sensor extra humidity sensor 2 raw value: 70 %

Limits for this sensor: 0.01 to 100

Sensor data within acceptable limits.

Sensor extra temperature sensor 3 raw value: 29.3 deg C

Limits for this sensor: -60 to 60

Sensor data within acceptable limits.

Sensor extra humidity sensor 3 raw value: 66 %

Limits for this sensor: 0.01 to 100

Sensor data within acceptable limits.

Sensor extra temperature sensor 4 raw value: 26.8 deg C

Limits for this sensor: -60 to 60

Sensor data within acceptable limits.

Sensor extra humidity sensor 4 raw value: 78 %

Limits for this sensor: 0.01 to 100

Sensor data within acceptable limits.

Cached data loaded from cache/apiCache.txt.

Parsing pressure

Pressure: 1014.5 hpa

Database pressure units: inhg

Pressure  converted to: 29.95816471 inhg

Checking pressure is between limits specified in template Main settings.

Minimum pressure limit: 0 inhg

Maximum pressure limit: 40 inhg

Pressure is OK and within the allowed limits

Pressure is valid.

Calculated dew point: 75.38 F

Dew point ok.

Calculated apparent temperature: 95.9 F

Apparent temperature ok.

End time for database update based on timestamp of first cache data: 2021-07-17 16:36:55

Rounded end time for database update: 2021-07-17 16:40:00

Time to update the database, preparing query.

Timestamp first cached record: 2021-07-17 16:36:55

Timestamp last cached record: 2021-07-17 16:38:56

Timestamp last received record: 2021-07-17 16:41:03

Timestamp new database record: 2021-07-17 16:40:00

No new day, currentRain=0.00

The database is updated with the following query: 
            INSERT INTO alldata
            (DateTime,T,Tmax,Tmin,H,P,W,G,B,R,RR,S,D,A)
            values ('2021-07-17 16:40:00',88.3,88.7,88.0,65.5,29.96,3.7,10.3,196,0.00,0.00,115.6,75.4,96.8
        )

Preparing extra sensor query...

The extra database table is updated with the following query: 
                INSERT INTO alldataExtra
                (TIN,HIN,UV,T1,H1,T2,H2,T3,H3,T4,H4,DateTime)
                values (31.15,64,1,28.55,74,29.35,71,29.35,65.5,26.8,78,'2021-07-17 16:40:00')
            

Cache file deleted.

Saving first new data to cache/apiCache.txt, timestamp=2021-07-17 16:41:03


ERRORS:

