Skip to main content

friendica - Link to source

FYI #fediverse
#friendica #databse #Fedi.Tips !Friendica Support !Friendica Admins !Friendica Developers

reshared this

in reply to pasjrwoctx👽

Fae Empress
friendica - Link to source
Fae Empress
• •
I'm getting NXDOMAIN when trying to access activitypub-troll.cf

reshared this

in reply to Fae Empress

pasjrwoctx👽
friendica - Link to source
pasjrwoctx👽
• •
@Fae Empress I did too, I was going to just do an ip block, but nslookup activitypub-troll.cf ** server can't find activitypub-troll.cf: NXDOMAIN so I had to temporally shutdown my instance, and do a lot of fast homework and cleaning, and blocking, what I did, at the moment seems to be working, I fear as the fediverse grows, so will the troubles with keeping up with this, but its really no different than back when everyone got online through a cd rom, and bombed each others computers through im and chat rooms the difference today is, the bad actors have vast resources and us little people, have to walk a fine line between blocking everything and letting just enough in to stay connected.
@Fae Empress

reshared this

in reply to pasjrwoctx👽

utopiArte
friendica - Link to source
utopiArte
• •

The real problem is that we might end up with positive connection lists instead of negative listing of servers.
I guess we all start to think about how tor create some kind of fediWeb of trust where we mutually confirm and integrate servers into our permitted server lists. Even maybe some kind of rules set for new servers restricting their access and bumping some allow request to the server admin for a domain and/or IP?
🤔

Where are the main problems for us as friendicans?
(Forum) profile pages that allow automatic following and any kind of automatic manually unapproved connections?
Well no, as interaction with public posts always is possible, some kinda emergency beak for spamming would be needed.

Gif of Marvin, the paranoid android, coming down in an elevator stating that he considers that all ought to know that he feels very depressed.

reshared this

in reply to pasjrwoctx👽

OldKid ⁂
friendica - Link to source
OldKid ⁂
• •

@pasjrwoctx

Go to /moderation/blocklist/server and enter *.activitypub-troll.cf in ‘Add new blocklist entry’. Then click ‘Check pattern’.
In the new window that opens, click ‘Remove server’ and, if you wish, enter a reason. Finally, click ‘Add pattern to blocklist’.
Then *.activitypub-troll.cf and all its subdomains will be blocked.

Once that's done, you just have to delete the corresponding entries from the database.

mysql -u [user_name] -p[password] [database_name]

SELECT COUNT(*) FROM gserver where nurl LIKE ‘%.activitypub-troll.cf’;

DELETE from gserver where nurl LIKE ‘%.activitypub-troll.cf’ LIMIT 1000000;

OPTIMIZE TABLE gserver;

EXIT;
@pasjrwoctx👽

reshared this

in reply to OldKid ⁂

Anomaly
friendica - Link to source
Anomaly
• •

@OldKid ⁂ @pasjrwoctx
My friendica database is 15 GB , I tried to follow your advice but i have error

sudo mysql
use myfriendicadb;
SELECT COUNT(*) FROM gserver where nurl LIKE ‘%.activitypub-troll.cf’;

Error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-troll.cf’' at line 1

@OldKid ⁂ @pasjrwoctx👽

reshared this

in reply to OldKid ⁂

Anomaly
friendica - Link to source
Anomaly
• •
@OldKid ⁂ @pasjrwoctx
I solved it, it was a problem when I did the copy and paste, it didn't copy the correct formatting my database has shrunk by 600MB 😅 , thanks
@OldKid ⁂ @pasjrwoctx👽

reshared this