wviewweather.com Forum Index wviewweather.com
wview and Weather Topics
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

no mysql activity nor cwop uploads

 
Post new topic   Reply to topic    wviewweather.com Forum Index -> wview Installation
View previous topic :: View next topic  
Author Message
newbush



Joined: 17 Apr 2006
Posts: 10

PostPosted: Tue Apr 18, 2006 10:59 pm    Post subject: no mysql activity nor cwop uploads Reply with quote

I'm using Ubuntu 5.10 (Breezy Badger) and I've compiled in mysql, cwop, and wunderground support with a vantage pro2. I managed to get the code to compile and everything to install fine, but different parts of the system just aren't working.

For instance wviewd fetches the live data off the station correctly, and htmlgend generates the respecitve pages, but wviewd never fetches to the historic data, so htmlgend thinks there's been no rain for the year, yet the station receiver says there's been 15.71 inches to date.

My /var/wview/archive contains only sensorstore.bin, and that was created on start. Shouldn't I have a bunch of .wik files or something?

Furthermore, wvsqld is running, and apparently logged in to mysql successfully (i.e. no "dbdatabaseOpen() failed" messages), but nothing is ever stored. (Because nothing is is in wview/archive?) and wvcwopd and wvunderd never upload anything to the servers. (I confirmed that nothing was uploaded via ethereal.)

It's been running for three hours. It seems like it should have done something by now. Normally, I'd think this was some sort of permissions problem or something, but there aren't any errors, so I have no idea what is wrong.

Thanks.

Here's my wview.conf

Quote:

ARCHIVE_PATH=/var/wview/archive
POLL_INTERVAL=15000
PUSH_INTERVAL=60000
VERBOSE_MSGS=11111111
DO_RXCHECK=1
SQLDB_ENABLE=1
SQLDB_EXTENDED_INFO=0
SQLDB_STORE_METRIC=0
SQLDB_HOST=localhost
SQLDB_USERNAME=weather
SQLDB_PASSWORD=*******
SQLDB_DB_NAME=wviewDB
SQLDB_TABLE_NAME=archive


Here's a clip from my /var/log/messages. I've enabled verbose logging for everything.

Quote:

