Thank you everyone for helping me get my issue fixed. With everyone’s input, it lead me to look more closely at MySQL server. There were several things that I modified that made it work. I changed the binding address in mysql to the IP address of the server instead of it using 127.0.0.1. Next from what I could tell, was the password encryption that mysql was using. Once I change it back to mysql_native and recreated the user, everything connect and is now working.
Thank you so much. Dave From: [email protected] <[email protected]> On Behalf Of vince Sent: Friday, October 1, 2021 6:53 PM To: weewx-user <[email protected]> Subject: Re: [weewx-user] Weewx MySQL help 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] <mailto:[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] <mailto:[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] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of vince Sent: Friday, October 1, 2021 3:27 PM To: weewx-user <[email protected] <mailto:[email protected]> > Subject: Re: [weewx-user] Weewx MySQL help On Friday, October 1, 2021 at 2:23:56 PM UTC-7 [email protected] <mailto:[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] <mailto:[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] <mailto:[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 <https://groups.google.com/d/msgid/weewx-user/75cd921b-3f15-4ce3-99f6-13908eca5187n%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/005a01d7b78e%24cca82690%2465f873b0%24%40gmail.com.
