First install (core): 404: Not Found

Olivier1974 · February 26, 2023, 5:16pm

Can you do an (obsolete) netstat -an | grep 8123?
Or ss -a | grep 8123?
To check that HA is well listening to the port.

Should look like
IP v4
tcp LISTEN 0 128 0.0.0.0:8123 0.0.0.0:*
IP v6
tcp LISTEN 0 128 [::]:8123 [::]:*

Can you also do an

ip addr

And try to connect with the IP address and :8123?

EDIT Oops, answer to fast. Your HA is not starting
Did you install the requirements specified in the guide?
Are you using the venv?
Are you using python 3.10? Because this is not available out-of-the-box on a RaspberryPi.

odwide · February 26, 2023, 5:41pm

The logs mentioned several times that HA can’t import sqlite3. So I’d follow Olivier1974’s suggestion and check prerequisites.

lalebarde · February 26, 2023, 5:53pm

Here it is:

root@raspberrypi:~# netstat -an | grep 8123
tcp        0      0 0.0.0.0:8123            0.0.0.0:*               LISTEN     
tcp6       0      0 :::8123                 :::*                    LISTEN

root@raspberrypi:~# ss -a | grep 8123
tcp               LISTEN                 0                   0                                                                 0.0.0.0:8123                                                              0.0.0.0:*                              
tcp               LISTEN                 0                   0                                                                       *:8123                        

root@raspberrypi:~# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
    link/ether dc:a6:32:f5:60:40 brd ff:ff:ff:ff:ff:ff
    inet 192.168.0.88/24 brd 192.168.0.255 scope global noprefixroute eth0
       valid_lft forever preferred_lft forever
    inet6 2a01:e0a:457:7f00:1161:9307:a768:7904/64 scope global dynamic mngtmpaddr noprefixroute 
       valid_lft 86179sec preferred_lft 86179sec
    inet6 fe80::8243:3fd7:4e1d:fd6d/64 scope link 
       valid_lft forever preferred_lft forever
3: wlan0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
    link/ether dc:a6:32:f5:60:41 brd ff:ff:ff:ff:ff:ff
    inet 192.168.0.89/24 brd 192.168.0.255 scope global noprefixroute wlan0
       valid_lft forever preferred_lft forever
    inet6 2a01:e0a:457:7f00:c92f:9802:1636:2da6/64 scope global dynamic mngtmpaddr noprefixroute 
       valid_lft 86179sec preferred_lft 86179sec
    inet6 fe80::fd32:7565:aeb8:3e01/64 scope link 
       valid_lft forever preferred_lft forever

Attempt to connect to http://192.168.0.88:8123/ leads to 404: Not Found

I have followed the guide and installed the dependencies as required, used venv, set python 3.10:

(homeassistant) homeassistant@raspberrypi:/srv/homeassistant $ python --version
Python 3.10.10

lalebarde · February 26, 2023, 5:55pm

ok, I am going to check other install instructions for sqlite3 and possibly other things.

lalebarde · February 26, 2023, 6:35pm

sqlite3 is already installed on my RP. Up to now, I don’t find installation tutorials that require other dependencies.

lalebarde · February 26, 2023, 6:39pm

It looks like to be a sqlite3 version compatibility issue.

Olivier1974 · February 26, 2023, 7:54pm

I’ve no issue, but I had to install Python 3.10.9 and in the venv, sqlite is installing whatever version is needed by HA.
That’s the beauty of a venv, every software its own version of the packages.

lalebarde · February 26, 2023, 10:21pm

I have installed sqlite3 v3.41.0 in /opt/sqlite:

(homeassistant) homeassistant@raspberrypi:~ $ ls -l /opt/sqlite/lib
total 12280
-rw-r--r-- 1 root root 6985348 f�vr. 26 23:07 libsqlite3.a
-rwxr-xr-x 1 root root     983 f�vr. 26 23:07 libsqlite3.la
lrwxrwxrwx 1 root root      19 f�vr. 26 23:07 libsqlite3.so -> libsqlite3.so.0.8.6
lrwxrwxrwx 1 root root      19 f�vr. 26 23:07 libsqlite3.so.0 -> libsqlite3.so.0.8.6
-rwxr-xr-x 1 root root 5575240 f�vr. 26 23:07 libsqlite3.so.0.8.6
drwxr-xr-x 2 root root    4096 f�vr. 26 23:07 pkgconfig

Then I have exported the path:

(homeassistant) homeassistant@raspberrypi:~ $ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sqlite/lib

Run hass again, but I have the same issue.

(homeassistant) homeassistant@raspberrypi:~ $ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sqlite/lib
(homeassistant) homeassistant@raspberrypi:~ $ hass
2023-02-26 23:15:29.250 ERROR (MainThread) [homeassistant.setup] Setup failed for analytics: Unable to import component: No module named '_sqlite3'

lalebarde · February 27, 2023, 6:17am

Does HA install itself sqlite in venv? Isn’t venv only for Python?

Olivier1974 · February 27, 2023, 8:39am

That’s an excellent question, and unfortunately, I’m not certain.
However, it appears that it installs SQLAlchemy 2.0.4, and from a Python standpoint, it enables the manipulation of the sqlite3 database in the homeassistant directory.

