SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed...

[seh2000]

Solved after 3 installs from scratch.
Not sure where the issue was.
Steen

Hi,
Happy New Year...
Again I have an issue that I am not sure why happened, well I had to move and re-install speedtest-tracker on another Pi.
Installed Docker and then created the folder for speedtest-tracker, added the config text for MariaDB which I done before however as app didn't I added APP_DEBUG=true, and got this

docker compose up -d && docker compose logs -f
Shows:
speedtest-tracker | In Connection.php line 825:
speedtest-tracker |
speedtest-tracker | SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
speedtest-tracker | MariaDB server (Connection: mariadb, SQL: select * from cache where key
speedtest-tracker | in (laravel_cache_illuminate:queue:restart))
speedtest-tracker |
speedtest-tracker |
speedtest-tracker | In Connector.php line 66:
speedtest-tracker |
speedtest-tracker | SQLSTATE[HY000] [1130] Host '172.18.0.3' is not allowed to connect to this
speedtest-tracker | MariaDB server

I presume it could be related to the error indicates that the host 172.18.0.3 is not allowed to connect to MariaDB server, which could be related to user privileges and host restrictions in MySQL/MariaDB. Just I can't figure out how to access MariaDB.

Any help will be very very much appreciated.

Steen

services:
speedtest-tracker:
image: lscr.io/linuxserver/speedtest-tracker:latest
restart: unless-stopped
container_name: speedtest-tracker
ports:
- 8980:80
- 8943:443
environment:
- PUID=1000
- PGID=1000
- APP_KEY=base64:p+CV1H+YoJGW76uPiXGxncQW5hSqydMETVvc2hpMH90=
- DB_CONNECTION=mariadb
- DB_HOST=db
- DB_PORT=3306
- DB_DATABASE=speedtest_tracker
- DB_USERNAME=speedtest_tracker
- DB_PASSWORD=password
- APP_DEBUG=true
volumes:
- /path/to/data:/config
depends_on:
- db
db:
image: mariadb:11
restart: always
environment:
- MYSQL_DATABASE=speedtest_tracker
- MYSQL_USER=speedtest_tracker
- MYSQL_PASSWORD=password
- MYSQL_RANDOM_ROOT_PASSWORD=true
volumes:
- speedtest-db:/var/lib/mysql
healthcheck:
test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
interval: 5s
retries: 3
timeout: 5s
volumes:
speedtest-db:

[seh2000]

Solved after 3 installs from scratch.
Not sure where the issue was.
Steen