(trying a third and last time - google groups deleted my first two attempts for some unknown reason)
Check your DNS settings and make sure that your pi can resolve the IP address of the hostname you defined for your database server. On Thursday, September 30, 2021 at 7:35:49 PM UTC-7 [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/aef61913-11df-4eb4-83bf-5051a4e5862cn%40googlegroups.com.
