Re: [weewx-user] Re: Ambient Weather WS-2902A

[Scott Grayban]

It's .bash_history

Log out first so it can write the history. Then log back in.

-- 
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] Re: IWDL - Vorhersage

[erwinheger]

Hallo Kalli, auf der Website zu iwdl gibt es einen Link zu einer 
Forumsdiskussion
http://www.weather-watch.com/smf/index.php/topic,43872.0.html
dort wird erwähnt, letzte Seite, dass es Probleme mit einem Yahoo-Service gibt, 
der zum 03.01.2019 eingestellt wurde. Verfolge die Diskussion bitte dort, dort 
ist die richtige Anlaufstelle für Deine Frage.
Beste Grüße,
Erwin

On the website accorded to iwdl you‘ll find a link to a discussion
http://www.weather-watch.com/smf/index.php/topic,43872.0.html
where they are talking about an outdated Yahoo-Service, see last page for it. 
Seems to be the problem, Kalli has.


> Am 22.01.2019 um 00:06 schrieb gjr80 :
> 
> Hallo Kalli,
> 
> Ah, mein Fehler, ich hätte genau schauen sollen, was iWDL ist. Egal, aus dem 
> Link, den Sie gepostet haben, scheint iWDL seine Daten von clientraw.txt zu 
> beziehen.
> 
> Wenn Sie auf Ihren ursprünglichen Beitrag zurückschauen, sagen Sie, das 
> Problem liegt darin, dass die Prognose nicht mehr angezeigt wird. Die einzige 
> Vorhersageinformation in clientraw.txt ist eine Symbolnummer, die zum 
> Anzeigen eines geeigneten Symbols verwendet wird. In clientraw.txt ist kein 
> Vorhersagetext vorhanden. Ist Ihr Problem, dass das Prognosesymbol nicht 
> angezeigt wird, oder etwas anderes? Ich möchte nur genau eingrenzen, was 
> fehlt, damit wir sicherstellen können, dass die entsprechenden Daten in 
> clientraw.txt sind. Bedenken Sie, dass ich keine WDL oder iWDL verwende.
> 
> grüß
> 
> Ah, my mistake, I should have looked to see exactly what iWDL is. No matter, 
> from the link you posted it appears that iWDL obtains its data from 
> clientraw.txt.
> 
> Looking back at your original post you say the problem is with the forecast 
> no longer being displayed. The only forecast information in clientraw.txt is 
> an icon number used to display a suitable icon. There is no forecast text in 
> clientraw.txt. Is your problem that the forecast icon is not displaying or 
> something else? Just want to narrow down exactly what is missing so we can 
> make sure the appropriate data is in clientraw.txt. Bear in mind I do not use 
> WDL or iWDL.
> 
> Gary
>> On Tuesday, 22 January 2019 03:25:12 UTC+10, Kalli wrote:
>> Hallo Gery
>> das ist ein missverständniss.
>> 
>> ich meinte Das hier https://www.sietse.net/iwdl-info/
>> 
>> mfg.Kalli
>> 
>> Am Sonntag, 20. Januar 2019 13:25:30 UTC+1 schrieb Kalli:
>>> 
>>> Hallo
>>> seit einiger zeit geht die Wettervorhersage bei IWDL nicht mehr.
>>> hat sich was geändert.
>>> 
>>> mfg. Kalli
> 
> -- 
> 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.

-- 
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] Re: Ambient Weather WS-2902A

[Liz]

On Tue, 22 Jan 2019 07:24:26 +0300
Adnan Mumtaz  wrote:

> Wonder how can I take a backup of all what I did.

cat history > /home/user/history.txt

and then edit out the steps which were dead ends!

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

Welcome.

-- 
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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

You were right, i didn't see this step in all the guidelines I was
following from Scott, after installing the weewx-mqtt it started working

http://www.riyadhweather.com/

Wonder how can I take a backup of all what I did.

Thanks mwall and hats off to Scott who had been made this site up and
running possible. Thank you so much Scott for your amazing support.

On Tue, Jan 22, 2019 at 4:24 AM mwall  wrote:

> btw, if you installed the weewx-mqtt extension using wee_extension, it
> should have done the addition to restful_services for you.
>
> perhaps you did not install weewx-mqtt?
>
> https://github.com/weewx/weewx/wiki/mqtt
>
> m
>
> --
> 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.
>

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

I figured he did this since that's part of the instructions I gave him.

On Monday, January 21, 2019 at 5:24:44 PM UTC-8, mwall wrote:
>
> btw, if you installed the weewx-mqtt extension using wee_extension, it 
> should have done the addition to restful_services for you.
>
> perhaps you did not install weewx-mqtt?
>
> https://github.com/weewx/weewx/wiki/mqtt
>
> m
>

-- 
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] Re: Ambient Weather WS-2902A

[mwall]

btw, if you installed the weewx-mqtt extension using wee_extension, it 
should have done the addition to restful_services for you.

perhaps you did not install weewx-mqtt?

https://github.com/weewx/weewx/wiki/mqtt

m

-- 
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] Re: Ambient Weather WS-2902A

[mwall]

adnan,

you have defined parameters for the weewx-mqtt uploader, but you have not 
told weewx to actually use weewx-mqtt.  put

user.mqtt.MQTT

at the end of restful_services in your weewx configuration file then 
restart weewx.

m

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

Then I have no clue. It works for me.

Go through all the settings again.

On Monday, January 21, 2019 at 5:08:59 PM UTC-8, Adnan Mumtaz wrote:
>
> It is exactly same
>
> On Tue, Jan 22, 2019 at 4:03 AM Scott Grayban  > wrote:
>
>> Then MQTT is still not setup right.
>>
>> /etc/mosquitto/conf.d/myconfig.conf should have this...
>>
>> persistence false
>> allow_anonymous true
>> password_file /etc/mosquitto/passwd
>> acl_file /etc/mosquitto/acl
>> listener 1883
>> protocol mqtt
>> # websockets
>> listener 9001
>> protocol websockets
>>
>>
>> -- 
>> 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 .
>> 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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

It is exactly same

On Tue, Jan 22, 2019 at 4:03 AM Scott Grayban  wrote:

> Then MQTT is still not setup right.
>
> /etc/mosquitto/conf.d/myconfig.conf should have this...
>
> persistence false
> allow_anonymous true
> password_file /etc/mosquitto/passwd
> acl_file /etc/mosquitto/acl
> listener 1883
> protocol mqtt
> # websockets
> listener 9001
> protocol websockets
>
>
> --
> 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.
>

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

Then MQTT is still not setup right.

/etc/mosquitto/conf.d/myconfig.conf should have this...

persistence false
allow_anonymous true
password_file /etc/mosquitto/passwd
acl_file /etc/mosquitto/acl
listener 1883
protocol mqtt
# websockets
listener 9001
protocol websockets


-- 
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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

checked the whole syslog, not even a single entry with the word mqtt is
there

On Tue, Jan 22, 2019 at 3:58 AM Adnan Mumtaz  wrote:

> Doesn't seem to post anything, see below part of current log
>
> Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter hourlyrainin=0.00
> Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter eventrainin=0.00
> Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter totalrainin=0.00
> Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter stationtype=AMBWeatherV4.1.0
> Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter maxdailygust=3.4
> Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter baromrelin=29.87
> Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter hourlyrainin=0.00
> Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter eventrainin=0.00
> Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter totalrainin=0.00
> Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter stationtype=AMBWeatherV4.1.0
> Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter maxdailygust=3.4
> Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter baromrelin=29.86
> Jan 22 03:56:34 Riyadh_WS weewx[429]: manager: Added record 2019-01-22
> 03:56:00 +03 (1548118560) to database 'weewx.
>sdb'
> Jan 22 03:56:34 Riyadh_WS weewx[429]: manager: Added record 2019-01-22
> 03:56:00 +03 (1548118560) to daily summary in
> 'weewx.sdb'
> Jan 22 03:56:35 Riyadh_WS weewx[429]: cheetahgenerator: Generated 13 files
> for report StandardReport in 1.07 seconds
> Jan 22 03:56:35 Riyadh_WS weewx[429]: copygenerator: copied 1 files to
> /var/www/html/weewx/
> Jan 22 03:56:39 Riyadh_WS weewx[429]: cheetahgenerator: Generated 4 files
> for report Highcharts_Belchertown in 4.17
> seconds
> Jan 22 03:56:39 Riyadh_WS weewx[429]: copygenerator: copied 0 files to
> /var/www/html/weewx/
> Jan 22 03:56:40 Riyadh_WS weewx[429]: cheetahgenerator: Generated 13 files
> for report Belchertown in 1.23 seconds
> Jan 22 03:56:40 Riyadh_WS weewx[429]: copygenerator: copied 1 files to
> /var/www/html/weewx/
> Jan 22 03:57:03 Riyadh_WS weewx[429]: ftpupload: Attempt #1. Failed
> uploading /style.css to ftp.riyadhweather.com. R
>eason: timed out
> Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter hourlyrainin=0.00
> Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter eventrainin=0.00
> Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter totalrainin=0.00
> Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter stationtype=AMBWeatherV4.1.0
> Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter maxdailygust=3.4
> Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread:
> unrecognized parameter baromrelin=29.87
> Jan 22 03:57:22 Riyadh_WS weewx[429]: ftpgenerator: ftp'd 18 files in
> 42.07 seconds
>
>
> On Tue, Jan 22, 2019 at 3:54 AM Scott Grayban  wrote:
>
>> Logs should show this
>>
>> Jan 21 16:52:09 weewx-pi weewx[771]: restx: MQTT: Published record
>> 2019-01-21 16:51:00 PST (1548118260)
>> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread:
>> unrecognized parameter hourlyrainin=0.00
>> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread:
>> unrecognized parameter eventrainin=0.00
>> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread:
>> unrecognized parameter totalrainin=1.00
>> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread:
>> unrecognized parameter stationtype=AMBWeatherV4.0.7
>> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread:
>> unrecognized parameter maxdailygust=5.8
>> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread:
>> unrecognized parameter baromrelin=30.36
>> Jan 21 16:53:09 weewx-pi weewx[771]: restx: MQTT: Published record
>> 2019-01-21 16:52:04 PST (1548118324)
>>
>>
>> On Monday, January 21, 2019 at 4:46:35 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Do I owe you a coffee ? :) I am a home barista btw :D It shows connected
>>> now, but keeps on waiting for data
>>>
>>> On Tue, Jan 22, 2019 at 3:33 AM Scott Grayban  wrote:
>>>
 In [StdRESTful]

 [[MQTT]]
 server_url = mqtt://user:pass@IP:1883/
 topic = weather/weewx
 unit_system = METRIC
 binding = archive, loop
 aggregation = aggregate

 Under
 [StdReport]
   

Re: [weewx-user] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

Doesn't seem to post anything, see below part of current log

Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter hourlyrainin=0.00
Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter eventrainin=0.00
Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter totalrainin=0.00
Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter stationtype=AMBWeatherV4.1.0
Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter maxdailygust=3.4
Jan 22 03:55:24 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter baromrelin=29.87
Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter hourlyrainin=0.00
Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter eventrainin=0.00
Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter totalrainin=0.00
Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter stationtype=AMBWeatherV4.1.0
Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter maxdailygust=3.4
Jan 22 03:56:28 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter baromrelin=29.86
Jan 22 03:56:34 Riyadh_WS weewx[429]: manager: Added record 2019-01-22
03:56:00 +03 (1548118560) to database 'weewx.
   sdb'
Jan 22 03:56:34 Riyadh_WS weewx[429]: manager: Added record 2019-01-22
03:56:00 +03 (1548118560) to daily summary in
'weewx.sdb'
Jan 22 03:56:35 Riyadh_WS weewx[429]: cheetahgenerator: Generated 13 files
for report StandardReport in 1.07 seconds
Jan 22 03:56:35 Riyadh_WS weewx[429]: copygenerator: copied 1 files to
/var/www/html/weewx/
Jan 22 03:56:39 Riyadh_WS weewx[429]: cheetahgenerator: Generated 4 files
for report Highcharts_Belchertown in 4.17
seconds
Jan 22 03:56:39 Riyadh_WS weewx[429]: copygenerator: copied 0 files to
/var/www/html/weewx/
Jan 22 03:56:40 Riyadh_WS weewx[429]: cheetahgenerator: Generated 13 files
for report Belchertown in 1.23 seconds
Jan 22 03:56:40 Riyadh_WS weewx[429]: copygenerator: copied 1 files to
/var/www/html/weewx/
Jan 22 03:57:03 Riyadh_WS weewx[429]: ftpupload: Attempt #1. Failed
uploading /style.css to ftp.riyadhweather.com. R
 eason: timed out
Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter hourlyrainin=0.00
Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter eventrainin=0.00
Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter totalrainin=0.00
Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter stationtype=AMBWeatherV4.1.0
Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter maxdailygust=3.4
Jan 22 03:57:21 Riyadh_WS weewx[429]: interceptor: MainThread: unrecognized
parameter baromrelin=29.87
Jan 22 03:57:22 Riyadh_WS weewx[429]: ftpgenerator: ftp'd 18 files in 42.07
seconds


On Tue, Jan 22, 2019 at 3:54 AM Scott Grayban  wrote:

