Thanks - I recreated the original poster's issue and corrected it by changing bind-address to 0.0.0.0 in /etc/mysql/mariadb.conf.d/50-server.cnf and then restarting mariadb-server. After that the second pi could indeed connect and write to the db. I used the instructions at https://wiki.tinkernet.ca/index.php/WeeWX for how to set up mysql on the pi.
On Friday, October 1, 2021 at 4:20:22 PM UTC-7 [email protected] wrote: > 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/75cd921b-3f15-4ce3-99f6-13908eca5187n%40googlegroups.com.
