Post by impactoz on Jul 3, 2019 4:43:59 GMT -8
So I finally have logging to the SQL Db
Why is it storing items as UTC date time stamp ? Not much use really - I am in UTC +10 and I would need to convert date / times throughout anything I am planning to do.... Its updating to Weather Underground with a correct time by the looks of it...
Currently Timestamps in the database are showing through PHPAdmin as 2019-07-03 12:30:48 yet my raspberry PI is showing correct date and time of 2019-07-03 22:30:48 - so to me it looks like its using UTC ?
I just wanted to install a solution that worked.... but so far I have had to workthrough issues of getting SQL installed, getting passwords set on Sql, Getting PHP to work.... Manual says it will update weather underground every 5 minutes but its doing it every 30 seconds, pressure might be updating incorrectly, email header shows title of XXXXYYYY and had to solve that - as I am not using WeatherSTEM the doco never told me I needed to update those fields as they are shared elsewhere... Nothing I have seen to clear data out yet - had to write code to clear log files, and as I don't want the SQL DB to fill, more code to keep only limited data... which then highlighted the issue of date / times...
This is not easy ! And I was not wanting to write it all myself!
Why is it storing items as UTC date time stamp ? Not much use really - I am in UTC +10 and I would need to convert date / times throughout anything I am planning to do.... Its updating to Weather Underground with a correct time by the looks of it...
Currently Timestamps in the database are showing through PHPAdmin as 2019-07-03 12:30:48 yet my raspberry PI is showing correct date and time of 2019-07-03 22:30:48 - so to me it looks like its using UTC ?
I just wanted to install a solution that worked.... but so far I have had to workthrough issues of getting SQL installed, getting passwords set on Sql, Getting PHP to work.... Manual says it will update weather underground every 5 minutes but its doing it every 30 seconds, pressure might be updating incorrectly, email header shows title of XXXXYYYY and had to solve that - as I am not using WeatherSTEM the doco never told me I needed to update those fields as they are shared elsewhere... Nothing I have seen to clear data out yet - had to write code to clear log files, and as I don't want the SQL DB to fill, more code to keep only limited data... which then highlighted the issue of date / times...
This is not easy ! And I was not wanting to write it all myself!
