[weewx-user] Re: importing weewx.sql not working

[VE4PER / Andy]

I use mysql because I am familiar with it.

I managed to get weewx ver 4 communicate with ACUrite display unit ptoper 
and with no logged errors. I was able to create a database named "weewx" 
with a new empty table with 114 columns named as posted here in this group 
post. I created the weewx user with password weewx on that database. I was 
able to log into the database using that userID and PW to verify the 
existence of the proper empty table which of course proves weewx ver 4 shud 
be able to log in and update the database; but it does not do it. Why I do 
not know. I purged all of weewx and re-installed it fresh to ensure it had 
not missed an initial connection to the database during the install 
process. To no avail; I have moved the display unit back onto the machine 
running linux 18.04lts instead of the currently available 20.04, and it is 
running weewx older version; BUT IT WORKS properly. 



On Sunday, May 17, 2020 at 8:07:46 PM UTC-5, VE4PER / Andy wrote:
>
> Hello,
>
> I did an export database from old mysql db using phpmyadmin. I copied the 
> weewx.sql file over to the new machine and tried to import data into the 
> empty weewx database using phpmyadmin. I kept getting errors on import; I 
> amend UPLOAD_MAX  POST_MAX to 64MB and also doubled time to 60 from 30 but 
> still generating errors size is 55.4 MB for weewx.sql file;  zipped it is 
> 8.1 MB but neither will import using phpmyadmin.
>
> Tried using mysql command line and all it seems to do is generate command 
> syntax errors. took commands from examples in mysql ref manual for vers 8
>
> I have system down for a number of hours now and unable to get old data in 
> to create the required archive table so info not being sent to remote 
> users. Usually in the past, if I remove /uninstall weewx and then reinstall 
> it from scratch it created the mysql database and tables ; doesn't now 
> though.
>
> Any tips or pointers would be appreciated
>
> Thanks
> Andy
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/674b0c35-78e3-42a6-99ce-94dc6d2a7538%40googlegroups.com.

Re: [weewx-user] Looking for somewhat 'open' weather station to use with Raspberry based projects

[vince]

On Monday, May 18, 2020 at 12:53:16 PM UTC-7, Luc Heijst wrote:
>
> The data protocol of their (not so cheap) data-loggers is publiced by 
> Davis, but I know from first hand that the raw data the sensors send to the 
> console is not public. I have put a lot of time in decoding the signals 
> (among others) and still we don’t know the full protocol yet.
>
>
Yet strangely enough the WeatherLinkLive API 'is' published 
- https://weatherlink.github.io/weatherlink-live-local-api/


-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/e63a91a3-722b-4565-83d5-b60da5422262%40googlegroups.com.

[weewx-user] Re: Vantage Vue Archive not working

[Jeff Rabin]

Yes, tried the clear_memory and did not fix it.

BUT, wow, what a find.   "record_generation = software" and all is working!

Thanks!
Jeff

On Monday, May 18, 2020 at 5:00:06 PM UTC-4, gjr80 wrote:
>
> Hi,
>
> Could be a case of corrupt station memory, have you tried clearing the 
> logger? 
> https://github.com/weewx/weewx/wiki/Troubleshooting-the-Davis-Vantage-station#corrupt-station-memory
>
> 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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/edad8c88-f72d-4dcc-9bf6-b3879cf165d8%40googlegroups.com.

Re: [weewx-user] Vantage Vue Archive not working

[Tom Keffer]

You can have WeeWX generate archive records in software. Just set the
option record_generation to software:

[StdArchive]

# Set the following to "software" to force software record generation.
record_generation = software

-tk

On Mon, May 18, 2020 at 1:54 PM Jeff Rabin  wrote:

> For some insane reason I decided to upgrade my Vantage Vue firmware and
> clear the memory.   Don't ask why, I just did (nothing was broken).
>
> Now the console will not update the archive records.I've tried
> changing the archive length and back (for debug), battery/power pull, etc.
>  Nothing works.   I just bought a new USB logger per the help desk at
> Davis, but that will take some days to get here.
>
> Quick question.   It appears the web file generation and online service
> updates (I use PWS and Wunderground) only get generated per the archive
> record.   So I am getting no updates sent out.   Is there a config option
> to use the Loop?
>
> BTW, I know for sure I am getting loop records as MQTT is sending to my
> HomeAssistant server just fine.
>
> May 18 16:35:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting
> archive packets since 2020-05-18 08:00:00 EDT (1589803200)
>
> May 18 16:35:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
> May 18 16:35:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Retrieving 0 page(s); starting index= 0
>
> May 18 16:35:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Requesting 200 LOOP packets.
>
> May 18 16:35:18 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
> May 18 16:40:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting
> archive packets since 2020-05-18 08:00:00 EDT (1589803200)
>
> May 18 16:40:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
> May 18 16:40:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Retrieving 0 page(s); starting index= 0
>
> May 18 16:40:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Requesting 200 LOOP packets.
>
> May 18 16:40:18 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
> May 18 16:45:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting
> archive packets since 2020-05-18 08:00:00 EDT (1589803200)
>
> May 18 16:45:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
> May 18 16:45:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Retrieving 0 page(s); starting index= 0
>
> May 18 16:45:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Requesting 200 LOOP packets.
>
> May 18 16:45:18 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
> May 18 16:50:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting
> archive packets since 2020-05-18 08:00:00 EDT (1589803200)
>
> May 18 16:50:21 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retry #0
> failed
>
> May 18 16:50:25 acer weewx[3602] ERROR weewx.drivers.*vantage*: ip-read
> error: timed out
>
> May 18 16:50:25 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retry #1
> failed
>
> May 18 16:50:26 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
> May 18 16:50:27 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Retrieving 0 page(s); starting index= 0
>
> May 18 16:50:27 acer weewx[3602] DEBUG weewx.drivers.*vantage*:
> Requesting 200 LOOP packets.
>
> May 18 16:50:27 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle
> wake up of console successful
>
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/963e2a23-901e-4a00-ac5c-0d1f2b98f0d9%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAPq0zEC5n7Wxc2zHtTDhM9ZRZNJUsfwLLh11YmaR0q0dnYhjig%40mail.gmail.com.

