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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.