I think it's possibly DNS related. Can your raspberry resolve a hostname 'mysql' to the IP address of the server running the database ?
On Friday, October 1, 2021 at 5:39:48 AM UTC-7 Tom Keffer wrote: > This could be due to any number of reasons. Insufficient privilege to open > up the socket, firewall issues, bad password, or even that you have not > installed the MySQL server. > > Can you connect by using the mysql tool? For example, for user 'weewx': > > *mysql -u weewx -p* > > But, honestly, do you need MySQL? It is much harder to administer. If you > don't have experience with it, you should stick with SQLite. See the Wiki > article *SQLite vs MySQL > <https://github.com/weewx/weewx/wiki/SQLite-vs-MySQL>*. > > -tk > > On Thu, Sep 30, 2021 at 7:35 PM <[email protected]> wrote: > >> Ok, Hopefully this is the last thing that I need help with on my rebuild. >> I have another server that is running MySQL and I am able to log into it >> with now issues. I have created an account for weewx. I have verified that >> I can log with that account. I have a DNS entry point to mysql. I have even >> tried using the IP of the MySQL server and still get the same results. Does >> anyone have any idea on why I can not connect to the server while running >> weewx? >> >> >> >> I have attached the log and highlighted the error in red. >> >> >> >> Thanks for all your help >> >> Dave >> >> >> >> ct 1 03:28:08 raspberrypi systemd[1]: Starting LSB: weewx weather >> system... >> >> Oct 1 03:28:08 raspberrypi weewx[1480] INFO __main__: Initializing weewx >> version 4.5.1 >> >> Oct 1 03:28:08 raspberrypi weewx[1480] INFO __main__: Using Python 3.7.3 >> (default, Jan 22 2021, 20:04:44) #012[GCC 8.3.0] >> >> Oct 1 03:28:08 raspberrypi weewx[1480] INFO __main__: Platform >> Linux-5.10.60-v7+-armv7l-with-debian-10.10 >> >> Oct 1 03:28:08 raspberrypi weewx[1480] INFO __main__: Locale is >> 'en_US.UTF-8' >> >> Oct 1 03:28:08 raspberrypi weewx[1480] INFO __main__: PID file is >> /var/run/weewx.pid >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO __main__: Using >> configuration file /home/weewx/weewx.conf >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO __main__: Debug is 0 >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO weewx.engine: Loading >> station type SDR (user.sdr) >> >> Oct 1 03:28:08 raspberrypi weewx[1470]: Starting weewx weather system: >> weewx. >> >> Oct 1 03:28:08 raspberrypi systemd[1]: Started LSB: weewx weather system. >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO user.sdr: driver version is >> 0.78 >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO user.sdr: sensor map is >> {'outTemp': 'temperature.0010.AcuriteAtlasPacket', 'outHumidity': >> 'humidity.0010.AcuriteAtlasPacket', 'outBatteryStatus': >> 'battery.0010.AcuriteAtlasPacket', 'rain_total': >> 'rain_total.0010.AcuriteAtlasPacket', 'windSpeed': >> 'wind_speed.0010.AcuriteAtlasPacket', 'windDir': >> 'wind_speed.0010.AcuriteAtlasPacket'} >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO user.sdr: deltas is {'rain': >> 'rain_total', 'strikes': 'strikes_total'} >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO user.sdr: startup process >> 'sudo /usr/local/bin/rtl_433 -M utc -F json' >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO weewx.engine: StdConvert >> target unit is 0x1 >> >> Oct 1 03:28:08 raspberrypi weewx[1484] INFO user.sdr: shutdown process >> sudo /usr/local/bin/rtl_433 -M utc -F json >> >> Oct 1 03:28:09 raspberrypi kernel: [ 1756.310053] r820t 12-001a: >> destroying instance >> >> Oct 1 03:28:09 raspberrypi kernel: [ 1756.310646] dvb_usb_v2: 'Realtek >> RTL2832U reference design:1-1.1.2' successfully deinitialized and >> disconnected >> >> Oct 1 03:28:28 raspberrypi weewx[1484] INFO user.sdr: timed out waiting >> for stderr-thread >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.066292] usb 1-1.1.2: >> dvb_usb_v2: found a 'Realtek RTL2832U reference design' in warm state >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.120633] usb 1-1.1.2: >> dvb_usb_v2: will pass the complete MPEG2 transport stream to the software >> demuxer >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.120679] dvbdev: DVB: >> registering new adapter (Realtek RTL2832U reference design) >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.120699] usb 1-1.1.2: media >> controller created >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.123765] dvbdev: >> dvb_create_media_entity: media entity 'dvb-demux' registered. >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.141830] i2c i2c-11: Added >> multiplexed i2c bus 12 >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.141856] rtl2832 11-0010: >> Realtek RTL2832 successfully attached >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.141950] usb 1-1.1.2: DVB: >> registering adapter 0 frontend 0 (Realtek RTL2832 (DVB-T))... >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.141984] dvbdev: >> dvb_create_media_entity: media entity 'Realtek RTL2832 (DVB-T)' registered. >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.142268] r820t 12-001a: >> creating new instance >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.149430] r820t 12-001a: Rafael >> Micro r820t successfully identified >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.163816] rtl2832_sdr >> rtl2832_sdr.0.auto: Registered as swradio0 >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.163840] rtl2832_sdr >> rtl2832_sdr.0.auto: Realtek RTL2832 SDR attached >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.163854] rtl2832_sdr >> rtl2832_sdr.0.auto: SDR API is still slightly experimental and >> functionality changes may follow >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.176856] Registered IR keymap >> rc-empty >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.177023] rc rc0: Realtek >> RTL2832U reference design as >> /devices/platform/soc/3f980000.usb/usb1/1-1/1-1.1/1-1.1.2/rc/rc0 >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.177233] rc rc0: lirc_dev: >> driver dvb_usb_rtl28xxu registered at minor = 0, raw IR receiver, no >> transmitter >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.177435] input: Realtek >> RTL2832U reference design as >> /devices/platform/soc/3f980000.usb/usb1/1-1/1-1.1/1-1.1.2/rc/rc0/input14 >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.177840] usb 1-1.1.2: >> dvb_usb_v2: schedule remote query interval to 200 msecs >> >> Oct 1 03:28:31 raspberrypi kernel: [ 1779.186235] usb 1-1.1.2: >> dvb_usb_v2: 'Realtek RTL2832U reference design' successfully initialized >> and connected >> >> Oct 1 03:28:31 raspberrypi weewx[1484] CRITICAL __main__: Database >> connection exception: (2002, "Can't connect to MySQL server on 'mysql' >> (115)") >> >> Oct 1 03:28:31 raspberrypi weewx[1484] CRITICAL __main__: **** >> Waiting 60 seconds then retrying... >> >> Oct 1 03:28:32 raspberrypi systemd-udevd[1516]: Process >> '/usr/sbin/th-cmd --socket /var/run/thd.socket --passfd --udev' failed with >> exit code 1. >> >> -- >> 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/016d01d7b66d%24088feee0%2419afcca0%24%40gmail.com >> >> <https://groups.google.com/d/msgid/weewx-user/016d01d7b66d%24088feee0%2419afcca0%24%40gmail.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/e19d6303-420e-4da5-bb16-10e317836897n%40googlegroups.com.