Apr 18 20:08:09 localhost radmrouted[7747]: <2947588629> : radlib: radmrouted started as a daemon ...
Apr 18 20:08:09 localhost radmrouted[7747]: <2947588631> : started on radlib system 1, workdir /var/wview
Apr 18 20:08:09 localhost radmrouted[7747]: <2947588631> : running...
Apr 18 20:08:10 localhost wviewd[7751]: <2947589665> : radlib: wviewd started as a daemon ...
Apr 18 20:08:10 localhost wviewd[7751]: <2947589667> : wview 3.2.1 starting ...
Apr 18 20:08:10 localhost wviewd[7751]: <2947589668> : station interface: serial ...
Apr 18 20:08:10 localhost wviewd[7751]: <2947589669> : Rain Season Start Month set to 1
Apr 18 20:08:10 localhost wviewd[7751]: <2947589669> : Rain Storm Start Trigger set to 0.05 in/hr
Apr 18 20:08:10 localhost wviewd[7751]: <2947589669> : Rain Storm Stop Time set to 12 hours
Apr 18 20:08:10 localhost wviewd[7751]: <2947589669> : station polling interval set to 15 seconds
Apr 18 20:08:10 localhost wviewd[7751]: <2947589697> : -- Station Init Start --
Apr 18 20:08:11 localhost wviewsqld[7755]: <2947590873> : radlib: wviewsqld started as a daemon ...
Apr 18 20:08:11 localhost wviewsqld[7755]: <2947590876> : SQLDB: basic US archiving enabled -
Apr 18 20:08:11 localhost wviewsqld[7755]: <2947590876> : SQLDB: to localhost table wviewDB.archive
Apr 18 20:08:11 localhost htmlgend[7758]: <2947590877> : radlib: htmlgend started as a daemon ...
Apr 18 20:08:11 localhost htmlgend[7758]: <2947590880> : generating to /var/wview/img
Apr 18 20:08:11 localhost wvcwopd[7762]: <2947590914> : radlib: wvcwopd started as a daemon ...
Apr 18 20:08:11 localhost wvcwopd[7762]: <2947590917> : CWOP: configured to submit station CW5752 data to:
Apr 18 20:08:11 localhost wvcwopd[7762]: <2947590917> : CWOP: Primary: indiana.aprs2.net:23
Apr 18 20:08:11 localhost wvcwopd[7762]: <2947590917> : CWOP: Secondary: arizona.aprs2.net:23
Apr 18 20:08:11 localhost wvcwopd[7762]: <2947590918> : CWOP: Tertiary: socal.aprs2.net:23
Apr 18 20:08:11 localhost wvwunderd[7765]: <2947590946> : radlib: wvwunderd started as a daemon ...
Apr 18 20:08:11 localhost wvwunderd[7765]: <2947590949> : WUNDERGROUND: configured to submit station KILROYAL1 data to wunderground.com
Apr 18 20:08:11 localhost wviewd[7751]: <2947590992> : Vantage Pro on /dev/ttyUSB0 opened ...
Apr 18 20:08:11 localhost wviewd[7751]: <2947591027> : station archive interval: 5 minutes
Apr 18 20:08:11 localhost wviewd[7751]: <2947591039> : running...
Apr 18 20:08:12 localhost htmlgend[7758]: <2947591409> : running...
Apr 18 20:08:12 localhost wviewd[7751]: <2947591569> : station location: elevation: 395 feet
Apr 18 20:08:12 localhost wviewd[7751]: <2947591569> : station location: latitude: 37.8 N longitude: 89.1 W
Apr 18 20:08:12 localhost wviewd[7751]: <2947591569> : initializing computed data values...
Apr 18 20:08:12 localhost wviewd[7751]: <2947591571> : -- Station Init Complete --
Apr 18 20:08:12 localhost wviewd[7751]: <2947591571> : newest archive record: 2000-00-00 00:00
Apr 18 20:08:12 localhost wviewsqld[7755]: <2947591572> : SQLDB: beginning initial database sync (this may take some time)...
Apr 18 20:08:12 localhost wviewsqld[7755]: <2947591572> : running...
Apr 18 20:08:12 localhost htmlgend[7758]: <2947591575> : received archive path /var/wview/archive from wviewd: 20060418 20:08:12
Apr 18 20:08:12 localhost htmlgend[7758]: <2947591580> : htmlmgrInit: 51 built-in image definitions added
Apr 18 20:08:12 localhost htmlgend[7758]: <2947591580> : htmlmgrInit: 0 user image definitions added
Apr 18 20:08:12 localhost htmlgend[7758]: <2947591580> : htmlmgrInit: 8 templates added
Apr 18 20:08:12 localhost htmlgend[7758]: <2947591580> : htmlmgrInit: forecast html tags are disabled - /etc/wview/forecast.conf not found...
Apr 18 20:08:12 localhost wvcwopd[7762]: <2947591584> : running...
Apr 18 20:08:12 localhost wvwunderd[7765]: <2947591584> : running...
Apr 18 20:08:12 localhost htmlgend[7758]: <2947591664> : noaaGenerateInit: noaa.dat has no records yet...
Apr 18 20:08:12 localhost htmlgend[7758]: <2947592151> : ARCREC: using header file /etc/wview/arcrec-header.conf ...
Apr 18 20:08:12 localhost htmlgend[7758]: <2947592151> : ARCREC: saving 7 daily archive reports ...
Apr 18 20:08:12 localhost htmlgend[7758]: <2947592152> : ARCREC: 0 daily archive reports available
Apr 18 20:08:13 localhost htmlgend[7758]: <2947592264> : starting html generation in 1 mins 57 secs
Apr 18 20:08:13 localhost htmlgend[7758]: <2947592264> : doing initial html generation now...
Apr 18 20:08:13 localhost wviewsqld[7755]: <2947592566> : SQLDB: initial database sync complete:
Apr 18 20:08:13 localhost wviewsqld[7755]: <2947592566> : SQLDB: 0 inserts, 0 duplicates, 0 errors
Apr 18 20:08:13 localhost htmlgend[7758]: <2947593177> : Generated: 913 ms: 51 images, 8 template files
Apr 18 20:08:31 localhost wviewd[7751]: <2947610467> : station time synchronized to: 04-18-2006 20:08:31
Apr 18 20:08:31 localhost wviewd[7751]: <2947610467> : station GMT offset synchronized to: -5 hours, 0 minutes
Apr 18 20:10:10 localhost htmlgend[7758]: <2947709777> : Generated: 261 ms: 17 images, 8 template files
Apr 18 20:10:15 localhost wviewd[7751]: <2947714584> : vproRunState: retrying archive record...
Apr 18 20:10:30 localhost wviewd[7751]: <2947729586> : vproRunState: retrying archive record...
...
Apr 18 20:15:00 localhost wviewd[7751]: <2947999614> : vproRunState: retrying archive record...
Apr 18 20:15:10 localhost htmlgend[7758]: <2948009777> : Generated: 261 ms: 17 images, 8 template files


