Hi, I have a Fine Offset USB weather station and use weewx Ver 3.6.1 on a
Raspberry Pi 2B running the Minibian distro. My weather station suffers from
the USB lockup problem so I have blocks of missing data. With the release of
Ver 3.6, I thought I'd have a go at adding the missing data using the
wee_import utility. All went well until the last step where I got an 'unable to
add record ... readonly database' error.
I did try to change the database file read/write permissions using 'chmod 666
weewx.sdb' but this made no difference.
Can anyone think of how I can get around the read only issue? Syslog and
config/data files follow.
thanks
Steve
Extract from syslog:
Oct 17 14:42:45 weewx wee_import[427]: wee_import: Starting wee_import...
Oct 17 14:42:45 weewx wee_import[427]: wxcalculate: The following values will
be calculated: barometer=prefer_hardware, windchill=prefer_hardware,
dewpoint=prefer_hardware, appTemp=prefer_hardware, rainRate=prefer_hardware,
windrun=prefer_hardware, heatindex=prefer_hardware,
maxSolarRad=prefer_hardware, humidex=prefer_hardware, pressure=prefer_hardware,
inDewpoint=prefer_hardware, ET=prefer_hardware, altimeter=prefer_hardware,
cloudbase=prefer_hardware
Oct 17 14:42:45 weewx wee_import[427]: wxcalculate: The following algorithms
will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS
Oct 17 14:42:45 weewx wee_import[427]: wee_import: A CSV import from source
file '/home/weewx/archive/csvdata.csv' has been requested.
Oct 17 14:42:45 weewx wee_import[427]: wee_import: Using database binding
'wx_binding', which is bound to database 'weewx.sdb'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: Destination table 'archive'
unit system is '0x10' (METRIC).
Oct 17 14:42:45 weewx wee_import[427]: wee_import: The following imported
field-to-weewx field map will be used:
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field 'outTemp'
in units 'degree_C' --> weewx field 'outTemp'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field
'outHumidity' in units 'percent' --> weewx field 'outHumidity'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field 'rain' in
units 'mm' --> weewx field 'rain'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field
'timestamp' in units 'unix_epoch' --> weewx field 'dateTime'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field 'windDir'
in units 'degree_compass' --> weewx field 'windDir'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field 'pressure'
in units 'hPa' --> weewx field 'pressure'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field
'windSpeed' in units 'km_per_hour' --> weewx field 'windSpeed'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field
'inHumidity' in units 'percent' --> weewx field 'inHumidity'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field 'inTemp'
in units 'degree_C' --> weewx field 'inTemp'
Oct 17 14:42:45 weewx wee_import[427]: wee_import: source field 'windGust'
in units 'km_per_hour' --> weewx field 'windGust'
Oct 17 14:42:48 weewx wee_import[427]: manager: unable to add record 2016-10-17
06:30:00 AEST (1476649800) to database 'weewx.sdb': attempt to write a readonly
database
Oct 17 14:42:48 weewx wee_import[427]: manager: unable to add record 2016-10-17
06:00:00 AEST (1476648000) to database 'weewx.sdb': attempt to write a readonly
database
Oct 17 14:42:48 weewx wee_import[427]: manager: unable to add record 2016-10-17
05:30:00 AEST (1476646200) to database 'weewx.sdb': attempt to write a readonly
database
Oct 17 14:42:48 weewx wee_import[427]: manager: unable to add record 2016-10-17
05:00:00 AEST (1476644400) to database 'weewx.sdb': attempt to write a readonly
database
Oct 17 14:42:48 weewx wee_import[427]: manager: unable to add record 2016-10-17
04:30:00 AEST (1476642600) to database 'weewx.sdb': attempt to write a readonly
database
Oct 17 14:42:48 weewx wee_import[427]: manager: unable to add record 2016-10-16
18:30:00 AEST (1476606600) to database 'weewx.sdb': attempt to write a readonly
database
Oct 17 14:42:48 weewx wee_import[427]: manager: unable to add record 2016-10-16
18:00:00 AEST (1476604800) to database 'weewx.sdb': attempt to write a readonly
database
Oct 17 14:42:48 weewx wee_import[427]: wee_import: Finished import. 7 raw
records resulted in 7 unique records being processed in 2.68 seconds.
Data file csvdata.csv:
timestamp,pressure,inTemp,outTemp,inHumidity,outHumidity,windSpeed,windDir,windGust,rain
2016-10-17 06:30:00,991.2,21.3,13.8,53,92,4,225,4,0
2016-10-17 06:00:00,991.2,21.3,12.9,53,94,0,,0,0
2016-10-17 05:30:00,991.1,21.4,11.7,53,96,0,,0,0
2016-10-17 05:00:00,991.1,21.4,11.7,53,94,0,,0,0
2016-10-17 04:30:00,991.1,21.4,11.7,53,95,0,,0,0
2016-10-16 18:30:00,992.8,24.3,20.3,42,61,6,45,6,0
2016-10-16 18:00:00,992.8,24.3,20.8,42,59,9,45,9,0
Config file csv-update.conf (comments deleted here to cut down on length):
[CSV]
file = /home/weewx/archive/csvdata.csv
interval = 30
qc = True
calc_missing = True
tranche = 250
UV_sensor = False
rain = cumulative
wind_direction = 0,360
[[FieldMap]]
dateTime = timestamp, unix_epoch
usUnits =
interval =
barometer =
pressure = pressure, hPa
altimeter =
inTemp = inTemp, degree_C
outTemp = outTemp, degree_C
inHumidity = inHumidity, percent
outHumidity = outHumidity, percent
windSpeed = windSpeed, km_per_hour
windDir = windDir, degree_compass
windGust = windGust, km_per_hour
windGustDir =
rainRate =
rain = rain, mm
dewpoint =
windchill =
heatindex =
ET =
radiation =
UV =
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
