After upgrading to Python 3.6 on a RP3, and installing Home Assistant I get the error after starting home assistant.
Seems to be a package is not available.
ERROR:homeassistant.components.recorder:Error during connection setup: No module named ‘pysqlite2’ (retrying in 3 seconds)
Hi
I have the same issue. Did you resolve it?
//JM
Hi…
I got this error after upgrading to 0.55.1, Debian 9 Stretch and Python 3.6.
Need help to overcome this error. No homeassistant.db is created and not many automation scripts are working since no recorder or history is available.
Is there NO on out there to help us… on this issue…??
HA is running without any db file and no history is recorded, hence automation and scripts failing…
did you get this sorted? I’m running into the same issue with newest update.
I was having the same issue and found this:
Basically run this install:
sudo apt-get install libsqlite3-dev
Now in the downloaded python source rebuild and install python with the following command:
./configure --enable-loadable-sqlite-extensions && make && sudo make install
After doing this I reinstalled homeassisant and the error was gone
Could you please tell me what you mean by “in the downloaded python source”`?
Currently having this issue after updating my venv from python 3.5 to 3.6
Your commands solved the problem on a fresh pip install:
apt-get install libsqlite3-dev
./configure --enable-loadable-sqlite-extensions && make && sudo make install
Also had to to:
python3.6 -m pip install sqlalchemy
python3.6 -m pip install aiohttp_cors
Thanks 4 the great work 