Lazirus33 Posted December 13, 2023 Share Posted December 13, 2023 (edited) 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, 2023 by Lazirus33 Quote Link to comment
DWomack Posted December 14, 2023 Share Posted December 14, 2023 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 Quote Link to comment
Lazirus33 Posted December 14, 2023 Share Posted December 14, 2023 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? Quote Link to comment
DWomack Posted December 14, 2023 Share Posted December 14, 2023 (edited) Yes, I did. It is linuxserver mariadb. Edited December 14, 2023 by DWomack Add info Quote Link to comment
Lazirus33 Posted December 14, 2023 Share Posted December 14, 2023 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 Quote Link to comment
DWomack Posted December 14, 2023 Share Posted December 14, 2023 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 Quote Link to comment
Lazirus33 Posted December 15, 2023 Share Posted December 15, 2023 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 Quote Link to comment
J05u Posted December 16, 2023 Share Posted December 16, 2023 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. Quote Link to comment
Fearmonger Posted December 20, 2023 Share Posted December 20, 2023 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? Quote Link to comment
mattalat Posted December 21, 2023 Share Posted December 21, 2023 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. Quote Link to comment
ZappyZap Posted December 21, 2023 Author Share Posted December 21, 2023 (edited) 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, 2023 by ZappyZap Quote Link to comment
te5s3rakt Posted December 27, 2023 Share Posted December 27, 2023 what's the ALLOW_EMBED setting do? could this be used to present say the down/up graph in a homepage iframe? Quote Link to comment
KLLSWITCH Posted January 8 Share Posted January 8 (edited) 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 by KLLSWITCH Quote Link to comment
malaki86 Posted January 29 Share Posted January 29 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 Quote Link to comment
malaki86 Posted January 29 Share Posted January 29 (edited) 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 by malaki86 Added log snippet Quote Link to comment
malaki86 Posted January 29 Share Posted January 29 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. Quote Link to comment
ZappyZap Posted January 29 Author Share Posted January 29 @malaki86 how did you setup the db ? you can use adminer to make sure and make sure the access is dbuser@% Quote Link to comment
malaki86 Posted January 29 Share Posted January 29 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@%" Quote Link to comment
malaki86 Posted January 29 Share Posted January 29 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 Quote Link to comment
NLS Posted January 29 Share Posted January 29 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? Quote Link to comment
malaki86 Posted January 29 Share Posted January 29 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. 2 Quote Link to comment
ZappyZap Posted January 29 Author Share Posted January 29 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 Quote Link to comment
ZappyZap Posted January 29 Author Share Posted January 29 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 Quote Link to comment
NLS Posted January 29 Share Posted January 29 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. 1 Quote Link to comment
simcole Posted January 29 Share Posted January 29 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? Quote Link to comment
Recommended Posts
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.