Display of measured values in the terminal? RPI

[karlch...@googlemail.com]

Hi,

I have an installation of weewx running on a raspberry pi - and would now like to check remotely via the terminal whether all measured values are recorded, or which measured values were currently retrieved by weewx from a Davis 2 Pro.
Unfortunately I can't find a command which allows this in the terminal - or is there a debug command which can display all measured values or transferred data? Would be a great advantage for troubleshooting if you could quickly take a look at the values via terminal.

VNC or similar is unfortunately not an option - as I only have terminal access - and need to find out why the data of the soil moisture sensors are not retrieved from meteotemplate.

[Tom Keffer]

On one of my installations I run an rsync command to copy the SQLite database file to a remote server. This way I can check the file and make sure everything is working.

--
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 on the web visit https://groups.google.com/d/msgid/weewx-user/5ee85acf-4cbf-4f1a-838e-ee6949621807n%40googlegroups.com.

[Tom Keffer]

Thank you in advance - but as long as the raspberry pi is just connected via cellular contract with just a few gigs per month... its not possible to copy the database. is there any other possibility to just view the last line of the database. why isnt there any function in weewx to view all data in terminal?

Not sure what you're asking for here. You said you have terminal access (but not VNC). Why not just check the SQLite database using sqlite3? Or, look at the generated webpages?

You also say you "...need to find out why the data of the soil moisture sensors are not retrieved from meteotemplate."

Why not ask the meteotemplate guys? 

[Cameron D]

For a simple command line tool, use the sqlite3 program and provide a command like..

 SELECT * FROM archive ORDER BY dateTime DESC LIMIT 10;

will print the last 10 rows.  Or to get a bit fancier replace the '*' with just the fields you are interested in...

 SELECT dateTime, datetime( dateTime, 'unixepoch') as dt,  outTemp, etc FROM archive ORDER BY dateTime DESC LIMIT 10;