Weewx Not Writing to Database

[Jonathan Emmert]

I have just installed Weewx on Lubuntu (22.04.5) but it doesn't seem to be writing to the sqlite db. Relevant notes. 

• Installed directly from Git
• Using a Vevor 7in1 Weather station
  • Communicating to the computer via rtl_433
  • rtl_433 is running correctly (have the command line in sdr.py also writing a json which is updating as expected)
  • I have installed the weewx-sdr add-on
• I have attached my syslog for a 15 minute run (debug = 1 enabled)

Any help is appreciated.

[vince]

A log in RTF format ?  Please.  Text files only.

I see nothing in your file with the string weewx.  See https://www.weewx.com/docs/5.1/usersguide/monitoring/#status for how to get the actual logs for your os.   Be sure to set debug=1 in weewx and restart weewx afterward to get verbose logging.

[Jonathan Emmert]

Sorry about that. Are these what you needed?

[vince]

40 lines isn't enough.  We need the debug=1 syslog from startup of the weewx process through at least one or two reporting cycles (typically 10 min+).

https://github.com/weewx/weewx/wiki/Help!-Posting-to-weewx-user#how-to-get-a-good-useful-log

[Tom Keffer]

For some reason, your installation is looking for the templates where the generated files normally go.

Please use the utility "weectl debug" to create an obfuscated copy of your configuration file, weewx.conf:

weectl debug --output=/var/tmp/debug.txt

Take a look at debug.txt and make sure that it does not include any of your passwords. Then post it here.

-tk

--
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 weewx-user+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/weewx-user/1c34fc81-5f78-464d-b857-e0269270a3e6n%40googlegroups.com.

[Jonathan Emmert]

Attached

[Jonathan Emmert]

I gotcha - I was having some trouble getting those. I've attached 2 logs, both with a. 20 minute run.

[vince]

Your syslog doesn't mention weewx at all.  Your journalctl log is under 'one' second of data from initial startup.  Give it another try please.

[Jonathan Emmert]

Okay...progress. I ran the report again and got the exact same results. I changed my Default Command where I was outputting the json to a specific folder/file. I modified that to just export the json to the default location. That changed the logs and I am now seeing data generated. (New logs attached.)

That being said, I still see 2 issues:

1. Mobile report showing errors

2. Not uploading to WeatherUnderground

[vince]

I'm sorry but again you need to provide the weewx log data, not the os log data (which is not including anything weewx for some reason).  There is no mention of weewx in your 'syslog' attachment at all.

Since you seem to be running rsyslog according to one log snippet, you might trying switching to rsyslog for your weewx logging to make finding the log data easier.  You can do this via:

sudo cp /etc/weewx/rsyslog.d/weewx.conf /etc/rsyslog.d/weewx.conf

sudo systemctl restart rsyslog

sudo systemctl restart weewx

Then your weewx logs will be in /var/log/weewx/weewx.log and nice and easy to grab.  You will probably need to use sudo to read them.

(I tested the above using debian12 so it should work the same on anything 'buntu)

[Jonathan Emmert]

Alright...trying that now. Sorry for the confusion, I'm obviously not used to Linux.  I've attached the journalctl logs, they are showing Weewx now.

When I run the copy command above I get the following error: cp: '/etc/weewx/rsyslog.d/weewx.conf' and '/etc/rsyslog.d/weewx.conf' are the same file

I see the weewx.log file now, but it is empty.

[vince]

ok - a little better at least.   Your weewx seems to be running ok, receiving data from your SDR, and saving it to the database.  That's the first part.

The Seasons skin is working and writing to  /var/www/html/weewx as expected.  That means you 'should' see the generated web pages at http://yourhostname_or_ip_here/weewx if you have a webserver installed and running locally.

You have a typo in weewx.conf for your MobileReport stanza.  You 'probably' set HTML_ROOT = true when you meant enable = true there.

WeatherUnderground is failing but lets leave that til the end after everything else is working,.

Suggest you do what Tom asked yesterday so we can see your weewx.conf file:

(from Tom's post...)

Please use the utility "weectl debug" to create an obfuscated copy of your configuration file, weewx.conf:

weectl debug --output=/var/tmp/debug.txt

Take a look at debug.txt and make sure that it does not include any of your passwords. Then post it here.

[Jonathan Emmert]

Alright, I think we can mark this as resolved. Here are a rundown of the things I had to correct:

1. Bad command in the Default Command line (changed 'rtl_433 -M utc -R 263 -F json:/var/tmp/Vevor.json -Y classic -f 915M' to 'rtl_433 -M utc -R 263 -F json -Y classic -f 915M')
2. Typo in the Mobile Reports line
3. Had to add permissions to the weewx user to /var/www/html/weewx & to /var/www/html
4. Had a DNS error on the system that was preventing upload to WeatherUnderground

I am now running error free, all reports are generating and WeatherUnderground is receiving data.

Thank you Vince & Tom! I appreciate you sticking with me.