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 <marcuszurho...@gmail.com> 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 weewx-user+unsubscr...@googlegroups.com. > 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBsjXot3S%3DmUuF5cTPrRHfoXAEov8hCO-u1dBgtOJpCkg%40mail.gmail.com.