> Logs should show this
>
> Jan 21 16:52:09 weewx-pi weewx[771]: restx: MQTT: Published record
> 2019-01-21 16:51:00 PST (1548118260)
> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized
> parameter hourlyrainin=0.00
> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized
> parameter eventrainin=0.00
> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized
> parameter totalrainin=1.00
> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized
> parameter stationtype=AMBWeatherV4.0.7
> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized
> parameter maxdailygust=5.8
> Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized
> parameter baromrelin=30.36
> Jan 21 16:53:09 weewx-pi weewx[771]: restx: MQTT: Published record
> 2019-01-21 16:52:04 PST (1548118324)
>
>
> On Monday, January 21, 2019 at 4:46:35 PM UTC-8, Adnan Mumtaz wrote:
>>
>> Do I owe you a coffee ? :) I am a home barista btw :D It shows connected
>> now, but keeps on waiting for data
>>
>> On Tue, Jan 22, 2019 at 3:33 AM Scott Grayban  wrote:
>>
>>> In [StdRESTful]
>>>
>>> [[MQTT]]
>>> server_url = mqtt://user:pass@IP:1883/
>>> topic = weather/weewx
>>> unit_system = METRIC
>>> binding = archive, loop
>>> aggregation = aggregate
>>>
>>> Under
>>> [StdReport]
>>> [[Belchertown]]
>>> [[[Extras]]]
>>> mqtt_enabled = 1
>>> mqtt_host = IP
>>> mqtt_topic = weather/weewx/loop
>>> mqtt_port = 9001
>>> mqtt_ssl = 0
>>> disconnect_live_website_visitor = 180
>>>
>>>
>>> On Monday, 

Re: [weewx-user] Re: Ambient Weather WS-2902A

[Scott Grayban]

Logs should show this

Jan 21 16:52:09 weewx-pi weewx[771]: restx: MQTT: Published record 
2019-01-21 16:51:00 PST (1548118260)
Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized 
parameter hourlyrainin=0.00
Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized 
parameter eventrainin=0.00
Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized 
parameter totalrainin=1.00
Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized 
parameter stationtype=AMBWeatherV4.0.7
Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized 
parameter maxdailygust=5.8
Jan 21 16:53:09 weewx-pi weewx[771]: interceptor: MainThread: unrecognized 
parameter baromrelin=30.36
Jan 21 16:53:09 weewx-pi weewx[771]: restx: MQTT: Published record 
2019-01-21 16:52:04 PST (1548118324)


On Monday, January 21, 2019 at 4:46:35 PM UTC-8, Adnan Mumtaz wrote:
>
> Do I owe you a coffee ? :) I am a home barista btw :D It shows connected 
> now, but keeps on waiting for data
>
> On Tue, Jan 22, 2019 at 3:33 AM Scott Grayban  > wrote:
>
>> In [StdRESTful]
>>
>> [[MQTT]]
>> server_url = mqtt://user:pass@IP:1883/
>> topic = weather/weewx
>> unit_system = METRIC
>> binding = archive, loop
>> aggregation = aggregate
>>
>> Under
>> [StdReport]
>> [[Belchertown]]
>> [[[Extras]]]
>> mqtt_enabled = 1
>> mqtt_host = IP
>> mqtt_topic = weather/weewx/loop
>> mqtt_port = 9001
>> mqtt_ssl = 0
>> disconnect_live_website_visitor = 180
>>
>>
>> On Monday, January 21, 2019 at 4:30:08 PM UTC-8, Scott Grayban wrote:
>>>
>>> That's because you don't have MQTT setup right.
>>>
>>> On Monday, January 21, 2019 at 4:28:29 PM UTC-8, Adnan Mumtaz wrote:

 On the server where I am running MQTT I am seeing RPi connections but 
 with errors, 46.153.24.43 is the WAN IP of RPi

 1548116710: Socket error on client , disconnecting.
 1548116710: New connection from 46.153.24.43 on port 1883.
 1548116710: Socket error on client , disconnecting.
 1548116722: New connection from 46.153.24.43 on port 1883.


 On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  
 wrote:

> When your PI gets delivered MQTT will work as required for MQTT and 
> the website.
>
> -- 
> 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.
> 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+...@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] Re: Ambient Weather WS-2902A

[Scott Grayban]

If MQTT is sending data it will show in the syslogs. The WS only sends data 
every 1 minutes.

On Monday, January 21, 2019 at 4:46:35 PM UTC-8, Adnan Mumtaz wrote:
>
> Do I owe you a coffee ? :) I am a home barista btw :D It shows connected 
> now, but keeps on waiting for data
>
> On Tue, Jan 22, 2019 at 3:33 AM Scott Grayban  > wrote:
>
>> In [StdRESTful]
>>
>> [[MQTT]]
>> server_url = mqtt://user:pass@IP:1883/
>> topic = weather/weewx
>> unit_system = METRIC
>> binding = archive, loop
>> aggregation = aggregate
>>
>> Under
>> [StdReport]
>> [[Belchertown]]
>> [[[Extras]]]
>> mqtt_enabled = 1
>> mqtt_host = IP
>> mqtt_topic = weather/weewx/loop
>> mqtt_port = 9001
>> mqtt_ssl = 0
>> disconnect_live_website_visitor = 180
>>
>>
>> On Monday, January 21, 2019 at 4:30:08 PM UTC-8, Scott Grayban wrote:
>>>
>>> That's because you don't have MQTT setup right.
>>>
>>> On Monday, January 21, 2019 at 4:28:29 PM UTC-8, Adnan Mumtaz wrote:

 On the server where I am running MQTT I am seeing RPi connections but 
 with errors, 46.153.24.43 is the WAN IP of RPi

 1548116710: Socket error on client , disconnecting.
 1548116710: New connection from 46.153.24.43 on port 1883.
 1548116710: Socket error on client , disconnecting.
 1548116722: New connection from 46.153.24.43 on port 1883.


 On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  
 wrote:

> When your PI gets delivered MQTT will work as required for MQTT and 
> the website.
>
> -- 
> 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.
> 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+...@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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

Do I owe you a coffee ? :) I am a home barista btw :D It shows connected
now, but keeps on waiting for data

On Tue, Jan 22, 2019 at 3:33 AM Scott Grayban  wrote:

> In [StdRESTful]
>
> [[MQTT]]
> server_url = mqtt://user:pass@IP:1883/
> topic = weather/weewx
> unit_system = METRIC
> binding = archive, loop
> aggregation = aggregate
>
> Under
> [StdReport]
> [[Belchertown]]
> [[[Extras]]]
> mqtt_enabled = 1
> mqtt_host = IP
> mqtt_topic = weather/weewx/loop
> mqtt_port = 9001
> mqtt_ssl = 0
> disconnect_live_website_visitor = 180
>
>
> On Monday, January 21, 2019 at 4:30:08 PM UTC-8, Scott Grayban wrote:
>>
>> That's because you don't have MQTT setup right.
>>
>> On Monday, January 21, 2019 at 4:28:29 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>> On the server where I am running MQTT I am seeing RPi connections but
>>> with errors, 46.153.24.43 is the WAN IP of RPi
>>>
>>> 1548116710: Socket error on client , disconnecting.
>>> 1548116710: New connection from 46.153.24.43 on port 1883.
>>> 1548116710: Socket error on client , disconnecting.
>>> 1548116722: New connection from 46.153.24.43 on port 1883.
>>>
>>>
>>> On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  wrote:
>>>
 When your PI gets delivered MQTT will work as required for MQTT and the
 website.

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

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

In [StdRESTful]

[[MQTT]]
server_url = mqtt://user:pass@IP:1883/
topic = weather/weewx
unit_system = METRIC
binding = archive, loop
aggregation = aggregate

Under
[StdReport]
[[Belchertown]]
[[[Extras]]]
mqtt_enabled = 1
mqtt_host = IP
mqtt_topic = weather/weewx/loop
mqtt_port = 9001
mqtt_ssl = 0
disconnect_live_website_visitor = 180


On Monday, January 21, 2019 at 4:30:08 PM UTC-8, Scott Grayban wrote:
>
> That's because you don't have MQTT setup right.
>
> On Monday, January 21, 2019 at 4:28:29 PM UTC-8, Adnan Mumtaz wrote:
>>
>> On the server where I am running MQTT I am seeing RPi connections but 
>> with errors, 46.153.24.43 is the WAN IP of RPi
>>
>> 1548116710: Socket error on client , disconnecting.
>> 1548116710: New connection from 46.153.24.43 on port 1883.
>> 1548116710: Socket error on client , disconnecting.
>> 1548116722: New connection from 46.153.24.43 on port 1883.
>>
>>
>> On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  wrote:
>>
>>> When your PI gets delivered MQTT will work as required for MQTT and the 
>>> website.
>>>
>>> -- 
>>> 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.
>>> 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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

I followed all the instructions from this link
https://obrienlabs.net/how-to-setup-your-own-mqtt-broker/

On Tue, Jan 22, 2019 at 3:30 AM Scott Grayban  wrote:

> That's because you don't have MQTT setup right.
>
> On Monday, January 21, 2019 at 4:28:29 PM UTC-8, Adnan Mumtaz wrote:
>>
>> On the server where I am running MQTT I am seeing RPi connections but
>> with errors, 46.153.24.43 is the WAN IP of RPi
>>
>> 1548116710: Socket error on client , disconnecting.
>> 1548116710: New connection from 46.153.24.43 on port 1883.
>> 1548116710: Socket error on client , disconnecting.
>> 1548116722: New connection from 46.153.24.43 on port 1883.
>>
>>
>> On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  wrote:
>>
>>> When your PI gets delivered MQTT will work as required for MQTT and the
>>> website.
>>>
>>> --
>>> 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.
>>> 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.
>

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

That's because you don't have MQTT setup right.

On Monday, January 21, 2019 at 4:28:29 PM UTC-8, Adnan Mumtaz wrote:
>
> On the server where I am running MQTT I am seeing RPi connections but with 
> errors, 46.153.24.43 is the WAN IP of RPi
>
> 1548116710: Socket error on client , disconnecting.
> 1548116710: New connection from 46.153.24.43 on port 1883.
> 1548116710: Socket error on client , disconnecting.
> 1548116722: New connection from 46.153.24.43 on port 1883.
>
>
> On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  > wrote:
>
>> When your PI gets delivered MQTT will work as required for MQTT and the 
>> website.
>>
>> -- 
>> 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 .
>> 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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

On the server where I am running MQTT I am seeing RPi connections but with
errors, 46.153.24.43 is the WAN IP of RPi

1548116710: Socket error on client , disconnecting.
1548116710: New connection from 46.153.24.43 on port 1883.
1548116710: Socket error on client , disconnecting.
1548116722: New connection from 46.153.24.43 on port 1883.


On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  wrote:

> When your PI gets delivered MQTT will work as required for MQTT and the
> website.
>
> --
> 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.
>

-- 
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] One archive database - two weewx implementations

[kutzenco]

Gary,

Thanks for your advice. I shall take it and set up my development instance 
as you suggest!

Also, thanks to Thomas for the info on the Raspberry Pi SD Card writes. I'd 
heard some time ago that a high quality SD Card is important when running a 
Pi. So, similar to Thomas' test setup, I am using a SanDisk Extreme Pro 
card on my production instance. I back the database up nightly (using the 
weewx rsync extension to ensure the database is between accesses) and keep 
a months worth of versions. So, it looks like there isn't any urgency for 
me to change my production instance setup- one less thing to do.

phil

On Monday, January 21, 2019 at 6:19:38 PM UTC-5, gjr80 wrote:
>
> Gee, this sound like a whole lot of trouble for a development instance of 
> WeeWX. Why not just have a separate simulator install, use the simulator in 
> generator mode to generate a few years of data then keep a copy of this 
> data for when you hose your development data. Switch the simulator back to 
> simulate mode and do your development. Sure it's nice to see the same data 
> but canned data is fine for 99% of development work. The risk with having 
> access to your production data is that sooner or later something is going 
> to do something it shouldn't.
>
> Gary
>
> On Tuesday, 22 January 2019 08:52:12 UTC+10, kutz...@gmail.com wrote:
>>
>> Thanks Thomas. I was worried the answer to my first question was going to 
>> be no.
>>
>> My fallback on the LAN-based database was going to be to use the rsync 
>> extension to copy the database from the production weewx instance to the 
>> development instance. A third option would be to mount the database on the 
>> production Pi onto the development Pi. Then the LAN instance is only being 
>> read. Since LAN access is only to a development instance, it would be no 
>> big deal if it dropped some records in reports. But requiring a device 
>> driver nixes those ideas also. 
>>
>> Does the driver need to generate ARCHIVE packets and try to store them? 
>> Or are just empty LOOP packets ok? I was actually planning to get LOOP 
>> packets from MQTT which my production weewx instance publishes. So, I 
>> wouldn't even want the development instance to grab LOOP packets other than 
>> the MQTT ones.
>>
>> phil
>>
>> On Monday, January 21, 2019 at 5:30:53 PM UTC-5, Thomas Keffer wrote:
>>>
>>> 1. Unfortunately, no. WeeWX expects a device driver. I suppose you could 
>>> create a dummy device driver that emits empty LOOP packets at regular 
>>> intervals, but I've never tried that.
>>> 2. Would not make any difference. Sqlite does quite well locking around 
>>> reads and writes.
>>> 3. The problem using a database on your LAN is that it exposes yourself 
>>> to network errors. WeeWX does not do very well recovering from these kinds 
>>> of errors. It won't crash, but it can drop a record. Still, lots of people 
>>> have used a database on another machine. Personally, I think the problem of 
>>> SD card writes is overstated. I have been running an instance of WeeWX 
>>>  on an RPi with a 
>>> Sandisk Extreme Plus SD card. It has been up for well over 4 years without 
>>> a disk crash.
>>>
>>> -tk
>>>
>>> On Mon, Jan 21, 2019 at 12:24 PM  wrote:
>>>
 I am currently running weewx (on a Raspberry Pi) inputting data from a 
 Vantage Vue station, using a sqlite3 database to archive the data. I 
 publish the generated webpages via an external web hosting service. I want 
 to set up a development weewx instance on a second Raspberry Pi and point 
 it to the existing database to get generated output. This would allow me 
 to 
 have the output from my development instance display current data gathered 
 from the production instance. But, if I hose my output while making 
 changes 
 in the development instance, I won't impact the published webpages.

 I'm looking for advice and have a few questions:

 1. Is there a way to run a weewx instance that skips the device 
 input (since that will be handled by the production instance) but goes 
 through the output items a skin would do including generating html pages 
 and copying them into the public_html directory?

 2. Is migrating to MySQL a better choice for this kind of setup? I 
 would think that using MySQL will solve any issues of locking caused 
 if/when both instances access the database simultaneously (though one is 
 is 
 reading and writing while the other is only reading).

 3. I am also thinking of moving the database (and maybe other weewx 
 directories) to a Synology NAS and mapping those locations to my two weewx 
 instances to reduce SDCard writes. Are there any significant gotchas or 
 warnings I should take heed of regarding this?

 phil

 -- 



