Zum Inhalt der Seite gehen


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

Friendica Admins hat dies geteilt.

Als Antwort auf 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 hat dies geteilt.

Als Antwort auf 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.

Friendica Admins hat dies geteilt.

Als Antwort auf 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 hat dies geteilt.

Als Antwort auf silverwizard

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

Friendica Admins hat dies geteilt.

Als Antwort auf silverwizard

sometimes volumes stick around and get reused, but I'll assume you got it

Friendica Admins hat dies geteilt.

Als Antwort auf 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 hat dies geteilt.

Als Antwort auf 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 hat dies geteilt.

Als Antwort auf zeitverschreib [friendica]

@zeitverschreib [friendica] @silverwizard is the DB container running? Can you exec into the DB container to make sure the DB user and password works?

Friendica Admins hat dies geteilt.

Als Antwort auf 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 hat dies geteilt.