Can someone please help me please and tell me which file I need to edit to add extraTemp sensor to get graph? Two works but third doesn't show up. Thank you
ponedeljek, 2. december 2024 ob 18:19:51 UTC+1 je oseba [email protected] napisala: > I have managed to add all what was missing in mysql not it work. It didn't > worked when weewx create all new tables. But just cant get a graph to work, > what else I miss here? http://vreme.povej.net > at the bottom is all mixed instead of graphs? > > četrtek, 28. november 2024 ob 13:59:27 UTC+1 je oseba [email protected] > napisala: > >> 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. >>>> >>>> [email protected] 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 [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/dbea1067-8df7-4448-8b74-1bbcc72065ebn%40googlegroups.com.
