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+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/weewx-user/d5298881-213a-4f70-86d5-09b098677cc5n%40googlegroups.com.
