Qnap NAS = Server Error 500

[seh2000]

Checklist

• I have read the docs.
• I have searched open and closed issues.

Deployment Environment

Docker Compose

Description

Hi,
Hope someone here can assist.
I am trying to get speedtest-tracker to run on my Qnap NAS, however I keep getting this Server Error 500.
For the APP_KEY I created the key on the NAS via SSH/CLI.
I no for sure that I don't fully understand the Logs, I do see the below repeating messages, but I don't know if they are related to the error 500.

In Connection.php line 824:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracker.cache' doesn't exist (Connection: mariadb, SQL: select * from `cache` where `key` in (laravel_cache_illuminate:queue:restart))                        
                                                                               
In Connection.php line 406:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speedtest_tracker.cache' doesn't exist

In Connection.php line 824:
SQLSTATE[HY000] [2002] Host is unreachable (Connection: mariadb, SQL: select * from `cache` where `key` in (laravel_cache_illuminate:queue:restart))    
                                                                               
In Connector.php line 67:
SQLSTATE[HY000] [2002] Host is unreachable                                                       

I copied and pasted the below from the Speedtest Tracker web.

version: '3.4'
services:
  speedtest-tracker:
    container_name: speedtest-tracker
    ports:
      - 8080:80
      - 8443:443
    environment:
      - PUID=1000
      - PGID=1000
      - DB_CONNECTION=mariadb
      - DB_HOST=db
      - DB_PORT=3306
      - DB_DATABASE=speedtest_tracker
      - DB_USERNAME=speedy
      - DB_PASSWORD=password
      - APP_KEY=base64:NTeK6aoXzxXRJobr5UW0Mfk0gVvRLAnePraKiOFoJxM=
      - DATETIME_FORMAT=l, d F Y @H:i e
      - APP_TIMEZONE=Europe/Dublin
      - SPEEDTEST_SCHEDULE=15 */1 * * * # Optional
      - SPEEDTEST_SERVERS=4604 #Dublin (Blacknight) # Optional
    volumes:
      - /path/to-data:/config
    image: lscr.io/linuxserver/speedtest-tracker:latest
    networks:
      qnet-network:
        ipv4_address: 192.168.1.12
    restart: unless-stopped
    depends_on:
      - db
  db:
    image: mariadb:10
    networks:
      qnet-network:
        ipv4_address: 192.168.1.14
    restart: always
    environment:
      - MARIADB_DATABASE=speedtest_tracker
      - MARIADB_USER=speedy
      - MARIADB_PASSWORD=password
      - MARIADB_RANDOM_ROOT_PASSWORD=true
    volumes:
      - speedtest-db:/var/lib/mysql
networks:
  qnet-network:
    driver_opts:
      iface: eth0
    driver: qnet
    ipam:
      driver: qnet
      options:
        iface: eth0
      config:
        - subnet: 192.168.1.0/24
          gateway: 192.168.1.1
volumes:
  speedtest-db:

Steen

Anything else?

No response

[svenvg93]

From the logs, it looks like the application can’t reach the MariaDB container. I’m not familiar with QNAP or its container setup, so I’m afraid I can’t offer much help with that part.

[seh2000]

Hi @svenvg93
Thanks for answering!
Yeah, me too regarding QNAP and its containers.
I have a couple of other containers running, one is the Orb Sensor and the other is OpenSpeedTest, both running fine, but neither uses a DB like MariaDB.
Hope someone else here got some ideas.
Steen

[svenvg93]

Otherwise you can use the SQLite db that might me easier
https://docs.speedtest-tracker.dev/getting-started/installation/using-docker-compose#sqlite

[seh2000]

Hi @svenvg93
Not too sure how I did.
Qnap NAS Container don't allow editing or viewing of the code 🤯 I had to do some modifications to the SQLite code and of cause I hit create before it copied the code. I'll see if I can figure it out a post here as perhaps others want to use on their Qnap NAS.
Anyhow it is working 🎉
Steen