[weewx-user] Vantage Vue Archive not working

[gjr80]

Hi,

Could be a case of corrupt station memory, have you tried clearing the logger? 
https://github.com/weewx/weewx/wiki/Troubleshooting-the-Davis-Vantage-station#corrupt-station-memory

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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/20b5bd8c-2611-4e8a-ba32-c7390f9e2200%40googlegroups.com.

[weewx-user] Vantage Vue Archive not working

[Jeff Rabin]

For some insane reason I decided to upgrade my Vantage Vue firmware and 
clear the memory.   Don't ask why, I just did (nothing was broken).

Now the console will not update the archive records.I've tried changing 
the archive length and back (for debug), battery/power pull, etc.   Nothing 
works.   I just bought a new USB logger per the help desk at Davis, but 
that will take some days to get here.

Quick question.   It appears the web file generation and online service 
updates (I use PWS and Wunderground) only get generated per the archive 
record.   So I am getting no updates sent out.   Is there a config option 
to use the Loop?

BTW, I know for sure I am getting loop records as MQTT is sending to my 
HomeAssistant server just fine.

May 18 16:35:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting 
archive packets since 2020-05-18 08:00:00 EDT (1589803200)

May 18 16:35:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful

May 18 16:35:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retrieving 
0 page(s); starting index= 0

May 18 16:35:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Requesting 
200 LOOP packets.

May 18 16:35:18 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful

May 18 16:40:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting 
archive packets since 2020-05-18 08:00:00 EDT (1589803200)

May 18 16:40:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful

May 18 16:40:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retrieving 
0 page(s); starting index= 0

May 18 16:40:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Requesting 
200 LOOP packets.

May 18 16:40:18 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful

May 18 16:45:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting 
archive packets since 2020-05-18 08:00:00 EDT (1589803200)

May 18 16:45:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful

May 18 16:45:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retrieving 
0 page(s); starting index= 0

May 18 16:45:17 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Requesting 
200 LOOP packets.

May 18 16:45:18 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful

May 18 16:50:16 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Getting 
archive packets since 2020-05-18 08:00:00 EDT (1589803200)

May 18 16:50:21 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retry #0 
failed

May 18 16:50:25 acer weewx[3602] ERROR weewx.drivers.*vantage*: ip-read 
error: timed out

May 18 16:50:25 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retry #1 
failed

May 18 16:50:26 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful

May 18 16:50:27 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Retrieving 
0 page(s); starting index= 0

May 18 16:50:27 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Requesting 
200 LOOP packets.

May 18 16:50:27 acer weewx[3602] DEBUG weewx.drivers.*vantage*: Gentle wake 
up of console successful



-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/963e2a23-901e-4a00-ac5c-0d1f2b98f0d9%40googlegroups.com.

Re: [weewx-user] Looking for somewhat 'open' weather station to use with Raspberry based projects

[Tom Keffer]

True enough.

On Mon, May 18, 2020 at 12:53 PM Luc Heijst  wrote:

> Tom,
>
> The data protocol of their (not so cheap) data-loggers is publiced by
> Davis, but I know from first hand that the raw data the sensors send to the
> console is not public. I have put a lot of time in decoding the signals
> (among others) and still we don’t know the full protocol yet.
>
> Luc
>
> On Sunday, 17 May 2020 21:34:27 UTC-3, Tom Keffer wrote:
>>
>> Just to correct the record, the Vantage protocol was not reverse
>> engineered. They are one of the few vendors who have published their
>> protocol
>> ,
>> and have for many years.
>>
>> On Sun, May 17, 2020 at 5:13 PM Greg Troxel  wrote:
>>
>>> "'Ben Luria' via weewx-user"  writes:
>>>
>>> > apologies if this topic came up before or in case I am off-topic here.
>>> I'm
>>> > toying with SDR and home automation on a Raspberry Pi and would like
>>> to add
>>> > weather data via WeeWX and a weather station. Is there any particular
>>> brand
>>> > / model I should go for or maybe avoid? Am looking for something solar
>>> > powered optimally, but that is not a must.
>>>
>>> You put "open" in quotes, which means that I don't know what you mean by
>>> that word :-)
>>>
>>> There are a few things you could mean:
>>>
>>>   1) well-understood interfaces and existing drivers so that you can get
>>>   at the weather data and use it, and not have problems due to closed
>>>   interfaces
>>>
>>>   2) open protocol, or perhaps reverse-engineered protocols, for the
>>>   sensor suite (outside part) to talk to the console (inside, that you
>>>   look at, and that usually is interfaced to a computer), so that you
>>>   can sniff it with an SDR instead of using the console receiver.
>>>
>>>   3) being able to get at the weather data locally, without the device
>>>   talking to some cloud service (not under your control, subject to the
>>>   company stopping it, and likely run with proprietary software)
>>>
>>>   3A) separately from transport via cloud, can the local station produce
>>>   observations by itself, or does it need a (perhaps implemented with
>>>   proprietary software) cloud service to do that?
>>>
>>>   4) firmware/software for the weather station equipment being open
>>> source
>>>
>>>   5) an open hardware design for the station, even if it uses proprietary
>>>   chips
>>>
>>>   6) full-on open, meaning open licenses for all silicon in the station,
>>>   including CPUs and sensors, which leads you to RISC-V and for
>>>   temp/humidity I'm really not sure what.
>>>
>>>
>>> You mentioned home automation, so I would recommend you check out the
>>> mqtt extension, which is I think what most use to bridge weewx data into
>>> an automation system (such as Home Assistant, which is the natural
>>> choice for weewx fans, being open source and python).
>>>   https://github.com/weewx/weewx/wiki/mqtt
>>>
>>>
>>> For 1, there are lots of choices, and basically you should look at what
>>> weewx supports.
>>>
>>> For 2, I am not really aware of anything open, except for build-your-own
>>> kinds of stations.  But maybe weatherflow is UDP over IP and counts
>>> here.  The Davis VP2 protocol has been reverse engineered and there is
>>> rtldavis.  However, the Davis datalogger/interface in the console has
>>> the really nice property that when your computer goes down, it keeps
>>> storing data, and then when you straighten out your computer from the
>>> botched upgrade, or you get power back, weewx reads the data and your
>>> historical record is 100% fine, as if you never went down.   So I don't
>>> really want to get my data with an SDR on a unix computer, even though
>>> I'd like to try that, because I really like it that I haven't lost data
>>> the probably 6 times I've had an issue in about 2.5 years.
>>>
>>> For 3, Davis is fine, and some acurite setups have local USB.  Various
>>> other systems have "interceptor" drivers that snoop the data going to
>>> the cloud, and I have the impression that sometimes people fetch their
>>> own data back from the cloud because that's all they can do.
>>>
>>> For 3a, note Vince's comments about weatherflow and rain.  (I think
>>> weatherflow is really interesting and don't mean to knock them.  I just
>>> find the notion that you don't know how much rain you got without the
>>> internet quite curious.  On the other hand sometimes with Davis it rains
>>> and you conclude from the readings that you have a bird's nest, wasp's
>>> nest or pine needles in your rain collector or blocking the tipping
>>> bucket from tipping.)
>>>
>>> For 4, and even more so for 5, I'm not aware of any contenders, other
>>> than build-your-own with arduino and e.g. i2c sensors.  But this is
>>> very interesting and may qualify:
>>>
>>> https://www.tinkerforge.com/en/doc/Kits/WeatherStation/WeatherStation.html
>>>   

