m0xEE @m0xee@librem.one

@Cocoa @p Alright, tested the process out on a VM with rebased that has like one user and three posts. I'm gonna assume you followed instructions on https://soapbox.pub/install/ during initial installation (which for whatever reason make you use some third-party package manager for Erlang/Elixir, which I think should work with base Pleroma). If not, you should already know whether something should be adjusted.
1. Stop pleromer (`systemctl stop pleroma` or whatever other init system you use)
2. Log in as pleroma user (`sudo -Hu pleroma bash`) and enter /opt/pleroma
3. Rollback vegan-specific migrations by executing following commands in that order:
MIX_ENV=prod mix pleroma.database rollback 20221207235104
MIX_ENV=prod mix pleroma.database rollback 20221029171353
MIX_ENV=prod mix pleroma.database rollback 20220927220033
MIX_ENV=prod mix pleroma.database rollback 20220819171321
MIX_ENV=prod mix pleroma.database rollback 20220624104914
MIX_ENV=prod mix pleroma.database rollback 20220225164000
MIX_ENV=prod mix pleroma.database rollback 20210612185407
4. Exit pleroma user (`exit`) and drop the column that can't be rolled back with mix: `sudo -Hu postgres psql pleroma -c "alter table users drop column location;"`
5. Go back to /opt, rename /opt/pleroma into something else (e.g. `mv /opt/pleroma /opt/glussy`), then clone upstream repo (`git clone https://git.pleroma.social/pleroma/pleroma`)
6. Copy config/prod.secret.exs from old directory to new.
7. Log back in as pleroma user, go to /opt/pleroma and run the following to compile the new version and migrate the DB
mix local.hex --force
mix local.rebar --force
mix deps.get
MIX_ENV=prod mix compile
MIX_ENV=prod mix ecto.migrate
8. After all that's done, log out and restart pleromer (`systemctl start pleroma`). If there are no invalid config entries, it should work out of box. If not, stop pleromer and try running it manually (`sudo -Hu pleroma MIX_ENV=prod mix phx.server`) then tell me what the error is. Worst case scenario, you'd have to remove DB configs (`TRUNCATE TABLE config`) and reconfigure it manually.

That explains a lot.
https://patreon.com/lowqualityfacts

LOL, on orders from Russia’s GenPro, Vkontakte blocks popular account of “Z-poet Gennady Rakitin” that was actually Nazi poems translated by antiwar activists trying to show invasion supporters that their "patriotism" is simpatico with 1930s–40s Germany. https://t.me/sotaproject/83006

A FUSE filesystem and dungeon crawling adventure game engine? What's this madness?

https://github.com/ChrisRx/dungeonfs

Rossiyskaya Gazeta, Russia’s official govt newspaper, publishes an essay by lawyer Ilya Rusyaev where he says the verdict against the Nevzorovs should be a model for outlawing more “extremist families” and various “small social groups.” Truly demented. https://rg.ru/2024/07/03/reg-szfo/iurist-rusiaev-konfiskovannyj-penthaus-nevzorova-s-cherepami-budet-slozhno-prodat.html

It's always tempting to allocate objects on the stack, but there's a good reason why you shouldn't allocate large ones if you care about your application's memory footprint: the stack space you use is used forever, even if you don't need it anymore.

Now you might be wondering, wait a sec, I thought that stack variables are freed when they go out of scope, right? Well, yes and no. Let's talk about this. 🧵 1/8

still wednesday

things that can break your DNS

Permalink: https://wizardzines.com/comics/how-dns-breaks/

#BBC live report on #Hungary featured this very optimistic map. If you can’t spot the hidden feature, check the alt text over the picture :)

@kaia YYHWHJDE punished his people for worshiping the idol of the Smiling Donkey Micro-Fleece-Decke, ultraweich

7月がくる

The OpenAI ChatGPT app on macOS is not sandboxed and stores all the conversations in **plain-text** in a non-protected location:

~/Library/Application\ Support/com.openai.chat/conversations-{uuid}/

So basically any other running app / process / malware can read all your ChatGPT conversations without any permission prompt:

Why did the Cube turn off ?
I surely didn’t press the top bu—

🐱 Marx seems happy about it

#catsofmastodon #retrocomputing

This is one golden comment on #Assange from Aleksandar Djokic, a political scientist often writing for Bloomberg:

I have to say I’m pleased with the Assange outcome. He should be free so he can start to openly shill for Moscow and Beijing together with Snowden. Why turn such people into martyrs, better for them to unmask themselves. I give him a month before he has his own show on RT.

Oops. Looks like war criminal Putin forgot to pay the bills for his pro-Trump bot farm.

#election #2024election #vote

best issue title of the month goes to...
the @element backlog ;)

"Unencrypted people are still people too"

https://github.com/element-hq/element-x-android/pull/3072
#matrix