SDR/RTL Process stops when using MySQL Database

[Clay Jackson]

Just getting started with weewx and an Acurite station that does not support USB - so, I'm using SDR/RTL.

If I set up to use a MySQL (Maria, actually) database on a different server, when I start weewx, the RTL process starts and then IMMEDIATELTY shuts down.    I haven't done a LOT more debugging on this, yet - wanted to see if anyone else has run into this.

Here's the log:

Feb  4 22:48:45 Weather weewx[1349]: engine: Initializing weewx version 3.6.2
Feb  4 22:48:45 Weather weewx[1349]: engine: Using Python 2.7.9 (default, Sep 17 2016, 20:26:04) #012[GCC 4.9.2]
Feb  4 22:48:45 Weather weewx[1349]: engine: Platform Linux-4.4.38-v7+-armv7l-with-debian-8.0
Feb  4 22:48:45 Weather weewx[1349]: engine: Using configuration file /home/weewx/weewx.conf
Feb  4 22:48:45 Weather weewx[1349]: engine: Loading station type SDR (user.sdr)
Feb  4 22:48:45 Weather weewx[1349]: sdr: MainThread: driver version is 0.21
Feb  4 22:48:45 Weather weewx[1349]: sdr: MainThread: sensor map is {'windDir': 'wind_dir.04C9.Acurite5n1Packet', 'windSpeed': 'wind_speed.04C9.Acurite5n1Packet', 'outTemp': 'temperature.04C9.Acurite5n1Packet', 'outHumidity': 'humidity.04C9.Acurite5n1Packet', 'rain_total': 'rain_total.04C9.Acurite5n1Packet'}
Feb  4 22:48:45 Weather weewx[1349]: sdr: MainThread: deltas is {'strikes': 'strikes_total', 'rain': 'rain_total'}
Feb  4 22:48:45 Weather weewx[1349]: sdr: MainThread: startup process 'rtl_433 -q -U -F json -G'
Feb  4 22:48:45 Weather weewx[1349]: engine: StdConvert target unit is 0x1
Feb  4 22:48:45 Weather weewx[1349]: wxcalculate: The following values will be calculated: barometer=prefer_hardware, windchill=prefer_hardware, dewpoint=prefer_hardware, appTemp=prefer_hardware, rainRate=prefer_hardware, windrun=prefer_hardware, heatindex=prefer_hardware, maxSolarRad=prefer_hardware, humidex=prefer_hardware, pressure=prefer_hardware, inDewpoint=prefer_hardware, ET=prefer_hardware, altimeter=prefer_hardware, cloudbase=prefer_hardware
Feb  4 22:48:45 Weather weewx[1349]: wxcalculate: The following algorithms will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS
Feb  4 22:48:45 Weather weewx[1349]: engine: Archive will use data binding wx_binding
Feb  4 22:48:45 Weather weewx[1349]: engine: Record generation will be attempted in 'hardware'
Feb  4 22:48:45 Weather weewx[1349]: engine: Using archive interval of 300 seconds (specified in weewx configuration)
Feb  4 22:48:45 Weather weewx[1349]: engine: Using binding 'wx_binding' to database 'weewx.sdb'
Feb  4 22:48:45 Weather weewx[1349]: manager: Starting backfill of daily summaries
Feb  4 22:48:45 Weather weewx[1349]: manager: Daily summaries up to date
Feb  4 22:48:45 Weather weewx[1349]: restx: StationRegistry: Registration not requested.
Feb  4 22:48:45 Weather weewx[1349]: restx: Wunderground: Posting not enabled.
Feb  4 22:48:45 Weather weewx[1349]: restx: PWSweather: Posting not enabled.
Feb  4 22:48:45 Weather weewx[1349]: restx: CWOP: Posting not enabled.
Feb  4 22:48:45 Weather weewx[1349]: restx: WOW: Posting not enabled.
Feb  4 22:48:45 Weather weewx[1349]: restx: AWEKAS: Posting not enabled.
Feb  4 22:48:45 Weather weewx[1349]: engine: Starting up weewx version 3.6.2
Feb  4 22:48:45 Weather weewx[1349]: engine: Starting main packet loop.
Feb  4 22:50:13 Weather weewx[1349]: sdr: MainThread: shutdown process rtl_433 -q -U -F json -G

[mwall]

On Sunday, February 5, 2017 at 2:47:32 AM UTC-5, Clay Jackson wrote:

Just getting started with weewx and an Acurite station that does not support USB - so, I'm using SDR/RTL.

If I set up to use a MySQL (Maria, actually) database on a different server, when I start weewx, the RTL process starts and then IMMEDIATELTY shuts down.    I haven't done a LOT more debugging on this, yet - wanted to see if anyone else has run into this.

i'll bet it has nothing to do with sdr and everything to do with maria.

set debug=1 in weewx.conf.  run weewx directly (not as a daemon) in one shell as you monitor the log in a second shell.

then report what you find.

m

[Clay Jackson]

Problem solved!   Turns out that after a reconfigure changes the station, the database needs to dropped and recreated empty.

 

Thanks!

Clay Jackson

 

 

From: weewx...@googlegroups.com [mailto:weewx...@googlegroups.com] On Behalf Of mwall
Sent: Sunday, February 5, 2017 5:47 AM
To: weewx-user <weewx...@googlegroups.com>
Subject: [weewx-user] Re: SDR/RTL Process stops when using MySQL Database

 

On Sunday, February 5, 2017 at 2:47:32 AM UTC-5, Clay Jackson wrote:

Just getting started with weewx and an Acurite station that does not support USB - so, I'm using SDR/RTL.

If I set up to use a MySQL (Maria, actually) database on a different server, when I start weewx, the RTL process starts and then IMMEDIATELTY shuts down.    I haven't done a LOT more debugging on this, yet - wanted to see if anyone else has run into this.

i'll bet it has nothing to do with sdr and everything to do with maria.

set debug=1 in weewxconf.  run weewx directly (not as a daemon) in one shell as you monitor the log in a second shell.

then report what you find.

m

--
You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/Z5w7qUFUUBQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Andrew Milner]

Clay - since weewx configuration changes do not usually require a database to be dropped and recreated empty can you clarify what reconfiguration changes you had made and what the logs showed?

[Clay Jackson]

Yeah – I changed the station type from simulator (testing) to SDR (I have an Acurite 5n1 with a console that does not support USB).

To unsubscribe from this group and all its topics, send an email to weewx-user+..@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Andrew Milner]

Aha - that makes more sense now - a little bit more than just a reconfiguration (depending on how you were running the simulator and what dates/times you were using).  Yes, switching from 'test mode' to 'live mode' would more than likely require the database tables being dropped, NOAA files deleting and probably more things cleaned up also.  Thanks for the additional info.

[Clay Jackson]

Yeah – and now that I’ve done it; it definitely makes sense – caught me by surprise more than anything.