Dear both, thanks for your help. So, I have verified the password once more. I do not have a typo in my config file. I can copy the password and paste it into a regular mariadb session, and I can access the server.
In a second step, I have no updated the password and removed the comma char. The weewx service is now connecting and starts w/o errors. I am using version 4.8.0 which I have installed in a Debian11-based LXC container in Proxmox. (apt install weewx ....) Regards, Marcus [email protected] schrieb am Dienstag, 30. August 2022 um 16:46:47 UTC+2: > I have been unable to reproduce this. When I surround the password with > quotes, it correctly interprets it as a single string, not a list of two > strings. > > Are you sure you correctly quoted the password? > > On Tue, Aug 30, 2022 at 5:01 AM Marcus Zurhorst <[email protected]> > wrote: > >> Hello all, >> >> I am stuck with an error that I do not understand with the configuration >> of my remote MariaDB server. >> >> *What I checked:* >> - Remote access on my database server is enabled. >> - Remote login from the weewx host is working as well. (confirmed with >> mariadb -uweewxdb -hdatabase.homenet.local -p; entered the password and >> had access) >> >> *My weewx.conf file: (shortened)* >> [DataBindings] >> [[wx_binding]] >> database = archive_mysql >> table_name = archive >> manager = weewx.manager.DaySummaryManager >> schema = schemas.wview_extended.schema >> [Databases] >> # MySQL >> [[archive_mysql]] >> database_name = weewx >> database_type = MySQL >> [DatabaseTypes] >> # Defaults for MySQL databases >> [[MySQL]] >> driver = weedb.mysql >> host = database.homenet.local >> user = weewxdb >> password = ComplexPrefix,weewxdb # tried also with single >> and double quotes >> >> >> My assumption is, that the comma in my password might cause trouble. >> But I also tried it with 'ComplexPrefix,weewxdb' or >> "ComplexPrefix,weewxdb", and neither helps. >> >> >> *I get an error in my Python:* >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** File "/usr/share/weewx/weedb/mysql.py", line 54, in gua> >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** return fn(*args, **kwargs) >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** File "/usr/share/weewx/weedb/mysql.py", line 136, in __> >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** connection = MySQLdb.connect(host=host, port=int(port> >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** File "/usr/lib/python3/dist-packages/MySQLdb/__init__.p> >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** return Connection(*args, **kwargs) >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** File "/usr/lib/python3/dist-packages/MySQLdb/connection> >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** super(Connection, self).__init__(*args, **kwargs2) >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** *TypeError: connect() argument 3 must be str, not list* >> Aug 30 11:34:46 weewx python3[2909]: weewx[2909] CRITICAL __main__: >> **** Exiting. >> >> >> What is the next thing that I should try? >> >> Thanks and best regards, >> Marcus >> >> -- >> 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/f33579fc-2ac0-44bf-a413-a2a1961cddd2n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/f33579fc-2ac0-44bf-a413-a2a1961cddd2n%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/f49c89c8-b498-444a-aefd-2095f4c89a6bn%40googlegroups.com.
