Hi,
Here are the requested sections :
##############################################################################
# This section binds a data store to a database.
[DataBindings]
[[wx_binding]]
# The database must match one of the sections in [Databases].
# This is likely to be the only option you would want to change.
database = archive_mysql
# The name of the table within the database
table_name = archive
# The manager handles aggregation of data for historical summaries
manager = weewx.wxmanager.WXDaySummaryManager
# The schema defines the structure of the database.
# It is *only* used when the database is created.
schema = schemas.wview.schema
[[wd_binding]]
manager = weewx.manager.DaySummaryManager
schema = user.wdschema.weewxwd_schema
table_name = archive
database = weewxwd_mysql
[[forecast_binding]]
database = forecast_mysql
manager = weewx.manager.Manager
schema = user.forecast.schema
table_name = archive
[[wdsupp_binding]]
database = wd_supp_mysql
table_name = supp
manager = weewx.manager.Manager
schema = user.wdschema.wdsupp_schema
[[pm_binding]]
database = archive_mysql
table_name = archive
manager = weewx.wxmanager.WXDaySummaryManager
schema = user.sds011.schema
##############################################################################
# This section defines various databases.
[Databases]
# A SQLite database is simply a single file
[[archive_sqlite]]
database_name = weewx.sdb
database_type = SQLite
# MySQL
[[archive_mysql]]
database_type = MySQL
database_name = weewx
host =
user =
password =
[[weewxwd_mysql]]
database_name = weewxwd
database_type = MySQL
host =
user =
password =
[[weewxwd_sqlite]]
database_name = weewxwd.sdb
root = %(WEEWX_ROOT)s
database_type = SQLite
[[forecast_sqlite]]
database_name = forecast.sdb
database_type = SQLite
[[forecast_mysql]]
database_name = forecast
database_type = MySQL
host =
user =
password =
[[wd_supp_sqlite]]
database_type = SQLite
database_name = wdsupp.sdb
[[wd_supp_mysql]]
database_name = weewxwd
database_type = MySQL
host =
user =
password =
[[pm_sqlite]]
database_name = pm.sdb
database_type = SQLite
##############################################################################
# This section defines defaults for the different types of databases.
[DatabaseTypes]
# Defaults for SQLite databases
[[SQLite]]
driver = weedb.sqlite
# Directory in which the database files are located
SQLITE_ROOT = %(WEEWX_ROOT)s/archive
# Defaults for MySQL databases
[[MySQL]]
driver = weedb.mysql
# The host where the database is located
host = localhost
# The user name for logging in to the host
user =
# The password for the user name (quotes guard against parsing
errors)
password =
##############################################################################
While reviewing this, I noticed the manager line in the PM_Binding. Could
this be the issue?
On Monday, April 12, 2021 at 5:10:19 PM UTC+2 [email protected] wrote:
> Sorry, I don't have an explanation.
>
> Can we see the [DataBindings], [Databases], and [DatabaseTypes] sections
> of weewx.conf? You can obfuscate any passwords.
>
> On Sat, Apr 10, 2021 at 7:58 AM [email protected] <[email protected]>
> wrote:
>
>> I checked, (I adjusted the query a bit since I am on mysql), but it
>> confirmed there are 31 rows in the last 1 hour.
>>
>> I ran :
>> select
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html>
>> count
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_count>
>> (*),avg
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_avg>
>> (pm2_5),max
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_max>
>> (pm2_5) from archive where dateTime
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html>
>> >=(select
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html>
>> max
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_max>
>> (dateTime
>> <http://diskstation/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html>
>> )-3600 from archive);
>>
>> and got :
>> count(*) avg(pm2_5) max(pm2_5)
>>
>> 31 1.0897849462365594 1.2
>>
>>
>>
>>
>>
>> On Saturday, April 10, 2021 at 4:49:26 PM UTC+2 [email protected] wrote:
>>
>>> Well, you can check what's in the database for the last hour. Adjust
>>> the path to the database as necessary.
>>>
>>> *sqlite3 /var/lib/weewx/weewx.sdb*
>>> sqlite> *select datetime(dateTime,'unixepoch','localtime'),pm2_5 from
>>> archive where dateTime>=(select max(dateTime)-3600 from archive);*
>>>
>>>
>>>
>>> On Sat, Apr 10, 2021 at 5:50 AM [email protected] <[email protected]>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> I am trying to improve my station sking with a proper AQI
>>>> computation/display. however when using $hour.pm2_5.has_data it is always
>>>> false.
>>>>
>>>> Data is stored in the pm2_5 column of weewx archive database. Gauges
>>>> show the current values, and history plot show prior data.
>>>>
>>>> Is there a setting I need to add somewhere so that hourly average can
>>>> be computed on this column as well?
>>>>
>>>> Regards,
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "weewx-user" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/weewx-user/6110a7ae-2012-47b9-9ffe-0cc7c8c67837n%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/weewx-user/6110a7ae-2012-47b9-9ffe-0cc7c8c67837n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "weewx-user" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>>
> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/28c7fca2-6552-4c19-9c51-8db602b9a416n%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/weewx-user/28c7fca2-6552-4c19-9c51-8db602b9a416n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/d3533f18-e001-48a4-b73a-aeab9b844644n%40googlegroups.com.
