[weewx-user] Re: Sqlite rookie errors

2018-11-14 Thread gjr80 
Hi,

When you tried sudo exactly what command did you use? The correct placement 
of sudo would be:

$  echo "UPDATE archive SET windGust=NULL  WHERE (windGust  > 100);" | sudo 
sqlite3 /var/lib/weewx/tmp/weewxback.sdb

Gary

On Thursday, 15 November 2018 14:20:33 UTC+10, Colin Larsen wrote:
>
> Hi all
>
> I know this is a simple fix but my sql/linux skills need a hand.
>
> I'm trying to get rid of errant data in windGust using the example in 
> Github.
>
> I copied the weewx.sdb file to /var/lib/weewx/tmp (after creating tmp), 
> and ran the commands below with an "unable to open database file error". 
> Did a chmod 666 thinking it might be permissions but still no go. Also 
> tried sudo. What did I miss?
>
> *pi@raspberrypi*:*/var/lib/weewx/tmp $* ls -l
>
> total 1180
>
> -rw-rw-rw- 1 root root 1208320 Nov 15 17:07 weewxback.sdb
>
> *pi@raspberrypi*:*/var/lib/weewx/tmp $* echo "UPDATE archive SET 
> windGust=NULL  WHERE (windGust  > 100);" | sqlite3 
> /var/lib/weewx/tmp/weewxback.sdb
>
> Error: near line 1: unable to open database file
>
> *pi@raspberrypi*:*/var/lib/weewx/tmp $* 
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[weewx-user] Re: Sqlite rookie errors

2018-11-14 Thread Colin Larsen 
The SELECT query does find the rouge records so I know I have the db name 
etc correct
>
>
*pi@raspberrypi*:*/var/lib/weewx/tmp $* echo "SELECT * FROM archive WHERE 
(windGust  > 100);" | sqlite3 /var/lib/weewx/tmp/weewxback.sdb

1541477100|16|5|1015.63406205386|1014.94112877484|1015.3380873102|20.8|18.2190082644628|50.0|60.3553719008264|32.2668425791104|341.022851705169|106.217232001969|315.0|0.0|0.0|10.4055078790016|18.2190082644628|18.2190082644628|0.00166485423528066|134.057851239669|1.57520661157025|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0||

1541477400|16|5|1015.74543504294|1015.05175906703|1015.44877912945|20.8268518518519|17.20139|50.0|63.19167|34.6681243339758|344.986725837175|106.217232001969|315.0|0.0|0.0|10.1329887215269|17.20139|17.20139|0.00167964919109554|104.25|1.512501|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0||

1542229500|16|5|1027.31710120178|1026.62485573394|1027.02830518995|20.7139577594123|20.5674931129477|56.0|60.0413223140496|6.46400885962392|7.44990218995227|109.435936002028|67.0|0.0|0.0|12.5361133103238|20.5674931129477|20.5674931129477|0.00262791834275244|507.074380165289|5.18532231404959|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0||

1542229800|16|5|1027.34974066616|1026.65706950735|1027.06053684033|20.67222|20.3518518518519|56.0|60.44167|6.79951220012602|350.985120187468|109.435936002028|67.0|0.0|0.0|12.4345174317077|20.3518518518519|20.3518518518519|0.00266028720245799|563.5583|5.889333|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0||

1542238200|16|5|1026.82061751635|1026.12968326586|1026.53285791421|22.2467592592593|21.799537037037|52.225|56.71667|8.56502589846382|331.062134258983|210.825112003907|313.0|0.0|0.0|12.8182544622233|21.79802259887|21.799537037037|0.00410429387224712|870.2667|4.82|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0||

1542238500|16|5|1026.77947709822|1026.08860020855|1026.49175205575|22.27778|21.783287419651|52.4380165289256|56.8925619834711|9.03099180182026|334.111099221049|210.825112003907|313.0|0.0|0.0|12.8506845658468|21.783287419651|21.783287419651|0.00414715091931264|874.454545454545|4.89669421487604|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|||0.0|0.0|0.0|0.0|0.0|0.0||1.0|0.0||

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[weewx-user] Sqlite rookie errors

2018-11-14 Thread Colin Larsen 
Hi all

I know this is a simple fix but my sql/linux skills need a hand.

I'm trying to get rid of errant data in windGust using the example in
Github.

I copied the weewx.sdb file to /var/lib/weewx/tmp (after creating tmp), and
ran the commands below with an "unable to open database file error". Did a
chmod 666 thinking it might be permissions but still no go. Also tried
sudo. What did I miss?

*pi@raspberrypi*:*/var/lib/weewx/tmp $* ls -l

total 1180

-rw-rw-rw- 1 root root 1208320 Nov 15 17:07 weewxback.sdb

*pi@raspberrypi*:*/var/lib/weewx/tmp $* echo "UPDATE archive SET
windGust=NULL  WHERE (windGust  > 100);" | sqlite3
/var/lib/weewx/tmp/weewxback.sdb

Error: near line 1: unable to open database file

*pi@raspberrypi*:*/var/lib/weewx/tmp $*

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[weewx-user] wlink driver | Vantage Pro2 Plus | ISS signal (rxCheckPercent)

2018-11-14 Thread trrisner 
Is there a way to get the ISS Signal Strength via the wlink driver? 
I'm aware that the Vantage Station Data does not list it as a possible 
variable, but with the Pro 2, weatherlink software does have that variable, 
but it cannot be pulled using the wlink driver. 

Thanks!

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Multiple errors in weewx 3.8.2

2018-11-14 Thread Andrew Milner 
Gary - FYI - there are only 3 countries who change clocks back at midnight 
- Brazil, Cuba and I think one other - everyone else changes at 0200 or 
0100, so on your reasoning would not have any issues.  A specific fudge may 
therefore not be too unreasonable an approach.

On Wednesday, 14 November 2018 15:27:00 UTC+2, Jonis Maurin Ceará wrote:
>
> tks! 
> :)
>
> Em qua, 14 de nov de 2018 às 11:19, gjr80  > escreveu:
>
>> Yes that link is exactly the same problem. Seems the issue was identified 
>> but never fixed. I know that a gambiarra was posted in that thread but I 
>> don't think that is really a viable long term solution. As I said earlier 
>> this is a presentation issue and not affecting the data going to database 
>> so I think we can take a little longer to work through and fix it properly. 
>> So that we don't lose track of it this time I have raised issue #356 
>> .
>>
>> Gary
>>
>> -- 
>> 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/llOh8p8emYY/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.
>>
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Multiple errors in weewx 3.8.2

2018-11-14 Thread Jonis Maurin Ceará 
tks!
:)

Em qua, 14 de nov de 2018 às 11:19, gjr80  escreveu:

> Yes that link is exactly the same problem. Seems the issue was identified
> but never fixed. I know that a gambiarra was posted in that thread but I
> don't think that is really a viable long term solution. As I said earlier
> this is a presentation issue and not affecting the data going to database
> so I think we can take a little longer to work through and fix it properly.
> So that we don't lose track of it this time I have raised issue #356
> .
>
> Gary
>
> --
> 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/llOh8p8emYY/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> weewx-user+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Multiple errors in weewx 3.8.2

2018-11-14 Thread gjr80 
Yes that link is exactly the same problem. Seems the issue was identified 
but never fixed. I know that a gambiarra was posted in that thread but I 
don't think that is really a viable long term solution. As I said earlier 
this is a presentation issue and not affecting the data going to database 
so I think we can take a little longer to work through and fix it properly. 
So that we don't lose track of it this time I have raised issue #356 
.

Gary

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.