wviewweather.com

Hrouda Peter · Joined: 03 Jul 2006 Posts: 20

1.)
'EPRT |1|192.168.2.141|35241|': command not understood
2.)
J
Jul 8 18:30:19 srcl0008 wviewsqld[5364]: <1324984357> : raddatabaseTableQuery: mysql_query(): error 1054 (Unknown column
Jul 8 18:33:10 srcl0008 htmlgend[5367]: <1325154968> : Generated: 45 ms: 17 images, 10 template files

Thanks Peter

bhnb · Joined: 28 Nov 2005 Posts: 127

1) EPRT - on the tnftp man page there's an example .netrc file showing how to fix this. I need to go out now but if it's still a problem tomorrow I'll try to figure out exacly what you need to do.

2) Could you post more information on your environment and what you've done so far? Are you able to verify that MySQL is installed and configured i.e. can you use mysqlclient to connect to the wview database?

Hrouda Peter · Joined: 03 Jul 2006 Posts: 20

1.)EPRT error disapear with
.netrc:
default
macdef init
epsv4 off

-----
2.) mysql Error
I start with sim to test (every build with --enable-mysql)
then i mov to vpro,
Copy the wlk File from Weatherlink.exe (Windows) to linux

The db wviewDB - table archive was build up with 9169 Records.
But no new record ist added.
Unknown column "nan"

Sould i add the column nan?

wview.conf:

STATION_INTERFACE=serial
STATION_DEV=/dev/ttyS0
STATION_RAIN_SEASON_START=1
STATION_RAIN_STORM_TRIGGER_START=0.05
STATION_RAIN_STORM_IDLE_STOP=12
ARCHIVE_PATH=/var/wview/archive
POLL_INTERVAL=15000
PUSH_INTERVAL=60000
VERBOSE_MSGS=00001011
STATION_ELEVATION=1903
STATION_LATITUDE=47.1
STATION_LONGITUDE=9.5
STATION_ARCHIVE_INTERVAL=15
SQLDB_EXTENDED_INFO=1
SQLDB_STORE_METRIC=1
SQLDB_HOST=localhost
SQLDB_USERNAME=root
SQLDB_PASSWORD=*****
SQLDB_DB_NAME=wviewDB

Peter

mhweather · Joined: 07 Aug 2005 Posts: 54

Where do you put the .netrc file ?

bhnb · Joined: 28 Nov 2005 Posts: 127

$HOME/.netrc