Re: [weewx-user] Graphics with calculation of data of the database

[Tom Keffer]

This trick worked by using an expression in the SQL SELECT statement.
Unfortunately, that ability got lost in V4.0.

Nevertheless, there's no good reason why it should not be allowed. Commit
e76e374

brings this ability back. Give it a try. Swap your version of xtypes.py
(probably located in either /usr/share/weewx/weewx/xtypes.py or
/home/weewx/bin/weewx/xtypes.py) with this one
.
Let me know how it goes.

-tk


On Mon, May 18, 2020 at 12:31 PM Mic G77  wrote:

> Hello,
>
> Last weekend, I moved from weewx3.8 to weewx4.0 and I'm not any more able
> to produce graph with data calculated from the database.
> If someone can help
>
> Thank you in advance.
>
>
>
>
> Le mardi 4 juin 2019 23:31:52 UTC+2, Thomas Keffer a écrit :
>>
>> That is very clever! It occurs to me you could probably combine SQL data
>> types. It doesn’t have to be just one type.
>>
>> On Tue, Jun 4, 2019 at 1:03 PM Mic G77  wrote:
>>
>>> Hello,
>>> i've been looking for a way to produce graph with data calculated from
>>> the database.
>>> I Finally find a solution. So I share it with you.
>>>
>>> This is an exemple :
>>>
>>> [[[dayPoid]]]
>>> yscale = None, None, None
>>> extraTemp2
>>> extraTest
>>> data_type = 18.3+0.03*extraHumid2
>>>
>>> In this case, i'm able to see a graph of the function : 18.3
>>> +0.03extraHumid2.
>>> I hope it could help.
>>>
>>>
>>>
>>> --
>>> 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...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/5689249a-ef2b-4c38-ad2a-72a1a2b643dc%40googlegroups.com
>>> 
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> -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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/eab7c178-93f5-4ccc-accc-d83c818a285b%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDmQV8oJ38GPqewyMc_pmOKxDczEfCSfVz38ZjmRLHLw%40mail.gmail.com.

Re: [weewx-user] Looking for somewhat 'open' weather station to use with Raspberry based projects

[Luc Heijst]

Tom,

The data protocol of their (not so cheap) data-loggers is publiced by 
Davis, but I know from first hand that the raw data the sensors send to the 
console is not public. I have put a lot of time in decoding the signals 
(among others) and still we don’t know the full protocol yet.

Luc

