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:
-
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
-
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