Patch to to use UNIX domain socket instead to TCP.

[Joe Smooze]

For those of us that prefer domain sockets to TCP for mysql.

This just looks for a slash in 'host = ' in the [[MySQL]] stanza of weewx.conf and then uses mysql.sock instead of TCP to connect to the database.

Regards,

Joe

[Tom Keffer]

Joe,

Have you actually tried this? The logic picks a socket if the name has a slash in it, but host IP addresses can also have a slash. E.g., https://acme.com

--
You received this message because you are subscribed to the Google Groups "weewx-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-developm...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/5eeaa553-9b04-499a-8efa-79f9303ca274n%40googlegroups.com.

[Tom Keffer]

With a little experimentation, it turns out you connect to a socket if you prefer with the present version of WeeWX. Use this in weewx.conf:

    [[MySQL]]
        # The host where the database is located
        host = ''
        unix_socket = /var/run/mysqld/mysqld.sock

Use an empty string for the hostname. Add an option "unix_socket" for the socket address.

This works because the driver passes on any unknown options, in this case, unix_socket, to the MySQL driver.

-tk

[Joe Smooze]

That's not a hostname. https://example.com is a URL. / is not an allowed character in a hostname.

[Joe Smooze]

Excellent. I didn't even try that.

Could you update the documentation and the examples in weewx.conf, please?

Regards,

Joe

[Tom Keffer]

Already did it, to appear V5. See https://weewx.com/v5-docs/usersguide/weewx-config-file/databasetypes/#mysql

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/3c457d48-de7d-40fa-af51-10b3f5273e85n%40googlegroups.com.