this is what I now get in log. Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: Caught unrecoverable exception: Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** (1050, "Table 'archive_day_altimeter' already exists") Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** Traceback (most recent call last): Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weedb/mysql.py", line 53, in guarded_fn Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** return fn(*args, **kwargs) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weedb/mysql.py", line 247, in execute Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** self.cursor.execute(mysql_string, tuple(sql_tuple)) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 163, in execute Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** result = self._query(query) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 321, in _query Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** conn.query(q) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 505, in query Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** self._affected_rows = self._read_query_result(unbuffered=unbuffered) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 724, in _read_query_result Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** result.read() Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1069, in read Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** first_packet = self.connection._read_packet() Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 676, in _read_packet Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** packet.raise_for_error() Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/protocol.py", line 223, in raise_for_error Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** err.raise_mysql_exception(self._data) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** raise errorclass(errno, errval) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** pymysql.err.OperationalError: (1050, "Table 'archive_day_altimeter' already exists") Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** During handling of the above exception, another exception occurred: Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** Traceback (most recent call last): Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewxd.py", line 160, in main Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** engine = weewx.engine.StdEngine(config_dict) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/engine.py", line 89, in __init__ Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** self.loadServices(config_dict) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/engine.py", line 157, in loadServices Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** obj = weeutil.weeutil.get_object(svc)(self, config_dict) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/wxservices.py", line 104, in __init__ Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** initialize=True) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/manager.py", line 755, in get_manager Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** self.manager_cache[data_binding] = open_manager(manager_dict, initialize) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/manager.py", line 906, in open_manager Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** manager_dict['schema']) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/manager.py", line 244, in open_with_create Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** dbmanager = cls(connection, table_name=table_name, schema=schema) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/manager.py", line 1051, in __init__ Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** self._initialize_day_tables(schema) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/manager.py", line 1113, in _initialize_day_tables Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** self._initialize_day_table(obs[0], obs[1].lower(), cursor) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weewx/manager.py", line 1136, in _initialize_day_table Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** cursor.execute(sql_create_str) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** File "/usr/share/weewx/weedb/mysql.py", line 62, in guarded_fn Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** raise klass(e) Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already exists") Nov 28 13:58:17 web weewxd[3684]: CRITICAL __main__: **** Exiting. Nov 28 13:58:17 web weewxd[3684]: Traceback (most recent call last): Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weedb/mysql.py", line 53, in guarded_fn Nov 28 13:58:17 web weewxd[3684]: return fn(*args, **kwargs) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weedb/mysql.py", line 247, in execute Nov 28 13:58:17 web weewxd[3684]: self.cursor.execute(mysql_string, tuple(sql_tuple)) Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 163, in execute Nov 28 13:58:17 web weewxd[3684]: result = self._query(query) Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 321, in _query Nov 28 13:58:17 web weewxd[3684]: conn.query(q) Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 505, in query Nov 28 13:58:17 web weewxd[3684]: self._affected_rows = self._read_query_result(unbuffered=unbuffered) Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 724, in _read_query_result Nov 28 13:58:17 web weewxd[3684]: result.read() Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1069, in read Nov 28 13:58:17 web weewxd[3684]: first_packet = self.connection._read_packet() Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 676, in _read_packet Nov 28 13:58:17 web weewxd[3684]: packet.raise_for_error() Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/protocol.py", line 223, in raise_for_error Nov 28 13:58:17 web weewxd[3684]: err.raise_mysql_exception(self._data) Nov 28 13:58:17 web weewxd[3684]: File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception Nov 28 13:58:17 web weewxd[3684]: raise errorclass(errno, errval) Nov 28 13:58:17 web weewxd[3684]: pymysql.err.OperationalError: (1050, "Table 'archive_day_altimeter' already exists") Nov 28 13:58:17 web weewxd[3684]: During handling of the above exception, another exception occurred: Nov 28 13:58:17 web weewxd[3684]: Traceback (most recent call last): Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewxd.py", line 265, in <module> Nov 28 13:58:17 web weewxd[3684]: main() Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewxd.py", line 160, in main Nov 28 13:58:17 web weewxd[3684]: engine = weewx.engine.StdEngine(config_dict) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/engine.py", line 89, in __init__ Nov 28 13:58:17 web weewxd[3684]: self.loadServices(config_dict) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/engine.py", line 157, in loadServices Nov 28 13:58:17 web weewxd[3684]: obj = weeutil.weeutil.get_object(svc)(self, config_dict) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/wxservices.py", line 104, in __init__ Nov 28 13:58:17 web weewxd[3684]: initialize=True) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/manager.py", line 755, in get_manager Nov 28 13:58:17 web weewxd[3684]: self.manager_cache[data_binding] = open_manager(manager_dict, initialize) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/manager.py", line 906, in open_manager Nov 28 13:58:17 web weewxd[3684]: manager_dict['schema']) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/manager.py", line 244, in open_with_create Nov 28 13:58:17 web weewxd[3684]: dbmanager = cls(connection, table_name=table_name, schema=schema) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/manager.py", line 1051, in __init__ Nov 28 13:58:17 web weewxd[3684]: self._initialize_day_tables(schema) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/manager.py", line 1113, in _initialize_day_tables Nov 28 13:58:17 web weewxd[3684]: self._initialize_day_table(obs[0], obs[1].lower(), cursor) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weewx/manager.py", line 1136, in _initialize_day_table Nov 28 13:58:17 web weewxd[3684]: cursor.execute(sql_create_str) Nov 28 13:58:17 web weewxd[3684]: File "/usr/share/weewx/weedb/mysql.py", line 62, in guarded_fn Nov 28 13:58:17 web weewxd[3684]: raise klass(e) Nov 28 13:58:17 web weewxd[3684]: weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already exists") Nov 28 13:58:17 web systemd[1]: weewx.service: Main process exited, code=exited, status=1/FAILURE Nov 28 13:58:17 web systemd[1]: weewx.service: Failed with result 'exit-code'. Nov 28 13:58:20 web systemd[1]: libvirtd.service: Succeeded.
sreda, 27. november 2024 ob 18:09:49 UTC+1 je oseba vince napisala: > Your 'Supported SQL keys' output from weectl debug does not have a > extraTemp4 element in the database. It looks to me like you are trying to > use an older weewx v3 wview-compatible database that only has 50 or so > elements rather than the current wview-extended schema that has 110 or so > elements in it. A normal output would look like: > > Supported SQL keys > dateTime usUnits interval > altimeter appTemp appTemp1 > barometer batteryStatus1 batteryStatus2 > batteryStatus3 batteryStatus4 batteryStatus5 > batteryStatus6 batteryStatus7 batteryStatus8 > cloudbase co co2 > consBatteryVoltage dewpoint dewpoint1 > ET extraHumid1 extraHumid2 > extraHumid3 extraHumid4 extraHumid5 > extraHumid6 extraHumid7 extraHumid8 > extraTemp1 extraTemp2 extraTemp3 > extraTemp4 extraTemp5 extraTemp6 > extraTemp7 extraTemp8 forecast > hail hailBatteryStatus hailRate > heatindex heatindex1 heatingTemp > heatingVoltage humidex humidex1 > inDewpoint inHumidity inTemp > inTempBatteryStatus leafTemp1 leafTemp2 > leafWet1 leafWet2 lightning_distance > lightning_disturber_count lightning_energy lightning_noise_count > lightning_strike_count luminosity maxSolarRad > nh3 no2 noise > o3 outHumidity outTemp > outTempBatteryStatus pb pm10_0 > pm1_0 pm2_5 pressure > radiation rain rainBatteryStatus > rainRate referenceVoltage rxCheckPercent > signal1 signal2 signal3 > signal4 signal5 signal6 > signal7 signal8 snow > snowBatteryStatus snowDepth snowMoisture > snowRate so2 soilMoist1 > soilMoist2 soilMoist3 soilMoist4 > soilTemp1 soilTemp2 soilTemp3 > soilTemp4 supplyVoltage txBatteryStatus > UV uvBatteryStatus windBatteryStatus > windchill windDir windGust > windGustDir windrun windSpeed > > I would suggest stopping weewx, 'renaming' your existing database, then > starting weewx again. That should create a new database with all the > wview-extended schema elements I listed above. Maybe that will help. > > On Wednesday, November 27, 2024 at 7:17:49 AM UTC-8 Karen K wrote: > >> Unfortunately I do not know much about the interceptor driver. There are >> other people around here who know more. >> >> There ist the section [[sensor_map_extensions]] in the driver >> configuration section. You will have to add entries there to use additional >> sensors. They look like "weewx_obs_type_name = ecowitt_sensor_name". Please >> refer to the Interceptor driver documentation >> <https://github.com/matthewwall/weewx-interceptor> for details. >> >> hajsek...@gmail.com schrieb am Sonntag, 24. November 2024 um 11:33:37 >> UTC+1: >> >>> Thank you for your info. >>> Driver is interceptor. Here is a weectl debug file >>> >>> >>> petek, 22. november 2024 ob 13:20:50 UTC+1 je oseba Karen K napisala: >>> >>>> It is more than before, but it is still not very much. >>>> >>>> weewx.conf is a long file, and "generic" can appear several times >>>> there. So where you added this? Try "weectl debug" to create an overview >>>> about your environment as the documentation says. >>>> >>>> From what you posted I assume you NAMED the sensors, but did not ADD >>>> them. >>>> >>>> It depends on the driver, and you did not say which one you use. It is >>>> not enough to say it is an Ecowitt clone. Again, "weectl debug" would show >>>> the information needed to comment. >>>> >>>> Read Help! Posting to weewx user >>>> <https://github.com/weewx/weewx/wiki/Help!-Posting-to-weewx-user> before >>>> you post. >>>> >>>> -- 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. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/20ad7094-6e95-4414-acca-5a99555d6b8fn%40googlegroups.com.