-- 
You received this message because you are subscribed to the Google Groups 
"weewx-user" 

Re: [weewx-user] Re: Ambient Weather WS-2902A

[Scott Grayban]

Just add it according to what the docs say. No you don't need to redo 
anything just update the sql db.

I haven't played with the battery addon.

On Monday, January 21, 2019 at 4:08:57 PM UTC-8, Adnan Mumtaz wrote:
>
> I forgot to add 'windrun', 'REAL' in the db file, if i add it now i will 
> have to redo the whole process? by the way the battery thing works? I was 
> reading your posts
>
> On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  > wrote:
>
>> When your PI gets delivered MQTT will work as required for MQTT and the 
>> website.
>>
>> -- 
>> 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 .
>> 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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

I forgot to add 'windrun', 'REAL' in the db file, if i add it now i will
have to redo the whole process? by the way the battery thing works? I was
reading your posts

On Tue, Jan 22, 2019 at 3:05 AM Scott Grayban  wrote:

> When your PI gets delivered MQTT will work as required for MQTT and the
> website.
>
> --
> 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.
>

-- 
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] My current would not update

[Thomas Keffer]

Hard to say without seeing the log.

Make sure you restart WeeWX after you fixed weewx.conf.

-tk

On Mon, Jan 21, 2019 at 4:03 PM  wrote:

> Thank you! Error-Message is gone.
>
> Still the html-pages with the weather data are not updated
>
> How can that be?
>
> On Monday, 21 January 2019 23:24:20 UTC+1, Thomas Keffer wrote:
>>
>> Take a look in your weewx.conf, section [StdArchive], option '
>> archive_interval'. It looks like you have a non-integer in there.
>>
>> -tk
>>
>> On Mon, Jan 21, 2019 at 11:37 AM  wrote:
>>
>>> Hello my weewx-install would not update the html-pages anymore.
>>>
>>> It´s funny - because the installation ran fine for about 2 years now.
>>> What happened 3 days ago was, that the display (wh1080) would not
>>> receive any transmitter-data. Changing the transmitter batteries would not
>>> help, I had to restart the display (turn off / turn on the wh1080), so that
>>> it recognized the transmitter and got data again.
>>>
>>> But now weewX would not update the current-html anymore - just the
>>> week-summary.
>>>
>>> So i updated the SDB regarding timestamps:
>>>
>>> "
>>>
>>> cp /home/weewx/archive/weewx.sdb /home/weewx/archive/weewx.sdb.backup
>>> sqlite3 /home/weewx/archive/weewx.sdb
>>> sqlite> delete from archive where dateTime > X;
>>> sqlite> .exit
>>> "
>>>
>>> Cleared the device-memory
>>>
>>> "
>>> wee_device --clear-memory
>>> "
>>>
>>> and got into debug mode and got this error after running "sudo service 
>>> weewx start":
>>>
>>> "
>>>
>>> Jan 21 20:22:41 se weewx[4312]: wxcalculate: The following algorithms
>>> will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS
>>> Jan 21 20:22:41 se weewx[4312]: engine: Finished loading service
>>> weewx.wxservices.StdWXCalculate
>>> Jan 21 20:22:41 seweewx[4312]: engine: Loading service
>>> weewx.engine.StdArchive
>>> Jan 21 20:22:41 seweewx[4312]: engine: Caught unrecoverable exception in
>>> engine:
>>> Jan 21 20:22:41 se weewx[4312]:   invalid literal for int() with
>>> base 10: ''
>>> Jan 21 20:22:41 se weewx[4312]:   Traceback (most recent call
>>> last):
>>> Jan 21 20:22:41 se weewx[4312]: File
>>> "/usr/share/weewx/weewx/engine.py", line 871, in main
>>> Jan 21 20:22:41 se weewx[4312]:   engine =
>>> engine_class(config_dict)
>>> Jan 21 20:22:41 se weewx[4312]: File
>>> "/usr/share/weewx/weewx/engine.py", line 78, in __init__
>>> Jan 21 20:22:41 se weewx[4312]: 
>>> self.loadServices(config_dict)
>>> Jan 21 20:22:41 se weewx[4312]: File
>>> "/usr/share/weewx/weewx/engine.py", line 142, in loadServices
>>> Jan 21 20:22:41 se weewx[4312]: 
>>> self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
>>> Jan 21 20:22:41 se weewx[4312]: File
>>> "/usr/share/weewx/weewx/engine.py", line 447, in __init__
>>> Jan 21 20:22:41 se weewx[4312]:   software_interval =
>>> to_int(config_dict['StdArchive'].get('archive_interval', 300))
>>> Jan 21 20:22:41 se weewx[4312]: File
>>> "/usr/share/weewx/weeutil/weeutil.py", line 1253, in to_int
>>> Jan 21 20:22:41 se weewx[4312]:   return int(x) if x is not
>>> None else None
>>> Jan 21 20:22:41 se weewx[4312]:   ValueError: invalid literal
>>> for int() with base 10: ''
>>> Jan 21 20:22:41 se weewx[4312]:   Exiting.
>>> "
>>>
>>> Any hints appreciated!
>>>
>>>
>>> --
>>> 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.
>>> 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.
>

-- 
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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

let me ask them

On Tue, Jan 22, 2019 at 3:03 AM Scott Grayban  wrote:

> Oh well that might be why MQTT isn't working as the hosting provider has
> blocked port 1883
>
> On Monday, January 21, 2019 at 4:00:30 PM UTC-8, Adnan Mumtaz wrote:
>>
>> I have an external server im uploading using ftp, can you try to open in
>> IE or in an Incognito window http://www.riyadhweather.com or without www
>>
>> On Tue, Jan 22, 2019 at 2:54 AM Scott Grayban  wrote:
>>
>>> Something is still wrong as https is still being forced on my end...
>>> remove ALL settings in apache for ssl.
>>>
>>> On Monday, January 21, 2019 at 3:43:21 PM UTC-8, Adnan Mumtaz wrote:

 Removed https and now charts are loading too, MQTT is still not working

 On Tue, Jan 22, 2019 at 2:35 AM Adnan Mumtaz  wrote:

> yes :)
>
> On Tuesday, 22 January 2019 02:32:36 UTC+3, Scott Grayban wrote:
>>
>> umm you do have a username though ?
>>
>> On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Fixed, on the server where I installed MQTT i have the below config
>>> in the acl file
>>>
>>> # Allow anonymous access to the sys
>>> topic read $SYS/#
>>>
>>> # Allow anonymous to read weather
>>> topic read weather/#
>>>
>>> # weewx readwrite to the loop
>>> user 
>>> topic weather/#
>>>
>> --
> 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.
> 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+...@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.
>

-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

When your PI gets delivered MQTT will work as required for MQTT and the 
website.

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

Oh well that might be why MQTT isn't working as the hosting provider has 
blocked port 1883

On Monday, January 21, 2019 at 4:00:30 PM UTC-8, Adnan Mumtaz wrote:
>
> I have an external server im uploading using ftp, can you try to open in 
> IE or in an Incognito window http://www.riyadhweather.com or without www 
>
> On Tue, Jan 22, 2019 at 2:54 AM Scott Grayban  > wrote:
>
>> Something is still wrong as https is still being forced on my end... 
>> remove ALL settings in apache for ssl.
>>
>> On Monday, January 21, 2019 at 3:43:21 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Removed https and now charts are loading too, MQTT is still not working 
>>>
>>> On Tue, Jan 22, 2019 at 2:35 AM Adnan Mumtaz  wrote:
>>>
 yes :)

 On Tuesday, 22 January 2019 02:32:36 UTC+3, Scott Grayban wrote:
>
> umm you do have a username though ?
>
> On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:
>>
>> Fixed, on the server where I installed MQTT i have the below config 
>> in the acl file
>>
>> # Allow anonymous access to the sys
>> topic read $SYS/#
>>  
>> # Allow anonymous to read weather
>> topic read weather/#
>>  
>> # weewx readwrite to the loop
>> user 
>> topic weather/#
>>
> -- 
 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.
 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+...@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] My current would not update

[olectrix]

Thank you! Error-Message is gone.

Still the html-pages with the weather data are not updated 

How can that be? 

On Monday, 21 January 2019 23:24:20 UTC+1, Thomas Keffer wrote:
>
> Take a look in your weewx.conf, section [StdArchive], option '
> archive_interval'. It looks like you have a non-integer in there.
>
> -tk
>
> On Mon, Jan 21, 2019 at 11:37 AM > wrote:
>
>> Hello my weewx-install would not update the html-pages anymore.
>>
>> It´s funny - because the installation ran fine for about 2 years now.
>> What happened 3 days ago was, that the display (wh1080) would not receive 
>> any transmitter-data. Changing the transmitter batteries would not help, I 
>> had to restart the display (turn off / turn on the wh1080), so that it 
>> recognized the transmitter and got data again.
>>
>> But now weewX would not update the current-html anymore - just the 
>> week-summary.
>>
>> So i updated the SDB regarding timestamps: 
>>
>> "
>>
>> cp /home/weewx/archive/weewx.sdb /home/weewx/archive/weewx.sdb.backup
>> sqlite3 /home/weewx/archive/weewx.sdb
>> sqlite> delete from archive where dateTime > X;
>> sqlite> .exit
>> "
>>
>> Cleared the device-memory
>>
>> "
>> wee_device --clear-memory
>> "
>>
>> and got into debug mode and got this error after running "sudo service weewx 
>> start":
>>
>> "
>>
>> Jan 21 20:22:41 se weewx[4312]: wxcalculate: The following algorithms 
>> will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS
>> Jan 21 20:22:41 se weewx[4312]: engine: Finished loading service 
>> weewx.wxservices.StdWXCalculate
>> Jan 21 20:22:41 seweewx[4312]: engine: Loading service 
>> weewx.engine.StdArchive
>> Jan 21 20:22:41 seweewx[4312]: engine: Caught unrecoverable exception in 
>> engine:
>> Jan 21 20:22:41 se weewx[4312]:   invalid literal for int() with 
>> base 10: ''
>> Jan 21 20:22:41 se weewx[4312]:   Traceback (most recent call 
>> last):
>> Jan 21 20:22:41 se weewx[4312]: File 
>> "/usr/share/weewx/weewx/engine.py", line 871, in main
>> Jan 21 20:22:41 se weewx[4312]:   engine = 
>> engine_class(config_dict)
>> Jan 21 20:22:41 se weewx[4312]: File 
>> "/usr/share/weewx/weewx/engine.py", line 78, in __init__
>> Jan 21 20:22:41 se weewx[4312]:   
>> self.loadServices(config_dict)
>> Jan 21 20:22:41 se weewx[4312]: File 
>> "/usr/share/weewx/weewx/engine.py", line 142, in loadServices
>> Jan 21 20:22:41 se weewx[4312]:   
>> self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
>> Jan 21 20:22:41 se weewx[4312]: File 
>> "/usr/share/weewx/weewx/engine.py", line 447, in __init__
>> Jan 21 20:22:41 se weewx[4312]:   software_interval = 
>> to_int(config_dict['StdArchive'].get('archive_interval', 300))
>> Jan 21 20:22:41 se weewx[4312]: File 
>> "/usr/share/weewx/weeutil/weeutil.py", line 1253, in to_int
>> Jan 21 20:22:41 se weewx[4312]:   return int(x) if x is not 
>> None else None
>> Jan 21 20:22:41 se weewx[4312]:   ValueError: invalid literal for 
>> int() with base 10: ''
>> Jan 21 20:22:41 se weewx[4312]:   Exiting.
>> "
>>
>> Any hints appreciated!
>>
>>
>> -- 
>> 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 .
>> 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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

I have an external server im uploading using ftp, can you try to open in IE
or in an Incognito window http://www.riyadhweather.com or without www

On Tue, Jan 22, 2019 at 2:54 AM Scott Grayban  wrote:

> Something is still wrong as https is still being forced on my end...
> remove ALL settings in apache for ssl.
>
> On Monday, January 21, 2019 at 3:43:21 PM UTC-8, Adnan Mumtaz wrote:
>>
>> Removed https and now charts are loading too, MQTT is still not working
>>
>> On Tue, Jan 22, 2019 at 2:35 AM Adnan Mumtaz  wrote:
>>
>>> yes :)
>>>
>>> On Tuesday, 22 January 2019 02:32:36 UTC+3, Scott Grayban wrote:

 umm you do have a username though ?

 On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:
>
> Fixed, on the server where I installed MQTT i have the below config in
> the acl file
>
> # Allow anonymous access to the sys
> topic read $SYS/#
>
> # Allow anonymous to read weather
> topic read weather/#
>
> # weewx readwrite to the loop
> user 
> topic weather/#
>
 --
>>> 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.
>>> 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.
>

-- 
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] Re: Ambient Weather WS-2902A

[Scott Grayban]

Something is still wrong as https is still being forced on my end... remove 
ALL settings in apache for ssl.

On Monday, January 21, 2019 at 3:43:21 PM UTC-8, Adnan Mumtaz wrote:
>
> Removed https and now charts are loading too, MQTT is still not working 
>
> On Tue, Jan 22, 2019 at 2:35 AM Adnan Mumtaz  > wrote:
>
>> yes :)
>>
>> On Tuesday, 22 January 2019 02:32:36 UTC+3, Scott Grayban wrote:
>>>
>>> umm you do have a username though ?
>>>
>>> On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:

 Fixed, on the server where I installed MQTT i have the below config in 
 the acl file

 # Allow anonymous access to the sys
 topic read $SYS/#
  
 # Allow anonymous to read weather
 topic read weather/#
  
 # weewx readwrite to the loop
 user 
 topic weather/#

>>> -- 
>> 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 .
>> 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] Re: Ambient Weather WS-2902A

[Adnan Mumtaz]

Removed https and now charts are loading too, MQTT is still not working

On Tue, Jan 22, 2019 at 2:35 AM Adnan Mumtaz  wrote:

> yes :)
>
> On Tuesday, 22 January 2019 02:32:36 UTC+3, Scott Grayban wrote:
>>
>> umm you do have a username though ?
>>
>> On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Fixed, on the server where I installed MQTT i have the below config in
>>> the acl file
>>>
>>> # Allow anonymous access to the sys
>>> topic read $SYS/#
>>>
>>> # Allow anonymous to read weather
>>> topic read weather/#
>>>
>>> # weewx readwrite to the loop
>>> user 
>>> topic weather/#
>>>
>> --
> 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.
>

-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

Your connection is not private

Attackers might be trying to steal your information from riyadhweather.com 
(for example, passwords, messages, or credit cards). 
NET::ERR_CERT_COMMON_NAME_INVALID


On Monday, January 21, 2019 at 3:35:36 PM UTC-8, Adnan Mumtaz wrote:
>
> yes :)
>
> On Tuesday, 22 January 2019 02:32:36 UTC+3, Scott Grayban wrote:
>>
>> umm you do have a username though ?
>>
>> On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Fixed, on the server where I installed MQTT i have the below config in 
>>> the acl file
>>>
>>> # Allow anonymous access to the sys
>>> topic read $SYS/#
>>>  
>>> # Allow anonymous to read weather
>>> topic read weather/#
>>>  
>>> # weewx readwrite to the loop
>>> user 
>>> topic weather/#
>>>
>>

-- 
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] Real Time Gauges (RTGD) for Steel Series

[nineback]

I'm a little confused which is nothing new.  I have RTGD configured as

[RealtimeGaugeData]
date_format = %Y.%m.%d %H:%M
rtgd_path = /home/weewx/public_html
scroller_source = WU
remote_server_url = http://www.XXX.com/weewx/ss/post_gauge-data.php
rtgd_file_name = gauge-data.txt

In my skin.com for ss is have

[CheetahGenerator]
   # search_list_extensions = user.forecast.ForecastVariables
encoding = html_entities
[[ToDate]]
[[[index]]]
template = index.html.tmpl
  #  [[[data]]]
   # template = gauge-data.txt.tmpl

I am getting the gauge-data.txt file created in the weewx/ss folder on my 
web site every loop but I am also getting the gauge-data.txt file upload to 
my weex folder at each archive interval.  I thought by commenting out the 
two lines in the ss skin that would prevent one file from being created.  I 
thought the loop file, created by RTGD, would go in the weex directory but 
it seems as though it is in my ss directory since the ss directory is being 
updated every loop.

When I look at my public_html folder on my Raspi I see the gauge-data.txt 
file in the root (weewx/public_html) but do not see the file in the 
weewx/public_html/ss folder.

So why am I getting two files and why is the loop going into the ss folder?

Tom




-- 
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: Ambient Weather WS-2902A

[Adnan Mumtaz]

yes :)

On Tuesday, 22 January 2019 02:32:36 UTC+3, Scott Grayban wrote:
>
> umm you do have a username though ?
>
> On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:
>>
>> Fixed, on the server where I installed MQTT i have the below config in 
>> the acl file
>>
>> # Allow anonymous access to the sys
>> topic read $SYS/#
>>  
>> # Allow anonymous to read weather
>> topic read weather/#
>>  
>> # weewx readwrite to the loop
>> user 
>> topic weather/#
>>
>

-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

umm you do have a username though ?

On Monday, January 21, 2019 at 3:27:50 PM UTC-8, Adnan Mumtaz wrote:
>
> Fixed, on the server where I installed MQTT i have the below config in the 
> acl file
>
> # Allow anonymous access to the sys
> topic read $SYS/#
>  
> # Allow anonymous to read weather
> topic read weather/#
>  
> # weewx readwrite to the loop
> user 
> topic weather/#
>

-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

And one more thing don't use https at its throwing a error in 
chrome about insecure scripts.

On Monday, January 21, 2019 at 3:24:43 PM UTC-8, Scott Grayban wrote:
>
> And this is wrong
>
> [[MQTT]]
> server_url = mqtt://weewx:remo...@kali.cpminhal.com.sa:1883/
> topic = weather/#
> unit_system = METRIC
> binding = archive, loop
> aggregation = aggregate
>
> should be
> [[MQTT]]
> server_url = mqtt://weewx:remo...@kali.cpminhal.com.sa:1883/
> topic = weather/weewx
> unit_system = METRIC
> binding = archive, loop
> aggregation = aggregate
>
>
> On Monday, January 21, 2019 at 3:21:12 PM UTC-8, Scott Grayban wrote:
>>
>> use this.
>> mqtt_topic = weather/weewx/loop
>>
>> not
>>
>>   mqtt_topic = "weather/#"
>>
>> On Monday, January 21, 2019 at 3:11:09 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>>
>>> Attaching my conf file, all passwords were removed from the file for 
>>> security, ive install MQTT in one of my remote servers which also doesnt 
>>> seem to work here :)
>>>
>>>
>>> On Monday, 21 January 2019 21:59:52 UTC+3, Scott Grayban wrote:

 That's the default skin. Did you  install Belchertown ?

 On Monday, January 21, 2019 at 9:27:24 AM UTC-8, Adnan Mumtaz wrote:
>
> Hi Scott,
>
> I am live https://riyadhweather.com/  , the station is not yet 
> connected properly its just lying on the roof only temp and humidity 
> would 
> be correct. was wondering is the barometer is inside the display screen 
> or 
> outside unit
>
>

-- 
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: Ambient Weather WS-2902A

[Adnan Mumtaz]

Fixed, on the server where I installed MQTT i have the below config in the 
acl file

# Allow anonymous access to the sys
topic read $SYS/#
 
# Allow anonymous to read weather
topic read weather/#
 
# weewx readwrite to the loop
user 
topic weather/#

On Tuesday, 22 January 2019 02:21:12 UTC+3, Scott Grayban wrote:
>
> use this.
> mqtt_topic = weather/weewx/loop
>
> not
>
>   mqtt_topic = "weather/#"
>
> On Monday, January 21, 2019 at 3:11:09 PM UTC-8, Adnan Mumtaz wrote:
>>
>>
>> Attaching my conf file, all passwords were removed from the file for 
>> security, ive install MQTT in one of my remote servers which also doesnt 
>> seem to work here :)
>>
>>
>> On Monday, 21 January 2019 21:59:52 UTC+3, Scott Grayban wrote:
>>>
>>> That's the default skin. Did you  install Belchertown ?
>>>
>>> On Monday, January 21, 2019 at 9:27:24 AM UTC-8, Adnan Mumtaz wrote:

 Hi Scott,

 I am live https://riyadhweather.com/  , the station is not yet 
 connected properly its just lying on the roof only temp and humidity would 
 be correct. was wondering is the barometer is inside the display screen or 
 outside unit



-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

And this is wrong

[[MQTT]]
server_url = mqtt://weewx:remo...@kali.cpminhal.com.sa:1883/
topic = weather/#
unit_system = METRIC
binding = archive, loop
aggregation = aggregate

should be
[[MQTT]]
server_url = mqtt://weewx:remo...@kali.cpminhal.com.sa:1883/
topic = weather/weewx
unit_system = METRIC
binding = archive, loop
aggregation = aggregate


On Monday, January 21, 2019 at 3:21:12 PM UTC-8, Scott Grayban wrote:
>
> use this.
> mqtt_topic = weather/weewx/loop
>
> not
>
>   mqtt_topic = "weather/#"
>
> On Monday, January 21, 2019 at 3:11:09 PM UTC-8, Adnan Mumtaz wrote:
>>
>>
>> Attaching my conf file, all passwords were removed from the file for 
>> security, ive install MQTT in one of my remote servers which also doesnt 
>> seem to work here :)
>>
>>
>> On Monday, 21 January 2019 21:59:52 UTC+3, Scott Grayban wrote:
>>>
>>> That's the default skin. Did you  install Belchertown ?
>>>
>>> On Monday, January 21, 2019 at 9:27:24 AM UTC-8, Adnan Mumtaz wrote:

 Hi Scott,

 I am live https://riyadhweather.com/  , the station is not yet 
 connected properly its just lying on the roof only temp and humidity would 
 be correct. was wondering is the barometer is inside the display screen or 
 outside unit



-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

use this.
mqtt_topic = weather/weewx/loop

not

  mqtt_topic = "weather/#"

On Monday, January 21, 2019 at 3:11:09 PM UTC-8, Adnan Mumtaz wrote:
>
>
> Attaching my conf file, all passwords were removed from the file for 
> security, ive install MQTT in one of my remote servers which also doesnt 
> seem to work here :)
>
>
> On Monday, 21 January 2019 21:59:52 UTC+3, Scott Grayban wrote:
>>
>> That's the default skin. Did you  install Belchertown ?
>>
>> On Monday, January 21, 2019 at 9:27:24 AM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Hi Scott,
>>>
>>> I am live https://riyadhweather.com/  , the station is not yet 
>>> connected properly its just lying on the roof only temp and humidity would 
>>> be correct. was wondering is the barometer is inside the display screen or 
>>> outside unit
>>>
>>>

-- 
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] One archive database - two weewx implementations

[gjr80]

Gee, this sound like a whole lot of trouble for a development instance of 
WeeWX. Why not just have a separate simulator install, use the simulator in 
generator mode to generate a few years of data then keep a copy of this 
data for when you hose your development data. Switch the simulator back to 
simulate mode and do your development. Sure it's nice to see the same data 
but canned data is fine for 99% of development work. The risk with having 
access to your production data is that sooner or later something is going 
to do something it shouldn't.

Gary

On Tuesday, 22 January 2019 08:52:12 UTC+10, kutz...@gmail.com wrote:
>
> Thanks Thomas. I was worried the answer to my first question was going to 
> be no.
>
> My fallback on the LAN-based database was going to be to use the rsync 
> extension to copy the database from the production weewx instance to the 
> development instance. A third option would be to mount the database on the 
> production Pi onto the development Pi. Then the LAN instance is only being 
> read. Since LAN access is only to a development instance, it would be no 
> big deal if it dropped some records in reports. But requiring a device 
> driver nixes those ideas also. 
>
> Does the driver need to generate ARCHIVE packets and try to store them? Or 
> are just empty LOOP packets ok? I was actually planning to get LOOP packets 
> from MQTT which my production weewx instance publishes. So, I wouldn't even 
> want the development instance to grab LOOP packets other than the MQTT ones.
>
> phil
>
> On Monday, January 21, 2019 at 5:30:53 PM UTC-5, Thomas Keffer wrote:
>>
>> 1. Unfortunately, no. WeeWX expects a device driver. I suppose you could 
>> create a dummy device driver that emits empty LOOP packets at regular 
>> intervals, but I've never tried that.
>> 2. Would not make any difference. Sqlite does quite well locking around 
>> reads and writes.
>> 3. The problem using a database on your LAN is that it exposes yourself 
>> to network errors. WeeWX does not do very well recovering from these kinds 
>> of errors. It won't crash, but it can drop a record. Still, lots of people 
>> have used a database on another machine. Personally, I think the problem of 
>> SD card writes is overstated. I have been running an instance of WeeWX 
>>  on an RPi with a 
>> Sandisk Extreme Plus SD card. It has been up for well over 4 years without 
>> a disk crash.
>>
>> -tk
>>
>> On Mon, Jan 21, 2019 at 12:24 PM  wrote:
>>
>>> I am currently running weewx (on a Raspberry Pi) inputting data from a 
>>> Vantage Vue station, using a sqlite3 database to archive the data. I 
>>> publish the generated webpages via an external web hosting service. I want 
>>> to set up a development weewx instance on a second Raspberry Pi and point 
>>> it to the existing database to get generated output. This would allow me to 
>>> have the output from my development instance display current data gathered 
>>> from the production instance. But, if I hose my output while making changes 
>>> in the development instance, I won't impact the published webpages.
>>>
>>> I'm looking for advice and have a few questions:
>>>
>>> 1. Is there a way to run a weewx instance that skips the device 
>>> input (since that will be handled by the production instance) but goes 
>>> through the output items a skin would do including generating html pages 
>>> and copying them into the public_html directory?
>>>
>>> 2. Is migrating to MySQL a better choice for this kind of setup? I 
>>> would think that using MySQL will solve any issues of locking caused 
>>> if/when both instances access the database simultaneously (though one is is 
>>> reading and writing while the other is only reading).
>>>
>>> 3. I am also thinking of moving the database (and maybe other weewx 
>>> directories) to a Synology NAS and mapping those locations to my two weewx 
>>> instances to reduce SDCard writes. Are there any significant gotchas or 
>>> warnings I should take heed of regarding this?
>>>
>>> phil
>>>
>>> -- 
>>>
>>>

