Dave & Vince: I believe WeeWX My SQL Client uses a TCP connection over port 3306 to connect to database. To understand the problem, here is what we know:
1. You are running WeeWX on a Raspberry pi. For this illustration, lets call it CLIENT 2. You are running MySQL on a Ubuntu 20.04 server. we will call that SERVER 3. you are able to ping SERVER from CLIENT. 4. You are able to login to SERVER via mysql command line from CLIENT. if anyone of the statements above are incorrect, please update accordingly. Here is what I would do: 1. in your weewx.conf, change mysql to the IP address of the server. 2. on the CLIENT, ensure you can login using a TCP network connection mysql -u <username that owns the database> -p --port=3306 --host=<IP Address of SERVER> --protocol=TCP 3. if that does not work, try sudo on the line above. One culprit is that your MySQL server is not setup to listen for clients outside of its server. this is the reason for my questions. Please let us know if this helps. On Friday, October 1, 2021 at 6:33:23 PM UTC-4 [email protected] wrote: > I have attached a copy of the syslog file and weewx.conf file. Hopefully > that will help decipher the issue that I am having with connecting to > MySQL. I have redacted the password in the mysql section. > > > > Litte bit more information: I am trying to make a MySQL connection. MySQL > is running on Ubuntu Server 20.04 LTS. This is also a brand new server as > my old server died during an upgrade > > No LSB modules are available. > > Distributor ID: Ubuntu > > Description: Ubuntu 20.04.3 LTS > > Release: 20.04 > > Codename: focal > > > > I am able to cli into the mysql using cli, mysql -u weewx -p. I have check > iptables -L and there are no rules for the firewall. I did check both the > MySQL server and the RPi and both have no firewall rules. > > > > I have run weewx with MySQL connection in the past with no issues, but > that was on a much older system. > > > > Thanks for any information that may help get a connection to MySQL server > > > > Thanks > > Dave > > > > > > *From:* [email protected] <[email protected]> *On Behalf > Of *vince > *Sent:* Friday, October 1, 2021 3:27 PM > *To:* weewx-user <[email protected]> > *Subject:* Re: [weewx-user] Weewx MySQL help > > > > On Friday, October 1, 2021 at 2:23:56 PM UTC-7 [email protected] wrote: > > Any other ideas? > > > > > > Not without seeing your weewx.conf file - see > https://github.com/weewx/weewx/wiki/faq-how-to-report-a-problem and > https://github.com/weewx/weewx/wiki/Help!-Posting-to-weewx-user > > > > > > -- > > 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 vis > https://groups.google.com/d/msgid/weewx-user/ae72c99b-a72d-41bd-8b54-6933a96cd4b8n%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/ae72c99b-a72d-41bd-8b54-6933a96cd4b8n%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/32827c5f-826e-44e2-b111-c9dc896d5873n%40googlegroups.com.
