Skip to main content


Is there any #Friendica admin out there reading this who's running their instance on a #Synology NAS using the setup instructions by Marius?

mariushosting.com/how-to-insta…

I seem to have a problem. Or two, I don't know.

The install finishes without errors and the instance is up and running. But: the global timeline is always empty, even though I can follow and also DM outside accounts.

Checking the logs of the cron and db containers, I see this:

Cron:

Waiting for MySQL friendica-db initialization...

DB:

...
2024-12-14 21:11:02 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: '172.22.0.5' (This connection closed normally without authentication)
2024-12-14 21:10:00 0 [Note] Plugin 'wsrep-provider' is disabled.
Version: '11.4.4-MariaDB-ubu2404' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-12-14 21:10:04 0 [Note] Server socket created on IP: '::'.
2024-12-14 21:10:05 0 [Note] mariadbd: ready for connections.
2024-12-14 21:10:05 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-12-14 21:10:04 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-12-14 21:10:02 0 [Note] InnoDB: Buffer pool(s) load completed at 241214 21:10:02

I guess the timelines are empty because cron is waiting for the db to initialize.

What am I missing?

Thanks in advance.

@Friendica Admins @mariush

in reply to zeitverschreib [friendica]

@zeitverschreib [friendica] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: '172.22.0.5' (This connection closed normally without authentication)
that line looks like you are trying to connect to a remote database rather than one on the same server, without a user? So the DB isn't initializing because the credentials/location are wrong? Probably some passwords don't match in step 13?

Friendica Admins reshared this.

in reply to silverwizard

@silverwizard The database is in a different container on the same docker installation. I copied the script from Marius' page and only changed the instance URL and admin mail address.

On my first try, I issued new passwords for redis, db, etc. Same problem. I then used the script verbatim, to make sure that I didn't introduce any password issues.

All containers created by the script have separate IPs.

This entry was edited (4 months ago)

Friendica Admins reshared this.

in reply to zeitverschreib [friendica]

@zeitverschreib [friendica] I wonder if the passwords were persisted to the volume? It might be you need to destroy the volume and restart?

Friendica Admins reshared this.

in reply to silverwizard

@silverwizard Also tried that, I deleted everything and started from scratch. But I will try again. :-)

Friendica Admins reshared this.

in reply to silverwizard

@silverwizard After a re-install I still see problems with the db connect:

2024-12-14 22:26:04 9 [Warning] Aborted connection 9 to db: 'friendica' user: 'friendicauser' host: '172.23.0.5' (Got an error reading communication packets)
2024-12-14 22:22:38 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.23.0.4' (This connection closed normally without authentication)
2024-12-14 22:23:08 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '172.23.0.5' (This connection closed normally without authentication)
2024-12-14 22:26:05 64 [Warning] Aborted connection 64 to db: 'unconnected' user: 'unauthenticated' host: '172.23.0.5' (This connection closed normally without authentication)

172.23.0.4 is the Friendica container
172.23.0.5 is the CRON container

Something's very wrong.

Friendica Admins reshared this.

in reply to zeitverschreib [friendica]

I just tried to run the same setup on a Pi 4 and get the very same messages:

Version: '11.4.4-MariaDB-ubu2404' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-12-14 23:09:21 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '172.21.0.5' (This connection closed normally without authentication)
2024-12-14 23:08:52 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.21.0.4' (This connection closed normally without authentication)

Friendica Admins reshared this.

in reply to zeitverschreib [friendica]

Thinking about this again (sorry for delay). Can you open an terminal for the cron container and try to ping the database? Does it say anything when doing so?

Friendica Admins reshared this.