I find I use sudo with almost everything on the rpi - as my Linux knowledge is low !!
On Tuesday, 11 July 2017 05:06:21 UTC+3, Alex Miler wrote: > Thank you Andrew - my bad for not searching for sqlite3 inline commands. I > found what the issue was; I did not have a root privilege when running the > import script. There was no any indication that data was not written into > database. Script completed and final message was that everything was > successful. However, after inspection of the database, number of entries > was only few hundred rather than tens of thousands entries (record every 5 > minutes for the past few months). Running "sudo wee_import ..." solve the > problem. > > Thanks again. > > On Monday, July 10, 2017 at 10:46:14 AM UTC-4, Andrew Milner wrote: >> >> the 'easiest' way is to use something like phpliteadmin or the other way >> is to execute sql statements directly using SQLite. >> >> More info about both can readily be found on the web. >> >> You can check for more than one database with >> sudo find / -name weewx.sdb -print >> >> >> >> On Monday, 10 July 2017 17:23:47 UTC+3, Alex Miler wrote: >> >>> No, I have not looked at the database. What is the easiest way to >>> display the SQL database and poke around? By the way, I can see that >>> database is around 180kb big and with time stamp that is advancing every >>> few minutes. To me, it seems reasonable to have 180kb big file with around >>> 6 months worth of weather data. I have not checked the size before the >>> import command so I cannot comment the difference before.after the import. >>> >>> On Monday, July 10, 2017 at 9:39:12 AM UTC-4, Andrew Milner wrote: >>>> >>>> Have you tried just looking at the database, or querying the database >>>> to see what data is actually in it?? It sounds as though you may possibly >>>> have got two different .sdb files being used - one which was used for the >>>> import, and weewx has created it's own because it could not find the >>>> database specified in weewx.conf for some reason or another. >>>> >>>> >>>> >>>> >>>> >>>> On Monday, 10 July 2017 15:59:22 UTC+3, Alex Miler wrote: >>>> >>>>> Hello, >>>>> >>>>> I am planning on moving my Davis Vue station of the PC (running >>>>> uploader to WU and other weather databases) to a Rasberry Pi. I was >>>>> playing >>>>> around with Weewx offline (setup as simulator) and with various skins >>>>> available. I have successfully imported data from the past 6 months (just >>>>> for testing) from the WU database. Everything seems to work (from import >>>>> side, no errors) but no historical data page or any other page is showing >>>>> the data that was imported. The only stuff that is been shown is the >>>>> semi-random data generated by the simulator. >>>>> >>>>> Any suggestion on how to debug the issue? Is it possible to see >>>>> historical data even if you setup weewx in "simulator mode"? If yes, what >>>>> would the reason why data is not shown? Pages are been generated on a >>>>> regular basis and with updated data from the simulator but no data that >>>>> was >>>>> imported. >>>>> >>>>> Alex >>>>> >>>> -- 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]. For more options, visit https://groups.google.com/d/optout.
