Error On First Run, Relates to SQLite3?

[NateEaton]

Interesting project that looks like it would meet my needs but after installing and configuring I get an error on the first run that I am not clear how to resolve. I'm including the output below.

BTW, a few points to share, the first two of which may relate directly to the issue:

• I do not see anything indicating which Raspberry Pi models this has been tested on. I am using a Pi Zero 2 W.
• I do not see anything indicating which Raspberry OS to run this on. I have tried it on the full Bookworm install and on the full legacy Bullseye install. On the former, I had to change requirements.txt to install pyyaml version 6.0.1 as version 6.0 failed with a dependency error relating to cython but it still had a first run error that relates to sqlite3. On the latter, I get an error on first run and the output below is from this version. Can/should this be installed on a lite version? It doesn't seem like that would have anything to do with this issue but if the full desktop and other apps (e.g., browser) aren't needed, I'd rather not install them.
• You have a few documentation typos, a reference to "env" instead of "venv" on the doc overview page instructions for setting up a virtual environment, and in the apt-get statement there is a reference to "x11-server-utils" that should be "x11-server-utils".

Output:
`(venv) pi@Framarama:~/framarama $ python manage.py runserver --noreload
Scheduler started
Added job "Config source updates" to job store "default"
Added job "Config source updates triggered" to job store "default"
Running job "Config source updates triggered (trigger: date[2024-07-27 14:34:21 UTC], next run at: 2024-07-27 14:34:21 UTC)" (scheduled at 2024-07-27 14:34:21.237985+00:00)
Removed job cfg_source_update_1722090861.235239
Job "Config source updates triggered (trigger: date[2024-07-27 14:34:21 UTC], next run at: 2024-07-27 14:34:21 UTC)" raised an exception
Traceback (most recent call last):
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 477, in execute
return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: no such table: config_source

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/home/pi/framarama/venv/lib/python3.9/site-packages/apscheduler/executors/base.py", line 125, in run_job
retval = job.func(*job.args, **job.kwargs)
File "/home/pi/framarama/framarama/jobs.py", line 38, in
self._scheduler.add_job(lambda *args, **kwargs: func(*args, **kwargs), id=job_id, args=_func_args, kwargs=_func_kwargs, *args, **kwargs)
File "/home/pi/framarama/config/jobs.py", line 55, in source_update
for _source in models.Source.objects.filter(_criteria).order_by('-update_date_start'):
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/models/query.py", line 320, in iter
self._fetch_all()
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1507, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/models/query.py", line 57, in iter
results = compiler.execute_sql(
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1361, in execute_sql
cursor.execute(sql, params)
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute
return self._execute_with_wrappers(
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/db/backends/sqlite3/base.py", line 477, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: no such table: config_source
Scheduler started
Run "which xinput": code=0, stdout=16 bytes, stderr=0 bytes
Run "which xmodmap": code=0, stdout=17 bytes, stderr=0 bytes
Error running "pidof xinput": code=1, stdout=b'', stderr=b''
Error running "xmodmap -pke": code=1, stdout=b'', stderr=b"xmodmap: unable to open display ''\n"
Traceback (most recent call last):
File "/home/pi/framarama/manage.py", line 22, in
main()
File "/home/pi/framarama/manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/core/management/init.py", line 446, in execute_from_command_line
utility.execute()
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/core/management/init.py", line 420, in execute
django.setup()
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/init.py", line 24, in setup
apps.populate(settings.INSTALLED_APPS)
File "/home/pi/framarama/venv/lib/python3.9/site-packages/django/apps/registry.py", line 124, in populate
app_config.ready()
File "/home/pi/framarama/framarama/apps.py", line 36, in ready
self.setup_frontend()
File "/home/pi/framarama/frontend/apps.py", line 11, in setup_frontend
self._scheduler.start()
File "/home/pi/framarama/framarama/jobs.py", line 118, in start
self.configure()
File "/home/pi/framarama/frontend/jobs.py", line 49, in configure
self._monitor.start()
File "/home/pi/framarama/framarama/base/frontend.py", line 593, in start
self._verify_running()
File "/home/pi/framarama/framarama/base/frontend.py", line 580, in _verify_running
self._keymap = [_line.split() for _line in Process.exec_run(['xmodmap', '-pke']).split(b'\n')]
AttributeError: 'NoneType' object has no attribute 'split'`

[ohinckel]

First of all, thanks for your feedback, which is really welcome and for testing this pice of code.

I made some adjustments in the meantime to the code base, which was not pushed to this repository yet. But now it is. It also includes some major changes and I sugest to do a complete reinstall (checkout and run general setup tasks as documented).

You log shows more different errors:

• sqlite3.OperationalError: no such table: config_source: the database setup was not run (I added a "makemigration" command to the setup task which will generate them)
• xmodmap: unable to open display : on the device running the code does not include an X server running to show images (which is required when running the frontend application)

My tested setup includes only some Raspberry Pi 1 and some Banana PI M2 Zero for the frontend component (showing the pictures) while the server component was tested on Raspberry Pi 3 and 5. The current running setup is running the frontend components and server component separately (3 frontend, 1 server).

Which setup do you want to run the components in your case?

Btw. I also tried to fix your mentioned typos and updated the package versions (also making mysql commented out, because it's an optional package only required when using MySQL database).

[ohinckel]

In the meantime there's also a docker setup available (check readme how to build it). Maybe it's easier to setup. Feedback is also welcome.