Hi! I installed the Addon in Home assistant. Configured
- db_password: password
db_username: homeassistant
db_host: 192.168.1.134
db_port: "3306"
db_database: home-assistant_v2.db
db_type: sqlite
installed
MariaDB
Current version: 2.5.2
In the magazine writes:
Starting to parse DB data
2023-02-07 09:21:56,743 - root - INFO - Reading from homedb...
2023-02-07 09:21:56,754 - root - INFO - Getting data from internal homeassistant db
2023-02-07 09:21:56,754 - root - INFO - Executing query
2023-02-07 09:21:56,763 - root - WARNING - Cannot find actuator cases for ids {'light.bathroom_lights', 'switch.livingroom_entrance_switch_right', 'light.bedroom_ceiling_light', 'switch.livingroom_entrance_switch_left', 'light.bedroom_sidetable_lamp', 'light.corridor_lights', 'switch.livingroom_entrance_switch_center'}. Removing...
2023-02-07 09:21:56,763 - root - WARNING - Cannot find sensor cases for ids {'binary_sensor.bathroom_entrance_sensor_occupancy', 'binary_sensor.corridor_end_sensor_occupancy', 'sensor.corridor_end_sensor_illuminance_lux', 'binary_sensor.livingroom_desk_sensor_occupancy', 'weather.home', 'sensor.livingroom_desk_sensor_illuminance_lux', 'sensor.corridor_entrance_sensor_illuminance_lux', 'sensor.bedroom_entrance_sensor_illuminance_lux', 'binary_sensor.chris_phone_is_charging', 'binary_sensor.bedroom_entrance_sensor_occupancy', 'device_tracker.chris_phone', 'binary_sensor.corridor_entrance_sensor_occupancy', 'sensor.bathroom_entrance_sensor_illuminance_lux'}. Removing...
2023-02-07 09:21:56,764 - root - INFO - []
2023-02-07 09:21:56,764 - root - INFO - []
2023-02-07 09:21:56,766 - root - INFO - Add previous state...
2023-02-07 09:21:56,766 - root - INFO - Start parallelization processing...
2023-02-07 09:21:56,784 - root - WARNING - No metrics.
2023-02-07 09:21:56,785 - root - INFO - Completed!
2023-02-07 09:21:56,799 - root - INFO - Runnining cron with cadence 0 0 * * 0
Starting Appdaemon
Starting frontend on 0.0.0.0:2300
Listening on 0.0.0.0:2300
2023-02-07 06:21:57.675989 INFO AppDaemon: AppDaemon Version 4.2.1 starting
2023-02-07 06:21:57.676117 INFO AppDaemon: Python version is 3.9.16
2023-02-07 06:21:57.676201 INFO AppDaemon: Configuration read from: /thesillyhome_src/appdaemon/appdaemon.yaml
2023-02-07 06:21:57.676305 INFO AppDaemon: Added log: AppDaemon
2023-02-07 06:21:57.676380 INFO AppDaemon: Added log: Error
2023-02-07 06:21:57.676444 INFO AppDaemon: Added log: Access
2023-02-07 06:21:57.676520 INFO AppDaemon: Added log: Diag
2023-02-07 06:21:57.688343 INFO AppDaemon: Loading Plugin HASS using class HassPlugin from module hassplugin
2023-02-07 06:21:57.825857 INFO HASS: HASS Plugin Initializing
2023-02-07 06:21:57.826516 INFO HASS: HASS Plugin initialization complete
2023-02-07 06:21:57.826805 INFO AppDaemon: HTTP is disabled
2023-02-07 06:21:57.833473 INFO HASS: Connected to Home Assistant 2023.2.2
2023-02-07 06:21:57.846275 INFO AppDaemon: App 'model_executor' added
2023-02-07 06:21:57.848495 INFO AppDaemon: Found 1 total apps
2023-02-07 06:21:57.849276 INFO AppDaemon: Starting Apps with 1 workers and 1 pins
2023-02-07 06:21:57.877802 INFO HASS: Evaluating startup conditions
2023-02-07 06:21:57.887557 INFO HASS: Startup condition met: hass state=RUNNING
2023-02-07 06:21:57.887868 INFO HASS: All startup conditions met
2023-02-07 06:21:57.903660 INFO AppDaemon: Got initial state from namespace default
2023-02-07 06:21:59.854620 INFO AppDaemon: Scheduler running in realtime
2023-02-07 06:21:59.856436 INFO AppDaemon: Adding /thesillyhome_src/appdaemon/apps to module import path
2023-02-07 06:21:59.857432 INFO AppDaemon: Loading App Module: /thesillyhome_src/appdaemon/apps/model_executor.py
2023-02-07 06:22:00.116386 INFO AppDaemon: Initializing app model_executor using class ModelExecutor from module model_executor
2023-02-07 06:22:00.140936 WARNING model_executor: ------------------------------------------------------------
2023-02-07 06:22:00.141764 WARNING model_executor: Unexpected error running initialize() for model_executor
2023-02-07 06:22:00.142593 WARNING model_executor: ------------------------------------------------------------
2023-02-07 06:22:00.144165 WARNING model_executor: Traceback (most recent call last):
File "/opt/venv/lib/python3.9/site-packages/appdaemon/app_management.py", line 165, in initialize_app
await utils.run_in_executor(self, init)
File "/opt/venv/lib/python3.9/site-packages/appdaemon/utils.py", line 337, in run_in_executor
response = future.result()
File "/usr/local/lib/python3.9/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/thesillyhome_src/appdaemon/apps/model_executor.py", line 27, in initialize
self.init_db()
File "/thesillyhome_src/appdaemon/apps/model_executor.py", line 51, in init_db
db_rules_engine.loc[0] = 1
File "/opt/venv/lib/python3.9/site-packages/pandas/core/indexing.py", line 716, in __setitem__
iloc._setitem_with_indexer(indexer, value, self.name)
File "/opt/venv/lib/python3.9/site-packages/pandas/core/indexing.py", line 1682, in _setitem_with_indexer
self._setitem_with_indexer_missing(indexer, value)
File "/opt/venv/lib/python3.9/site-packages/pandas/core/indexing.py", line 1982, in _setitem_with_indexer_missing
raise ValueError("cannot set a frame with no defined columns")
ValueError: cannot set a frame with no defined columns
2023-02-07 06:22:00.146623 WARNING model_executor: ------------------------------------------------------------
2023-02-07 06:22:00.147353 INFO AppDaemon: App initialization complete
Is this how it should be? Does it work? Where can I track or watch something? Thanks for the help