date:20170902

[weewx-user] database error

2017-09-02 Thread 'Ralf Buck' via weewx-user

hello

it seems that my database had a error

Sep 02 12:11:56 raspberrypi weewx[1385]: File 
"/usr/share/weewx/weewx/manager.py", line 214, in firstGoodStamp
Sep 02 12:11:56 raspberrypi weewx[1385]:   _row = 
self.getSql("SELECT MIN(dateTime) FROM %s" % self.table_name)
Sep 02 12:11:56 raspberrypi weewx[1385]: File 
"/usr/share/weewx/weewx/manager.py", line 394, in getSql
Sep 02 12:11:56 raspberrypi weewx[1385]:   _cursor.execute(sql, 
sqlargs)
Sep 02 12:11:56 raspberrypi weewx[1385]: File 
"/usr/share/weewx/weedb/sqlite.py", line 29, in guarded_fn
Sep 02 12:11:56 raspberrypi weewx[1385]:   return fn(*args, 
**kwargs)
Sep 02 12:11:56 raspberrypi weewx[1385]: File 
"/usr/share/weewx/weedb/sqlite.py", line 211, in execute
Sep 02 12:11:56 raspberrypi weewx[1385]:   return 
sqlite3.Cursor.execute(self, *args, **kwargs)
Sep 02 12:11:56 raspberrypi weewx[1385]:   DatabaseError: database disk 
image is malformed
Sep 02 12:11:56 raspberrypi weewx[1385]:   Exiting.


how can i fix this?

regard

-- 
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] Data from Blitzortung Lightning detector?

2017-09-02 Thread Steve2Q

Hello: I recently built a lightning detector and joined the Blitzortung.org 
network. I was wondering if anyone knows of a way to integrate data from 
the detector into Weewx so the lightning data can be processed and 
displayed graphically? Right now I have a link on my Weewx page ( 
photokinetics.org/Weather ) to the Blitzortung map of Florida which shows 
the strikes in real time, but no data such as strikes/hour or distance.

Thanks, Steve

-- 
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] database error

2017-09-02 Thread Thomas Keffer

Are you using an SD card? If so, see this thread
.

-tk

On Sat, Sep 2, 2017 at 3:12 AM, 'Ralf Buck' via weewx-user <
weewx-user@googlegroups.com> wrote:

> hello
>
> it seems that my database had a error
>
> Sep 02 12:11:56 raspberrypi weewx[1385]: File
> "/usr/share/weewx/weewx/manager.py", line 214, in firstGoodStamp
> Sep 02 12:11:56 raspberrypi weewx[1385]:   _row =
> self.getSql("SELECT MIN(dateTime) FROM %s" % self.table_name)
> Sep 02 12:11:56 raspberrypi weewx[1385]: File
> "/usr/share/weewx/weewx/manager.py", line 394, in getSql
> Sep 02 12:11:56 raspberrypi weewx[1385]:   _cursor.execute(sql,
> sqlargs)
> Sep 02 12:11:56 raspberrypi weewx[1385]: File
> "/usr/share/weewx/weedb/sqlite.py", line 29, in guarded_fn
> Sep 02 12:11:56 raspberrypi weewx[1385]:   return fn(*args,
> **kwargs)
> Sep 02 12:11:56 raspberrypi weewx[1385]: File
> "/usr/share/weewx/weedb/sqlite.py", line 211, in execute
> Sep 02 12:11:56 raspberrypi weewx[1385]:   return
> sqlite3.Cursor.execute(self, *args, **kwargs)
> Sep 02 12:11:56 raspberrypi weewx[1385]:   DatabaseError: database
> disk image is malformed
> Sep 02 12:11:56 raspberrypi weewx[1385]:   Exiting.
>
>
> how can i fix this?
>
> regard
>
> --
> 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: database error

2017-09-02 Thread 'Ralf Buck' via weewx-user

i will read this.

my sdb file is on a usb stick


