December 13, 20232 yr Hello, This is for the unraid docker version of this app. My speedtest results keeps showing the Latest results 7 hours ago. And when you look at the time line, the most recent speedtest listed as 7 hours prior to current time. Incase I didnt make any sense, if I manually run a speedtest, and the current time is 10:00am on Dec 13th. It will show on the graph as DEC-13 - 3:00. Is there a fix for this. Edited December 13, 20232 yr by Lazirus33
December 14, 20232 yr So this is not working. I used the sqlite version previously and it worked. Here is my mariadb container: docker run -d --name='mariadb' --net='bridge' -e TZ="America/New_York" -e HOST_OS="Unraid" -e HOST_HOSTNAME="NucBerthaPlus" -e HOST_CONTAINERNAME="mariadb" -e 'MYSQL_ROOT_PASSWORD'='mySQL.Root' -e 'MYSQL_DATABASE'='speedtest_tracker' -e 'MYSQL_USER'='speedtest' -e 'MYSQL_PASSWORD'='speedtest.DB' -e 'REMOTE_SQL'='http://URL1/your.sql,https://URL2/your.sql' -e 'PUID'='99' -e 'PGID'='100' -e 'UMASK'='022' -l net.unraid.docker.managed=dockerman -l net.unraid.docker.icon='https://raw.githubusercontent.com/linuxserver/docker-templates/master/linuxserver.io/img/mariadb-logo.png' -p '3306:3306/tcp' -v '/mnt/user/appdata/mariadb':'/config':'rw' 'lscr.io/linuxserver/mariadb' b79dac9b15ed29de5d70028a2a0254653bd13e9fd6924803196ec4b0aa5da554 Here is my speedtest-tracker container: docker run -d --name='speedtest-tracker' --net='bridge' -e TZ="America/New_York" -e HOST_OS="Unraid" -e HOST_HOSTNAME="NucBerthaPlus" -e HOST_CONTAINERNAME="speedtest-tracker" -e 'PUID'='1000' -e 'PGID'='1000' -e 'DB_CONNECTION'='mysql' -e 'DB_HOST'='mariadb' -e 'DB_PORT'='3306' -e 'DB_DATABASE'='speedtest_tracker' -e 'DB_USERNAME'='speedtest' -e 'DB_PASSWORD'='speedtest.DB' -e 'APP_KEY'='' -l net.unraid.docker.managed=dockerman -l net.unraid.docker.webui='https://[IP]:[PORT:443]/' -l net.unraid.docker.icon='https://raw.githubusercontent.com/devzwf/unraid-docker-templates/main/images/speedtest-tracker-icon.png' -p '9443:443/tcp' -v '/mnt/user/appdata/speedtest-tracker':'/config':'rw' 'ghcr.io/alexjustesen/speedtest-tracker:latest' 52ebcb52520f00856adc80ac39787169bdf43f38c7f77ec1f8be59840db218f8 speedtest-tracker log ends in this: In Connection.php line 822: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select t able_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from infor mation_schema.tables where table_schema = 'speedtest_tracker' and table_typ e = 'BASE TABLE' order by table_name) In Connector.php line 65: SQLSTATE[HY000] [2002] Connection refused What am I missing? Thanks for the help. Dennis
December 14, 20232 yr 1 hour ago, DWomack said: So this is not working. I used the sqlite version previously and it worked. Here is my mariadb container: docker run -d --name='mariadb' --net='bridge' -e TZ="America/New_York" -e HOST_OS="Unraid" -e HOST_HOSTNAME="NucBerthaPlus" -e HOST_CONTAINERNAME="mariadb" -e 'MYSQL_ROOT_PASSWORD'='mySQL.Root' -e 'MYSQL_DATABASE'='speedtest_tracker' -e 'MYSQL_USER'='speedtest' -e 'MYSQL_PASSWORD'='speedtest.DB' -e 'REMOTE_SQL'='http://URL1/your.sql,https://URL2/your.sql' -e 'PUID'='99' -e 'PGID'='100' -e 'UMASK'='022' -l net.unraid.docker.managed=dockerman -l net.unraid.docker.icon='https://raw.githubusercontent.com/linuxserver/docker-templates/master/linuxserver.io/img/mariadb-logo.png' -p '3306:3306/tcp' -v '/mnt/user/appdata/mariadb':'/config':'rw' 'lscr.io/linuxserver/mariadb' b79dac9b15ed29de5d70028a2a0254653bd13e9fd6924803196ec4b0aa5da554 Here is my speedtest-tracker container: docker run -d --name='speedtest-tracker' --net='bridge' -e TZ="America/New_York" -e HOST_OS="Unraid" -e HOST_HOSTNAME="NucBerthaPlus" -e HOST_CONTAINERNAME="speedtest-tracker" -e 'PUID'='1000' -e 'PGID'='1000' -e 'DB_CONNECTION'='mysql' -e 'DB_HOST'='mariadb' -e 'DB_PORT'='3306' -e 'DB_DATABASE'='speedtest_tracker' -e 'DB_USERNAME'='speedtest' -e 'DB_PASSWORD'='speedtest.DB' -e 'APP_KEY'='' -l net.unraid.docker.managed=dockerman -l net.unraid.docker.webui='https://[IP]:[PORT:443]/' -l net.unraid.docker.icon='https://raw.githubusercontent.com/devzwf/unraid-docker-templates/main/images/speedtest-tracker-icon.png' -p '9443:443/tcp' -v '/mnt/user/appdata/speedtest-tracker':'/config':'rw' 'ghcr.io/alexjustesen/speedtest-tracker:latest' 52ebcb52520f00856adc80ac39787169bdf43f38c7f77ec1f8be59840db218f8 speedtest-tracker log ends in this: In Connection.php line 822: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select t able_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from infor mation_schema.tables where table_schema = 'speedtest_tracker' and table_typ e = 'BASE TABLE' order by table_name) In Connector.php line 65: SQLSTATE[HY000] [2002] Connection refused What am I missing? Thanks for the help. Dennis Did you install Mariadb and Speedtest-tracker from the unraid community apps?
December 14, 20232 yr Yes, I did. It is linuxserver mariadb. Edited December 14, 20232 yr by DWomack Add info
December 14, 20232 yr 1 hour ago, DWomack said: Yes, I did. It is linuxserver mariadb. I know you can use which ever settings you want, but this worked for me, So I installed the MariaDB-Official by mgutt and these are the settings I used. Repository: mariadb:10 Port: 3306 Generate Random Pass: Yea Database Name: speedtest_tracker Database User: speedy Database Password: password Then with the speedtest-tracker docker the settings are WebUI Port: 8943 Puid: 1000 PGID: 1000 Database: mysql Database host: IP of your unraid server Database Port: 3306 Database Name: speedtest_tracker Database username: speedy Database Password: password host Port 2: 9999
December 14, 20232 yr 15 minutes ago, Lazirus33 said: I know you can use which ever settings you want, but this worked for me, So I installed the MariaDB-Official by mgutt and these are the settings I used. Repository: mariadb:10 Port: 3306 Generate Random Pass: Yea Database Name: speedtest_tracker Database User: speedy Database Password: password Then with the speedtest-tracker docker the settings are WebUI Port: 8943 Puid: 1000 PGID: 1000 Database: mysql Database host: IP of your unraid server Database Port: 3306 Database Name: speedtest_tracker Database username: speedy Database Password: password host Port 2: 9999 My repository is lscr.io/linuxserver/mariadb That is the default. I don’t see a Generate Random Pass
December 15, 20232 yr 8 hours ago, DWomack said: My repository is lscr.io/linuxserver/mariadb That is the default. I don’t see a Generate Random Pass It must be with the version I used then. The devs will probably be more help
December 16, 20232 yr On 12/8/2023 at 4:29 AM, ZappyZap said: you need to provide more details I have this errror Nginx 404 Not Found In container logs I see - ✅ All set, Speedtest Tracker started.
December 20, 20232 yr What needs to be done to properly set up the database? Just installing a supported database on the same unraid does not seem to be sufficient. Do we need to create databases and / or users on the database? Is it possible to get a little more guidance on what needs to be done with the database or to get a pre-configured database included with the docker package?
December 21, 20232 yr 6 hours ago, Fearmonger said: What needs to be done to properly set up the database? Just installing a supported database on the same unraid does not seem to be sufficient. Do we need to create databases and / or users on the database? Is it possible to get a little more guidance on what needs to be done with the database or to get a pre-configured database included with the docker package? Totally agree - even the "Unraid Installation" instructions on the developer's website doesn't say anything about installing and setting up a database. Seems that the documentation is lacking.
December 21, 20232 yr Author Here what i did . Just a note : i have this template install for a while and as everybody was using file db. and i had already a Mariadb running on my unraid when the app swithc to Mariadb what i did : i create a DB and user using adminer (of course added the correct permission etc) and simply feed the info to the template. Edited December 21, 20232 yr by ZappyZap
December 27, 20232 yr what's the ALLOW_EMBED setting do? could this be used to present say the down/up graph in a homepage iframe?
January 8, 20242 yr Ive got a new install and i keep getting this maria db error even tho the DB is setup. any ideas??? Database connection [mariadb] not configured. -------------------------------------------------------------------- _______ __ __ __ | __|.-----.-----.-----.--| | |_.-----.-----.| |_ |__ || _ | -__| -__| _ | _| -__|__ --|| _| |_______|| __|_____|_____|_____|____|_____|_____||____| |__| _______ __ |_ _|.----.---.-.----.| |--.-----.----. | | | _| _ | __|| <| -__| _| |___| |__| |___._|____||__|__|_____|__| -------------------------------------------------------------------- To support Speedtest Tracker visit: https://github.com/alexjustesen/speedtest-tracker ------------------------------------- GID/UID ------------------------------------- User uid: 1000 User gid: 1000 ------------------------------------- 🔒 SSL_MODE has been set to MIXED, setting the web server to work in HTTP + HTTPS... 🏃♂️ An SSL key was not detected, so I'll generate a self-signed SSL certificate pair for you... 🐇 Configuring Speedtest Tracker... 🔒 Fixing app path file permissions... ✅ Permissions fixed. 🧹 Clearing any previous caches... ✅ Cache cleared. ✅ Environment file exists. 🔗 Creating symlinks for config and log files... ✅ Symlinks created. ⏳ Generating an application key... ⚠️ An application key was generated at start up, no environment variable was set. 👀 To set an application key that persists, read the docs: https://docs.speedtest-tracker.dev/ 💰 Building the cache... ✅ Cache set. 🚛 Migrating the database... In DatabaseManager.php line 173: Database connection [mariadb] not configured. ** Press ANY KEY to close this window ** mariaDB settings https://photos.google.com/lr/photo/ACEPBf2_TGwG0AUHMfZdQPFbxpAXjIoSpj4b3e_NsKnC--BhnmMG7B5284jLYDMlR9RZQ1dJhU0hlVjplH92I97RLkTWWWa9IQ Edited January 8, 20242 yr by KLLSWITCH
January 29, 20242 yr I can't get this to run whatsoever. I installed the MySQL-Official addon (Docker), used the same database name, user name & password on both. I tried using the Unraid IP address and the docker container name (mysql), but I can't get anywhere. No matter the DB_HOST, it always fails. It comes up with a "connection refused" error every single time. Hoping someone can help. I can send more info if it's needed, but here's the end of the log, where it errors out and closes. #39 {main} "} s6-rc: warning: unable to start service laravel-automations: command exited 1 /run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information. prog: fatal: stopping the container. In Connection.php line 822: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mysql fail ed: Name or service not known (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment` , engine as `engine`, table_collation as `collation` from information_schem a.tables where table_schema = 'db' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name) In Connector.php line 65: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mysql fail ed: Name or service not known In Connector.php line 65: PDO::__construct(): php_network_getaddresses: getaddrinfo for mysql failed: Name or service not known
January 29, 20242 yr I uninstalled MySQL & install MariaDB-Official, instead. I'm not getting a 'Connection refused' error. Instead, I'm getting an 'Access Denied' error. Again, I've verified that the dbname, username & passwords match. Log for Speedtest-Tracker: #36 {main} "} s6-rc: warning: unable to start service laravel-automations: command exited 1 /run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information. prog: fatal: stopping the container. In Connection.php line 822: SQLSTATE[HY000] [1045] Access denied for user 'dbuser'@'172.17.0.1' (using password: YES) (Connection: mysql, SQL: select table_name as `name`, (data_ length + index_length) as `size`, table_comment as `comment`, engine as `en gine`, table_collation as `collation` from information_schema.tables where table_schema = 'mydb' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name) In Connector.php line 65: SQLSTATE[HY000] [1045] Access denied for user 'dbuser'@'172.17.0.1' (using password: YES) Log for MariaDB: 2024-01-28 20:53:46 3 [Warning] Access denied for user 'dbuser'@'172.17.0.1' (using password: YES) 2024-01-28 20:54:31 4 [Warning] Access denied for user 'dbuser'@'172.17.0.1' (using password: YES) Edited January 29, 20242 yr by malaki86 Added log snippet
January 29, 20242 yr On 10/9/2023 at 7:57 PM, gamerkonks said: Hi there, I noticed my speedtest container wasn't working anymore and saw there's been some changes. Namely, no more sqlite support. I've deleted the old container and installed the new one (to bring in the new container mappings) and added the details to point it to my existing mariaDB instance, but I'm getting the following issue. It seems the container is using a completing different IP address to reach my DB than I've specified. My key: DB_HOST Value: 192.168.70.9 I see the following in the log. I'm not sure where it's getting 172.19.0.1 from. ``` In Connection.php line 801: SQLSTATE[HY000] [1045] Access denied for user 'speedtest'@'172.19.0.1' (usi ng password: YES) (Connection: mysql, SQL: select * from information_schema .tables where table_schema = speedtest_tracker and table_name = migrations and table_type = 'BASE TABLE') In Connector.php line 65: SQLSTATE[HY000] [1045] Access denied for user 'speedtest'@'172.19.0.1' (usi ng password: YES) ```` Did you find a fix for this? I'm having the exact same problem.
January 29, 20242 yr Author @malaki86 how did you setup the db ? you can use adminer to make sure and make sure the access is dbuser@%
January 29, 20242 yr 5 hours ago, ZappyZap said: @malaki86 how did you setup the db ? you can use adminer to make sure and make sure the access is dbuser@% I just filled in the blanks on the MariaDB setup. Gave it a new database name, username, userpass, and rootpass. I dont know what adminer is, or what "access is dbuser@%"
January 29, 20242 yr 5 minutes ago, malaki86 said: I just filled in the blanks on the MariaDB setup. Gave it a new database name, username, userpass, and rootpass. I dont know what adminer is, or what "access is dbuser@%" I found adminer and installed it. When I try to login, I get the same access denied error
January 29, 20242 yr Guys I have the container for long time, update it regularly (when there is an update), but haven't run it for a couple of months. So now that I start it, I get 500 error. What died?
January 29, 20242 yr Ok - I finally managed to get the database setup after a removal and clean install. You may want to describe the database installation as part of the tracker installation.
January 29, 20242 yr Author 4 hours ago, malaki86 said: Ok - I finally managed to get the database setup after a removal and clean install. You may want to describe the database installation as part of the tracker installation. You should raise this point to the app dev i will try to write something in the support thread
January 29, 20242 yr Author 4 hours ago, NLS said: Guys I have the container for long time, update it regularly (when there is an update), but haven't run it for a couple of months. So now that I start it, I get 500 error. What died? The app move from sqlite to mysql/mariadb. you you must provide a DB
January 29, 20242 yr 30 minutes ago, ZappyZap said: The app move from sqlite to mysql/mariadb. you you must provide a DB Thanks - but no thanks. I moved to another that is self contained. That said, if I get more containers that need a stand-alone DB, I might revisit.
January 29, 20242 yr Just now, NLS said: Thanks - but no thanks. I moved to another that is self contained. That said, if I get more containers that need a stand-alone DB, I might revisit. Which did you move to?
.thumb.jpg.bec61e4e919a9235cc4475f8cb53d5e3.jpg)
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.