The first one is a 'yes'.
For the second one, look for 'archive_interval' in weewx.conf
[StdArchive]
# If the station hardware supports data logging then the archive
interval
# will be downloaded from the station. Otherwise, specify it (in
seconds).
archive_interval = 300
On Wednesday, January 8, 2025 at 11:36:20 AM UTC-8 Adam Morgan wrote:
> Thanks again! Just to be clear, I should make the exact changes that you
> made?
>
> Also, can you explain something to me? The word "archive" is used, and I
> did see a reference to an archive interval. I am assuming that the data
> gets dumped to the SQL db on that schedule?
>
> On Wednesday, January 8, 2025 at 2:08:09 PM UTC-5 Tom Keffer wrote:
>
>> Only a few sections need to be changed from the standard weewx.conf file.
>> I've highlighted them below. Everything else should be the same.
>>
>>
>> # 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.manager.DaySummaryManager
>> # The schema defines the structure of the database.
>> # It is *only* used when the database is created.
>> schema = schemas.wview_extended.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_name = weewx
>> database_type = MySQL
>>
>>
>> ##############################################################################
>>
>> # This section defines defaults for the different types of databases.
>>
>> [DatabaseTypes]
>>
>> # Defaults for SQLite databases.
>> [[SQLite]]
>> driver = weedb.sqlite
>> # Directory in which database files are located, relative to
>> WEEWX_ROOT
>> SQLITE_ROOT = archive
>>
>>
>> # Defaults for MySQL databases.
>> [[MySQL]]
>> driver = weedb.mysql
>> # The host where the database is located.
>> host = 192.168.1.100
>> port = 3306
>> # The user name for logging in to the host.
>> user = weewx
>> # Use quotes around the password to guard against parsing errors.
>> password = weewx
>>
>> On Wed, Jan 8, 2025 at 9:37 AM Adam Morgan <adamco...@gmail.com> wrote:
>>
>>> Thanks Tom! This is all the part that I find a little confusing - how
>>> the sections tie together. I did see the note about the db name needing to
>>> be consistent across sections, but I am unclear if I am missing something
>>> beyond that.
>>>
>>> I have stripped out the sections that don't apply to this task. I have
>>> commented out the lines that were causing the program to fail.
>>>
>>>
>>>
>>> ##############################################################################
>>>
>>> # 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 = weewx
>>> # The name of the table within the database.
>>> #table_name = archive
>>> # The manager handles aggregation of data for historical
>>> summaries.
>>> #manager = weewx.manager.DaySummaryManager
>>> # The schema defines the structure of the database.
>>> # It is *only* used when the database is created.
>>> #schema = schemas.wview_extended.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_name = weewx
>>> database_type = MySQL
>>>
>>>
>>> ##############################################################################
>>>
>>> # This section defines defaults for the different types of databases.
>>>
>>> [DatabaseTypes]
>>>
>>> # Defaults for SQLite databases.
>>> [[SQLite]]
>>> driver = weedb.sqlite
>>> # Directory in which database files are located, relative to
>>> WEEWX_ROOT
>>> SQLITE_ROOT = /var/lib/weewx
>>>
>>> # Defaults for MySQL databases.
>>> [[MySQL]]
>>> #driver = weedb.mysql
>>> # The host where the database is located.
>>> #host = 192.168.1.100
>>> #port = 3306
>>> # The user name for logging in to the host.
>>> #user = weewx
>>> # Use quotes around the password to guard against parsing errors.
>>> #password = "weewx"
>>>
>>>
>>> ##############################################################################
>>>
>>> On Wednesday, January 8, 2025 at 10:39:17 AM UTC-5 Tom Keffer wrote:
>>>
>>>> I'm assuming that the section [[MySQL]], which you show as being under
>>>> [Databases], is actually under [DatabaseTypes].
>>>>
>>>> If that's the case, then the problem is that under [[wx_binding]], the
>>>> option "database" should be set to "archive_mysql", not "weewx".
>>>>
>>>> But, if [[MySQL]] is in fact under [Databases], then that has to be
>>>> corrected. If you get confused, look at the original weewx.conf
>>>> <https://github.com/weewx/weewx/blob/master/src/weewx_data/weewx.conf>.
>>>> The comments tell you what to do.
>>>>
>>>> On Wed, Jan 8, 2025 at 6:21 AM Adam Morgan <adamco...@gmail.com> wrote:
>>>>
>>>>> I left out this part of the config:
>>>>>
>>>>> [[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 = weewx
>>>>> # The name of the table within the database.
>>>>> table_name = archive
>>>>> # The manager handles aggregation of data for historical
>>>>> summaries.
>>>>> manager = weewx.manager.DaySummaryManager
>>>>> # The schema defines the structure of the database.
>>>>> # It is *only* used when the database is created.
>>>>> schema = schemas.wview_extended.schema
>>>>>
>>>>> On Wednesday, January 8, 2025 at 9:06:28 AM UTC-5 Adam Morgan wrote:
>>>>>
>>>>>> Hello, and thank you so much to all of you that work on the software
>>>>>> and participate in this forum. I've been using weewx for a while now,
>>>>>> and
>>>>>> I hope to be able to contribute to the community going forward.
>>>>>>
>>>>>> I am trying to write to a mariadb instance on my network. I have
>>>>>> several other self-hosted apps on my network that write to the database,
>>>>>> and there are absolutely no network / port restrictions on the db.
>>>>>>
>>>>>> Maybe its just me, but the instructions
>>>>>> <https://weewx.com/docs/5.0/usersguide/mysql-mariadb/#2-change-the-weewx-configuration-to-use-mysql>
>>>>>>
>>>>>> are a little murky. I am not sure that I have the config right. I
>>>>>> can
>>>>>> connect to the db with the user and password, so I don't think that is
>>>>>> the
>>>>>> issue.
>>>>>>
>>>>>> Here are some snippets from my config.
>>>>>>
>>>>>> [Databases]
>>>>>>
>>>>>> # A SQLite database is simply a single file.
>>>>>> [[archive_sqlite]]
>>>>>> database_name = weewx.sdb
>>>>>> database_type = SQLite
>>>>>>
>>>>>> # MySQL
>>>>>> [[archive_mysql]]
>>>>>> database_name = weewx
>>>>>> database_type = MySQL
>>>>>>
>>>>>> [[MySQL]]
>>>>>> driver = weedb.mysql
>>>>>> # The host where the database is located.
>>>>>> host = 192.168.1.100
>>>>>> port = 3306
>>>>>> # The user name for logging in to the host.
>>>>>> user = weewx
>>>>>> # Use quotes around the password to guard against parsing
>>>>>> errors.
>>>>>> password = "weewx"
>>>>>>
>>>>>>
>>>>>>
>>>>>> *Note: I tried appending the port to the end of "host" - same error.*
>>>>>> here is the error:
>>>>>>
>>>>>> admin@WeatherPi:~ $ sudo journalctl -u weewx -f
>>>>>> Jan 08 08:47:00 WeatherPi weewxd[19901]: weewx.UnknownDatabase:
>>>>>> Unknown database ''weewx''
>>>>>> Jan 08 08:47:00 WeatherPi weewxd[19901]: CRITICAL __main__: ****
>>>>>> manager_dict['database_dict'] =
>>>>>> get_database_dict_from_config(config_dict, database)
>>>>>> Jan 08 08:47:00 WeatherPi weewxd[19901]: CRITICAL __main__: ****
>>>>>>
>>>>>> [image: weewx.png]
>>>>>>
>>>>> --
>>>>> 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 weewx-user+...@googlegroups.com.
>>>>> To view this discussion visit
>>>>> https://groups.google.com/d/msgid/weewx-user/d5298881-213a-4f70-86d5-09b098677cc5n%40googlegroups.com
>>>>>
>>>>> <https://groups.google.com/d/msgid/weewx-user/d5298881-213a-4f70-86d5-09b098677cc5n%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 weewx-user+...@googlegroups.com.
>>>
>> To view this discussion visit
>>> https://groups.google.com/d/msgid/weewx-user/c22faed6-2b1b-49cb-ac31-cbfb13e09476n%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/weewx-user/c22faed6-2b1b-49cb-ac31-cbfb13e09476n%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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/weewx-user/2233f0f4-c4dd-4145-9302-6ad1c741a6c9n%40googlegroups.com.