Am Samstag, 2. September 2017 12:12:56 UTC+2 schrieb Ralf Buck:
>
> hello
>
> it seems that my database had a error
>
> Sep 02 12:11:56 raspberrypi weewx[1385]: File 
> "/usr/share/weewx/weewx/manager.py", line 214, in firstGoodStamp
> Sep 02 12:11:56 raspberrypi weewx[1385]:   _row = 
> self.getSql("SELECT MIN(dateTime) FROM %s" % self.table_name)
> Sep 02 12:11:56 raspberrypi weewx[1385]: File 
> "/usr/share/weewx/weewx/manager.py", line 394, in getSql
> Sep 02 12:11:56 raspberrypi weewx[1385]:   _cursor.execute(sql, 
> sqlargs)
> Sep 02 12:11:56 raspberrypi weewx[1385]: File 
> "/usr/share/weewx/weedb/sqlite.py", line 29, in guarded_fn
> Sep 02 12:11:56 raspberrypi weewx[1385]:   return fn(*args, 
> **kwargs)
> Sep 02 12:11:56 raspberrypi weewx[1385]: File 
> "/usr/share/weewx/weedb/sqlite.py", line 211, in execute
> Sep 02 12:11:56 raspberrypi weewx[1385]:   return 
> sqlite3.Cursor.execute(self, *args, **kwargs)
> Sep 02 12:11:56 raspberrypi weewx[1385]:   DatabaseError: database 
> disk image is malformed
> Sep 02 12:11:56 raspberrypi weewx[1385]:   Exiting.
>
>
> how can i fix this?
>
> regard
>

-- 
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: database error

2017-09-02 Thread 'Ralf Buck' via weewx-user

echo '.dump' | sqlite3 ./weewx.sdb


INSERT INTO "archive_day_wind" 
VALUES(1494972000,0.0,1494973048,13.7,1495019248,3.62385185185185498824e+02,288,3.62385185185185498824e+02,288,NULL,2.34090915588452297413e+02,-8.79672687838567135543e+01,259,9.18866833690265671918e+02,9.18866833690265671918e+02);
/ ERROR: (11) database disk image is malformed */
COMMIT;

-- 
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: database error

2017-09-02 Thread Thomas Keffer

Most likely the USB stick is corrupted. They are not designed to be primary
storage, so it has probably worn out and failed.

One thing to try. The error occurred while dumping the daily summaries,
which need not be saved --- they can recreated from the archive. So, you
can try just dumping the archive:

echo '.dump archive' | sqlite 3 ./weewx.sdb

If that does not work, you will have to restore from a backup.

Then use a top-quality SD card or, better yet, a SSD or hard drive.

-tk

On Sat, Sep 2, 2017 at 6:17 AM, 'Ralf Buck' via weewx-user <
weewx-user@googlegroups.com> wrote:

> echo '.dump' | sqlite3 ./weewx.sdb
>
> 
> INSERT INTO "archive_day_wind" VALUES(1494972000,0.0,
> 1494973048,13.7,1495019248,3.62385185185185498824e+02,288,
> 3.62385185185185498824e+02,288,NULL,2.34090915588452297413e+02,-8.
> 79672687838567135543e+01,259,9.18866833690265671918e+02,9.
> 18866833690265671918e+02);
> / ERROR: (11) database disk image is malformed */
> COMMIT;
>
> --
> 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] Vantage Pro2 Data Logger: SECURED-LOGGER FAILED

2017-09-02 Thread Larry Walker

I'm trying to help someone set up their Vantage Pro2 with WeeWx.  When I 
try to TEST the communications with:
minicom -b 19200 -D /dev/ttyUSB0

It connects, but when I type TEST, it says:
SECURED-LOGGER FAILED

In fact, no matter what I type, it says: SECURED-LOGGER FAILED

(This is a new 6510USB logger bought directly from Davis. )

*Any Ideas?*



This is my startup log (with debug turned on): 
Sep  2 15:35:58 raspberrypi weewx[1038]: engine: Initializing engine
Sep  2 15:35:58 raspberrypi weewx[1038]: engine: Loading station type 
Vantage (weewx.drivers.vantage)
Sep  2 15:35:58 raspberrypi weewx[1038]: vantage: driver version is 3.0.9
Sep  2 15:35:58 raspberrypi weewx[1038]: vantage: Opened up serial port 
/dev/ttyUSB0; baud 19200; timeout 5.00
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: gentle wake up of console 
successful
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
console
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; retry 
#0
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
console
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; retry 
#1
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
console
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; retry 
#2
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
console
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; retry 
#3
Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: _setup; unable to read 
hardware type; raise WeeWxIOError
Sep  2 15:35:59 raspberrypi weewx[1038]: import of driver failed: Unable to 
read hardware type ()
Sep  2 15:35:59 raspberrypi weewx[1038]: engine: Unable to load driver: 
Unable to read hardware type
Sep  2 15:35:59 raspberrypi weewx[1038]:   Exiting...

-- 
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] Vantage Pro2 Data Logger: SECURED-LOGGER FAILED

2017-09-02 Thread Thomas Keffer

Are you trying to use a new logger with an old console? If so, you may have
to upgrade the firmware.

I would give Davis a call. Their tech support can be very helpful.

-tk

On Sat, Sep 2, 2017 at 12:39 PM, Larry Walker  wrote:

