I just spent 3 hours cleaning my #Friendica #databse, I got flooded by activitypub-trollcf and well lets just say that was not fun. !Friendica Admins !Friendica Developers !Friendica Support be safe #Fedi.Tips

sql
CREATE TABLE blocklist (
id INT AUTO_INCREMENT PRIMARY KEY,
domain VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

UPDATE `gserver` SET `blocked` = TRUE WHERE `url` LIKE '%activitypub-troll.cf%';

DELETE FROM `workerqueue` WHERE `parameter` LIKE '%activitypub-troll.cf%';

DELIMITER $$
CREATE TRIGGER before_insert_workerqueue
BEFORE INSERT ON `workerqueue`
FOR EACH ROW
BEGIN
IF NEW.parameter LIKE '%activitypub-troll.cf%' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Insert of activitypub-troll.cf is not allowed';
END IF;
END$$
DELIMITER ;

DELETE FROM `workerqueue` WHERE `done` = 1;
DELETE FROM `workerqueue` WHERE `done` = 0;

htasccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{HTTP_REFERER} activitypub-troll\.cf
[NC]RewriteCond %{REMOTE_HOST} activitypub-troll\.cf
[NC]RewriteCond %{HTTP_USER_AGENT} activitypub-troll\.cf
[NC]RewriteRule .* -
[F]</IfModule>

I just spent 3 hours cleaning my #Friendica #databse, I got flooded by activitypub-trollcf and well lets just say that was not fun. !Friendica Admins !Friendica Developers !Friendica Support be safe #Fedi.Tips

sql
CREATE TABLE blocklist (
id INT AUTO_INCREMENT PRIMARY KEY,
domain VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

UPDATE `gserver` SET `blocked` = TRUE WHERE `url` LIKE '%activitypub-troll.cf%';

DELETE FROM `workerqueue` WHERE `parameter` LIKE '%activitypub-troll.cf%';

DELIMITER $$
CREATE TRIGGER before_insert_workerqueue
BEFORE INSERT ON `workerqueue`
FOR EACH ROW
BEGIN
IF NEW.parameter LIKE '%activitypub-troll.cf%' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Insert of activitypub-troll.cf is not allowed';
END IF;
END$$
DELIMITER ;

DELETE FROM `workerqueue` WHERE `done` = 1;
DELETE FROM `workerqueue` WHERE `done` = 0;

htasccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{HTTP_REFERER} activitypub-troll\.cf
[NC]RewriteCond %{REMOTE_HOST} activitypub-troll\.cf
[NC]RewriteCond %{HTTP_USER_AGENT} activitypub-troll\.cf
[NC]RewriteRule .* -
[F]</IfModule>

I just spent 3 hours cleaning my #Friendica #databse, I got flooded by activitypub-trollcf and well lets just say that was not fun. !Friendica Admins !Friendica Developers !Friendica Support be safe #Fedi.Tips

sql
CREATE TABLE blocklist (
id INT AUTO_INCREMENT PRIMARY KEY,
domain VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

UPDATE `gserver` SET `blocked` = TRUE WHERE `url` LIKE '%activitypub-troll.cf%';

DELETE FROM `workerqueue` WHERE `parameter` LIKE '%activitypub-troll.cf%';

DELIMITER $$
CREATE TRIGGER before_insert_workerqueue
BEFORE INSERT ON `workerqueue`
FOR EACH ROW
BEGIN
IF NEW.parameter LIKE '%activitypub-troll.cf%' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Insert of activitypub-troll.cf is not allowed';
END IF;
END$$
DELIMITER ;

DELETE FROM `workerqueue` WHERE `done` = 1;
DELETE FROM `workerqueue` WHERE `done` = 0;

htasccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{HTTP_REFERER} activitypub-troll\.cf
[NC]RewriteCond %{REMOTE_HOST} activitypub-troll\.cf
[NC]RewriteCond %{HTTP_USER_AGENT} activitypub-troll\.cf
[NC]RewriteRule .* -
[F]</IfModule>

@Friendica Support

Hi there,
testing around with the software #castopod, developed by @Castopod 😛odcasting2: .

In general terms federation with #friendica works, even integration into public forum pages and reshare by those when the castopod profile is followed by the forum page in the first place, as tested with the forum page @podCasts. As of now following from castopod profiles apparently isn't implemented. Also as of now we didn't manage to get the cron job to work at that new instalation on a shared hosting.

What is strange is that a podcast episode publication doesn't embeed the audio player so it can't be reproduced inside the post shown over here on friendica. On mastodon this works, the post displayes a video like screen and reproduces the audio file.

Not sure if this is a specific issue of this friendica instance as it is stil 2023.05 or if this is something the latest versions experience to.

The uploaded audio file was in the format m4a.

This is the link to the original post:
https://cast.tupambae.com/@bitPickup/posts/d88b27ab-c8c2-461d-9ec6-ac684af2908f

Link to a mastodon instance where the post can be seen:
https://troet.cafe/@bitpickup/113875013233253536

Link to this site here where the audio is not displayed but only a link:
https://tupambae.org/display/db58d9ad-f363bd74ed16681c-f66973c5

!Friendica Developers !Friendica Support As of right now I am not sure if my #Friendica instance is working across the #fediverse as I am not seeing much engagement at all, and more than half of who I am following, I am not receiving their #feeds at all, and at this point I am clueless as to what is going on or how to deal with, because I dont know what is wrong, or if anything is wrong.

VersionFriendica 'Interrupted Fern' 2025.02-dev - 1576
Server Settings
PHP
version 8.1.31
php.ini /opt/alt/php81/etc/php.ini
upload_max_filesize 256M
post_max_size 256M
memory_limit 512M
MySQL / MariaDB
max_allowed_packet 268435456

I am not seeing much engagement, more so I am not seeing posts of those I follow across the fediveres, and I know several post a few times a day, but I am not seeing much activity at all, any ideas on what may be going on would be great, and please any directions please make very simple to understand, brain issues, sometimes I struggle grasping things that should be easy. If it matters, I am in cPanel on shared hosting, so not root access to anything.

https://social.2ndshot.photos/profile/pasjrwoctx pasjrwoctx@social.2ndshot.photos

Friendica Installation

Ich versuche gerade die #Fediverse Anwendung #Friendica auf meinem #Raspberry Pi 5 in einem #Podman #Container zu installieren. Aber bei der Datenbank ist Schluss. da bleibt es hängen. Weiß jemand Rat? @Friendica Support zum Beispiel?

version: "3.7"

services:

  mariadb:
    image: docker.io/library/mariadb:latest
    restart: always
    volumes:
      - mydb:/var/lib/mysql
    ports:
      - "6033:3306"
    environment:
      MYSQL_ROOT_PASSWORD: *****
      MYSQL_DATABASE: friendica
      MYSQL_USER: friendica
      MYSQL_PASSWORD: *****

  phpmyadmin:
    container_name: phpmyadmin_9092
    image: docker.io/library/phpmyadmin:latest
    restart: always
    ports:
      - "9092:80"
    environment:
      - PMA_ARBITRARY=1
      - PMA_HOST=mariadb
    depends_on:
      - mariadb

  app:
    image: docker.io/library/friendica
    container_name: friendica_9093
    restart: always
    volumes:
      - friendica:/var/www/html    
    ports:
      - "9093:80"
    environment:
      - MYSQL_HOST=mydb
      - MYSQL_USER=friendica
      - MYSQL_PASSWORD=*****
      - MYSQL_DATABASE=friendica
      - FRIENDICA_ADMIN_MAIL=*****
    depends_on:
      - mariadb

volumes:
  mydb:
  friendica:

networks:
  proxy-tier:

TROM in numbers

Some TROM numbers!

TROM.tf

Social (friendica): we have 1.100 users and this year it was a record of sane registrations. Still the majority of accounts are likely not active. Our database is around 50GB in size and we store 23GB of files.

Files (nextcloud): we have 100 users and 81 of them are active. We store a total of 370GB of files. We are still able to provide trade-free accounts with 10GB storage space for each.

Chat (matrix): around 500 users, 22GB of files stored and a 200GB database (too big, needs optimization). Unsure how many of these users are active but we are using this for our own TROM chats every single day.

Videos (peertube): 1.400 users, 2.800 videos stored with a total of 400.000 views and 1TB in size. Unfortunately only a few users are active and uploading but this is our main TROM hub for videos and we will do our best to keep it alive and grow it.

In total our TROM.tf provides 17 services and is around 2TB in size. We do daily backups of the system with Timeshift (some 1.2TB) plus daily backups of our files and services to Borg.

—————–

TROMjaro : This year we have coded from ground up our own custom made Layout and Theme Switcher apps and made them better. We are still managing a library of over 600 curated trade-free apps and have released a new ISO almost every single month!

—————–

TROMnews : This year we did a major upgrade to the website. We made it a lot better, more diverse, and relevant. Every month there are thousands of items that are posted to this website.

—————–

VideoNeat : Since 2012 we kept this website relevant and updated. We have over 1.300 documentaries/courses available trade-free!

—————–

Trade-Free Directory : We have over 750 entries in the directory, manually added and reviewed. A must have database of wonderful projects that we will use more in the future. We are trying to add more to the directory whenever we have time.

—————–

TROMSite : Do not forget that we are still providing 2 huge documentaries, over 30 books, and many videos. All trade-free, all full of relevant information. The hope is that we will start to create new content soon!

Lastly, we are almost half way with the support we need to keep these projects alive and relevant! 94 out of 200 people are donating 5 Euros a month! https://tromsite.com/donate Thank you so much!

If we are not going to fight for a different kind of world, offline or online, and walk the talk, then nothing, for sure, will ever change. We are trying to change the online landscape bit by bit, by providing trade-free, saner services, and scientific content. We need this more than ever in today’s idiotic society.

#trom #tromsite #foss #opensource #peertube #nextcloud #friendica #xfce #linux #tromjaro #capitalism #society

#capitalism #foss #friendica #linux #nextcloud #opensource #peertube #society #tromjaro #tromsite #xfce

Some TROM numbers!

TROM.tf

Social (friendica): we have 1.100 users and this year it was a record of sane registrations. Still the majority of accounts are likely not active. Our database is around 50GB in size and we store 23GB of files.

Files (nextcloud): we have 100 users and 81 of them are active. We store a total of 370GB of files. We are still able to provide trade-free accounts with 10GB storage space for each.

Chat (matrix): around 500 users, 22GB of files stored and a 200GB database (too big, needs optimization). Unsure how many of these users are active but we are using this for our own TROM chats every single day.

Videos (peertube): 1.400 users, 2.800 videos stored with a total of 400.000 views and 1TB in size. Unfortunately only a few users are active and uploading but this is our main TROM hub for videos and we will do our best to keep it alive and grow it.

In total our TROM.tf provides 17 services and is around 2TB in size. We do daily backups of the system with Timeshift (some 1.2TB) plus daily backups of our files and services to Borg.

-----------------

TROMjaro : This year we have coded from ground up our own custom made Layout and Theme Switcher apps and made them better. We are still managing a library of over 600 curated trade-free apps and have released a new ISO almost every single month!

-----------------

TROMnews : This year we did a major upgrade to the website. We made it a lot better, more diverse, and relevant. Every month there are thousands of items that are posted to this website.

-----------------

VideoNeat : Since 2012 we kept this website relevant and updated. We have over 1.300 documentaries/courses available trade-free!

-----------------

Trade-Free Directory : We have over 750 entries in the directory, manually added and reviewed. A must have database of wonderful projects that we will use more in the future. We are trying to add more to the directory whenever we have time.

-----------------

TROMSite : Do not forget that we are still providing 2 huge documentaries, over 30 books, and many videos. All trade-free, all full of relevant information. The hope is that we will start to create new content soon!

Lastly, we are almost half way with the support we need to keep these projects alive and relevant! 94 out of 200 people are donating 5 Euros a month! https://tromsite.com/donate Thank you so much!

If we are not going to fight for a different kind of world, offline or online, and walk the talk, then nothing, for sure, will ever change. We are trying to change the online landscape bit by bit, by providing trade-free, saner services, and scientific content. We need this more than ever in today's idiotic society.

#trom #tromsite #foss #opensource #peertube #nextcloud #friendica #xfce #linux #tromjaro #capitalism #society