On Sunday, 17 May 2020 21:34:27 UTC-3, Tom Keffer wrote:
>
> Just to correct the record, the Vantage protocol was not reverse 
> engineered. They are one of the few vendors who have published their 
> protocol 
> ,
>  
> and have for many years.
>
> On Sun, May 17, 2020 at 5:13 PM Greg Troxel > 
> wrote:
>
>> "'Ben Luria' via weewx-user" > 
>> writes:
>>
>> > apologies if this topic came up before or in case I am off-topic here. 
>> I'm 
>> > toying with SDR and home automation on a Raspberry Pi and would like to 
>> add 
>> > weather data via WeeWX and a weather station. Is there any particular 
>> brand 
>> > / model I should go for or maybe avoid? Am looking for something solar 
>> > powered optimally, but that is not a must.
>>
>> You put "open" in quotes, which means that I don't know what you mean by
>> that word :-)
>>
>> There are a few things you could mean:
>>
>>   1) well-understood interfaces and existing drivers so that you can get
>>   at the weather data and use it, and not have problems due to closed
>>   interfaces
>>
>>   2) open protocol, or perhaps reverse-engineered protocols, for the
>>   sensor suite (outside part) to talk to the console (inside, that you
>>   look at, and that usually is interfaced to a computer), so that you
>>   can sniff it with an SDR instead of using the console receiver.
>>
>>   3) being able to get at the weather data locally, without the device
>>   talking to some cloud service (not under your control, subject to the
>>   company stopping it, and likely run with proprietary software)
>>
>>   3A) separately from transport via cloud, can the local station produce
>>   observations by itself, or does it need a (perhaps implemented with
>>   proprietary software) cloud service to do that?
>>
>>   4) firmware/software for the weather station equipment being open source
>>
>>   5) an open hardware design for the station, even if it uses proprietary
>>   chips
>>
>>   6) full-on open, meaning open licenses for all silicon in the station,
>>   including CPUs and sensors, which leads you to RISC-V and for
>>   temp/humidity I'm really not sure what.
>>
>>
>> You mentioned home automation, so I would recommend you check out the
>> mqtt extension, which is I think what most use to bridge weewx data into
>> an automation system (such as Home Assistant, which is the natural
>> choice for weewx fans, being open source and python).
>>   https://github.com/weewx/weewx/wiki/mqtt
>>
>>
>> For 1, there are lots of choices, and basically you should look at what
>> weewx supports.
>>
>> For 2, I am not really aware of anything open, except for build-your-own
>> kinds of stations.  But maybe weatherflow is UDP over IP and counts
>> here.  The Davis VP2 protocol has been reverse engineered and there is
>> rtldavis.  However, the Davis datalogger/interface in the console has
>> the really nice property that when your computer goes down, it keeps
>> storing data, and then when you straighten out your computer from the
>> botched upgrade, or you get power back, weewx reads the data and your
>> historical record is 100% fine, as if you never went down.   So I don't
>> really want to get my data with an SDR on a unix computer, even though
>> I'd like to try that, because I really like it that I haven't lost data
>> the probably 6 times I've had an issue in about 2.5 years.
>>
>> For 3, Davis is fine, and some acurite setups have local USB.  Various
>> other systems have "interceptor" drivers that snoop the data going to
>> the cloud, and I have the impression that sometimes people fetch their
>> own data back from the cloud because that's all they can do.
>>
>> For 3a, note Vince's comments about weatherflow and rain.  (I think
>> weatherflow is really interesting and don't mean to knock them.  I just
>> find the notion that you don't know how much rain you got without the
>> internet quite curious.  On the other hand sometimes with Davis it rains
>> and you conclude from the readings that you have a bird's nest, wasp's
>> nest or pine needles in your rain collector or blocking the tipping
>> bucket from tipping.)
>>
>> For 4, and even more so for 5, I'm not aware of any contenders, other
>> than build-your-own with arduino and e.g. i2c sensors.  But this is
>> very interesting and may qualify:
>>   
>> https://www.tinkerforge.com/en/doc/Kits/WeatherStation/WeatherStation.html
>>   https://www.tinkerforge.com/en/shop/bricklets/sensors.html
>> However, I don't see rain and wind.
>>
>> For 6, my impresssion is that I will be viewed as crazy just for
>> bringing it up.
>>
>>
>> 

Re: [weewx-user] Graphics with calculation of data of the database

[Mic G77]

Hello,

Last weekend, I moved from weewx3.8 to weewx4.0 and I'm not any more able 
to produce graph with data calculated from the database.
If someone can help

Thank you in advance.




Le mardi 4 juin 2019 23:31:52 UTC+2, Thomas Keffer a écrit :
>
> That is very clever! It occurs to me you could probably combine SQL data 
> types. It doesn’t have to be just one type.
>
> On Tue, Jun 4, 2019 at 1:03 PM Mic G77 > 
> wrote:
>
>> Hello,
>> i've been looking for a way to produce graph with data calculated from 
>> the database.
>> I Finally find a solution. So I share it with you.
>>
>> This is an exemple : 
>>
>> [[[dayPoid]]]
>> yscale = None, None, None
>> extraTemp2
>> extraTest
>> data_type = 18.3+0.03*extraHumid2
>>
>> In this case, i'm able to see a graph of the function : 18.3 
>> +0.03extraHumid2.
>> I hope it could help.
>>
>>
>>
>> -- 
>> 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...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/weewx-user/5689249a-ef2b-4c38-ad2a-72a1a2b643dc%40googlegroups.com
>>  
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
> -- 
> -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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/eab7c178-93f5-4ccc-accc-d83c818a285b%40googlegroups.com.

Re: [weewx-user] Re: Weewx-interceptor stopped working

[I L]

Hi Gary,

Thanks for trying!

I get things like this when running sudo tcpdump -i any host 192.168.1.51
(the IP address is for the wx station and I have replaced the password with
):

15:44:02.007755 IP ESP_7692C2.lekteus.local.22280 > 192.168.1.111.http:
Flags [P.], seq 1:457, ack 1, win 5840, length 456: HTTP: GET
ID=IEKER22==75.0=56.1=34.5=56.1=33=44=1.6=3.4=346=29.708=29.864=0.000=0.000=0.000=1.000=637.62=6=2020-05-18%2013:43:51=EasyWeatherV1.4.9=updateraw=1=5
HTTP/1.0

But obviously something more is needed.

Ingemar

Den mån 18 maj 2020 kl 15:38 skrev gjr80 :

> Hi Ingemar,
>
> From the log it would appear that the interceptor driver is configured
> correctly but is not receiving any data, hence the empty queue and blank
> raw data log entries. Since there is no data the mapped packets just have a
> timestamp and unit code which means no data for WeeWX. I am no
> interceptor/observer expert but it appears that the data is never making
> its way to the socket server being run by the driver and listening on port
> 80. I know you said that tcpdump is showing weather data is making it to
> your RPi but as you surmise I wonder if something has changed on your RPi
> to drop the data? If data was making its way to the interceptor socket
> server I would expect at the very least you would see something in the raw
> data in the log. Sorry I am not much help but I don't run the interceptor
> in Observer mode. Hopefully someone else can offer more help.
>
> Gary
>
>
> On Monday, 18 May 2020 22:57:27 UTC+10, IL wrote:
>>
>> Hi Gary,
>>
>> Thank you for coming back to me. I have attached the log file.
>>
>> Ingemar
>>
>> Den mån 18 maj 2020 kl 14:27 skrev gjr80 :
>>
>>> Hi,
>>>
>>> The description is helpful but a debug log is better. Could you please
>>> post a log extract as outlined in the Help! Posting to weewx user
>>>  wiki
>>> entry.
>>>
>>> Gary
>>>
>>> On Monday, 18 May 2020 22:21:43 UTC+10, IL wrote:

 I am using a Froggit WH3000SE which is essentially the same as Fine
 Offset WH2900. A couple of days ago WU said my station was offline. (It was
 still sending data to other weather services and to weewx, so this
 surprised me.) When I tried to fix that data stopped coming into weewx. I
 succeeded coming online in WU by setting up the weather station again but
 still no data to to weewx.

 Driver = user.interceptor, device_type = observer, port is default
 (=80) (not specified). On the wx console page Customized I have specified
 the server IP (which is static), the station ID and station key from the WU
 page, port = 80 and upload interval = 60. In short the same as worked
 before for a long time. The weewx config is also the same as before. The
 server has been restarted and there are no error messages in syslog.

 I have used tcpdump on the RaspberryPi running weewx and I can see
 weather data coming from Froggit, so I must have done something wrong on
 the Pi (or data is suddenly in wrong format?)  but I don’t know what. Any
 suggestions?
 --
 --
 Ingemar Lekteus
 Älgstigen 2
 178 52  EKERÖ

 E-post: ingemar...@gmail.com
 Mobil: 0704-71 33 30

