newjack.city flood Show more
I wondered why newjack.city bots weren't followed me.
Apparently, the secret trigger was to post on the federated timeline without a mention.
Database migration status update Show more
So the very slow PostgreSQL migration to get statuses statistics is done, with 100973033896636693 the last status ID.
"some hours" release notes said. Indeed, that's correct, at least for a definition of "some" still accepting 80.
Currently, the migration code is busy with ~6 156 470 rows for silent mentions, with an announced time of 13 minutes remaining.
Maintenance Show more
To populate the status_stats table is very slow (as the table is huge: it contains every status on the fediverse with fav/reblog/etc. counts)
@dean apk install bc?
Merci @Shangril pour le super CD DIY et le CD bonus avec la gazette DIY.
A story about the source of JIS then Unicode ghost characters.
Server maintenance Show more
A small issue in the previous nginx configuration forbids nginx to serve some URLs like / /web or /web/getting-started.
If you tried to connect on theose URLs between 15:20 and 15:40 UTC, you got a 403 (or a small explanation message).
Connectivity through already open page or clients like Tusky worked and wasn't affected.
An excellent article comparing strengths of CLI and web UI. And a sensible opinion: when to use which one?
The CentOS 7 server used by this instance has been upgraded with last software, including new microcode patches for the CPU security issues.
There is also a Mastodon upgrade ready (2.4.0 → 2.4.2), but it's pending a long database migration.
Registrations are again open, as it appears all spam bots posted from the same IP ranges,.
So, from their IP addresses, I got the two AS they use, and from bgp.he.net, I get the associated known IP ranges (the route they accounce in various BGP sessions).
Nginx is configured not to send a reply when a request origin is one of those IP addresses.
We'll see if that works in the next 72 hours.
For instance administrators Show more
To get the mail addresses of spam bots accounts, you can try the following pgsql query:
SELECT DISTINCT ower(substring(email from position('@' in email) + 1)) AS domain FROM accounts INNER JOIN users ON users.account_id =accounts.id WHERE suspended = true OR silenced = true ORDER BY domain;
Of course, that only works if you've an instance with nice people. If not, you'll also get the mail domains used by reported regular users.
Infrastructure, devops, social justice, free culture, Wikimedia.
Nasqueron is a budding community of creative people, writers, developers and thinkers. We focus on free culture, ethics and to be a positive change. We share values like respect, justice and equity.