Hey all, I've been trying to get up and running with Friendica in a docker container behind Nginx Proxy Manager and connected to a separate MariaDB container.

The scenario that I have is that the only combination I've gotten to work to connect to Friendica is to use the alpine docker image with the complete web server, as putting configs into separate nginx instances wasn't getting me anywhere. However, using the full image, I can get to the UI and do the install to set things that I already set in env variables(?) whatever.

But what happens is that when it goes to save, it fails to save to the DB and maria db says that it rejected the connection for unauthenticated user and unknown host (implying to me that it rejected the connection before it even pulled this info). But the thing is that I've been able to shell into the friendica container and connect to the MariaDB. I can use adminer and log in as the friendica user to the friendica db that I created. Has anyone run in to this?

I'm starting to wonder if I need to use actual MySQL, maybe? This is a very strange issue as I've been able to create the database, user with privileges, and log in as that user. The host name for the user is '%', so 'friendica'@'%'.

I'd appreciate any help that I could get there.

you are viewing a single comment's thread
view the rest of the comments

[–] JASN_DE@feddit.org 2 points 4 weeks ago (6 children)

How did you set it up? Docker compose? Can you post your config?

[–] RagingHungryPanda@lemm.ee 2 points 4 weeks ago* (last edited 2 weeks ago) (5 children)

Thank you for the help. Here is the last set of configurations that I was running.
Edit: this is running on my TrueNas server.

networks:
  maria-db-network:
    external: True
services:
  friendica:
    build: /mnt/MainStorage/apps/friendica/config/app
    environment:
      - FRIENDICA_ADMIN_MAIL=<admin email>
      - FRIENDICA_TZ=America/Chicago
      - FRIENDICA_LANG=en-US
      - FRIENDICA_URL=https://friendica.mydomain.com/
      - FRIENDICA_SITENAME=My Friendica
      - SMTP=<the smtp>
      - SMTP_DOMAIN=<smtp domain
      - SMTP_FROM=admin
      - SMTP_AUTH_USER=<le user>
      - SMTP_AUTH_PASS=<auth pass>
      - SMTP_TLS=true
      - SMTP_STARTTLS=true
      - MYSQL_PASSWORD=<db pass>
      - MYSQL_DATABASE=friendica
      - MYSQL_USER=friendica
      - MYSQL_HOST=mariadb
      - MYSQL_PORT=3306
    image: friendica
    networks:
      - maria-db-network
    ports:
      - '30110:80'
    volumes:
      - /mnt/MainStorage/apps/friendica/data:/var/www/html
      - /mnt/MainStorage/apps/friendica/config/app:/app

addon.config.php file:

<?php

return [
	'system' => [
		'cache_driver' => 'redis',
		'lock_driver' => 'redis',

		'redis_host' => 'redis',

		'pidfile' => '/var/run/friendica.pid',
	]
];

docker file in the config folder

FROM friendica:friendica

RUN mkdir -p /usr/src/config
COPY addon.config.php /usr/src/config/

[–] RagingHungryPanda@lemm.ee 2 points 4 weeks ago

Now that I'm looking at it again, I wonder if I can get rid of some of this stuff 🤔

load more comments (4 replies)