>>> --
>>> 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...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/27a412ed-3f6f-4cd2-be4d-c560f574579a%40googlegroups.com
>>> 
>>> .
>>>
>>
>>
>> --
>> --
>> Ingemar Lekteus
>> Älgstigen 2
>> 178 52  EKERÖ
>>
>> E-post: ingemar...@gmail.com
>> Mobil: 0704-71 33 30
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/e70ac4a8-58f4-450e-9749-c963a2dfc3cc%40googlegroups.com
> 
> .
>


-- 
--
Ingemar Lekteus
Älgstigen 2
178 52  EKERÖ

E-post: ingemar.lekt...@gmail.com
Mobil: 0704-71 33 30

-- 
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.
To view this discussion on the web 

Re: [weewx-user] Re: Weewx-interceptor stopped working

[gjr80]

Hi Ingemar,

>From the log it would appear that the interceptor driver is configured 
correctly but is not receiving any data, hence the empty queue and blank 
raw data log entries. Since there is no data the mapped packets just have a 
timestamp and unit code which means no data for WeeWX. I am no 
interceptor/observer expert but it appears that the data is never making 
its way to the socket server being run by the driver and listening on port 
80. I know you said that tcpdump is showing weather data is making it to 
your RPi but as you surmise I wonder if something has changed on your RPi 
to drop the data? If data was making its way to the interceptor socket 
server I would expect at the very least you would see something in the raw 
data in the log. Sorry I am not much help but I don't run the interceptor 
in Observer mode. Hopefully someone else can offer more help.

Gary


On Monday, 18 May 2020 22:57:27 UTC+10, IL wrote:
>
> Hi Gary,
>
> Thank you for coming back to me. I have attached the log file.
>
> Ingemar
>
> Den mån 18 maj 2020 kl 14:27 skrev gjr80 
> >:
>
>> Hi,
>>
>> The description is helpful but a debug log is better. Could you please 
>> post a log extract as outlined in the Help! Posting to weewx user 
>>  wiki 
>> entry.
>>
>> Gary
>>
>> On Monday, 18 May 2020 22:21:43 UTC+10, IL wrote:
>>>
>>> I am using a Froggit WH3000SE which is essentially the same as Fine 
>>> Offset WH2900. A couple of days ago WU said my station was offline. (It was 
>>> still sending data to other weather services and to weewx, so this 
>>> surprised me.) When I tried to fix that data stopped coming into weewx. I 
>>> succeeded coming online in WU by setting up the weather station again but 
>>> still no data to to weewx. 
>>>
>>> Driver = user.interceptor, device_type = observer, port is default (=80) 
>>> (not specified). On the wx console page Customized I have specified the 
>>> server IP (which is static), the station ID and station key from the WU 
>>> page, port = 80 and upload interval = 60. In short the same as worked 
>>> before for a long time. The weewx config is also the same as before. The 
>>> server has been restarted and there are no error messages in syslog.
>>>
>>> I have used tcpdump on the RaspberryPi running weewx and I can see 
>>> weather data coming from Froggit, so I must have done something wrong on 
>>> the Pi (or data is suddenly in wrong format?)  but I don’t know what. Any 
>>> suggestions?
>>> -- 
>>> --
>>> Ingemar Lekteus
>>> Älgstigen 2
>>> 178 52  EKERÖ
>>>
>>> E-post: ingemar...@gmail.com
>>> Mobil: 0704-71 33 30
>>>
>> -- 
>> 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...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/weewx-user/27a412ed-3f6f-4cd2-be4d-c560f574579a%40googlegroups.com
>>  
>> 
>> .
>>
>
>
> -- 
> --
> Ingemar Lekteus
> Älgstigen 2
> 178 52  EKERÖ
>
> E-post: ingemar...@gmail.com 
> Mobil: 0704-71 33 30
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/e70ac4a8-58f4-450e-9749-c963a2dfc3cc%40googlegroups.com.

Re: [weewx-user] Re: Weewx-interceptor stopped working

[I L]

Hi Gary,

Thank you for coming back to me. I have attached the log file.

Ingemar

Den mån 18 maj 2020 kl 14:27 skrev gjr80 :

> Hi,
>
> The description is helpful but a debug log is better. Could you please
> post a log extract as outlined in the Help! Posting to weewx user
>  wiki
> entry.
>
> Gary
>
> On Monday, 18 May 2020 22:21:43 UTC+10, IL wrote:
>>
>> I am using a Froggit WH3000SE which is essentially the same as Fine
>> Offset WH2900. A couple of days ago WU said my station was offline. (It was
>> still sending data to other weather services and to weewx, so this
>> surprised me.) When I tried to fix that data stopped coming into weewx. I
>> succeeded coming online in WU by setting up the weather station again but
>> still no data to to weewx.
>>
>> Driver = user.interceptor, device_type = observer, port is default (=80)
>> (not specified). On the wx console page Customized I have specified the
>> server IP (which is static), the station ID and station key from the WU
>> page, port = 80 and upload interval = 60. In short the same as worked
>> before for a long time. The weewx config is also the same as before. The
>> server has been restarted and there are no error messages in syslog.
>>
>> I have used tcpdump on the RaspberryPi running weewx and I can see
>> weather data coming from Froggit, so I must have done something wrong on
>> the Pi (or data is suddenly in wrong format?)  but I don’t know what. Any
>> suggestions?
>> --
>> --
>> Ingemar Lekteus
>> Älgstigen 2
>> 178 52  EKERÖ
>>
>> E-post: ingemar...@gmail.com
>> Mobil: 0704-71 33 30
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/27a412ed-3f6f-4cd2-be4d-c560f574579a%40googlegroups.com
> 
> .
>


