His iPad shows fields of black and green surrounding Bakhmut. As far as the drone’s electric eye can see, everything up to the horizon is a giant moonscape of black impact holes.
Time and again, new plumes of smoke rise up in the field from fresh impacts.
“Our godawful Starlink just isn’t working the way it should,” the specialist says as he angrily digs into his laptop.
“How am I supposed to work when the internet is so damn slow?”
As simple as that, the Ukrainian military shares the picture from drones with other units via link-only live streams on YouTube.
https://kyivindependent.com/national/as-battle-of-bakhmut-nears-culmination-ukraines-artillery-gasps-for-more-ammo
Can I delete unused items from storage?
For me, the new storage table is pretty unfamiliar. But it seems to me that there's a lot of unused data there. Everything in storage must be either a photo or an attachment - right? I have 191433 rows in
storage
. I have 127206 rows in photo
, and just one in attach
. And it seems that the remaining rows are using 12GB, about half of the space of the whole DB:MariaDB [friendica]> select count(*), sum(octet_length(storage.data)) from storage left outer join photo on storage.id = photo.`backend-ref` where photo.id is null;
+----------+---------------------------------+
| count(*) | sum(octet_length(storage.data)) |
+----------+---------------------------------+
| 63459 | 13781405163 |
+----------+---------------------------------+
Am I right that I could just delete those rows (except for the single row in
attach
)?!Friendica Support
Roland Häder likes this.
Bot for Friendica/ActivityPub
- Have the post include an image
- Have the post be a reply to another post with a specified URL
- Option to wait for a new post from a specified user, with the post being a reply to that post
- Authentication via username/password passed on command line
- Nicer authentication options available
!Friendica Support
Then I woke up.
I was once baffled to discover that gender-api.com claims to be able to "determine the gender of an email address", a ludicrous claim.However, thanks to the advanced technology of genders.wtf, I have been able to one-up this feat, and I am proud to announce that we can now gender fediverse instances.
Uncanny. @Effy Elden
oh no! Curious to see how a post like this should be displayed titleless. Probably best to just fallback to some default.
The Register: Apple lets devs charge up to $10,000 per app (Thomas Claburn)
CAPTCHA
CAPTCHA
This is an actual CAPTCHA I was shown when trying to log into PayPal.As an actual human and not a bot, I had no idea how to answer. Is this a joke? (Seems not.) Is it a Magritte-like existential question? (It’s not a bicycle. It’s a drawing of a bicycle. Actually, it’s a photograph of a drawing of a bicycle. No, it’s really a computer image of a photograph of a drawing of a bicycle.) Am I overthinking this? (Definitely.) I stared at the screen, paralyzed, for way too long.
It’s probably the best CAPTCHA I have ever encountered; a computer would have just answered.
(In the end, I I treated the drawing as a real bicycle and selected the appropriate squares…and it seemed to like that.)
Tags: authentication, captchas
Posted on December 5, 2022 at 7:10 AM • 11 Comments
Retrieved 2022-12-05: https://www.schneier.com/blog/archives/2022/12/captcha.html
like this
NegativePrimes reshared this.
Why is Huawei "hoo-ah-way" and not "hoo-ah-vey", when Wuhan is "voo-han"? I mean, if you're gonna mangle it that badly, might as well go all the way. Some days this language seems more impenetrable than others 😭
tagesschau 20:00 Uhr, 26.11.2022
Also, the Hundred Flowers Campaign was ultimately a crackdown on dissent. A lot of brilliant, devoted, caring people died. So if you're gonna invoke that, please ensure your post is funny.
https://fivethirtyeight.com/videos/the-pollsters-seem-to-have-had-a-good-night/
The Pollsters Seem To Have Had A Good Night
In this late-night installment of the FiveThirtyEight Politics podcast, Nate Silver and Galen Druke put their “Model Talk” hats on and discuss the initial results from the 2022 midterms. As of this writing, we still don’t know which party will control the House or Senate, and we may not know come the morning. But that doesn’t stop us from talking about what we do know: that Republicans didn’t make major gains in the Senate, and that the polls were pretty good this cycle.Retrieved 2022-11-09: https://fivethirtyeight.com/videos/the-pollsters-seem-to-have-had-a-good-night/
mat@exon:~$ uptime
18:38:13 up 3 days, 11:42, 1 user, load average: 0.29, 0.20, 0.36
I'm almost offended...
@Friendica Support
And you're probably right, maybe! The ship will stay sorta afloat a while longer. Perhaps the lifeboat won't leave. Perhaps you can get to the lifeboat at any time. Probably it'll be OK.
Congratulations to NASA on the successful test of their planetary doomsday device! I for one will sleep easier knowing that the human race will not be permitted to survive any serious deviation from ideological correctness.
NASA Smashes Into an Asteroid, Completing a Mission to Save a Future Day
The DART spacecraft completed its 10-month journey to demonstrate a technique that could defend the planet from deadly space rocks in the future.https://www.nytimes.com/2022/09/26/science/dart-nasa-asteroid-dimorphos-contact.html
Recovering disk space in MariaDB
Now that I've moved to mariadb, it seems like "innodb_file_per_table = on" doesn't do anything: all the space is used by a single storage.idb file. I tried deleting half the photos and rebuilding the entire database from a dump, but it didn't seem to help. Now that I no longer have tables in individual files, I can't even tell how much space each table is taking up.
Is there any way to manage this disk space? I'd like to find out which tables are taking up the space, and then after deleting unnecessary data from those, recover the disk space on my filesystem.
!Friendica Support
https://apps.apple.com/us/app/keepassium-keepass-passwords/id1435127111
https://apps.apple.com/us/app/authenticator/id766157276
If you are looking for a simple, open-source TOTP app, there is always FreeOTP: https://freeotp.github.io/
It has iOS and Android versions.
iPhone app?
@Friendica Support
Matthew Exon likes this.
Twitter connector OAuth failure
So questions:
* Does the twitter addon still work for new connections?
* Am I supposed to be using "OAuth 1.0a" or "OAuth 2.0"?
* How can I troubleshoot the problems with my connection?
!Friendica Support
The point of this, by the way, is that I finally am getting around to fixing mailstream so it correctly sends Twitter posts with attachments. At the moment it sends the text of the tweet but not any images. Since this is better than nothing, I want to have a test server with a test twitter account for development.
Hypolite Petovan likes this.
Nice use of ASCII art to make a point
Let’s represent express trains with a “|” and local trains with a “/”.Our current railways are run inefficiently, like this:
|/|/|/|/|/|/|/|/|/With #HS2, we’ll have a twin network with doubly boosted capacity, like this:
|||||||||||||||||||||||||||
////////////////////9/n
(Nitter addon enabled: Twitter links via https://nitter.net)
utzer [Friendica]
in reply to Matthew Exon • • •Did you ever optimize the database? Do you have enough free space on you server for a copy of the largest table (optimize or update could require to copy a whole table). Did you try to gain some free space by purging old versions of updated packages?
You can do the backup to some ssh accessible storage by piping the dump straight to another server by ssh.
Matthew Exon
in reply to utzer [Friendica] • • •sudo mysqlcheck -o --all-databases
, and it saved 1GB. But my dumps are 24GB and that's about the same as the database on disk, so it looks like that won't solve anything this time. Interestingly, the optimise succeeded despite claiming that it was rebuilding, and obviously there's not enough space to really rebuild. So something's fishy.It's just Digital Ocean, I could easily add another disk, but that's not really the point. The database is twice as big as it should be, and that's going to make every step from now on a lot more than twice as hard as it should be. I should fix the biggest problem first.
utzer [Friendica]
in reply to Matthew Exon • • •When you go to https://friendica.exon.name/friendica you can see that the update did not finish. So there is a problem.
utzer [Friendica]
in reply to utzer [Friendica] • • •https://friendi.ca/2022/06/11/friendica-2022-06-released/
So at least
bin/console dbstructure update
has to be run, but maybe alsobin/console postupdate
needs to be executed, but I am not sure about the later one and not sure about the best order to run these.Matthew Exon
in reply to utzer [Friendica] • • •/friendica
diagnostics page.I did run
dbstructure update
when I updated in July. I even copied and pasted the terminal output into my notes so that I can prove it 😛 But I've never heard ofpostupdate
before, that does explain a lot.Right now when I run
dbstructure update
it does nothing. When I runpostupdate
I get this error:I can probably try to untangle this myself. Thanks for the hints!
utzer [Friendica]
in reply to Matthew Exon • • •