friendica - Link to source

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


How to Install Friendica on Your Synology NAS

Trustworthy expert guide to your Synology NAS.
Marius Hosting
#friendica #synology @Friendica Admins
in reply to zeitverschreib [friendica]

friendica - Link to source

silverwizard

@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

friendica - Link to source

zeitverschreib [friendica]

@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 and password issues.

All containers created by the script have separate IPs.

@silverwizard
in reply to silverwizard

friendica - Link to source

zeitverschreib [friendica]

@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.

@silverwizard
in reply to zeitverschreib [friendica]

friendica - Link to source

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)
⇧