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 hajsek...@gmail.com 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. >>> >>> 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/474b8f0e-0a0e-4100-bf6e-a60d39143ba7n%40googlegroups.com.
