Doc Edward Morbius

2021-01-16 22:06:01

Diaspora Podmins: Please be help prevent and rapidly address abusive network activity

@MondiAspora Podmin and other podmins: Please be aware that "Ivan Zlax" is a serial sockpuppet spaming harrasser now creating spoof identities on open pods to specifically harrass those reporting on their activities.

Accounts typically include a gorilla profile avatar and the name "ivan zlax" or "zlax ivan", increasingly with non-ASCII characters (e.g., Cyrillic "а") to avoid simple text search.

A recent extensive listing:
https://joindiaspora.com/posts/82638e60380e013926147085c2fdcc0b

Please consider closing registrations or manually approving them.

Please remove accounts and all associated content (typically principally comments), some of which is now reported to contain pornography and/or CP.

Few pods prominently name or report their pod admins. Doing so, or providing unambiguous Diaspora and email reporting addresses is strongly encouraged as a global practice. Yes, I'm aware these are spambait.

Sadly, it only takes one asshat to ruin things for many.

Thank you.

#PodMin #IvanZlax

Vengeur Masqué

2020-12-24 11:17:00

#diaspora #spam #troll #ban #podmin

Sigh! #zlax is back again. New version of the script. I guess it is better to run it regularly until the guy gets tired.

# Load diaspora environment                                                                                                                                                                                                                                                                                                  
ENV["RAILS_ENV"] ||= "production"
require_relative "config/environment"

for toxic in [ 'vm666@diaspora.ruhrmail.de', 'ivan_exlax@pod.dapor.net ', 'zlax@%', 'zlaxyizlax@%' ] do
  puts "Blocking and cleaning #{toxic}"

  local_spammers, remote_spammers = Person.where("diaspora_handle LIKE ?", toxic).where(closed_account: false).partition(&:local?)

# Retract all comments of local spammers and close their accounts                                                                                                                                                                                                                                                            
local_spammers.each do |spammer|
  Comment.where(author_id: spammer.id).each do |comment|
    puts "delete #{comment.guid} from post #{comment.parent.guid}"
    spammer.owner.retract(comment)
  end
  spammer.owner.close_account!
end

# Retract all spam comments on posts of local users and delete the rest                                                                                                                                                                                                                                                      
Comment.where(author_id: remote_spammers.map(&:id)).each do |comment|
  puts "delete #{comment.guid} from post #{comment.parent.guid}"
  post_author = comment.parent.author
  if post_author.local?
    post_author.owner.retract(comment)
  else
    comment.destroy
  end
end

# Close accounts of remote users if wanted                                                                                                                                                                                                                                                                                   
remote_spammers.each do |spammer|
  puts "close account #{spammer.diaspora_handle}"
  #AccountDeleter.new(spammer.diaspora_handle).perform!                                                                                                                                                                                                                                                                      
  spammer.update_column(:serialized_public_key, "BLOCKED")
  puts "closed account #{spammer.diaspora_handle}"
end

end

Vengeur Masqué

2020-12-24 12:14:02

#diaspora #spam #troll #ban #podmin

#zlax is such a huge #PITA. Third version of the cleaner script. I hope it won't do innocent victims.I guess it will have to run by cron regularly until hell freezes and Zlax tires.

\#!/usr/bin/env ruby

# Load diaspora environment
ENV["RAILS_ENV"] ||= "production"
require_relative "config/environment"

toxic_accounts = Person.find_by_substring('ivan zlax')
toxic_list = toxic_accounts.map { |z| z.diaspora_handle }
toxic_list.append('vm66%@diaspora.ruhrmail.de', 'ivan_exlax@pod.dapor.net ', 'zlax@%', 'zlaxyizlax@%')
puts toxic_list.inspect
\#exit

for toxic in toxic_list do
  puts "Blocking and cleaning #{toxic}"

  local_spammers, remote_spammers = Person.where("diaspora_handle LIKE ?", toxic).where(closed_account: false).partition(&:local?)

# Retract all comments of local spammers and close their accounts
local_spammers.each do |spammer|
  Comment.where(author_id: spammer.id).each do |comment|
    puts "delete #{comment.guid} from post #{comment.parent.guid}"
    spammer.owner.retract(comment)
  end
  spammer.owner.close_account!
end

# Retract all spam comments on posts of local users and delete the rest
Comment.where(author_id: remote_spammers.map(&:id)).each do |comment|
  puts "delete #{comment.guid} from post #{comment.parent.guid}"
  post_author = comment.parent.author
  if post_author.local?
    post_author.owner.retract(comment)
  else
    comment.destroy
  end
end

# Close accounts of remote users if wanted
remote_spammers.each do |spammer|
  puts "close account #{spammer.diaspora_handle}"
  #AccountDeleter.new(spammer.diaspora_handle).perform!
  spammer.update_column(:serialized_public_key, "BLOCKED")
  puts "closed account #{spammer.diaspora_handle}"
end

end

Dennis Schubert

2020-12-14 04:42:08

If you are a #podmin running a #diaspora pod on PostgreSQL, you should look into upgrading to version 13. These are runserver response times for Geraspora, the yellow line represents the average response times, the green line represents the the 99.9 percentile. The blue marker is the point I upgraded from pg12 to pg13. There was no other change to the environment, and since we've had a weekend just now, the amount of requests per second and the server load even went up slightly.

As you'll notice, the peaks went down significantly, but even the average response time went down by a considerable amount. Parallel autovacuuming and the performance improvements around b-tree indexes and aggregate/grouping queries is clearly help stream queries a lot. Not enough to significantly change the responsiveness for users, but still noteworthy.

(Ignore that one peak in the night of 2020-12-11 to 2020-12-12, that was a unlucky coincidence with autovac running while the server was running its "aw crap an entirely new database"-backup, so that always causes some locking issues.)