> I'm trying to help someone set up their Vantage Pro2 with WeeWx.  When I
> try to TEST the communications with:
> minicom -b 19200 -D /dev/ttyUSB0
>
> It connects, but when I type TEST, it says:
> SECURED-LOGGER FAILED
>
> In fact, no matter what I type, it says: SECURED-LOGGER FAILED
>
> (This is a new 6510USB logger bought directly from Davis. )
>
> *Any Ideas?*
>
> 
>
> This is my startup log (with debug turned on):
> Sep  2 15:35:58 raspberrypi weewx[1038]: engine: Initializing engine
> Sep  2 15:35:58 raspberrypi weewx[1038]: engine: Loading station type
> Vantage (weewx.drivers.vantage)
> Sep  2 15:35:58 raspberrypi weewx[1038]: vantage: driver version is 3.0.9
> Sep  2 15:35:58 raspberrypi weewx[1038]: vantage: Opened up serial port
> /dev/ttyUSB0; baud 19200; timeout 5.00
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: gentle wake up of
> console successful
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from
> console
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware;
> retry #0
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from
> console
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware;
> retry #1
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from
> console
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware;
> retry #2
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from
> console
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware;
> retry #3
> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: _setup; unable to read
> hardware type; raise WeeWxIOError
> Sep  2 15:35:59 raspberrypi weewx[1038]: import of driver failed: Unable
> to read hardware type ()
> Sep  2 15:35:59 raspberrypi weewx[1038]: engine: Unable to load driver:
> Unable to read hardware type
> Sep  2 15:35:59 raspberrypi weewx[1038]:   Exiting...
>
> --
> 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] Vantage Pro2 Data Logger: SECURED-LOGGER FAILED

2017-09-02 Thread Larry Walker

Thanks..

The station and the logger are both new.  The firmware is version: 3.63 
(US).  (Interestingly, the latest version on their website is 3.59 
) 

I don't think Davis support is open until Tuesday, and I'm only here until 
Monday.  I might try connecting it to a Windows PC and using WeatherLink 
and see what that says. 


On Saturday, September 2, 2017 at 3:48:58 PM UTC-4, Tom Keffer wrote:

> Are you trying to use a new logger with an old console? If so, you may 
> have to upgrade the firmware.
>
> I would give Davis a call. Their tech support can be very helpful.
>
> -tk
>
> On Sat, Sep 2, 2017 at 12:39 PM, Larry Walker  > wrote:
>
>> I'm trying to help someone set up their Vantage Pro2 with WeeWx.  When I 
>> try to TEST the communications with:
>> minicom -b 19200 -D /dev/ttyUSB0
>>
>> It connects, but when I type TEST, it says:
>> SECURED-LOGGER FAILED
>>
>> In fact, no matter what I type, it says: SECURED-LOGGER FAILED
>>
>> (This is a new 6510USB logger bought directly from Davis. )
>>
>> *Any Ideas?*
>>
>> 
>>
>> This is my startup log (with debug turned on): 
>> Sep  2 15:35:58 raspberrypi weewx[1038]: engine: Initializing engine
>> Sep  2 15:35:58 raspberrypi weewx[1038]: engine: Loading station type 
>> Vantage (weewx.drivers.vantage)
>> Sep  2 15:35:58 raspberrypi weewx[1038]: vantage: driver version is 3.0.9
>> Sep  2 15:35:58 raspberrypi weewx[1038]: vantage: Opened up serial port 
>> /dev/ttyUSB0; baud 19200; timeout 5.00
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: gentle wake up of 
>> console successful
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
>> console
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; 
>> retry #0
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
>> console
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; 
>> retry #1
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
>> console
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; 
>> retry #2
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: No  received from 
>> console
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: determine_hardware; 
>> retry #3
>> Sep  2 15:35:59 raspberrypi weewx[1038]: vantage: _setup; unable to read 
>> hardware type; raise WeeWxIOError
>> Sep  2 15:35:59 raspberrypi weewx[1038]: import of driver failed: Unable 
>> to read hardware type ()
>> Sep  2 15:35:59 raspberrypi weewx[1038]: engine: Unable to load driver: 
>> Unable to read hardware type
>> Sep  2 15:35:59 raspberrypi weewx[1038]:   Exiting...
>>
>> -- 
>> 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: weewx with SteelSeries

2017-09-02 Thread gjr80

On Friday, 1 September 2017 07:07:17 UTC+10, Robert Schneider wrote:
>
> thanks it is working great . 
>

That is good to hear.

> is thair a way to add radar and maybe a long-term forecast to that page
>

