Url:

[http://www.lauraritchie.com/.well-known/webfinger]

Remote connection: [193.30.122.67:38678]

Headers: [array (

  'Host' => 'http://www.lauraritchie.com',

  'user-agent' => 'Friendica 'Red Hot Poker' 2021.01-1384; https://f.praschnig.com',

  'accept-encoding' => 'deflate, gzip, br',

  'accept' => 'application/jrd+json',

  'host' => 'http://www.lauraritchie.com',

  'BN-Frontend' => 'captcha-https',

  'X-Forwarded-Port' => '443',

  'X-Forwarded-Proto' => 'https',

  'BN-Client-Port' => '52532',

  'X-Forwarded-For' => '193.30.122.67',

)]

Get data: [Array

(

    [resource] => acct:la###@###ww.com

)

]

Ich habe eine Abuse-Meldung, welche meine Friendica-Instanz betrifft. Folgende Log-Informationen wurden angehängt:

Url:

[http://www.lauraritchie.com/.well-known/webfinger]

Remote connection: [193.30.122.67:38678]

Headers: [array (

  'Host' => 'http://www.lauraritchie.com',

  'user-agent' => 'Friendica 'Red Hot Poker' 2021.01-1384; https://f.praschnig.com',

  'accept-encoding' => 'deflate, gzip, br',

  'accept' => 'application/jrd+json',

  'host' => 'http://www.lauraritchie.com',

  'BN-Frontend' => 'captcha-https',

  'X-Forwarded-Port' => '443',

  'X-Forwarded-Proto' => 'https',

  'BN-Client-Port' => '52532',

  'X-Forwarded-For' => '193.30.122.67',

)]

Get data: [Array

(

    [resource] => acct:la###@###ww.com

)

]

Ich kann sehr wenig bis nichts damit anfangen. Vor allem fällt mir auf, dass diese Logeinträge gar nicht aktuell sein können, da ich diese Instanz nach Erscheinen gleich auf 2021.4 updatete.

Was meint ihr dazu?

#Abuse-Meldung #abuse #friendica #bitninja

!Friendica Support

Commands:
	cache                  Manage node cache
	config                 Edit site config
	createdoxygen          Generate Doxygen headers
	dbstructure            Do database updates
	docbloxerrorchecker    Check the file tree for DocBlox errors
	extract                Generate translation string file for the Friendica project (deprecated)
	globalcommunityblock   Block remote profile from interacting with this node
	globalcommunitysilence Silence a profile from the global community page
	archivecontact         Archive a contact when you know that it isn't existing anymore
	help                   Show help about a command, e.g (bin/console help config)
	autoinstall            Starts automatic installation of friendica based on values from htconfig.php
	lock                   Edit site locks
	maintenance            Set m

For those stumbling over the baracuda warning message for the #Friendica update, Friendicas own bin/console has a command for this:

Commands:
	cache                  Manage node cache
	config                 Edit site config
	createdoxygen          Generate Doxygen headers
	dbstructure            Do database updates
	docbloxerrorchecker    Check the file tree for DocBlox errors
	extract                Generate translation string file for the Friendica project (deprecated)
	globalcommunityblock   Block remote profile from interacting with this node
	globalcommunitysilence Silence a profile from the global community page
	archivecontact         Archive a contact when you know that it isn't existing anymore
	help                   Show help about a command, e.g (bin/console help config)
	autoinstall            Starts automatic installation of friendica based on values from htconfig.php
	lock                   Edit site locks
	maintenance            Set maintenance mode for this node
	user                   User management
	php2po                 Generate a messages.po file from a strings.php file
	po2php                 Generate a strings.php file from a messages.po file
	typo                   Checks for parse errors in Friendica files
	postupdate             Execute pending post update scripts (can last days)
	serverblock            Manage blocked servers
	storage                Manage storage backend
	relay                  Manage ActivityPub relay servers

When you enter bin/console dbstructure now, it will show you:

console dbstructure - Performs database updates
Usage
	bin/console dbstructure <command> [options]

Commands
    drop     Show tables that aren't in use by Friendica anymore and can be dropped
       -e|--execute    Execute the dropping

    update   Update database schema
       -f|--force      Force the update command (Even if the database structure matches)
       -o|--override   Override running or stalling updates

    dryrun   Show database update schema queries without running them
    dumpsql  Dump database schema
    toinnodb Convert all tables from MyISAM or InnoDB in the Antelope file format to InnoDB in the Barracuda file format
    initial  Set needed initial values in the tables
    version  Set the database to a given number

General Options
    -h|--help|-?       Show help information
    -v                 Show more debug information.

The command you're looking for is:

bin/console dbstructure toinnodb

If there is no tables like this it will just output that.


!Friendica Admins

Hallo @Friendica Support ,
vor kurzem habe ich mich getraut, bei meinem bisher erfolgreichsten Langzeit-Test mit Friendica bei Shared-Hostern ein Update von 2020.09-1 auf 2021.01 zu versuchen.
Das Update erfolgt wie vor kurzem auch bei Joseph Hogan beschrieben über einen Upload der entpackten Archiv-Files und Übernahme der local.config.php und der .htaccess. Dieser Prozess ist auf Github unter Friendica > Releases beschrieben.

Wie vielfach hier im Forum gelesen, gibt es Probleme - mutmaßlich beim Datenbank-Update. Möglicherweise auch aufgrund von Limitierungen beim Shared-Hoster.
Das Login in die Instanz funktioniert, aber alle Bilder sind verschwunden. Die liegen übrigens im Filesystem und nicht in der Datenbank.

Die Admin-Oberfläche zeigt
bei Datenbank > DB Updtaes > Datenbankstruktur überprüfen

Fehler 1050 beim Update der Datenbank aufgetreten Table './k145584_dfriendica/notify@002dthreads' already exists Fehler 1050 beim Update der Datenbank aufgetreten Table './k145584_dfriendica/post@002dcategory' already exists
Das Update 1384 der Struktur der Datenbank schlug mit folgender Fehlermeldung fehl: Fehler beim Ändern der Datenbank aufgetretenALTER TABLE `notify-threads` MODIFY `master-parent-item` int unsigned COMMENT '', ADD INDEX `master-parent-item` (`master-parent-item`), ADD FOREIGN KEY (`master-parent-item`) REFERENCES `item` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE, ADD FOREIGN KEY (`master-parent-uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE;
Fehler beim Ändern der Datenbank aufgetretenALTER TABLE `post-category` ADD INDEX `uid` (`uid`), ADD FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE;

und bei Information > Übersicht

Das Update der Datenbank ist fehlgeschlagen. Bitte führe 'php bin/console.php dbstructure update' in der Kommandozeile aus und achte auf eventuell auftretende Fehlermeldungen.
Das letzte Update ist fehlgeschlagen. Bitte führe "php bin/console.php dbstructure update" auf der Kommandozeile aus und werfe einen Blick auf eventuell auftretende Fehler. (Zusätzliche Informationen zu Fehlern könnten in den Logdateien stehen.)

An der Konsole liefert der Befehl

php bin/console.php dbstructure update

die Fehlermeldung

[Error] Missing database structure config file static/dbstructure.config.php

Die bemängelte Datei dbstructure.config.php existiert allerdings.

Ich weiß, dass Instanzen bei Shared-Hostern hier unbeliebt sind und vermutlich unterliegt der Konsolen-Zauber beim derzeitigen Hoster Netcup Einschränkungen, aber vielleicht lässt sich dica.interfel.de auch reanimieren.

Einem Impuls folgend habe ich das Update angestoßen und bin bereit die Instanz jederzeit platt zu machen und durch eine neue zu ersetzen (Backups der Nutzer existieren).
Vielleicht erneut bei Netcup, auf einem Raspi oder auch mal bei uberspace.de

#friendica #shared #hosting

#introductions Better late than never, I'm Hypolite Petovan, this isn't my official name but it is my real name for all intents and purposes. I joined the #Fediverse on #Diaspora then #Friendica late 2016 after #Facebook froze my account for using this pseudonym for 10 years straight.

My social media policy is to read absolutely everything my follows post. As a result, I heavily curate my follow list that will never grow bigger than what it is now mainly for time constraints. Additionally, I don't automatically follow back and unfollowing isn't personal, your content just doesn't fit with my social media usage, no hard feelings.

I like liberally to signify I read, enjoyed or sympathize with a post without having anything meaningful to contribute further.

I also block liberally, users and whole instances alike, the world is too big and my time is too limited to give a second chance to bigots, racists, misogynists and transphobes (including TERFs). I host my own single-user node which makes any moderation decision easy.

My own editorial line is mainly about good-natured humor and social justice. Tone-wise, I do not mind aggressiveness but I do mind who it is targeted at. I do not tolerate edgy shitpost, and neither bad faith nor logical fallacies no matter how soft-spoken they are.

My personal interests revolve around #programming (mainly #PHP for #Friendica ), #videogames and recently #LEGO, but I'm curious about everything and have trouble specializing in anything and don't follow the latest news for any specific topic.

Hi! 👋

The performance footprint of the translation system in #Friendica is actually quite small. The translation itself is performed by humans in the Transifex project page at https://transifex.com/friendica (requires a free account), but then we manually convert the resulting translations into a native PHP array. The translation system then is mostly a simple file loading and array lookups which aren't costly.

Now, the base translation strings are in English, mostly. The problem is that many were written by people whose primary language isn't English. So some people created American English and British English translations to fix the quirks of the base translation strings with regard to the respective local language.

From then on, the base translation strings have become little more than mere identifiers, generally improper to be displayed as is, and enhanced by the translated strings in either English languages.

However, even if these base translation strings could have been used on their own, the performance gain from not having a translated string array to load in memory and look up would be minimal.