[/quote]
Back to top
View user's profile Send private message
newbush



Joined: 17 Apr 2006
Posts: 10

PostPosted: Tue Apr 18, 2006 11:34 pm    Post subject: Reply with quote

To follow up to my own post, running vpconfig gives:

Quote:

root@weather:/usr/local/bin# vpconfig /dev/ttyUSB0 show
vpconfigGetArchiveInterval failed - aborting


I have a feeling that this is the root cause, however I still don't know what's wrong.
Back to top
View user's profile Send private message
newbush



Joined: 17 Apr 2006
Posts: 10

PostPosted: Wed Apr 19, 2006 7:43 pm    Post subject: Reply with quote

I cleared out my archive via the receiver/console. Still no joy. Mad
Back to top
View user's profile Send private message
bhnb



Joined: 28 Nov 2005
Posts: 127

PostPosted: Thu Apr 20, 2006 3:16 am    Post subject: Reply with quote

Hiya

Do you get the 'newest archive record: 2000-00-00 00:00' message every time it starts up or does the date and time change?

This is a total shot in the dark, but in the Davis specs there is a START and a STOP command for archiving. As far as I can tell wview doesn't issue those commands (just had a grep through the code), but is it possible that a STOP has been issued by some other software and archiving just isn't happening? It may be worth connecting to the VP with some terminal emulation software and giving it a 'START' just to make sure.

Cheers

Jon
Back to top
View user's profile Send private message
newbush



Joined: 17 Apr 2006
Posts: 10

PostPosted: Sun Apr 23, 2006 4:27 pm    Post subject: Reply with quote

I've got it working now.

I used to get the 2000-00-00 00:00 message right before I got a series of "retry archive" messages. I managed to get the archives to download correctly by clearing the archive from the VP console, then putting the console into to setup mode, then reseting the console by pulling the power, setup the station through the console, then finally clearing the archive again via `vpconfig cleararchive`.

I suspect I might have just needed to clear the archive through vpconfig, but clearing the archive from the alone wasn't enough.
Back to top
View user's profile Send private message
newbush



Joined: 17 Apr 2006
Posts: 10

PostPosted: Sun Apr 23, 2006 4:29 pm    Post subject: Reply with quote

Oh to answer your question about whether the 2000-00-00 appeared all the time, it didn't. 2000-00-00 just happened to be the most popular. Occasiaonally I'd get data from 2037-12-13 and other data from the future.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    wviewweather.com Forum Index -> wview Installation All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group