Setting up FreshRSS in Dockge with own MariaDB server

My TrueNAS 24.10 setup currently has several Apps from the IX community running, including Dockge and FreshRSS. I have been gradually moving away from the IX apps to ones I’ve composed in Dockage, as I have more control over them this way.

Prior to this, I set up a Piwigo container, with the Piwigo app / image, and a MariaDB app / image to support it. That is working smoothly.

Now, I want to deploy a FreshRSS container, with the FreshRSS app, and its own MariaDB app as well (my logic being, I don’t want a potential issue with one app to impact other apps, and I can delete or roll back each one individually). However, I am running into two challenges:

  1. FreshRSS cannot connect to the MariaDB app. I am assuming this is because I changed the port for the new instance of MariaDB, and I am not sure if I specified this correctly for FreshRSS to connect to it

  2. When I browse to the FreshRSS instance, I get “Connection Refused.”

Below is my Compose file - any guidance in what to tweak to get it running would be appreciated.

version: "2.4"
volumes:
  data: null
  extensions: null
services:
  freshrss:
    image: freshrss/freshrss:edge
    container_name: freshrss-app
    restart: unless-stopped
    logging:
      options:
        max-size: 10m
    volumes:
      - /mnt/data/apps/freshrss/data:/var/www/FreshRSS/data # Recommended volume for FreshRSS persistent data such as configuration and SQLite databases
      - /mnt/data/apps/freshrss/extensions:/var/www/FreshRSS/extensions # Optional volume for storing third-party extensions
    ports:
      - 30029:80
    environment:
      CRON_MIN: 2,17,32,47
      FRESHRSS_INSTALL: |-
        --api-enabled
        --base-url https://rss.aiskon.net
        --db-host freshrss-db:3307
        --db-password REDACTED1
        --db-type mysql
        --db-user freshrss
        --default_user admin
        --language en
      FRESHRSS_USER: |-
        --api-password REDACTED2
        --email gjschaller@gmail.com	
        --language en
        --password REDACTED3
        --user Geoffreey
  mariadb:
    image: lscr.io/linuxserver/mariadb:latest
    container_name: freshrss-db
    environment:
      - PUID=999
      - PGID=999
      - TZ=America/New_York
      - MYSQL_ROOT_PASSWORD=REDACTED4
      - MYSQL_DATABASE=freshrss
      - MYSQL_USER=freshrss
      - MYSQL_PASSWORD=REDACTED1
    volumes:
      - /mnt/data/apps/freshrss/database:/config
    ports:
      - 3307:3306
    restart: unless-stopped
networks: {}

Output from the Dockge terminal, if this will help:

freshrss-db   | 2024-11-25 15:43:08 0 [Note] Starting MariaDB 10.11.10-MariaDB-log source revision 3d0fb150289716ca75cd64d62823cf715ee47646 server_uid qY1TIOUCFVfBFz71K6kut64NEYA= as process 182
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Number of transaction pools: 1
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
freshrss-db   | 2024-11-25 15:43:08 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Using Linux native AIO
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Completed initialization of buffer pool
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: End of log at LSN=46846
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: 128 rollback segments are active.
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: log sequence number 46846; transaction id 14
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
freshrss-db   | 2024-11-25 15:43:08 0 [Note] Plugin 'FEEDBACK' is disabled.
freshrss-db   | 2024-11-25 15:43:08 0 [Note] InnoDB: Buffer pool(s) load completed at 241125 15:43:08
freshrss-db   | 2024-11-25 15:43:08 0 [Note] Server socket created on IP: '0.0.0.0'.
freshrss-db   | 2024-11-25 15:43:08 0 [Note] Server socket created on IP: '::'.
freshrss-db   | 2024-11-25 15:43:08 0 [Note] mariadbd: ready for connections.
freshrss-db   | Version: '10.11.10-MariaDB-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Alpine Linux
freshrss-db   | 2024-11-25 15:43:10 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
freshrss-db   | 2024-11-25 15:43:10 0 [Note] InnoDB: FTS optimize thread exiting.
freshrss-db   | 2024-11-25 15:43:10 0 [Note] InnoDB: Starting shutdown...
freshrss-db   | 2024-11-25 15:43:10 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool
freshrss-db   | 2024-11-25 15:43:10 0 [Note] InnoDB: Buffer pool(s) dump completed at 241125 15:43:10
freshrss-db   | 2024-11-25 15:43:10 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
freshrss-db   | 2024-11-25 15:43:10 0 [Note] InnoDB: Shutdown completed; log sequence number 46846; transaction id 16
freshrss-db   | 2024-11-25 15:43:10 0 [Note] mariadbd: Shutdown complete
freshrss-db   | 
freshrss-db   | Database Setup Completed
freshrss-db   | [custom-init] No custom files found, skipping...
freshrss-db   | 241125 15:43:11 mysqld_safe Logging to '/config/databases/019080cddda8.err'.
freshrss-db   | 241125 15:43:11 mysqld_safe Starting mariadbd daemon with databases from /config/databases
freshrss-db   | Connection to localhost (::1) 3306 port [tcp/mysql] succeeded!
freshrss-db   | [ls.io-init] done.
freshrss-app  | FreshRSS deprecation warning: the CLI option(s): default_user are deprecated and will be removed in a future release. Use: default-user instead
freshrss-app  | FreshRSS install…
freshrss-app  | FreshRSS database error: Access to database is denied for `freshrss`: SQLSTATE[HY000] [2002] Connection refused
freshrss-app  | ❌ FreshRSS error during installation!
freshrss-app exited with code 0