2023-02-20 07:59:29
2023-02-14 18:40:55
2023-02-14 18:40:55
24024857
error 500 and nothing in the logs :-(
Hi @Friendica Support
friendica quits with an error 500 (internal error) and don not show anything special in the logs...
What can I do?
last entry in the application logs is from yesterday evening, it's a warning
2023-02-13T23:01:51Z worker [WARNING]: Invalid URL {"dirtyUrl":"https://https:mastodon.social","worker_id":"3facd10","worker_cmd":"UpdateGServer"} - {"file":"GServer.php","line":509,"function":"cleanURL","request-id":"63eac0f5978a0","uid":"b8b1b6","process_id":17853}
php_error log after restarting the php service:
[14-Feb-2023 19:22:03] NOTICE: configuration file /opt/uberspace/etc/punkrock/php-fpm.conf test is successful
[14-Feb-2023 19:22:03] NOTICE: using inherited socket fd=3, "/run/php-fpm-punkrock.sock"
[14-Feb-2023 19:22:03] NOTICE: fpm is running, pid 6089
[14-Feb-2023 19:22:03] NOTICE: ready to handle connections
[14-Feb-2023 19:22:03] NOTICE: systemd monitor interval set to 10000ms
apache_error log:
[Tue Feb 14 07:32:31 2023] [error] [pid 17898] proxy_util.c(3178): (111)Connection refused: [client -] AH02454: FCGI: attempt to connect to Unix domain socket /run/php-fpm-punkrock.sock (php-fpm-punkrock:8000) failed
[Tue Feb 14 07:32:31 2023] [error] [pid 17898] mod_proxy_fcgi.c(1198): [client 195.201.0.0] AH01079: failed to make connection to backend: httpd-UDS
I have absolutly no idea how to debug this.
I'm on the dev branch.
Friendica Support hat dies geteilt.
Matthias Moritz
Unbekannter Ursprungsbeitrag • •@Peter Schlager
I this helpful?
Friendica Support hat dies geteilt.
Matthias Moritz
Als Antwort auf Matthias Moritz • •any other ideas how to debug this?
Friendica Support hat dies geteilt.
Philipp Holzer
Als Antwort auf Matthias Moritz • • •system.url
andconfig.hostname
in yourconfig/local.config.php
? There's a new exception if this entries are missingMatthias Moritz mag das.
Friendica Support hat dies geteilt.
Matthias Moritz
Als Antwort auf Philipp Holzer • •@Philipp Holzer @Peter Schlager
yes.
Friendica Support hat dies geteilt.
Philipp Holzer
Als Antwort auf Matthias Moritz • • •php bin/console.php config system url
Friendica Support hat dies geteilt.
Matthias Moritz
Als Antwort auf Philipp Holzer • •Friendica Support hat dies geteilt.
Philipp Holzer
Als Antwort auf Matthias Moritz • — (48.2083537 16.3725042) • •OK this doesn't look right! it seems like it's tripple serialized
Can you echo the following SQL command in your Friendica namespace:
SELECT `v` FROM `config` WHERE `cat` = "system" AND `k` = "url"
And can you check if there're more "multi-serialized" entries in the Database?
There has to be just one prefix like
s:48
(for string) ora:2
(for array) or similar prefix for each value.Matthias Moritz mag das.
Friendica Support hat dies geteilt.
Matthias Moritz
Als Antwort auf Philipp Holzer • •@Philipp Holzer @Peter Schlager
I think there are More! I'll check that tomorrow.
Philipp Holzer mag das.
Friendica Support hat dies geteilt.
Matthias Moritz
Unbekannter Ursprungsbeitrag • •Friendica Support hat dies geteilt.
Matthias Moritz
Als Antwort auf Matthias Moritz • •@Roland Häder @Philipp Holzer
all int, bool, strings were affected of this. it was double, triple or even 4 times serialized.
I did now a manual cleanup for 200 lines in the db and WOW, the instance is online 😀
Thank you for the support.
github.com/friendica/friendica…
Multipe serialized configurations in the database · Issue #12803 · friendica/friendica
GitHubmögen das
Raroun und Philipp Holzer mögen das.
Friendica Support hat dies geteilt.
Philipp Holzer
Als Antwort auf Matthias Moritz • • •@Roland Häder - I introduced an auto-fix for multi-serialized values 😀
mögen das
Raroun und Matthias Moritz mögen das.
Friendica Support hat dies geteilt.