-- 
--
Ingemar Lekteus
Älgstigen 2
178 52  EKERÖ

E-post: ingemar.lekt...@gmail.com
Mobil: 0704-71 33 30

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CALhjqz%3DU0S%2B%2BuYTvN7UAtLNV0m%3DyJH3afgjwxpeAr-vg3wnpAg%40mail.gmail.com.


mylog
Description: Binary data

Re: [weewx-user] WeeWx Database

[Ron Sell]

Thanks , that what I am doing now. I appreciate all the help.

Easiest way :
Uninstall 4.0
Install 3.9
Configure Weewx
Done

On Mon, May 18, 2020 at 8:35 AM Tom Keffer  wrote:

> I don't know how many different ways I can say it, but I'll try again: *there
> is no difference between a V3.9 database and a V4.0 database!*
>
> Just keep using your old database. Copy it over into your new installation
> and restart weewx. Done.
>
> -tk
>
> On Mon, May 18, 2020 at 5:24 AM Ron Sell  wrote:
>
>> I upgraded to Pi4,
>> when I started installing everything I just went with the latest version.
>> I guess i could uninstall weewx4 and go with 3.9.
>>
>> On Mon, May 18, 2020 at 8:17 AM Tom Keffer  wrote:
>>
>>> Yeah, I guess that strategy won't work, at least not with a
>>> simple ".dump" command.
>>>
>>> Can we pause for a second and ask why you are doing this? What was wrong
>>> with your old database?
>>>
>>> On Sun, May 17, 2020 at 7:01 PM Ron Sell  wrote:
>>>
 Thanks.

 Got the script working but now i get this\:
 Error: near line 38817: table archive has 114 columns but 59 values
 were supplied

 do i need to modify the .sql to provide the difference in values?


 On Sun, May 17, 2020 at 8:47 PM Tom Keffer  wrote:

> It's in the commands I suggested. Make a backup first.
>
> On Sun, May 17, 2020 at 5:41 PM Ron Sell  wrote:
>
>> Thanks,
>> I did the data dump. Its now an SQL file. How do I get it into the
>> weewx4.0 database?
>>
>> thanks
>>
>>
>> On Sun, May 17, 2020 at 11:06 AM Tom Keffer 
>> wrote:
>>
>>> How about doing a dump of the v3.9 database, then delete the CREATE
>>> TABLE statement. Then import into the V4 database.
>>>
>>> Something like:
>>>
>>> # Create a dump, then strip out the CREATE TABLE
>>> echo ".dump" | sqlite3 weewx3.92.sdb | sed -e 's/^CREATE TABLE//' >
>>> weewx3.92.sql
>>> # Use the results to insert into the V4.0 table
>>> sqlite3 weewx4.0.sdb < weewx3.92.sql
>>>
>>> One thing I want to stress is that there is no difference between a
>>> V3.9 database and a V4.0 database. The only difference is that V4.0 
>>> offers
>>> a new, extended schema.
>>>
>>> -tk
>>>
>>> On Sun, May 17, 2020 at 6:55 AM Ron Sell 
>>> wrote:
>>>
 I upgraded to a new Pi and weewx 4.0.

 Old Pi
 weexwx 3.9.2
 Database extended for more observations
 58 columns
 Running for a year

 New Pi
 Weewx 4.0
 Database not extended Included all of the observstions i needed in
 the new version.'
 113 columns

 What is the best way to keep all my old data?


 I can't just copy the old database 1 for 1 since they are different.

 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.
 To view this discussion on the web visit
 https://groups.google.com/d/msgid/weewx-user/378b9004-78d2-4a80-bccb-27b35ecdc64c%40googlegroups.com
 
 .

>>> --
>>> 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.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEAL8auPoQODgMaMgepLgt9HLGDdMb-0goiLESJdt%2BEQvw%40mail.gmail.com
>>> 
>>> .
>>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/CABn15dYbjnGtZ%3DaNSCqrYhCBpw56uN%3DAfKYWPuxhQ7ZVF2i48Q%40mail.gmail.com
>> 
>> .
>>
> --
> 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.
> To view this 

Re: [weewx-user] WeeWx Database

[Tom Keffer]

I don't know how many different ways I can say it, but I'll try again: *there
is no difference between a V3.9 database and a V4.0 database!*

Just keep using your old database. Copy it over into your new installation
and restart weewx. Done.

-tk

On Mon, May 18, 2020 at 5:24 AM Ron Sell  wrote:

> I upgraded to Pi4,
> when I started installing everything I just went with the latest version.
> I guess i could uninstall weewx4 and go with 3.9.
>
> On Mon, May 18, 2020 at 8:17 AM Tom Keffer  wrote:
>
>> Yeah, I guess that strategy won't work, at least not with a
>> simple ".dump" command.
>>
>> Can we pause for a second and ask why you are doing this? What was wrong
>> with your old database?
>>
>> On Sun, May 17, 2020 at 7:01 PM Ron Sell  wrote:
>>
>>> Thanks.
>>>
>>> Got the script working but now i get this\:
>>> Error: near line 38817: table archive has 114 columns but 59 values were
>>> supplied
>>>
>>> do i need to modify the .sql to provide the difference in values?
>>>
>>>
>>> On Sun, May 17, 2020 at 8:47 PM Tom Keffer  wrote:
>>>
 It's in the commands I suggested. Make a backup first.

 On Sun, May 17, 2020 at 5:41 PM Ron Sell  wrote:

