Skip to main content

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

Friendica Support reshared this.

Unknown parent

Matthias Moritz
Matthias Moritz
• •

@Peter Schlager

I this helpful?

@Peter Schlager

Friendica Support reshared this.

in reply to Matthias Moritz

Matthias Moritz
Matthias Moritz
• •
@Peter Schlager after restarting php this error is gone. But still have just a blank start page and no info in the logs :-(
any other ideas how to debug this?
@Peter Schlager

Friendica Support reshared this.

in reply to Matthias Moritz

Philipp Holzer
Philipp Holzer
•
did you set system.url and config.hostname in your config/local.config.php ? There's a new exception if this entries are missing

Friendica Support reshared this.

in reply to Matthias Moritz

Philipp Holzer
Philipp Holzer
•
hmm .. what happened if you execute a command, like php bin/console.php config system url

Friendica Support reshared this.

in reply to Philipp Holzer

Matthias Moritz
Matthias Moritz
• •
@Philipp Holzer @Peter Schlager 
[punkrock@libra html]$ php bin/console.php config system url
system.url => s:48:"s:40:"s:32:"https://punkrock-underground.com";";";
@Philipp Holzer @Peter Schlager

Friendica Support reshared this.

in reply to Matthias Moritz

Philipp Holzer
Philipp Holzer
 — (Vienna) •
OK this doesn't look right! it seems like it's tripple serialized

  • s:48 ..
  • s:40 ..
  • S:32 ..



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) or a:2 (for array) or similar prefix for each value.

Friendica Support reshared this.

Unknown parent

Matthias Moritz
Matthias Moritz
• •
@Roland HĂ€der @Philipp Holzer Ok, I checkt this and yes, there are triple serialized values for nearly all configurations.
@Philipp Holzer @Roland HĂ€der

Friendica Support reshared this.

in reply to Matthias Moritz

Matthias Moritz
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.

https://github.com/friendica/friendica/issues/12803

Multipe serialized configurations in the database · Issue #12803 · friendica/friendica

There were stange configs in the database that leads to Error 500 It was like [punkrock@libra html]$ php bin/console.php config system url system.url => s:48:"s:40:"s:32:"https://...
GitHub
@Philipp Holzer @Roland HĂ€der
This entry was edited (1 year ago)

Friendica Support reshared this.

⇧