-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

So you have some things wrong still.


   1. MQTT is not working
   2. Settings for Highcharts_Belchertown not set
   
So you have more work to do but you are close.

On Monday, January 21, 2019 at 2:46:10 PM UTC-8, Adnan Mumtaz wrote:
>
> Hi Scott,
>
> Installed belchertown but I dont know whats wrong, the HTML_Root path was 
> belchertown and it kept uploading to 
> https://www.riyadhweather.com/belchertown fixed it later but it all looks 
> upside down and the charts are also not loading see the main URL too and 
> advise.
>
> On Monday, 21 January 2019 21:59:52 UTC+3, Scott Grayban wrote:
>>
>> That's the default skin. Did you  install Belchertown ?
>>
>> On Monday, January 21, 2019 at 9:27:24 AM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Hi Scott,
>>>
>>> I am live https://riyadhweather.com/  , the station is not yet 
>>> connected properly its just lying on the roof only temp and humidity would 
>>> be correct. was wondering is the barometer is inside the display screen or 
>>> outside unit
>>>
>>>

-- 
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: Ambient Weather WS-2902A

[Adnan Mumtaz]

Hi Scott,

Installed belchertown but I dont know whats wrong, the HTML_Root path was 
belchertown and it kept uploading to 
https://www.riyadhweather.com/belchertown fixed it later but it all looks 
upside down and the charts are also not loading see the main URL too and 
advise.

On Monday, 21 January 2019 21:59:52 UTC+3, Scott Grayban wrote:
>
> That's the default skin. Did you  install Belchertown ?
>
> On Monday, January 21, 2019 at 9:27:24 AM UTC-8, Adnan Mumtaz wrote:
>>
>> Hi Scott,
>>
>> I am live https://riyadhweather.com/  , the station is not yet connected 
>> properly its just lying on the roof only temp and humidity would be 
>> correct. was wondering is the barometer is inside the display screen or 
>> outside unit
>>
>>

-- 
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] One archive database - two weewx implementations

[Thomas Keffer]

1. Unfortunately, no. WeeWX expects a device driver. I suppose you could
create a dummy device driver that emits empty LOOP packets at regular
intervals, but I've never tried that.
2. Would not make any difference. Sqlite does quite well locking around
reads and writes.
3. The problem using a database on your LAN is that it exposes yourself to
network errors. WeeWX does not do very well recovering from these kinds of
errors. It won't crash, but it can drop a record. Still, lots of people
have used a database on another machine. Personally, I think the problem of
SD card writes is overstated. I have been running an instance of WeeWX
 on an RPi with a
Sandisk Extreme Plus SD card. It has been up for well over 4 years without
a disk crash.

-tk

On Mon, Jan 21, 2019 at 12:24 PM  wrote:

> I am currently running weewx (on a Raspberry Pi) inputting data from a
> Vantage Vue station, using a sqlite3 database to archive the data. I
> publish the generated webpages via an external web hosting service. I want
> to set up a development weewx instance on a second Raspberry Pi and point
> it to the existing database to get generated output. This would allow me to
> have the output from my development instance display current data gathered
> from the production instance. But, if I hose my output while making changes
> in the development instance, I won't impact the published webpages.
>
> I'm looking for advice and have a few questions:
>
> 1. Is there a way to run a weewx instance that skips the device input
> (since that will be handled by the production instance) but goes through
> the output items a skin would do including generating html pages and
> copying them into the public_html directory?
>
> 2. Is migrating to MySQL a better choice for this kind of setup? I
> would think that using MySQL will solve any issues of locking caused
> if/when both instances access the database simultaneously (though one is is
> reading and writing while the other is only reading).
>
> 3. I am also thinking of moving the database (and maybe other weewx
> directories) to a Synology NAS and mapping those locations to my two weewx
> instances to reduce SDCard writes. Are there any significant gotchas or
> warnings I should take heed of regarding this?
>
> phil
>
> --
> 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.
>

-- 
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] My current would not update

[Thomas Keffer]

Take a look in your weewx.conf, section [StdArchive], option '
archive_interval'. It looks like you have a non-integer in there.

-tk

On Mon, Jan 21, 2019 at 11:37 AM  wrote:

> Hello my weewx-install would not update the html-pages anymore.
>
> It´s funny - because the installation ran fine for about 2 years now.
> What happened 3 days ago was, that the display (wh1080) would not receive
> any transmitter-data. Changing the transmitter batteries would not help, I
> had to restart the display (turn off / turn on the wh1080), so that it
> recognized the transmitter and got data again.
>
> But now weewX would not update the current-html anymore - just the
> week-summary.
>
> So i updated the SDB regarding timestamps:
>
> "
>
> cp /home/weewx/archive/weewx.sdb /home/weewx/archive/weewx.sdb.backup
> sqlite3 /home/weewx/archive/weewx.sdb
> sqlite> delete from archive where dateTime > X;
> sqlite> .exit
> "
>
> Cleared the device-memory
>
> "
> wee_device --clear-memory
> "
>
> and got into debug mode and got this error after running "sudo service weewx 
> start":
>
> "
>
> Jan 21 20:22:41 se weewx[4312]: wxcalculate: The following algorithms will
> be used for calculations: altimeter=aaNOAA, maxSolarRad=RS
> Jan 21 20:22:41 se weewx[4312]: engine: Finished loading service
> weewx.wxservices.StdWXCalculate
> Jan 21 20:22:41 seweewx[4312]: engine: Loading service
> weewx.engine.StdArchive
> Jan 21 20:22:41 seweewx[4312]: engine: Caught unrecoverable exception in
> engine:
> Jan 21 20:22:41 se weewx[4312]:   invalid literal for int() with
> base 10: ''
> Jan 21 20:22:41 se weewx[4312]:   Traceback (most recent call
> last):
> Jan 21 20:22:41 se weewx[4312]: File
> "/usr/share/weewx/weewx/engine.py", line 871, in main
> Jan 21 20:22:41 se weewx[4312]:   engine =
> engine_class(config_dict)
> Jan 21 20:22:41 se weewx[4312]: File
> "/usr/share/weewx/weewx/engine.py", line 78, in __init__
> Jan 21 20:22:41 se weewx[4312]: 
> self.loadServices(config_dict)
> Jan 21 20:22:41 se weewx[4312]: File
> "/usr/share/weewx/weewx/engine.py", line 142, in loadServices
> Jan 21 20:22:41 se weewx[4312]: 
> self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
> Jan 21 20:22:41 se weewx[4312]: File
> "/usr/share/weewx/weewx/engine.py", line 447, in __init__
> Jan 21 20:22:41 se weewx[4312]:   software_interval =
> to_int(config_dict['StdArchive'].get('archive_interval', 300))
> Jan 21 20:22:41 se weewx[4312]: File
> "/usr/share/weewx/weeutil/weeutil.py", line 1253, in to_int
> Jan 21 20:22:41 se weewx[4312]:   return int(x) if x is not
> None else None
> Jan 21 20:22:41 se weewx[4312]:   ValueError: invalid literal for
> int() with base 10: ''
> Jan 21 20:22:41 se weewx[4312]:   Exiting.
> "
>
> Any hints appreciated!
>
>
> --
> 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.
>

-- 
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: calcMissing() for non-import observations?

[Pat]

Hopefully simpler than the bitwise shifting issue I have in my driver going 
on which is way over my head!

On Monday, January 21, 2019 at 4:13:31 PM UTC-5, gjr80 wrote:
>
> In that case, no there is nothing in any of the utlilities, you will need 
> to roll your own. But it is dead simple.
>
> 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.

[weewx-user] Re: calcMissing() for non-import observations?

[gjr80]

In that case, no there is nothing in any of the utlilities, you will need to 
roll your own. But it is dead simple.

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.

[weewx-user] Re: calcMissing() for non-import observations?

[Pat]

Thanks Gary - I meant something "built in" to wee_database or something of 
the like (e.g. not a custom extension). I've been known to overlook the 
simple solutions - so while I haven't found anything in GitHub yet within 
weewx core, I wanted to ask before I tried to figure it out on my own. 

Thanks - will check those a bit deeper (already have started looking at 
them).


On Monday, January 21, 2019 at 4:04:00 PM UTC-5, gjr80 wrote:
>
> Yes, it's called the StdWXCalculate service? The 'Service' classes have 
> somewhat of an overhead and they really need an instance of the weeWX 
> engine to be running to be used. The StdWXCalculate was slightly 
> restructured some time ago so that it called the WXCalculate class that 
> essentially does all the missing calcs. That is how wee_import works, it 
> taps into the WXCalculate class without the need for engine to be running.
>
> Not really sure of your requirements so have a look at wxsevices.py and 
> weeimport/weeimport.py, you may find something there.
>
> 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.

[weewx-user] calcMissing() for non-import observations?

[gjr80]

Yes, it's called the StdWXCalculate service? The 'Service' classes have 
somewhat of an overhead and they really need an instance of the weeWX engine to 
be running to be used. The StdWXCalculate was slightly restructured some time 
ago so that it called the WXCalculate class that essentially does all the 
missing calcs. That is how wee_import works, it taps into the WXCalculate class 
without the need for engine to be running.

Not really sure of your requirements so have a look at wxsevices.py and 
weeimport/weeimport.py, you may find something there.

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.

[weewx-user] One archive database - two weewx implementations

[kutzenco]

I am currently running weewx (on a Raspberry Pi) inputting data from a 
Vantage Vue station, using a sqlite3 database to archive the data. I 
publish the generated webpages via an external web hosting service. I want 
to set up a development weewx instance on a second Raspberry Pi and point 
it to the existing database to get generated output. This would allow me to 
have the output from my development instance display current data gathered 
from the production instance. But, if I hose my output while making changes 
in the development instance, I won't impact the published webpages.

I'm looking for advice and have a few questions:

1. Is there a way to run a weewx instance that skips the device input 
(since that will be handled by the production instance) but goes through 
the output items a skin would do including generating html pages and 
copying them into the public_html directory?

2. Is migrating to MySQL a better choice for this kind of setup? I 
would think that using MySQL will solve any issues of locking caused 
if/when both instances access the database simultaneously (though one is is 
reading and writing while the other is only reading).

3. I am also thinking of moving the database (and maybe other weewx 
directories) to a Synology NAS and mapping those locations to my two weewx 
instances to reduce SDCard writes. Are there any significant gotchas or 
warnings I should take heed of regarding this?

phil

-- 
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: Weewx without driver

[mwall]

On Sunday, January 20, 2019 at 11:54:01 AM UTC-5, Andrej B. wrote:
>
> I plan to read, store and generating graphs for voltage. ADC is ADS1115 
> and database is MySQL. Can Weewx work without hardware driver? 
> I just need to point weewx to already prepared data from database and next 
> use weewx as usually (plotting, statistics etc.). 
> I need small how-to for this.
>

you can use the utility wee_reports to do this.

http://weewx.com/docs/utilities.htm#wee_reports_utility

however, you must ensure that the database uses a schema that wee_reports 
expects:

http://weewx.com/docs/customizing.htm#The_database

m

-- 
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] calcMissing() for non-import observations?

[Pat]

When using wee_import there's an option to --calc-missing 
 
upon import. This will populate the observations in the archive that are 
missing ( heatindex, pressure, rainRate, windchill, appTemp, cloudbase, 
humidex, maxSolarRad, windrun)

I haven't found anything, but wanted to ask. Does such a function exist in 
another method for non-import? 

I'm looking to calculate some missing observations. I have nothing to 
import. Wanted to do it on the fly. 

Thoughts?

-- 
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: Ambient Weather WS-2902A

[Scott Grayban]

Looks good...

I think it's outside. Have you read the manual ? It should have that info.

On Monday, January 21, 2019 at 9:27:24 AM UTC-8, Adnan Mumtaz wrote:
>
> Hi Scott,
>
> I am live https://riyadhweather.com/  , the station is not yet connected 
> properly its just lying on the roof only temp and humidity would be 
> correct. was wondering is the barometer is inside the display screen or 
> outside unit
>
> On Monday, 21 January 2019 15:27:07 UTC+3, Adnan Mumtaz wrote:
>>
>> Thanks for sharing your link Scott, looks so good. I have received the 
>> station today and will mount it today too, I have configured the RPi as per 
>> your guidelines, edited the dhcpcd.conf file too, do i have to assign a 
>> manual IP to the eth0 interface? as I see it is still DHCP enabled.
>>
>> On Monday, 21 January 2019 01:11:26 UTC+3, Scott Grayban wrote:
>>>
>>> This is my site http://www.nettletondistrict.com/Nettleton/
>>>
>>> On Sunday, January 20, 2019 at 2:01:00 PM UTC-8, Adnan Mumtaz wrote:

 Sorry , I was a bit confused,  I forgot with this I will make the RPi 
 an AP where the station will connect to, so in that case I will install 
 plain weewx and then follow your instructions and once I can see data 
 being 
 received I will work on different skins, more interested in Belchertown 
 and 
 also weather34 

 On Monday, 21 January 2019 00:05:18 UTC+3, Adnan Mumtaz wrote:
>
> Hi Scott,
>
> Received the RPi , installed the OS and installed WeeWX to test, 
> everything went smooth, then started reading the links you shared, 
> tomorrow 
> I should be receiving my WS too hopefully it was held by customs  :) 
>
> Question, the link you shared with me has prerequisites , which are 
> straight but there is a link which takes to 
> https://github.com/matthewwall/weewx-interceptor , so the first step 
> of prerequisites should be to install weewx interceptor and then follow 
> the 
> rest in the link, I understand the RPi will sniff data via WiFi and it 
> will 
> have access to WAN using Ethernet connection, can you also share your 
> website.
>
> Thanks a lot,
> Adnan
>
> On Wednesday, 16 January 2019 01:48:06 UTC+3, Scott Grayban wrote:
>>
>> I use this one https://smile.amazon.com/gp/product/B06XWMQ81P/
>>
>> SanDisk Extreme 32GB microSDHC UHS-3 Card - SDSQXAF-032G-GN6MA
>>
>> On Tuesday, January 15, 2019 at 2:23:52 PM UTC-8, Adnan Mumtaz wrote:
>>>
>>> I am a Debian user , not a very advanced one but i have concepts, I 
>>> am dowloading the RPi Debian Lite version as I wouldnt need a desktop, 
>>> what 
>>> size and brand SD would you recommend
>>>
>>> On Tuesday, 15 January 2019 22:38:12 UTC+3, Scott Grayban wrote:

 Sure but you shouldn't have any problems unless you don't know 
 anything about linux.

 On Tuesday, January 15, 2019 at 11:35:11 AM UTC-8, Adnan Mumtaz 
 wrote:
>
> Thanks a lot, ordered it. Will need your help again if i get stuck 
> in something. So kind of you.
>
> Regards,
> Adnan
>
> On Tuesday, 15 January 2019 22:27:19 UTC+3, Scott Grayban wrote:
>>
>> This one 
>> https://saudi.souq.com/sa-en/raspberry-pi-3-model-b+-plus-32895409/i/
>>
>> On Tuesday, January 15, 2019 at 11:09:11 AM UTC-8, Adnan Mumtaz 
>> wrote:
>>>
>>> Hi Scott,
>>>
>>> Bundle of thanks for sharing your hardwork, will you suggest 
>>> which RPi should I buy, I can find few available in a local e-store 
>>> https://saudi.souq.com/sa-en/raspberry-pi/s/?as=1
>>>
>>> Regards,
>>> Adnan
>>>
>>> On Tuesday, 15 January 2019 21:37:41 UTC+3, Scott Grayban wrote:

 You also need to buy a Rpi from amazon or the UK Rpi store for 
 this to work. https://www.raspberrypi.org/


 On Tuesday, January 15, 2019 at 10:14:38 AM UTC-8, Adnan Mumtaz 
 wrote:
>
> Greetings from Saudi Arabia,
>
> I am an expat living and working in Riyadh, Saudi Arabia. I 
> have recently purchased Ambient Weather WS-2902A which I will be 
> receiving 
> next week, I have a domain and web hosting where I want to 
> publish my 
> weather using WeeWX (belchertown template). I am a systems 
> engineer but far 
> from programming since a very long time, I will appreciate if 
> someone can 
> guide me, I did search the forum and found few had issues and 
> those who had 
> success are not publishing details.
>
> Awaiting positive response .
>
> 

[weewx-user] Re: IWDL - Vorhersage

[Kalli]

Hallo Gery
das ist ein missverständniss.

ich meinte Das hier https://www.sietse.net/iwdl-info/

mfg.Kalli

Am Sonntag, 20. Januar 2019 13:25:30 UTC+1 schrieb Kalli:
>
> Hallo
> seit einiger zeit geht die Wettervorhersage bei IWDL nicht mehr.
> hat sich was geändert.
>
> mfg. Kalli
>

-- 
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] Re: Reliable Switch to MySQL?

[Greg Troxel]

Cycle London  writes:

> Doesn't look similar to me...
>
> [cyclelondon@weather ~]$ sqlite3
> SQLite version 3.7.17 2013-05-20 00:56:22
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> show databases ;
> Error: near "show": syntax error
> sqlite> show tables ;
> Error: near "show": syntax error

Standard sql is the same.  nonstandard extensions are different, but you
can do the same things.

Each database is a file, so there is no notion of show databases.

"man sqlite3" will explain many things.  But ".tables" will do what you
want.   In all seriousness, if you understand mysql, you can figure out
how to do what you want in sqlite in well under an hour.

If sqlite is adequate in terms of size, which it certainly is a year in,
then it is vastly simpler.   Think about reliability and weewx being
able to store new data as archive records happen.  So you really want a
local db, that is guaranteed to be up if weewx is up.



-- 
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: use Weewx on raspberry

[Patrick Tranchant]

hello Pat and Gary

if I put the driver on the Raspberry forum where several people have built 
the same weather station as me, does that bother you, maybe it could help 
solve the problem.
tell me.

Patrick

On Saturday, December 8, 2018 at 3:40:43 PM UTC+1, Patrick Tranchant wrote:
>
> hello I am a newbie from France ( sorry for my english )
>
> I want to use weewx on a raspberry with a weather station built by myself 
> (view on Magpi)
> I don't see my station on your website to configure :
>
> Weather Station Hardware Comparison: I don't found my weather station.
> Do you have a solution or how to configure Weewx
>
> thank you for your help
>
> Patrick
>

-- 
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] Re: Reliable Switch to MySQL?

[Cycle London]

Apologies - by 'the GUI' I mean the weewx web frontend.

I reckon it's about time I moved to  MySQL.  That involves raising a change
- which in my case, means asking my wife if she has anything planned the
weekend after next.  :-)



On Mon, 21 Jan 2019 at 13:28, Andrew Milner 
wrote:

> to answer that one it may help to know how you installed weewx in the
> first place!!  Different installation methods put things in different
> places.
>
> what exactly do you mean by 'getting data on the GUI'??
>
> the likely explanation is that the webpages are being generated from a
> version of weewx.sdb which is located in a different place - and weewx
> itself is possibly using a version of weewx.conf which is not the one you
> looked at!!
>
>
>
> On Monday, 21 January 2019 15:16:01 UTC+2, Cycle London wrote:
>>
>> Oh, you are so right, man.
>>
>> If I could, I'd be travelling the world as a landscape photographer.  Or
>> flying in the Royal Air Force.  But although I'm 'not bad' with a camera,
>> the world is full of people who are 'not bad'.  And my eyesight was too bad
>> for the RAF to accept me.
>>
>> Anyway, I digress.  In response to your other post, I note that the
>> weewx.sdb file in /home/weewx is owned by root but is empty.   Inside
>> ./archive there is another file of the same name.   .table works on that
>> file.  Curiously, however..
>>
>> [root@weather weewx]# pwd && grep sdb weewx.conf
>> /home/weewx
>> database_name = weewx.sdb
>>
>> Can't figure out how, if the weewx.conf file is pointing to what is
>> essentially an empty file, how I'm getting data on the GUI.
>>
>>
>>
>> On Mon, 21 Jan 2019 at 13:09, Thomas Keffer  wrote:
>>
>>> The thing is that I work in IT but I hate it.  I have a set of skills
 (RHEL, Citrix, MySQL, OpenVMS..), but have little desire to increase that.
 I do what I do because it pays the bills, and lets me buy nice toys like
 the weather station, like my Nikon D850, and I get to go on nice holidays.
 But when I think of extracting data for the weather last year, I think "why
 bother to learn sqlite when I already know MySQL?".

>>>
>>> That's unfortunate. Life is way too short to work on something you don't
>>> love.
>>>
>>> "Live as if you were to die tomorrow. Learn as if you were to live
>>> forever." --- Gandhi
>>>
>>> -tk
>>>
>>> --
>>> 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/nlfPiicnLsw/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 a topic in the
> Google Groups "weewx-user" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Thomas Keffer]

The database location is /home/weewx/archive/weewx.sdb.

I'd guess you're trying /home/weewx/weewx.sdb.

On Mon, Jan 21, 2019 at 5:16 AM Cycle London 
wrote:

> Oh, you are so right, man.
>
> If I could, I'd be travelling the world as a landscape photographer.  Or
> flying in the Royal Air Force.  But although I'm 'not bad' with a camera,
> the world is full of people who are 'not bad'.  And my eyesight was too bad
> for the RAF to accept me.
>
> Anyway, I digress.  In response to your other post, I note that the
> weewx.sdb file in /home/weewx is owned by root but is empty.   Inside
> ./archive there is another file of the same name.   .table works on that
> file.  Curiously, however..
>
> [root@weather weewx]# pwd && grep sdb weewx.conf
> /home/weewx
> database_name = weewx.sdb
>
> Can't figure out how, if the weewx.conf file is pointing to what is
> essentially an empty file, how I'm getting data on the GUI.
>
>
>
> On Mon, 21 Jan 2019 at 13:09, Thomas Keffer  wrote:
>
>> The thing is that I work in IT but I hate it.  I have a set of skills
>>> (RHEL, Citrix, MySQL, OpenVMS..), but have little desire to increase that.
>>> I do what I do because it pays the bills, and lets me buy nice toys like
>>> the weather station, like my Nikon D850, and I get to go on nice holidays.
>>> But when I think of extracting data for the weather last year, I think "why
>>> bother to learn sqlite when I already know MySQL?".
>>>
>>
>> That's unfortunate. Life is way too short to work on something you don't
>> love.
>>
>> "Live as if you were to die tomorrow. Learn as if you were to live
>> forever." --- Gandhi
>>
>> -tk
>>
>> --
>> 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/nlfPiicnLsw/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.
>

-- 
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] Re: Reliable Switch to MySQL?

[Andrew Milner]

to answer that one it may help to know how you installed weewx in the first 
place!!  Different installation methods put things in different places.

what exactly do you mean by 'getting data on the GUI'??

the likely explanation is that the webpages are being generated from a 
version of weewx.sdb which is located in a different place - and weewx 
itself is possibly using a version of weewx.conf which is not the one you 
looked at!!



On Monday, 21 January 2019 15:16:01 UTC+2, Cycle London wrote:
>
> Oh, you are so right, man.  
>
> If I could, I'd be travelling the world as a landscape photographer.  Or 
> flying in the Royal Air Force.  But although I'm 'not bad' with a camera, 
> the world is full of people who are 'not bad'.  And my eyesight was too bad 
> for the RAF to accept me.  
>
> Anyway, I digress.  In response to your other post, I note that the 
> weewx.sdb file in /home/weewx is owned by root but is empty.   Inside 
> ./archive there is another file of the same name.   .table works on that 
> file.  Curiously, however.. 
>
> [root@weather weewx]# pwd && grep sdb weewx.conf
> /home/weewx
> database_name = weewx.sdb
>
> Can't figure out how, if the weewx.conf file is pointing to what is 
> essentially an empty file, how I'm getting data on the GUI.  
>
>
>
> On Mon, 21 Jan 2019 at 13:09, Thomas Keffer  > wrote:
>
>> The thing is that I work in IT but I hate it.  I have a set of skills 
>>> (RHEL, Citrix, MySQL, OpenVMS..), but have little desire to increase that.  
>>> I do what I do because it pays the bills, and lets me buy nice toys like 
>>> the weather station, like my Nikon D850, and I get to go on nice holidays.  
>>> But when I think of extracting data for the weather last year, I think "why 
>>> bother to learn sqlite when I already know MySQL?". 
>>>
>>
>> That's unfortunate. Life is way too short to work on something you don't 
>> love. 
>>
>> "Live as if you were to die tomorrow. Learn as if you were to live 
>> forever." --- Gandhi
>>
>> -tk
>>
>> -- 
>> 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/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Cycle London]

Oh, you are so right, man.

If I could, I'd be travelling the world as a landscape photographer.  Or
flying in the Royal Air Force.  But although I'm 'not bad' with a camera,
the world is full of people who are 'not bad'.  And my eyesight was too bad
for the RAF to accept me.

Anyway, I digress.  In response to your other post, I note that the
weewx.sdb file in /home/weewx is owned by root but is empty.   Inside
./archive there is another file of the same name.   .table works on that
file.  Curiously, however..

[root@weather weewx]# pwd && grep sdb weewx.conf
/home/weewx
database_name = weewx.sdb

Can't figure out how, if the weewx.conf file is pointing to what is
essentially an empty file, how I'm getting data on the GUI.



On Mon, 21 Jan 2019 at 13:09, Thomas Keffer  wrote:

> The thing is that I work in IT but I hate it.  I have a set of skills
>> (RHEL, Citrix, MySQL, OpenVMS..), but have little desire to increase that.
>> I do what I do because it pays the bills, and lets me buy nice toys like
>> the weather station, like my Nikon D850, and I get to go on nice holidays.
>> But when I think of extracting data for the weather last year, I think "why
>> bother to learn sqlite when I already know MySQL?".
>>
>
> That's unfortunate. Life is way too short to work on something you don't
> love.
>
> "Live as if you were to die tomorrow. Learn as if you were to live
> forever." --- Gandhi
>
> -tk
>
> --
> 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/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Thomas Keffer]

>
> The thing is that I work in IT but I hate it.  I have a set of skills
> (RHEL, Citrix, MySQL, OpenVMS..), but have little desire to increase that.
> I do what I do because it pays the bills, and lets me buy nice toys like
> the weather station, like my Nikon D850, and I get to go on nice holidays.
> But when I think of extracting data for the weather last year, I think "why
> bother to learn sqlite when I already know MySQL?".
>

That's unfortunate. Life is way too short to work on something you don't
love.

"Live as if you were to die tomorrow. Learn as if you were to live
forever." --- Gandhi

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

Re: [weewx-user] Re: Reliable Switch to MySQL?

[Thomas Keffer]

That's what you get if you try it on an empty file. Try it on weewx.sdb,
the file that WeeWX uses.

-tk

On Mon, Jan 21, 2019 at 5:02 AM Cycle London 
wrote:

> Hi Thomas,
> I'll give you a screenshot this time, so you know I'm not actually lying
> about what I'm typing and what result I'm getting
>
> On Mon, 21 Jan 2019 at 12:58, Thomas Keffer  wrote:
>
>> Try either
>>
>> .table
>>
>> or
>>
>> SELECT tbl_name FROM sqlite_master WHERE type='table';
>>
>> -tk
>>
>>
>> On Mon, Jan 21, 2019 at 4:54 AM Cycle London 
>> wrote:
>>
>>> Hi Andrew,
>>>
>>> Please forgive me, I'm not being deliberately thick, and I'm not trying
>>> to annoy anyone.   Tried the above - even tried to remove the space between
>>> the command the semicolon, just in case sqllite handled white space
>>> differently than MySQL ...
>>>
>>> [cyclellondon@weather ~]$ sqlite3 archive.sdb
>>> SQLite version 3.7.17 2013-05-20 00:56:22
>>> Enter ".help" for instructions
>>> Enter SQL statements terminated with a ";"
>>> sqlite> show tables ;
>>> Error: near "show": syntax error
>>> sqlite> show tables;
>>> Error: near "show": syntax error
>>>
>>> On Mon, 21 Jan 2019 at 12:50, Andrew Milner 
>>> wrote:
>>>
 you are being very obscure

 SQLite only has one database in use at one time - the one you open

 usage - eg - sqlite3 archive.sdb

 then you can
 show tables;



 On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote:
>
> CHeers.  Those links aren't really clear.  Maybe i'm too old.  Or too
> dim.
>
> Anyway, time to gird my loins, snapshot the VM .. and just do it.
>
> On Mon, 21 Jan 2019 at 10:42, gjr80  wrote:
>
>> Regards transferring from SQLite to MySQL have you ready through the
>> Transfer from SQLite to MySQL page of the wiki (
>> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL)
>> and the Configuring MySQL section of the User's Guide (
>> http://weewx.com/docs/usersguide.htm#configuring_mysql) ?
>>
>> Those two areas have about everything you need for the transfer.
>>
>> 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/nlfPiicnLsw/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 a topic in the
 Google Groups "weewx-user" group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/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.
>>>
>> --
>> 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/nlfPiicnLsw/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.
>

-- 
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] Re: Reliable Switch to MySQL?

[Cycle London]

Hi Thomas,
I'll give you a screenshot this time, so you know I'm not actually lying
about what I'm typing and what result I'm getting

On Mon, 21 Jan 2019 at 12:58, Thomas Keffer  wrote:

> Try either
>
> .table
>
> or
>
> SELECT tbl_name FROM sqlite_master WHERE type='table';
>
> -tk
>
>
> On Mon, Jan 21, 2019 at 4:54 AM Cycle London 
> wrote:
>
>> Hi Andrew,
>>
>> Please forgive me, I'm not being deliberately thick, and I'm not trying
>> to annoy anyone.   Tried the above - even tried to remove the space between
>> the command the semicolon, just in case sqllite handled white space
>> differently than MySQL ...
>>
>> [cyclellondon@weather ~]$ sqlite3 archive.sdb
>> SQLite version 3.7.17 2013-05-20 00:56:22
>> Enter ".help" for instructions
>> Enter SQL statements terminated with a ";"
>> sqlite> show tables ;
>> Error: near "show": syntax error
>> sqlite> show tables;
>> Error: near "show": syntax error
>>
>> On Mon, 21 Jan 2019 at 12:50, Andrew Milner 
>> wrote:
>>
>>> you are being very obscure
>>>
>>> SQLite only has one database in use at one time - the one you open
>>>
>>> usage - eg - sqlite3 archive.sdb
>>>
>>> then you can
>>> show tables;
>>>
>>>
>>>
>>> On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote:

 CHeers.  Those links aren't really clear.  Maybe i'm too old.  Or too
 dim.

 Anyway, time to gird my loins, snapshot the VM .. and just do it.

 On Mon, 21 Jan 2019 at 10:42, gjr80  wrote:

> Regards transferring from SQLite to MySQL have you ready through the
> Transfer from SQLite to MySQL page of the wiki (
> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL)
> and the Configuring MySQL section of the User's Guide (
> http://weewx.com/docs/usersguide.htm#configuring_mysql) ?
>
> Those two areas have about everything you need for the transfer.
>
> 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/nlfPiicnLsw/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 a topic in the
>>> Google Groups "weewx-user" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/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.
>>
> --
> 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/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Cycle London]

The thing is that I work in IT but I hate it.  I have a set of skills
(RHEL, Citrix, MySQL, OpenVMS..), but have little desire to increase that.
I do what I do because it pays the bills, and lets me buy nice toys like
the weather station, like my Nikon D850, and I get to go on nice holidays.
But when I think of extracting data for the weather last year, I think "why
bother to learn sqlite when I already know MySQL?".

If that makes me sound ungrateful for the effort Thomas has put in, I'm
really not.


On Mon, 21 Jan 2019 at 12:53, Cycle London 
wrote:

> Hi Andrew,
>
> Please forgive me, I'm not being deliberately thick, and I'm not trying to
> annoy anyone.   Tried the above - even tried to remove the space between
> the command the semicolon, just in case sqllite handled white space
> differently than MySQL ...
>
> [cyclellondon@weather ~]$ sqlite3 archive.sdb
> SQLite version 3.7.17 2013-05-20 00:56:22
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> show tables ;
> Error: near "show": syntax error
> sqlite> show tables;
> Error: near "show": syntax error
>
> On Mon, 21 Jan 2019 at 12:50, Andrew Milner 
> wrote:
>
>> you are being very obscure
>>
>> SQLite only has one database in use at one time - the one you open
>>
>> usage - eg - sqlite3 archive.sdb
>>
>> then you can
>> show tables;
>>
>>
>>
>> On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote:
>>>
>>> CHeers.  Those links aren't really clear.  Maybe i'm too old.  Or too
>>> dim.
>>>
>>> Anyway, time to gird my loins, snapshot the VM .. and just do it.
>>>
>>> On Mon, 21 Jan 2019 at 10:42, gjr80  wrote:
>>>
 Regards transferring from SQLite to MySQL have you ready through the
 Transfer from SQLite to MySQL page of the wiki (
 https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL)
 and the Configuring MySQL section of the User's Guide (
 http://weewx.com/docs/usersguide.htm#configuring_mysql) ?

 Those two areas have about everything you need for the transfer.

 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/nlfPiicnLsw/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 a topic in the
>> Google Groups "weewx-user" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Thomas Keffer]

Try either

.table

or

SELECT tbl_name FROM sqlite_master WHERE type='table';

-tk


On Mon, Jan 21, 2019 at 4:54 AM Cycle London 
wrote:

> Hi Andrew,
>
> Please forgive me, I'm not being deliberately thick, and I'm not trying to
> annoy anyone.   Tried the above - even tried to remove the space between
> the command the semicolon, just in case sqllite handled white space
> differently than MySQL ...
>
> [cyclellondon@weather ~]$ sqlite3 archive.sdb
> SQLite version 3.7.17 2013-05-20 00:56:22
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> show tables ;
> Error: near "show": syntax error
> sqlite> show tables;
> Error: near "show": syntax error
>
> On Mon, 21 Jan 2019 at 12:50, Andrew Milner 
> wrote:
>
>> you are being very obscure
>>
>> SQLite only has one database in use at one time - the one you open
>>
>> usage - eg - sqlite3 archive.sdb
>>
>> then you can
>> show tables;
>>
>>
>>
>> On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote:
>>>
>>> CHeers.  Those links aren't really clear.  Maybe i'm too old.  Or too
>>> dim.
>>>
>>> Anyway, time to gird my loins, snapshot the VM .. and just do it.
>>>
>>> On Mon, 21 Jan 2019 at 10:42, gjr80  wrote:
>>>
 Regards transferring from SQLite to MySQL have you ready through the
 Transfer from SQLite to MySQL page of the wiki (
 https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL)
 and the Configuring MySQL section of the User's Guide (
 http://weewx.com/docs/usersguide.htm#configuring_mysql) ?

 Those two areas have about everything you need for the transfer.

 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/nlfPiicnLsw/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 a topic in the
>> Google Groups "weewx-user" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/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.
>

-- 
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] Re: Reliable Switch to MySQL?

[Cycle London]

Hi Andrew,

Please forgive me, I'm not being deliberately thick, and I'm not trying to
annoy anyone.   Tried the above - even tried to remove the space between
the command the semicolon, just in case sqllite handled white space
differently than MySQL ...

[cyclellondon@weather ~]$ sqlite3 archive.sdb
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> show tables ;
Error: near "show": syntax error
sqlite> show tables;
Error: near "show": syntax error

On Mon, 21 Jan 2019 at 12:50, Andrew Milner 
wrote:

> you are being very obscure
>
> SQLite only has one database in use at one time - the one you open
>
> usage - eg - sqlite3 archive.sdb
>
> then you can
> show tables;
>
>
>
> On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote:
>>
>> CHeers.  Those links aren't really clear.  Maybe i'm too old.  Or too
>> dim.
>>
>> Anyway, time to gird my loins, snapshot the VM .. and just do it.
>>
>> On Mon, 21 Jan 2019 at 10:42, gjr80  wrote:
>>
>>> Regards transferring from SQLite to MySQL have you ready through the
>>> Transfer from SQLite to MySQL page of the wiki (
>>> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL)
>>> and the Configuring MySQL section of the User's Guide (
>>> http://weewx.com/docs/usersguide.htm#configuring_mysql) ?
>>>
>>> Those two areas have about everything you need for the transfer.
>>>
>>> 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/nlfPiicnLsw/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 a topic in the
> Google Groups "weewx-user" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/weewx-user/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Andrew Milner]

you are being very obscure

SQLite only has one database in use at one time - the one you open

usage - eg - sqlite3 archive.sdb

then you can 
show tables;



On Monday, 21 January 2019 14:41:10 UTC+2, Cycle London wrote:
>
> CHeers.  Those links aren't really clear.  Maybe i'm too old.  Or too dim. 
>   
>
> Anyway, time to gird my loins, snapshot the VM .. and just do it. 
>
> On Mon, 21 Jan 2019 at 10:42, gjr80 > 
> wrote:
>
>> Regards transferring from SQLite to MySQL have you ready through the 
>> Transfer from SQLite to MySQL page of the wiki (
>> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL) 
>> and the Configuring MySQL section of the User's Guide (
>> http://weewx.com/docs/usersguide.htm#configuring_mysql) ?
>>
>> Those two areas have about everything you need for the transfer.
>>
>> 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/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Cycle London]

CHeers.  Those links aren't really clear.  Maybe i'm too old.  Or too dim.


Anyway, time to gird my loins, snapshot the VM .. and just do it.

On Mon, 21 Jan 2019 at 10:42, gjr80  wrote:

> Regards transferring from SQLite to MySQL have you ready through the
> Transfer from SQLite to MySQL page of the wiki (
> https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL)
> and the Configuring MySQL section of the User's Guide (
> http://weewx.com/docs/usersguide.htm#configuring_mysql) ?
>
> Those two areas have about everything you need for the transfer.
>
> 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/nlfPiicnLsw/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] Re: Reliable Switch to MySQL?

[Cycle London]

Hi Andrew,

Doesn't look similar to me...

[cyclelondon@weather ~]$ sqlite3
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> show databases ;
Error: near "show": syntax error
sqlite> show tables ;
Error: near "show": syntax error

On Mon, 21 Jan 2019 at 12:31, Andrew Milner 
wrote:

> well as I keep on saying, as far as I know you can do exactly the same
> with sqlite3
>
>
>
> On Monday, 21 January 2019 13:11:32 UTC+2, Cycle London wrote:
>>
>> On Monday, 21 January 2019 10:54:24 UTC, Andrew Milner wrote:
>>
>> LOL - I'm 68 and still learning.  As I said though MySQL and SQLite are
>>> close enough to being the same for data retrieval select statements - if
>>> you were going to retrieve using sql select statements - and it is never
>>> too late to learn python.  Still not sure what/where/how you were planning
>>> on retrieving and displaying/outputting the data once retrieved.
>>>
>>>
>>> IF you were going to use MySQL interactively then you cn do the same
>>> with sqlite3
>>>
>>>
>>
>> Fair point.  :-)
>>
>> I planned to use mysql to get the data I need from the db.   It's really
>> just for my own interest.  Maybe I'll get around to doing a simple PhP
>> interface to it at some point.
>>
> --
> 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/nlfPiicnLsw/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.