> Thanks,
> I did the data dump. Its now an SQL file. How do I get it into the
> weewx4.0 database?
>
> thanks
>
>
> On Sun, May 17, 2020 at 11:06 AM Tom Keffer  wrote:
>
>> How about doing a dump of the v3.9 database, then delete the CREATE
>> TABLE statement. Then import into the V4 database.
>>
>> Something like:
>>
>> # Create a dump, then strip out the CREATE TABLE
>> echo ".dump" | sqlite3 weewx3.92.sdb | sed -e 's/^CREATE TABLE//' >
>> weewx3.92.sql
>> # Use the results to insert into the V4.0 table
>> sqlite3 weewx4.0.sdb < weewx3.92.sql
>>
>> One thing I want to stress is that there is no difference between a
>> V3.9 database and a V4.0 database. The only difference is that V4.0 
>> offers
>> a new, extended schema.
>>
>> -tk
>>
>> On Sun, May 17, 2020 at 6:55 AM Ron Sell  wrote:
>>
>>> I upgraded to a new Pi and weewx 4.0.
>>>
>>> Old Pi
>>> weexwx 3.9.2
>>> Database extended for more observations
>>> 58 columns
>>> Running for a year
>>>
>>> New Pi
>>> Weewx 4.0
>>> Database not extended Included all of the observstions i needed in
>>> the new version.'
>>> 113 columns
>>>
>>> What is the best way to keep all my old data?
>>>
>>>
>>> I can't just copy the old database 1 for 1 since they are different.
>>>
>>> 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.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/378b9004-78d2-4a80-bccb-27b35ecdc64c%40googlegroups.com
>>> 
>>> .
>>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEAL8auPoQODgMaMgepLgt9HLGDdMb-0goiLESJdt%2BEQvw%40mail.gmail.com
>> 
>> .
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/CABn15dYbjnGtZ%3DaNSCqrYhCBpw56uN%3DAfKYWPuxhQ7ZVF2i48Q%40mail.gmail.com
> 
> .
>
 --
 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.
 To view this discussion on the web visit
 https://groups.google.com/d/msgid/weewx-user/CAPq0zEBQAYkbKek3Gt-mMzEYb8AFBv3twPfCMFDnWu1LZsgrwg%40mail.gmail.com
 
 .

>>> --
>>> You 

[weewx-user] Re: Weewx-interceptor stopped working

[gjr80]

Hi,

The description is helpful but a debug log is better. Could you please post 
a log extract as outlined in the Help! Posting to weewx user 
 wiki 
entry.

Gary

On Monday, 18 May 2020 22:21:43 UTC+10, IL wrote:
>
> I am using a Froggit WH3000SE which is essentially the same as Fine Offset 
> WH2900. A couple of days ago WU said my station was offline. (It was still 
> sending data to other weather services and to weewx, so this surprised me.) 
> When I tried to fix that data stopped coming into weewx. I succeeded coming 
> online in WU by setting up the weather station again but still no data to 
> to weewx. 
>
> Driver = user.interceptor, device_type = observer, port is default (=80) 
> (not specified). On the wx console page Customized I have specified the 
> server IP (which is static), the station ID and station key from the WU 
> page, port = 80 and upload interval = 60. In short the same as worked 
> before for a long time. The weewx config is also the same as before. The 
> server has been restarted and there are no error messages in syslog.
>
> I have used tcpdump on the RaspberryPi running weewx and I can see weather 
> data coming from Froggit, so I must have done something wrong on the Pi (or 
> data is suddenly in wrong format?)  but I don’t know what. Any suggestions?
> -- 
> --
> Ingemar Lekteus
> Älgstigen 2
> 178 52  EKERÖ
>
> E-post: ingemar...@gmail.com 
> Mobil: 0704-71 33 30
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/27a412ed-3f6f-4cd2-be4d-c560f574579a%40googlegroups.com.

Re: [weewx-user] WeeWx Database

[Ron Sell]

I upgraded to Pi4,
when I started installing everything I just went with the latest version. I
guess i could uninstall weewx4 and go with 3.9.

On Mon, May 18, 2020 at 8:17 AM Tom Keffer  wrote:

> Yeah, I guess that strategy won't work, at least not with a simple ".dump"
> command.
>
> Can we pause for a second and ask why you are doing this? What was wrong
> with your old database?
>
> On Sun, May 17, 2020 at 7:01 PM Ron Sell  wrote:
>
>> Thanks.
>>
>> Got the script working but now i get this\:
>> Error: near line 38817: table archive has 114 columns but 59 values were
>> supplied
>>
>> do i need to modify the .sql to provide the difference in values?
>>
>>
>> On Sun, May 17, 2020 at 8:47 PM Tom Keffer  wrote:
>>
>>> It's in the commands I suggested. Make a backup first.
>>>
>>> On Sun, May 17, 2020 at 5:41 PM Ron Sell  wrote:
>>>
 Thanks,
 I did the data dump. Its now an SQL file. How do I get it into the
 weewx4.0 database?

 thanks


 On Sun, May 17, 2020 at 11:06 AM Tom Keffer  wrote:

> How about doing a dump of the v3.9 database, then delete the CREATE
> TABLE statement. Then import into the V4 database.
>
> Something like:
>
> # Create a dump, then strip out the CREATE TABLE
> echo ".dump" | sqlite3 weewx3.92.sdb | sed -e 's/^CREATE TABLE//' >
> weewx3.92.sql
> # Use the results to insert into the V4.0 table
> sqlite3 weewx4.0.sdb < weewx3.92.sql
>
> One thing I want to stress is that there is no difference between a
> V3.9 database and a V4.0 database. The only difference is that V4.0 offers
> a new, extended schema.
>
> -tk
>
> On Sun, May 17, 2020 at 6:55 AM Ron Sell  wrote:
>
>> I upgraded to a new Pi and weewx 4.0.
>>
>> Old Pi
>> weexwx 3.9.2
>> Database extended for more observations
>> 58 columns
>> Running for a year
>>
>> New Pi
>> Weewx 4.0
>> Database not extended Included all of the observstions i needed in
>> the new version.'
>> 113 columns
>>
>> What is the best way to keep all my old data?
>>
>>
>> I can't just copy the old database 1 for 1 since they are different.
>>
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/378b9004-78d2-4a80-bccb-27b35ecdc64c%40googlegroups.com
>> 
>> .
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/CAPq0zEAL8auPoQODgMaMgepLgt9HLGDdMb-0goiLESJdt%2BEQvw%40mail.gmail.com
> 
> .
>
 --
 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.
 To view this discussion on the web visit
 https://groups.google.com/d/msgid/weewx-user/CABn15dYbjnGtZ%3DaNSCqrYhCBpw56uN%3DAfKYWPuxhQ7ZVF2i48Q%40mail.gmail.com
 
 .

>>> --
>>> 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.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBQAYkbKek3Gt-mMzEYb8AFBv3twPfCMFDnWu1LZsgrwg%40mail.gmail.com
>>> 
>>> .
>>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/CABn15dbU-yaVfDiXk03CW-f-BhVqb%3DmYGzArKKi6VbWn2EQ5_A%40mail.gmail.com
>> 

[weewx-user] Weewx-interceptor stopped working

[I L]

I am using a Froggit WH3000SE which is essentially the same as Fine Offset
WH2900. A couple of days ago WU said my station was offline. (It was still
sending data to other weather services and to weewx, so this surprised me.)
When I tried to fix that data stopped coming into weewx. I succeeded coming
online in WU by setting up the weather station again but still no data to
to weewx.

Driver = user.interceptor, device_type = observer, port is default (=80)
(not specified). On the wx console page Customized I have specified the
server IP (which is static), the station ID and station key from the WU
page, port = 80 and upload interval = 60. In short the same as worked
before for a long time. The weewx config is also the same as before. The
server has been restarted and there are no error messages in syslog.

I have used tcpdump on the RaspberryPi running weewx and I can see weather
data coming from Froggit, so I must have done something wrong on the Pi (or
data is suddenly in wrong format?)  but I don’t know what. Any suggestions?
-- 
--
Ingemar Lekteus
Älgstigen 2
178 52  EKERÖ

E-post: ingemar.lekt...@gmail.com
Mobil: 0704-71 33 30

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CALhjqzkTxGXhhKpL_LeE%3DdW5tuZekKRVT2T3SNEB8fgfhruxeA%40mail.gmail.com.

Re: [weewx-user] WeeWx Database

[Tom Keffer]

Yeah, I guess that strategy won't work, at least not with a simple ".dump"
command.

Can we pause for a second and ask why you are doing this? What was wrong
with your old database?

On Sun, May 17, 2020 at 7:01 PM Ron Sell  wrote:

> Thanks.
>
> Got the script working but now i get this\:
> Error: near line 38817: table archive has 114 columns but 59 values were
> supplied
>
> do i need to modify the .sql to provide the difference in values?
>
>
> On Sun, May 17, 2020 at 8:47 PM Tom Keffer  wrote:
>
>> It's in the commands I suggested. Make a backup first.
>>
>> On Sun, May 17, 2020 at 5:41 PM Ron Sell  wrote:
>>
>>> Thanks,
>>> I did the data dump. Its now an SQL file. How do I get it into the
>>> weewx4.0 database?
>>>
>>> thanks
>>>
>>>
>>> On Sun, May 17, 2020 at 11:06 AM Tom Keffer  wrote:
>>>
 How about doing a dump of the v3.9 database, then delete the CREATE
 TABLE statement. Then import into the V4 database.

 Something like:

 # Create a dump, then strip out the CREATE TABLE
 echo ".dump" | sqlite3 weewx3.92.sdb | sed -e 's/^CREATE TABLE//' >
 weewx3.92.sql
 # Use the results to insert into the V4.0 table
 sqlite3 weewx4.0.sdb < weewx3.92.sql

 One thing I want to stress is that there is no difference between a
 V3.9 database and a V4.0 database. The only difference is that V4.0 offers
 a new, extended schema.

 -tk

 On Sun, May 17, 2020 at 6:55 AM Ron Sell  wrote:

> I upgraded to a new Pi and weewx 4.0.
>
> Old Pi
> weexwx 3.9.2
> Database extended for more observations
> 58 columns
> Running for a year
>
> New Pi
> Weewx 4.0
> Database not extended Included all of the observstions i needed in the
> new version.'
> 113 columns
>
> What is the best way to keep all my old data?
>
>
> I can't just copy the old database 1 for 1 since they are different.
>
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/378b9004-78d2-4a80-bccb-27b35ecdc64c%40googlegroups.com
> 
> .
>
 --
 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.
 To view this discussion on the web visit
 https://groups.google.com/d/msgid/weewx-user/CAPq0zEAL8auPoQODgMaMgepLgt9HLGDdMb-0goiLESJdt%2BEQvw%40mail.gmail.com
 
 .

>>> --
>>> 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.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/CABn15dYbjnGtZ%3DaNSCqrYhCBpw56uN%3DAfKYWPuxhQ7ZVF2i48Q%40mail.gmail.com
>>> 
>>> .
>>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBQAYkbKek3Gt-mMzEYb8AFBv3twPfCMFDnWu1LZsgrwg%40mail.gmail.com
>> 
>> .
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/weewx-user/CABn15dbU-yaVfDiXk03CW-f-BhVqb%3DmYGzArKKi6VbWn2EQ5_A%40mail.gmail.com
> 
> .
>

-- 
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 

Re: [weewx-user] Number of days on which the average Temperature was above a certain value

[Rolf Zanchettin]

>
> Hey, Tom,
>>
>> i have installed the extension and it works perfectly!
>>
>>  Thanks a lot .

Best regards
Rolf 

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/d11aae69-c401-4af6-a94b-9d02105479d2%40googlegroups.com.