Forecast wise with the current SteelSeries Gauges page/skin you are limited 
to what you can put in the scrolling text display. Putting text is the 
scrolling text display is a simple change to the template but the trick is 
in having the text available to include in the first place. The forecast 
extension could provide the Zambretti forecast and that could be used, the 
forecast extension does not provide the Weather Underground textual 
forecast and I am not sure about NWS, I am not in USA. I put together a 
weeWX extension that produces a loop based gauge-data.txt (the SteelSeries 
skin provides an archive based gauge-data.txt) that can add the Zambretti 
forecast text to the scroller or it can optionally use the contents of a 
text file in the scroller. I have been meaning to add the WU textual 
forecast but need to find the time. You can find the extension here 
.

In terms of radar, there is nothing that I am aware of. I have seen some 
folks incorporate some or all of the gauges on a page that displays other 
(not necessarily radar) info. The actual inclusion of one or more gauges on 
a page is quite simple, but it is something you would need to create 
yourself.

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] DroidWX Android app

2017-09-02 Thread Gone Bush

I have developed an Android app - DroidWX - that displays data sourced from my 
weeWX database. (Please keep the cheering to a dull roar.)

The reason for this post is to gauge the interest in this app. If there is 
sufficient demand, I'll publish it on the Play Store - free, sans ads and with 
copious bugs for your delectation.

I am running a Davis Vantage Pro 2 located in outback Australia so the DroidWX 
functionality reflects the locate climate - there is very little call for snow 
skis around here. (Anybody know a good rain dance?)

1) Firstly, you'll need to have a PHP enabled web server running on the same 
machine as your weeWX database (I use Apache).

I'll publish the PHP script but will not provide support for PHP or web servers 
- there are plenty of places where you can get that support.

2) The app runs a process in the background that contacts your server (URL is 
configurable, obviously) every (configurable) "n" minutes.

It requests all data in the weeWX database that is newer than the latest 
date/time in the DroidWX database. (This is also how the DroidWX database is 
initialised.)

My weeWX system has been running for about 10 months with an update interval of 
5 minutes (because I can). This gives me a DroidWX database size of around 7MB.

If you want to calculate the (very rough) approximate size of your database (in 
MB):

90,000 * (no of days you've been running weeWX) / (weeWX update interval in 
minutes)
+
3,500 * (no of days you've been running weeWX)
+
a bit for luck.

3) The following graphs are available:
* Barometer & Pressure
* Dew point
* Heat index & Windchill
* Humidity - inside and out 
* Rain
* Rain (aggregate)
* Temperature - inside and out
* Wind speed
* Wind gust

4) The following tables are available:
* Daily statistics
* Day in detail
* Long Term Averages (these need to be entered manually and feed into other 
screens)
* Rain summary
* Summary
* Temperature summary

5) A menu bar at the top of the screen has the following options:
* Quick access (view) - configurable, any of the above
* Summary - a simple snapshot of the "current" (or selected date/time) weather
* Graphs - as above
* Tables - ditto
* An overflow menu containing items that are used less often

6) Documentation - Refer to Chapter MCDLXXVIII of that well-thumbed tome "The 
Mysterious and Enduring Art of Suck It and See".

7) As I alluded to above, there may be weeWX data that is not currently 
included in DroidWX. If you want some of that missing data included in DroidWX, 
all you have to do is to ask nicely (even better, meet me down the pub and 
shout me copious amounts of beer). Of course the database will increase in size.

8) There is not, nor will there ever be, an iCrap version of DroidWX

9) Other:
* The screen shown at start-up is configurable
* The database can be exported / imported
* Configure your own theme (may be unstable as I don't use it). There are two 
built-in themes - light and dark.
* Graphs can be displayed for various time frames - day, 2 day, 14 day, 
monthly...
* The start date/time for (most of) the above can be selected
* Some graphs can show weighted averages (number of weights and their values 
are configurable)
* Lots of other shit

I realise that this is pretty disjointed and light on detail, so feel free to 
complain loudly and passionately. I won't take any notice but you'll feel 
better. And other people will get a laugh.

Over to you.
Kevin

-- 
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] database error

[weewx-user] Data from Blitzortung Lightning detector?

Re: [weewx-user] database error

[weewx-user] Re: database error

[weewx-user] Re: database error

Re: [weewx-user] Re: database error

[weewx-user] Vantage Pro2 Data Logger: SECURED-LOGGER FAILED

Re: [weewx-user] Vantage Pro2 Data Logger: SECURED-LOGGER FAILED

Re: [weewx-user] Vantage Pro2 Data Logger: SECURED-LOGGER FAILED

Re: [weewx-user] Re: weewx with SteelSeries

[weewx-user] DroidWX Android app

11 matches

Site Navigation

Mail list logo

Footer information