Spotweb in Container Manager on Synology NAS

1. VenimK

   I guess this is wrong

   cat dbsettings.inc.php
   <?php
   $dbsettings['engine'] = getenv('DB_ENGINE') ?: 'pdo_mysql';
   $dbsettings['host'] = sprintf('%s:%s', getenv('DB_HOST') ?: 'mysql', getenv('DB_PORT') ?: '3306');
   $dbsettings['dbname'] = getenv('DB_NAME') ?: 'spotweb';
   $dbsettings['user'] = getenv('DB_USER') ?: 'spotweb';
   $dbsettings['pass'] = getenv('DB_PASS') ?: 'spotweb';

   # 26 August 2023 Reply
   • Dr_Frankenstein

     Hey, it should reflect the details you add to the compose file. Worst case delete the container and run the project again.

     # 26 August 2023 Reply
2. rugah

   Hello,

   I have used your manual to set this up, and everything is up and running, so thank you! The only problem that I have: if I setup my nzbget, I don’t get the green arrow. I have tested, and if I choose sabnzb, the green arrow is there, but I don’t use sabnzb. I hope you can help me with this.

   Regards

   # 22 August 2023 Reply
   • Dr_Frankenstein

     Hey – I have not actually tried that feature, I use the NZB Unity add on for Firefox to pass the details to Sab/NZBGet

     # 22 August 2023 Reply
3. VenimK

   Yes, created the SynoBridge network

   phpMyAdmin has 172.20.0.4
   MariaDb has 172.20.0.2

   both on the Synobridge Gateway

   # 17 August 2023 Reply
   • Dr_Frankenstein

     Also if doing via Portainer it takes a minute for the database to initially be setup, can you try doing via the Projects feature first in line with the guide.

     # 17 August 2023 Reply
4. Christiaan

   Hi Dr_Frankenstein,

   I am running Spotweb based on your install guide. Many thanks. But I have the same problem as mentioned at FAQ: “My Spots only seem to be populating from the day I set up Spotweb”

   You refering to this page
   https://drfrankenstein.co.uk/spotweb-not-backfilling/

   First step is to add a code to the project.. But surprisingly the Project page is empty, I also have not installed PHPadmin.. PHPAdmin was not in the guide too… strange the Spotweb is working fine, but only problem with the backfilling

   Can you help me?

   # 7 August 2023 Reply
   • Dr_Frankenstein

     Hey, so you should be able to follow the steps in the additional FAQ page and it will get you pulling the extra years of Spots

     # 8 August 2023 Reply
5. Tyndell

   Shoud I still use the mariadb section if I already have MariaDB running as a container? I have it running for shared kodi db.

   # 26 July 2023 Reply
   • Dr_Frankenstein

     Hey – Yes you can use the existing one if you like.

     # 26 July 2023 Reply
     • Tyndell

       But if use the mariadb sections in the yaml i’ll be creating a seperate mariadb container for spotweb right?

       Sorry for the extra questions, the whole docker/container expierence is still a bit of a deepdive for me :).

       # 26 July 2023 Reply
       • Dr_Frankenstein

         You would remove that section and then fill out the appropriate username and password for your existing MariaDB install. There is no harm in running multiple versions if you want to just run with the Docker version as well. You will just need to adjust the external 3306 port to something higher such as 3307:3306.

         # 26 July 2023 Reply
         • VenimK

           Hi

           I made it with portainer/compose
           Can make everything to work, except PhpMyAdmin, can’t ‘ login

           services:
           mariadb:
           image: mariadb:latest
           container_name: mariadb
           environment:
           – MYSQL_ROOT_PASSWORD=StRoNgPa55WoRd
           – PUID=1000
           – PGID=1000
           – TZ=Europe/London
           – MYSQL_DATABASE=spotweb
           – MYSQL_USER=Ausername
           – MYSQL_PASSWORD=AnotherPassword
           volumes:
           – /volume1/docker/mariadb:/var/lib/mysql
           ports:
           – 3346:3306
           network_mode: synobridge
           restart: unless-stopped

           spotweb:
           image: erikdevries/spotweb
           container_name: spotweb
           environment:
           – TZ=Europe/London
           – DB_PORT=3346
           – DB_HOST=172.20.0.1
           – DB_NAME=spotweb
           – DB_USER=Ausername
           – DB_PASS=AnotherPassword
           ports:
           – 8085:80
           network_mode: synobridge
           depends_on:
           – mariadb
           restart: unless-stopped

           phpmyadmin:
           image: phpmyadmin/phpmyadmin:latest
           hostname: phpmyadmin
           container_name: phpmyadmin
           environment:
           – PMA_HOST=172.20.0.1
           ports:
           – 3309:80/tcp
           network_mode: synobridge
           depends_on:
           – mariadb
           restart: unless-stopped

           Message I get is
           mysqli::real_connect(): (HY000/2002): Connection refused

           # 16 August 2023 Reply
           • Dr_Frankenstein

             Hey – do you have the synobridge network setup / make sure the PMA Host / DB Host IPs are correct if doing via Portainer..

             # 16 August 2023 Reply
             • Maarten

               Thank you very much or your time and effort. You’re a big help!!

               I was gettting “acces denied” for PHPMyAdmin.
               Changed the setting in the YAML to “PMA_HOST=spotweb_db” and now it’s working 100%

               Thanks again!!

               # 20 June 2024 Reply
               • Dr_Frankenstein

                 OK good idea, I have adjusted the yaml 🙂

                 # 20 June 2024 Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.