Need help - first unstall and stuck

Hi all.

Just installed HA on my local server running gentoo linux.

pip3 install --user homeassistant.

I have mysql server running too. Tried to setup recorder according to this tutorial (https://kevinfronczak.com/blog/mysql-with-homeassistant) in order to use it - but no luck. Still get same error:

2018-06-15 04:31:28 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: No module named 'sqlite3' (retrying in 3 seconds)

Please help me - i am stuck,

Can you post the config for MySQL in HA. Looks like missing sql dependency but not sure.

Docker or other install methods avoid this FYI. Just in case you not want troubleshoot these type errors

1 Like

Managed to solve this problem - compiled python with sqlite support. But why it should be compiled with sqlite support if i am going to use mysql? Ok - let’s move forward.

Second problem - can not setup zwave support. I have aeotec zwave usb stick and got this error:

2018-06-15 04:59:42 ERROR (MainThread) [homeassistant.setup] Error during setup of component zwave
Traceback (most recent call last):
  File "/root/.local/lib64/python3.5/site-packages/homeassistant/setup.py", line 143, in _async_setup_component
    hass, processed_config)
  File "/root/.local/lib64/python3.5/site-packages/homeassistant/components/zwave/__init__.py", line 229, in async_setup
    from openzwave.option import ZWaveOption
  File "/root/.homeassistant/deps/lib64/python3.5/site-packages/openzwave/option.py", line 29, in <module>
    import libopenzwave
ImportError: /root/.homeassistant/deps/lib64/python3.5/site-packages/libopenzwave.cpython-35m-x86_64-linux-gnu.so: undefined symbol: _ZN9OpenZWave7Manager16GetNodeProductIdB5cxx11Ejh

Any ideas?

Same. Missing some dependency.

The guide you follow may miss something and result in missing packages in python. May have look at HA provided guide. Look like you have venv install so I provide guide for venv

2 Likes

it is not a virtual environment. Why no error in log about missing dependancies?

p.s. - which version of python i more stable and less problematic for HA - any ideas?

Last line “ImportError: /root/.homeassistant/deps/lib64/python3.5/site-pac…” ususally mean it tried to install it and couldn’t

Guide says python 3.5.3 or later. Not sure if any version python is more stable

The tutorial was assuming venv so I thought you use that.

Tbh, that’s the reason that venv is the recommended option.

3.6.4 is the version I think most of us techies are using.

1 Like

A quick internet search reveals this, although there doesn’t seem to be an obvious resolution.

1 Like

tried installation in virtual environment - same error. Looks like this issue is more related to openzwave project than home assistant.

little update - i have compiled python-openzwave from git sources and noticed that size of compiled library libopenzwave.cpython-36m-x86_64-linux-gnu.so is two times bigger than library installed during HA installation. So i replaced library in /root/.homeassistant/deps/lib64/python3.6/site-packages/ with one compiled and installed manual from /usr/lib64/python3.6/site-packages/

and after restart i get rid of this error and seems like zwave component in HA is working now.

So main question is how to set up HA using manual compiled python-openzwave package instead of downloaded during HA installation?

I am not a programmer - so i am sorry for stupd questions ))