A trick used by me today to quickly found the few remaining spammers:
in the PGSQL DB :
select id,username,domain,display_name,avatar_file_name from accounts where username ~ '^[0-9a-z]{10}$' AND username=display_name and created_at > '2024-02-15 00:00:00' and suspended_at IS NULL AND avatar_file_name IS NULL limit 100;
Then from the obtained file :
for i in $(cat piaille-spam.txt|awk '{print $1}' ) ; do xdg-open "https://piaille.fr/admin/accounts/$i"; sleep 6 ; done
and check manually and block ;)
MastodonDE
Mastodon für die DACH Region (Deutschland, Österreich, Schweiz) - and everyone is welcome!Mastodon hosted on mastodon.de
Hast mal nen Euro für mastodon.de? 
Spende gerne über folgende Methoden:
• 
Liberapay • 
Ko-Fi • 
Patreon • 
PayPal
Direkte Banküberweisung (keine Gebühren):
IBAN: DE36283500000145760443
BIC: BRLADE21ANO
Kontoinhaber: Uden UG (haftungsbeschraenkt)
Setz die Memo / Referenz als "Spende für mastodon.de"
Erklärung der Kosten (276,84 €/Monat) in deutsch und englisch.
Du kannst auch unseren offiziellen Twitch-Kanal abonnieren oder das kostenlose Prime-Abonnement nutzen um uns geldlich zu unterstützen, ohne, dass es dich etwas kostet!
Danke, dass du mastodon.de unterstützt!
Solidarische Grüße,
@Emily, @ErikUden & @Sleagle 
🤎🧡💛💚💙💜
Get more from mastodon.de on Patreon
Mastodon für die DACH Region (Deutschland, Österreich, Schweiz)mastodon.de (Patreon)
Hast mal nen Euro für mastodon.de?
Spende gerne über folgende Methoden:
• Liberapay • Ko-Fi • Patreon • PayPal
Direkte Banküberweisung (keine Gebühren):
IBAN: DE36283500000145760443
BIC: BRLADE21ANO
Kontoinhaber: Uden UG (haftungsbeschraenkt)
Setz die Memo / Referenz als "Spende für mastodon.de"
Erklärung der Kosten (276,84 €/Monat) in deutsch und englisch.
Du kannst auch unseren offiziellen Twitch-Kanal abonnieren oder das kostenlose Prime-Abonnement nutzen um uns geldlich zu unterstützen, ohne, dass es dich etwas kostet!
Danke, dass du mastodon.de unterstützt!
Solidarische Grüße,
@Emily, @ErikUden & @Sleagle
🤎🧡💛💚💙💜
Get more from mastodon.de on Patreon
Mastodon für die DACH Region (Deutschland, Österreich, Schweiz)mastodon.de (Patreon)
Interested in supporting this instance?
Feel free to donate using one of the below links:
• Liberapay • Ko-Fi • Patreon • PayPal
Direct Bank Transfer (no fees):
IBAN: DE36283500000145760443
BIC: BRLADE21ANO
Account holder: Uden UG (haftungsbeschraenkt)
Set your Memo / Reference as “Donation for mastodon.de”
Explanation of these operating expenses (276.84 €/Month) in English and German.
You can also subscribe to our official Twitch channel or use your Prime Sub free of charge!
Thank you for supporting mastodon.de!
Kind regards,
@Emily, @ErikUden & @Sleagle
🤎🧡💛💚💙💜
Get more from mastodon.de on Patreon
Mastodon für die DACH Region (Deutschland, Österreich, Schweiz)mastodon.de (Patreon)
Informationsabend Queere Pflege
Verdi (Bezirk Mittleres Ruhrgebiet, Bochum, Herne Recklinghausen) veranstaltet morgen in in der Verdi-Geschäftsstelle Recklinghausen einen Informationsabend zum Thema queere Pflege: »Das Pflegebündnis Recklinghausen und die Gewerkschaft ver.di laden herzlich alle Beschäftigten in der Altenpflege und Interessierte zu einer Informationsveranstaltung zum Thema "Queere
einer freundin wurde vor kurzem in berlin friedrichshain dieses fahrrad geklaut. das lenkerband war zuletzt braun. sollte es euch begegnen, würden wir uns über hinweise freuen
boost wäre nett. danke
🆘 ~51 Pers., darunter 27 Kinder, landeten heute früh auf #Kastellorizo! Sie melden, dass sie medizinische Hilfe benötigen
Hellenic Coast Guard & Hellenic Police sind informiert. Die Hafenpolizei von Kastellorizo wollte #AlarmPhone nicht mitteilen, ob eine Suche eingeleitet wurde.
🆘 Auf #Kalymnos benötigen ~18 Personen Hilfe!
Die Gruppe bat #AlarmPhone gestern um Hilfe und medizinische Versorgung. Seitdem sind sie nicht mehr zu erreichen. Die örtl. Polizeistation sagte Alarm Phone, sie sollten die Hafenpolizei anrufen, die aber nicht ans Telefon ging.
Palestinians and Jews for Peace
Im Rahmen Aktionstage gegen Antisemitismus und Rassismus findet morgen, am 30.10. von 18 bis 20 Uhr in der Ruhr-Uni ein Panel statt zum Krieg in Nahost und dem Diskurs darüber hierzulande: »Bei unserem Panel Talk sprechen wir über den Krieg in Israel / Palästina und darüber, wie er die Menschen vor Ort, aber auch uns in Deutschland beeinflusst.
Der Diskurs übe
We were not first & won't be last whose ship was confiscated because we rescued people in distress at sea. Unlike others, we have the means & opportunities to defend ourselves. Tomorrow is the first hearing in our civil lawsuit! SOLIDARITY & RESISTANCE
🆘 ~50 Leben im zentralen #Med in Gefahr!
#AlarmPhone hat die Behörden über eine Gruppe in Not informiert, die von #Libyen Richtung #Kreta geflohen ist. Sie berichteten von sich verschlechternden Wetterbedingungen und hohem Wellengang, der ein Weiterkommen unmöglich macht.
Handelsschiffe befinden sich in der Nähe. Der Kapitän der BTG MISTI sagt, dass es keine Anweisungen von Behörden gibt; die sog. 'Libyan Coastguard' koordiniert keine Rettung und gibt an, nach dem Boot zu suchen.
1/x
2/2
Erik Uden => ErikUden@mastodon.de
Als Antwort auf Erik Uden => ErikUden@mastodon.de • • •2023.06.26 — The Last Piece of the Puzzle
We’ve just successfully purchased a MikroTik hEX S RB760IGS router which we needed as an L2TP client to connect to our noBGP IP tunnel! This concludes our quest for finding the right hardware, meaning we now have ALL hardware necessary to build #MastodonDE!
Now all we need to do is transport parts of that hardware from Frankfurt to our secure location, which will happen on the 29th and the 30th of June.
So, on the 1st of July we will begin assembling everything which will take 10-14 days (80 work hours). Nick has assembled a full plan that is attached to this post detailing every step necessary for building the complex server infrastructure that will host MastodonDE (in German)!
MastodonDE is becoming more and more a reality with every minute that passes!
... mehr anzeigen2023.06.26 — The Last Piece of the Puzzle
We’ve just successfully purchased a MikroTik hEX S RB760IGS router which we needed as an L2TP client to connect to our noBGP IP tunnel! This concludes our quest for finding the right hardware, meaning we now have ALL hardware necessary to build #MastodonDE!
Now all we need to do is transport parts of that hardware from Frankfurt to our secure location, which will happen on the 29th and the 30th of June.
So, on the 1st of July we will begin assembling everything which will take 10-14 days (80 work hours). Nick has assembled a full plan that is attached to this post detailing every step necessary for building the complex server infrastructure that will host MastodonDE (in German)!
MastodonDE is becoming more and more a reality with every minute that passes!
Erik Uden => ErikUden@mastodon.de
2023-06-26 17:14:31
Erik Uden => ErikUden@mastodon.de
Als Antwort auf Erik Uden => ErikUden@mastodon.de • • •2023-06-27 — A Surprise to Be Sure, But a Welcome One
Yesterday something amazing happened! Sarah (@sarah) from Servperso Systems, a one-person-ISP, offered to give us a noBGP IP tunnel for free for a year in order to help kickstart #MastodonDE!
She is heavily in support of Mastodon and wants to help hobbyists like us to make a better community for everyone!
Please support her back by going to servperso.net/ and considering Servperso Systems as a BGP VM/Tunnel, IP Transit, or NoBGP IPv4 provider! You’d absolutely be supporting the right person.
7.26€/Month for a noBGP IPv4 tunnel is an awesome deal.
Once again, thank you SO much Sarah, the MastodonDE team will forever be in your debt 🙏!
♥ AS34872 & AS208210 ♥
Servperso Systems - BGP & LIR Services for small network operators
www.servperso.netErik Uden => ErikUden@mastodon.de
Als Antwort auf Erik Uden => ErikUden@mastodon.de • • •2023-06-28 - All Done and Dusted - Clock’s Ticking
Two nice things happened today! For starters: Around 14:00 GMT+1 we received the MikroTik hEX S router fully operational and in original packaging. If we had ordered it through Amazon we’d be lucky if it were to arrive even in the month of July!
Thanks to that anonymous individual who sold it on eBay, Nick will be able to set up the IP tunnel on the original device and not bring his own and then transfer the configuration to the correct MikroTik router once it arrives (which was our backup plan).
The OTHER more important thing that was finally done today is the DECLUTTERING (entrümpeln) / clearing out of the secure location. I took the measurements of the rack and found the perfect spot to put it with an ethernet Internet connection and unused power source nearby.
This took all day and I’m super exhausted. Really, we (me and my dad @Wall_E
... mehr anzeigen2023-06-28 - All Done and Dusted - Clock’s Ticking
Two nice things happened today! For starters: Around 14:00 GMT+1 we received the MikroTik hEX S router fully operational and in original packaging. If we had ordered it through Amazon we’d be lucky if it were to arrive even in the month of July!
Thanks to that anonymous individual who sold it on eBay, Nick will be able to set up the IP tunnel on the original device and not bring his own and then transfer the configuration to the correct MikroTik router once it arrives (which was our backup plan).
The OTHER more important thing that was finally done today is the DECLUTTERING (entrümpeln) / clearing out of the secure location. I took the measurements of the rack and found the perfect spot to put it with an ethernet Internet connection and unused power source nearby.
This took all day and I’m super exhausted. Really, we (me and my dad @Wall_E) began this morning at 08:30 and JUST finished at 21:22. We’re far from done with clearing the whole site, but at least the place we need is nice and clean.
Tomorrow, with my train starting at 04:51 in the morning, I will drive to Frankfurt to pick up the final pieces of hardware that cannot be transported by a car. I will arrive in Frankfurt by 13:38 if all goes well, so I will most likely really arrive around 15:00. The next day, Friday the 30th of June 2023, I will go back home starting 05:21 AM from the Frankfurt central station arriving 15:05 if all goes to plan.
Nick will join me a day later, July 1st 2023. Mark this date, folx! July 1st 2023 is the day when all pieces of the puzzle and all key figures will be located in the exact right spot to build #MastodonDE. That day will mark the beginning of the 80 hour two week journey that is creating the monstrosity known as a huge general purpose Mastodon instance. Although the plan to make this instance already began in January this year, the execution to full construct it will begin in THREE DAYS!
Erik Uden => ErikUden@mastodon.de
Als Antwort auf Erik Uden => ErikUden@mastodon.de • • •2023-06-29 — Loading Up all the Pieces (1/2)
As the date where construction will begin comes closer and closer (JULY 1ST, IN TWO DAYS), I’ve traveled all the way to Frankfurt to help Nick sort all his server / networking components, load them up to his car, and also to carry the rack back to our secure location in Norden by train in an escapade beginning 3:00 AM tomorrow. Or rather today, as I am writing this at 2:00 AM in the morning, as that’s how long it took to load up all the servers.
Erik Uden => ErikUden@mastodon.de
Als Antwort auf Erik Uden => ErikUden@mastodon.de • • •2023-06-29 — Loading Up all the Pieces (2/2)
I’ve met with @Emily at the Frankfurt central station ~14:00, we were picked up by Nick at ~15:00, we ate a currywurst, drove to Nick’s home ~17:00, turned everything upside down to put it all sorted and well into Nick’s car. We also carried the rack from their allotments (Schrebergarten) to their home and finished round about now at 02:00 AM on the 30th of June.
Soooo, considering my train is leaving today in three hours rom the Frankfurt central station AND I haven’t slept yet AND it takes ~40 minutes to get to the Frankfurt central station, it’s gonna be another wild night.
Erik Uden => ErikUden@mastodon.de
Als Antwort auf Erik Uden => ErikUden@mastodon.de • • •2023-06-30 — RACK TRAVEL STORY
1st picture: 04:01 AM - Nick’s house
2nd picture: 04:14 AM - Tram station
3rd picture: 04:23 AM - Tram
4th picture: 04:50 AM - Frankfurt Central
5th picture: 05:06 AM - RE30 to Kassel
6th picture: 07:31 AM - RE30 to Kassel
7th picture: 07:41 AM - RB83 to Göttingen
More pictures to follow as the rack continues to travel across Germany!