CRITICAL: Database schema creation failed for /data/db/app.db.

[HeyItsJono]

Did I research?

• I have searched the docs https://jokob-sk.github.io/NetAlertX/
• I have searched the existing open and closed issues
• I confirm my SCAN_SUBNETS is configured and tested as per https://github.com/jokob-sk/NetAlertX/blob/main/docs/SUBNETS.md

The issue occurs in the following browsers. Select at least 2.

• Firefox
• Chrome
• Other (unsupported) - PRs welcome
• N/A - This is an issue with the backend

What I want to do

This error occurs on first run of NetAlertX via docker compose.

Relevant settings you changed

No response

docker-compose.yml

services:
  netalertx:
    container_name: netalertx
    image: "ghcr.io/jokob-sk/netalertx"
    network_mode: "host"
    cap_drop:                                       # Drop all capabilities for enhanced security
      - ALL
    cap_add:                                        # Add only the necessary capabilities
      - NET_ADMIN                                   # Required for ARP scanning
      - NET_RAW                                     # Required for raw socket operations
      - NET_BIND_SERVICE                            # Required to bind to privileged ports (nbtscan)
    restart: unless-stopped
    volumes:
      - /local_data_dir:/data
      - /etc/localtime:/etc/localtime
    environment:
      - PORT=20211
    tmpfs:
      - "/tmp:uid=20211,gid=20211,mode=1700,rw,noexec,nosuid,nodev,async,noatime,nodiratime"

What installation are you running?

Production (netalertx)

app.log

---

| \ | | | | / _ | | | | \ \ / /
| | | | |/ /\ \ | ___ _ _| | \ V /
| . |/ _ \ __| _ | |/ _ \ __| __|/
| |\ | __/ || | | | | / | | |_/ /^\
_| _/_|__| |/|___|| __/ /

\033[0m Network intruder and presence detector.
https://netalertx.com

Startup pre-checks
--> storage permission.sh
--> data migration.sh
--> mounts.py
Path | Writeable | Mount | RAMDisk | Performance | DataLoss
--------------------------+-----------+-------+---------+-------------+----------
/data | ✅ | ✅ | ➖ | ➖ | ✅
/data/db | ✅ | ✅ | ➖ | ➖ | ✅
/data/config | ✅ | ✅ | ➖ | ➖ | ✅
/tmp/run/tmp | ✅ | ✅ | ✅ | ✅ | ✅
/tmp/api | ✅ | ✅ | ✅ | ✅ | ✅
/tmp/log | ✅ | ✅ | ✅ | ✅ | ✅
/tmp/run | ✅ | ✅ | ✅ | ✅ | ✅
/tmp/nginx/active-config | ✅ | ✅ | ✅ | ✅ | ✅
--> first run config.sh
--> first run db.sh
══════════════════════════════════════════════════════════════════════════════
🆕 First run detected. Building initial database schema in /data/db/app.db.

Do not interrupt this step. Once complete, consider backing up the fresh
database before onboarding sensitive networks.

══════════════════════════════════════════════════════════════════════════════
Error: unable to open database "/data/db/app.db": unable to open database file
══════════════════════════════════════════════════════════════════════════════
❌ CRITICAL: Database schema creation failed for /data/db/app.db.

NetAlertX cannot start without a properly initialized database. This
failure typically indicates:

* Insufficient disk space or write permissions in the database directory
* Corrupted or inaccessible SQLite installation
* File system issues preventing database file creation

Check the logs for detailed SQLite error messages. Ensure the container
has write access to the database path and adequate storage space.

══════════════════════════════════════════════════════════════════════════════
\033[1;31m══════════════════════════════════════════════════════════════════════════════
❌ NetAlertX startup aborted: critical failure in first run db.sh.
https://github.com/jokob-sk/NetAlertX/blob/main/docs/docker-troubleshooting/troubleshooting.md
══════════════════════════════════════════════════════════════════════════════
\033[0m

Debug enabled

• I have read and followed the steps in the wiki link above and provided the required debug logs and the log section covers the time when the issue occurs.

[jokob-sk]

Hi,

Can you confirm that you have to folders created in your local data folder, one /db and one /config folder?

Please post your folder structure and make sure you run the following

sudo chown -R 20211:20211 /local_data_dir
sudo chmod -R a+rwx /local_data_dir/

[HeyItsJono]

Hi, that did fix it thank you. I had tried the same earlier but had left the trailing / off /local_data_dir/ for the chmod command.