[weewx-user] Re: Reliable Switch to MySQL?

[Andrew Milner]

well as I keep on saying, as far as I know you can do exactly the same with 
sqlite3



On Monday, 21 January 2019 13:11:32 UTC+2, Cycle London wrote:
>
> On Monday, 21 January 2019 10:54:24 UTC, Andrew Milner wrote:
>
> LOL - I'm 68 and still learning.  As I said though MySQL and SQLite are 
>> close enough to being the same for data retrieval select statements - if 
>> you were going to retrieve using sql select statements - and it is never 
>> too late to learn python.  Still not sure what/where/how you were planning 
>> on retrieving and displaying/outputting the data once retrieved.
>>
>>
>> IF you were going to use MySQL interactively then you cn do the same with 
>> sqlite3
>>
>>
>
> Fair point.  :-)   
>
> I planned to use mysql to get the data I need from the db.   It's really 
> just for my own interest.  Maybe I'll get around to doing a simple PhP 
> interface to it at some point.  
>

-- 
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: Ambient Weather WS-2902A

[Adnan Mumtaz]

Thanks for sharing your link Scott, looks so good. I have received the 
station today and will mount it today too, I have configured the RPi as per 
your guidelines, edited the dhcpcd.conf file too, do i have to assign a 
manual IP to the eth0 interface? as I see it is still DHCP enabled.

On Monday, 21 January 2019 01:11:26 UTC+3, Scott Grayban wrote:
>
> This is my site http://www.nettletondistrict.com/Nettleton/
>
> On Sunday, January 20, 2019 at 2:01:00 PM UTC-8, Adnan Mumtaz wrote:
>>
>> Sorry , I was a bit confused,  I forgot with this I will make the RPi an 
>> AP where the station will connect to, so in that case I will install plain 
>> weewx and then follow your instructions and once I can see data being 
>> received I will work on different skins, more interested in Belchertown and 
>> also weather34 
>>
>> On Monday, 21 January 2019 00:05:18 UTC+3, Adnan Mumtaz wrote:
>>>
>>> Hi Scott,
>>>
>>> Received the RPi , installed the OS and installed WeeWX to test, 
>>> everything went smooth, then started reading the links you shared, tomorrow 
>>> I should be receiving my WS too hopefully it was held by customs  :) 
>>>
>>> Question, the link you shared with me has prerequisites , which are 
>>> straight but there is a link which takes to 
>>> https://github.com/matthewwall/weewx-interceptor , so the first step of 
>>> prerequisites should be to install weewx interceptor and then follow the 
>>> rest in the link, I understand the RPi will sniff data via WiFi and it will 
>>> have access to WAN using Ethernet connection, can you also share your 
>>> website.
>>>
>>> Thanks a lot,
>>> Adnan
>>>
>>> On Wednesday, 16 January 2019 01:48:06 UTC+3, Scott Grayban wrote:

 I use this one https://smile.amazon.com/gp/product/B06XWMQ81P/

 SanDisk Extreme 32GB microSDHC UHS-3 Card - SDSQXAF-032G-GN6MA

 On Tuesday, January 15, 2019 at 2:23:52 PM UTC-8, Adnan Mumtaz wrote:
>
> I am a Debian user , not a very advanced one but i have concepts, I am 
> dowloading the RPi Debian Lite version as I wouldnt need a desktop, what 
> size and brand SD would you recommend
>
> On Tuesday, 15 January 2019 22:38:12 UTC+3, Scott Grayban wrote:
>>
>> Sure but you shouldn't have any problems unless you don't know 
>> anything about linux.
>>
>> On Tuesday, January 15, 2019 at 11:35:11 AM UTC-8, Adnan Mumtaz wrote:
>>>
>>> Thanks a lot, ordered it. Will need your help again if i get stuck 
>>> in something. So kind of you.
>>>
>>> Regards,
>>> Adnan
>>>
>>> On Tuesday, 15 January 2019 22:27:19 UTC+3, Scott Grayban wrote:

 This one 
 https://saudi.souq.com/sa-en/raspberry-pi-3-model-b+-plus-32895409/i/

 On Tuesday, January 15, 2019 at 11:09:11 AM UTC-8, Adnan Mumtaz 
 wrote:
>
> Hi Scott,
>
> Bundle of thanks for sharing your hardwork, will you suggest which 
> RPi should I buy, I can find few available in a local e-store 
> https://saudi.souq.com/sa-en/raspberry-pi/s/?as=1
>
> Regards,
> Adnan
>
> On Tuesday, 15 January 2019 21:37:41 UTC+3, Scott Grayban wrote:
>>
>> You also need to buy a Rpi from amazon or the UK Rpi store for 
>> this to work. https://www.raspberrypi.org/
>>
>>
>> On Tuesday, January 15, 2019 at 10:14:38 AM UTC-8, Adnan Mumtaz 
>> wrote:
>>>
>>> Greetings from Saudi Arabia,
>>>
>>> I am an expat living and working in Riyadh, Saudi Arabia. I have 
>>> recently purchased Ambient Weather WS-2902A which I will be 
>>> receiving next 
>>> week, I have a domain and web hosting where I want to publish my 
>>> weather 
>>> using WeeWX (belchertown template). I am a systems engineer but far 
>>> from 
>>> programming since a very long time, I will appreciate if someone 
>>> can guide 
>>> me, I did search the forum and found few had issues and those who 
>>> had 
>>> success are not publishing details.
>>>
>>> Awaiting positive response .
>>>
>>> Thank you,
>>> Adnan
>>>
>>

-- 
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: IWDL - Vorhersage

[gjr80]

Hallo Kalli,

Wenn Sie WeeWX-WD als Quelle für die WDL verwenden, wird die Vorhersage von 
WeatherUnderground (WU) mithilfe der WU-API abgerufen. Die API sollte am 
31. Dezember 2018 eingestellt werden, aber ich habe gehört, dass sich dies 
verzögert hat. Als ich das letzte Mal überprüft habe, funktionierte es 
noch. Ich benutze die API nicht mehr, aber ich habe gerade in meinem 
Browser nachgesehen und konnte eine Vorhersage aus der API für meine 
Station anzeigen.

Die WU ist bekannt für Dinge, die einfach kaputt gehen oder nicht wie 
erwartet funktionieren oder andere zufällige Dinge tun. Vielleicht haben 
sie Probleme in Europa / Deutschland.

Hast du im Protokoll nachgesehen? Die WeeWX-WD-Prognose wird (glaube ich) 
etwa alle drei Stunden aktualisiert, so dass Sie möglicherweise einen Teil 
des Protokolls durchsehen müssen. Wenn WeeWX-WD einen Fehler in der WU-API 
festgestellt hat, sollte der Fehler protokolliert werden.

grüß

Gary

If you are using WeeWX-WD as the source for the WDL the forecast is 
obtained from WeatherUnderground (WU) using the WU API. The API was to be 
retired at 31 December 2018 but I heard this was delayed and when I last 
checked it was still working. I no longer use the API but I just checked 
now in my browser and I was able to display a forecast from the API for my 
station.

WU is known for things just breaking or not working as expected or doing 
other random things so perhaps they are having forecast issues in 
Europe/Germany.

Have you looked in the log? The WeeWX-WD forecast is updated every three or 
so hours (I think) so you might need to look back through quite a bit of 
the log. If WeeWX-WD encountered an error with the WU API it should log the 
error. 


On Sunday, 20 January 2019 22:25:30 UTC+10, Kalli wrote:
>
> Hallo
> seit einiger zeit geht die Wettervorhersage bei IWDL nicht mehr.
> hat sich was geändert.
>
> mfg. Kalli
>

-- 
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: Reliable Switch to MySQL?

[Cycle London]

On Monday, 21 January 2019 10:54:24 UTC, Andrew Milner wrote:

LOL - I'm 68 and still learning.  As I said though MySQL and SQLite are 
> close enough to being the same for data retrieval select statements - if 
> you were going to retrieve using sql select statements - and it is never 
> too late to learn python.  Still not sure what/where/how you were planning 
> on retrieving and displaying/outputting the data once retrieved.
>
>
> IF you were going to use MySQL interactively then you cn do the same with 
> sqlite3
>
>

Fair point.  :-)   

I planned to use mysql to get the data I need from the db.   It's really 
just for my own interest.  Maybe I'll get around to doing a simple PhP 
interface to it at some point.  

-- 
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: Reliable Switch to MySQL?

[gjr80]

Regards transferring from SQLite to MySQL have you ready through the Transfer 
from SQLite to MySQL page of the wiki 
(https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL) and 
the Configuring MySQL section of the User's Guide 
(http://weewx.com/docs/usersguide.htm#configuring_mysql) ?

Those two areas have about everything you need for the transfer.

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.

[weewx-user] Re: Reliable Switch to MySQL?

[Cycle London]

Hi.  Sorry, I wasn't clear.  

I want to use MySQL as I'm MySQL DBA trained.  OK, so I was, about 5 years 
ago.   And I'm a little too long in the tooth to learn new stuff.  

On Monday, 21 January 2019 10:23:16 UTC, Andrew Milner wrote:
>
> The database granularity, contents and structure is identical for sqlite3 
> and MySQL.
>
> The archive records are stored at 'archive interval' granularity.
>
> There are also 'daily' tables for each of the reading type which give max 
> and min for each calendar day.
>
> If you can use MySQL then you should also be capable of using sqlite3.
>
> How would you plan to retrieve the data from MySQL?
>
> Use the same method/approach to retrieve it from sqlite3
>
> (Granted, you may need to install sqlite3 on your weewx computer first)
>
> I guess I did not fully understand how/why going to MySQL would enable you 
> to get information from the database easier than from sqlite3.  The select 
> statements are nearly identical - albeit a little different for date\time 
> fields.
>
>
>
>
>
> On Monday, 21 January 2019 12:03:18 UTC+2, Cycle London wrote:
>>
>> Hi,
>> I've been running my station for just over a year, and would like to 
>> switch from sqilite to MySQL on a different server.   To be clear, what I 
>> mean by that is: I want to use a 'production' MySQL instance that is on a 
>> 'live' server.  
>>
>> A couple of questions, if I may. 
>>
>> 1.  What 'granularity' of data is available inside the database?  I ask 
>> because today for example, 21 January, I'd like to know what the 
>> temperature was like last year on the same date.  In the weewx GUI, I can 
>> see that the coldest day of the month of January 2018 was the 30th, but I 
>> can't see what the temperature was on the 21st.   Is this inside the DB?   
>> I know nothing of sqlite, so even if it's in there, I can't get it out.   
>>
>> 2.  Is there an easy, foolproof way of switching to MySQL?   I can do 
>> Linux, I can do MySQL but I don't know python or sqlite.  A quick method of 
>> switching would be great.  
>>
>> Many 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.

[weewx-user] Re: Reliable Switch to MySQL?

[Andrew Milner]

The database granularity, contents and structure is identical for sqlite3 
and MySQL.

The archive records are stored at 'archive interval' granularity.

There are also 'daily' tables for each of the reading type which give max 
and min for each calendar day.

If you can use MySQL then you should also be capable of using sqlite3.

How would you plan to retrieve the data from MySQL?

Use the same method/approach to retrieve it from sqlite3

(Granted, you may need to install sqlite3 on your weewx computer first)

I guess I did not fully understand how/why going to MySQL would enable you 
to get information from the database easier than from sqlite3.  The select 
statements are nearly identical - albeit a little different for date\time 
fields.





On Monday, 21 January 2019 12:03:18 UTC+2, Cycle London wrote:
>
> Hi,
> I've been running my station for just over a year, and would like to 
> switch from sqilite to MySQL on a different server.   To be clear, what I 
> mean by that is: I want to use a 'production' MySQL instance that is on a 
> 'live' server.  
>
> A couple of questions, if I may. 
>
> 1.  What 'granularity' of data is available inside the database?  I ask 
> because today for example, 21 January, I'd like to know what the 
> temperature was like last year on the same date.  In the weewx GUI, I can 
> see that the coldest day of the month of January 2018 was the 30th, but I 
> can't see what the temperature was on the 21st.   Is this inside the DB?   
> I know nothing of sqlite, so even if it's in there, I can't get it out.   
>
> 2.  Is there an easy, foolproof way of switching to MySQL?   I can do 
> Linux, I can do MySQL but I don't know python or sqlite.  A quick method of 
> switching would be great.  
>
> Many 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.

[weewx-user] Reliable Switch to MySQL?

[Cycle London]

Hi,
I've been running my station for just over a year, and would like to switch 
from sqilite to MySQL on a different server.   To be clear, what I mean by 
that is: I want to use a 'production' MySQL instance that is on a 'live' 
server.  

A couple of questions, if I may. 

1.  What 'granularity' of data is available inside the database?  I ask 
because today for example, 21 January, I'd like to know what the 
temperature was like last year on the same date.  In the weewx GUI, I can 
see that the coldest day of the month of January 2018 was the 30th, but I 
can't see what the temperature was on the 21st.   Is this inside the DB?   
I know nothing of sqlite, so even if it's in there, I can't get it out.   

2.  Is there an easy, foolproof way of switching to MySQL?   I can do 
Linux, I can do MySQL but I don't know python or sqlite.  A quick method of 
switching would be great.  

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