SQLite Errors on new Docker Install

[dschulz72]

Hey all. I just created a new Ubuntu 22.04 VM in VirtualBox to install ARM using Docker.

I'm not sure what's going wrong, but my docker container starts and keeps throwing SQLite3 errors. I've tried this with two separate docker installs, and they both do the same thing. I tried with docker.io installed via apt and now with the official install instructions here

I assume that when ARM doesn't see a DB, it attempts to create one, and that's what's failing?

When I look at the logs, this what's there:

Starting web ui
[2024-02-17 20:55:11,522] DEBUG ARM: __init__.<module> Debugging pin: 12345
[2024-02-17 20:55:11,584] DEBUG ARM: utils.arm_alembic_get Alembic Head is: 469d88477c13
[2024-02-17 20:55:11,584] DEBUG ARM: utils.arm_db_check Database file is not present: /home/arm/db/arm.db
[2024-02-17 20:55:11,584] DEBUG ARM: utils.arm_db_cfg No armui cfg setup
[2024-02-17 20:55:11,584] INFO ARM: utils.check_db_version No database found.  Initializing arm.db...
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 145, in __init__
    self._dbapi_connection = engine.raw_connection()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/base.py", line 3288, in raw_connection
    return self.pool.connect()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py", line 452, in connect
    return _ConnectionFairy._checkout(self)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py", line 1267, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py", line 716, in checkout
    rec = pool._do_get()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/impl.py", line 284, in _do_get
    return self._create_connection()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py", line 678, in __init__
    self.__connect()
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py", line 903, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/util/langhelpers.py", line 147, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/pool/base.py", line 898, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/create.py", line 637, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/engine/default.py", line 615, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)
sqlite3.OperationalError: unable to open database file

There's a bit more, but it doesn't really give any more information other than that it was unable to open the DB file. LMK if you need any more info.

[KuJoe]

I had this same issue when I installed ARM today. Run this command as root:
chown -R arm:arm /home/arm

The problem I was having is that the installer set the ownership to everything as root so the arm user it created couldn't access anything in the /home/arm directory including the SQLite3 file.

[microtechno9000]

Darn, that shouldn't happen. The last PR aimed to solve some of the chown issues. Will need to look into it and fix

[dschulz72]

Thanks @KuJoe, that fixed it for me. I always forget to check ownership when I'm having strange issues.