I don’t have any sqlite packages installed otherwise, but I do have numerous apt packages that are incompatible with what HA installs in the venv. In the past, following the venv creation from the installation guide has always resolved my conflicts.

Moreover, I no longer use the sqlite3 DB because it was on the SD card, and I encountered corruption issues previously. Currently, the HA database is on my NAS using MariaDB.

If you have created the venv, then we need to investigate the matter further.

lalebarde · February 27, 2023, 6:23pm

Yes, I did I follow the guide, installed the dependencies and used venv with python 3.10. I am blocked.

Olivier1974 · February 28, 2023, 2:53pm

I assume that you really need sqlite for something else …
How did you install it?
From sqlite-devel and libsqlite3-dev packages or compiling it?
Did you (re)compile python3.10 after installing it?

Olivier1974 · February 28, 2023, 3:07pm

For what it’s worth, I don’t have sqlite3 installed but can use the sqlite3 module in the python3.10 venv of HA:

(homeassistant) homeassistant@hassbian:~/.homeassistant $ python3
Python 3.10.9 (main, Feb  2 2023, 09:53:17) [GCC 10.2.1 20210110] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> print(sqlite3.version)
2.6.0

But it is an old version compared to the one you installed.

In your linked post, did you try the solution of exporting the LD_LIBRARY_PATH before starting hass as suggested in post #18

lalebarde · February 28, 2023, 5:34pm

Here is how I built Python 3.10:

# How to Install Python 3.10.7 on the Raspberry Pi - https://aruljohn.com/blog/python-raspberrypi/
sudo su -
wget https://www.python.org/ftp/python/3.10.10/Python-3.10.10.tgz
apt install build-essential zlib1g-dev libncurses5-dev libgdbm-dev libnss3-dev
tar -xzvf Python-3.10.10.tgz
cd Python-3.10.10/
./configure --enable-optimizations
sudo make altinstall
# test
/usr/local/bin/python3.10 -V
	Python 3.10.10

Then venv:

apt-get update
apt-get upgrade -y
apt-get install -y python3 python3-dev python3-venv python3-pip bluez libffi-dev libssl-dev libjpeg-dev zlib1g-dev autoconf build-essential libopenjp2-7 libtiff5 libturbojpeg0-dev tzdata
useradd -rm homeassistant -G dialout,gpio,i2c
mkdir /srv/homeassistant
chown homeassistant:homeassistant /srv/homeassistant
sudo -u homeassistant -H -s
cd /srv/homeassistant
python3.10 -m venv .
source bin/activate
python -m pip install --upgrade pip
python3 -m pip install wheel

Rust was also needed: curl https://sh.rustup.rs -sSf | sh

Then HA following the official procedure for core install : pip3 install homeassistant==2023.2.5

As it was complaining about sqlite3 as already depicted in my former post, I have installed it:

sudo chmod a+wr /opt
cd /opt
wget https://sqlite.org/2023/sqlite-autoconf-3410000.tar.gz
tar -xvf sqlite-autoconf-3410000.tar.gz
cd sqlite-autoconf-3410000
./configure --prefix=/opt/sqlite
make
sudo make install

And finally run hass

lalebarde · February 28, 2023, 5:37pm

My python does not see the sqlite3 module:

(homeassistant) homeassistant@raspberrypi:/srv/homeassistant $ python
Python 3.10.10 (main, Feb 26 2023, 09:31:27) [GCC 8.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python3.10/sqlite3/__init__.py", line 57, in <module>
    from sqlite3.dbapi2 import *
  File "/usr/local/lib/python3.10/sqlite3/dbapi2.py", line 27, in <module>
    from _sqlite3 import *
ModuleNotFoundError: No module named '_sqlite3'

lalebarde · February 28, 2023, 5:50pm

If I try:


(homeassistant) homeassistant@raspberrypi:/srv/homeassistant $ LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sqlite/lib hass
2023-02-28 18:40:10.462 ERROR (MainThread) [homeassistant.setup] Setup failed for analytics: Unable to import component: No module named '_sqlite3'
2023-02-28 18:40:10.521 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of onboarding. Setup failed for dependencies: analytics

hass still complains and the service does not start.

Same with export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sqlite/lib before running hass.

I could not try to edit /etc/systemd/system/[email protected] since I do not have this file.

lalebarde · February 28, 2023, 6:05pm

Even after the LD_LIBRARY_PATH export, python still does not see sqlite3. But what puzzles me is that you say it is not necessary.

Olivier1974 · February 28, 2023, 7:49pm

I swear that it is not installed on my system, here is a “proof”

(homeassistant) homeassistant@hassbian:~/.homeassistant $ python3
Python 3.10.9 (main, Feb  2 2023, 09:53:17) [GCC 10.2.1 20210110] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> print(sqlite3.version)
2.6.0
>>>
(homeassistant) homeassistant@hassbian:~/.homeassistant $ which sqlite3
(homeassistant) homeassistant@hassbian:~/.homeassistant $ sqlite3
bash: sqlite3: command not found

lalebarde · March 1, 2023, 9:30pm

I have tried the suggestion of dc125 here unsuccessfully.

Olivier1974 · March 2, 2023, 4:37pm

Ok, I think this was the aim of my question here.

But glad you made it.