DISPERSION

Many people ask me why I have accounts on multiple diaspora* pods (I currently have seven). When the project launched in 2010, and then passed into community hands in 2012, I was heavily involved, primarily working on translating the interface. I was then absent for an extended period and am now (as I like to say) coming home.
The truth is, since diaspora* is a federated and decentralized network, each pod’s database grows from user interaction. The more interactions there are between users from different pods, the greater the reach of each published post.
I know it’s part of my obsession and my love for diaspora*, but it’s also a way to quietly improve the network.
So don’t worry if I follow you from multiple accounts. 😀

DISPERSIÓN

Mucha gente me pregunta por qué tengo cuentas en varios pods de diaspora* (actualmente tengo siete). Cuando se lanzó el proyecto en 2010, y luego pasó a manos de la comunidad en 2012, estuve muy involucrado trabajando principalmente en la traducción de la interfaz. Luego estuve ausente un tiempo prolongado y ahora estoy (como me gusta decir) volviendo a casa.
Lo cierto es que, al ser diaspora* una red federada y descentralizada, la base de datos de cada pod se nutre de la interacción entre los usuarios. Cuando mayor cantidad de interacciones haya entre usuarios de distintos pods, mayor será la dispersión de cada post publicado.
Sé que es parte de mi locura y de mi amor por diaspora*, pero también es una forma de mejorar la red de manera silenciosa.
Así que no se preocupen si los sigo desde varias cuentas. 😀

#diaspora #pods #dispersion #socialnetwork #social #hello #hola #newhere #freedom #freesoftware #posts #love #mywork #fediverse #podmin #question #publish #home #account #database #network #followme #followyou #users

@faghy diaspo

Hi! Yes, I just changed my name and also my username. Yes, this means what you think it means! But don't worry, I'm still the old person.

I know that diaspora* doesn't have UI support for account migrations yet, but I feel a strong obligation now to document how to make that happen.

All your contacts, all your posts, all your comments etcetc will be transferred to your new account automagically. Your contacts will just see your new profile, and it's almost like nothing changed - except for your name, of course. ❤ The following steps only work if you want to stay on the same pod but change your username - if you want to switch to a different pod, please reach out to me (that's also already possible, but the process is different).

You need to create your new account first, so do that. You need to set all the profile details on your own, but don't bother with adding contacts. Then, tell your podmin to do the rest. Please note that as soon as those steps are complete, your old account will be marked as closed.

As a podmin, you need to open a Rails console (bin/rails c inside the diaspora* directory) and then run a few commands:

# First, we need to load the old and new users from the database
old_user = User.find_by(username: "old_username")
new_user = User.find_by(username: "new_username")

# This creates a manual AccountMigration entity. This would usually be done
# by the importer, but there's no reason we can't do this on our own!
migration = AccountMigration.new(
  old_person:             old_user.person,
  new_person:             new_user.person,
  old_private_key:        old_user.serialized_private_key,
  old_person_diaspora_id: old_user.diaspora_handle,
  archive_contacts:       old_user.contacts
)

# Next, we need to save the AccountMigration entity in the database...
migration.save!

# ... and then run it. This might take a few moments depending on the account!
migration.perform!

I will tag this with #diaspora and #podmin so that people have a chance to see this. Sorry if you feel that's inappropriate, but I don't really care. Also, very special thanks to @Benjamin Neff who helped me with this, since I wasn't very confident in how our migrations actually work. ❤

🏳️‍🌈🏳️‍⚧️🏳️‍🌈

Diaspora spam

SQL

SELECT current_sign_in_ip, COUNT(username)
  FROM users
  GROUP BY 1
  HAVING COUNT(username)>1
  ORDER BY 2 DESC;

SELECT id, username, getting_started, language, email, 
        sign_in_count, last_sign_in_at, last_sign_in_ip, last_seen
  FROM users
  WHERE sign_in_count=1 AND last_seen+'1 day'::INTERVAL < NOW()
  ORDER BY last_seen ;

SELECT username, getting_started, language, email,
        sign_in_count, last_sign_in_at, last_sign_in_ip, last_seen
  FROM users
  WHERE last_sign_in_ip IN ('51.91.67.153','151.80.230.21','85.113.129.7','178.159.37.139')
  ORDER BY username;