Jump to content

Lazirus33

Members
  • Posts

    8
  • Joined

  • Last visited

Posts posted by Lazirus33

  1. 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

  2. 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?

  3. 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.

    Screenshot 2023-12-13 at 9.56.06 AM.png

  4. Edit: I was able to get it to work by installing mariadb and matching the setting from the docker_compose file. Then edited the Speedtest tracker Docker and also matched what was in the compose file and it finally came up. But I was with the understanding that when you install the docker from the community apps, that it should install the db along with the app. Also, once I got to the Web-UI, I logged in with the default creds and the page would return to the host/admin portal setup page. I ended up typing in myserverIP:9443/admin and it took me to the admin page and was able to run speedtests. Hope this helps.     P.S Timezone is set for my local time, however it keeps showing a negative next to the wrong time.

     

     

    Hello, I apologize in advance if this has already been addressed. Ive looked through and did not find a fix. I just recently installed the SpeedTest Tracker from the Community apps on Unraid. After the install, the docker comes up and then immediately goes back down. Any help would be appreciated, Here are the logs:

     

    ,
    --------------------------------------------------------------------,
    ,
     _______                       __ __                __,
    |     __|.-----.-----.-----.--|  |  |_.-----.-----.|  |_,
    |__     ||  _  |  -__|  -__|  _  |   _|  -__|__ --||   _|,
    |_______||   __|_____|_____|_____|____|_____|_____||____|,
             |__|,
     _______                   __,
    |_     _|.----.---.-.----.|  |--.-----.----.,
      |   |  |   _|  _  |  __||    <|  -__|   _|,
      |___|  |__| |___._|____||__|__|_____|__|,
    ,
    ,
    --------------------------------------------------------------------,
    ,
    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...,
    ,
     Environment file exists.,
    ,
    🔗  Creating symlinks for config and log files...,
     Symlinks created.,
    ,
     App key exists,
    ,
    🔒  Fixing app path file permissions...,
     Permissions fixed.,
    ,
    🔐  Linking the storage...,
     Storage linked.,
    ,
    💰  Building the cache...,
     Cache set.,
    ,
    🚛  Migrating the database...,
    ,
    In Connection.php line 760:,
                                                                                   ,
      SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from inform  ,
      ation_schema.tables where table_schema = speedtest_tracker and table_name =  ,
       migrations and table_type = 'BASE TABLE')                                   ,
                                                                                   ,
    ,
    In Connector.php line 70:,
                                                        ,
      SQLSTATE[HY000] [2002] No such file or directory  ,
                                                        ,
    ,
    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.,

  5. 32 minutes ago, KluthR said:

    Docker.img does not need being backed up.

     

     

    Thanks again for getting back to me, Is this something that I can disable to prevent it from failing? I dont see it anywhere

     

    Edit. I believe I figured that out, I added the file location of the docker.img to the exclude section. 

  6. Hey KluthR, Thanks for all you do! Since updating from the deprecated ver. Ive been continually getting the " "File changed as we read it" or "Contents differ" (during verification) " I just now tried changing the setting to yes on the compression, verify backup and Create separate archives. Ran another backup and it looks like its failing on the  Backing Up: docker.img, /usr/bin/tar: docker.img: file changed as we read it. I know you mentioned it at the header of the forum. But as far as I can tell, all of the dockers are shut while backing up, So im not sure what its referring to. Any help with this is appreciated. Below is the backup logs.

     

    [29.12.2022 13:31:05] Backup of appData starting. This may take awhile
    [29.12.2022 13:31:05] Stopping binhex-overseerr... done! (took 1 seconds)
    [29.12.2022 13:31:06] Stopping binhex-plexpass... done! (took 2 seconds)
    [29.12.2022 13:31:08] Stopping binhex-radarr... done! (took 0 seconds)
    [29.12.2022 13:31:08] Stopping binhex-sabnzbd... done! (took 1 seconds)
    [29.12.2022 13:31:09] Stopping binhex-sonarr... done! (took 0 seconds)
    [29.12.2022 13:31:09] Stopping SpeedTest-By-OpenSpeedTest... done! (took 11 seconds)
    [29.12.2022 13:31:20] Stopping speedtest-tracker... done! (took 4 seconds)
    [29.12.2022 13:31:24] Backing Up appData from /mnt/cache/AppData/ to /mnt/user/Backups/[email protected]
    [29.12.2022 13:31:24] Separate archives enabled!
    [29.12.2022 13:31:24] Ignoring: .
    [29.12.2022 13:31:24] Ignoring: ..
    [29.12.2022 13:31:24] Ignoring: binhex-nzbget
    [29.12.2022 13:31:24] Backing Up: binhex-overseerr
    [29.12.2022 13:31:24] Verifying Backup binhex-overseerr
    [29.12.2022 13:31:24] Backing Up: binhex-plexpass
    [29.12.2022 13:35:54] Verifying Backup binhex-plexpass
    [29.12.2022 13:37:55] Backing Up: binhex-radarr
    [29.12.2022 13:38:27] Verifying Backup binhex-radarr
    [29.12.2022 13:38:45] Backing Up: binhex-sabnzbd
    [29.12.2022 13:38:46] Verifying Backup binhex-sabnzbd
    [29.12.2022 13:38:46] Backing Up: binhex-sonarr
    [29.12.2022 13:38:55] Verifying Backup binhex-sonarr
    [29.12.2022 13:38:57] Backing Up: docker.img
    /usr/bin/tar: docker.img: file changed as we read it
    [29.12.2022 13:42:45] tar creation/extraction failed!
    [29.12.2022 13:42:45] Backing Up: speedtest-tracker
    [29.12.2022 13:42:45] Verifying Backup speedtest-tracker
    [29.12.2022 13:42:45] done
    [29.12.2022 13:42:45] Searching for updates to docker applications
    [29.12.2022 13:42:51] Starting binhex-overseerr... (try #1) done!
    [29.12.2022 13:42:54] Starting binhex-plexpass... (try #1) done!
    [29.12.2022 13:42:56] Starting binhex-radarr... (try #1) done!
    [29.12.2022 13:42:58] Starting binhex-sabnzbd... (try #1) done!
    [29.12.2022 13:43:01] Starting binhex-sonarr... (try #1) done!
    [29.12.2022 13:43:03] Starting SpeedTest-By-OpenSpeedTest... (try #1) done!
    [29.12.2022 13:43:05] Starting speedtest-tracker... (try #1) done!
    [29.12.2022 13:43:07] A error occurred somewhere. Not deleting old backup sets of appdata
    [29.12.2022 13:43:07] Backup / Restore Completed 

    • Upvote 1
×
×
  • Create New...