Do not forget to run the upgrade script to fix some incompatibilities with MariaDB 10.2 (STRICT_TRANS_TABLES).
In your particular instance, it is also important to run /plugins/Nodeinfo/scripts/fix_stats.php as you've joined GNU social 1.3.0 faster than we could add the statistics fix to the upgrade script ^^ Right now your instance is showing up as only having 3 users and 18026 notes: https://fediverse.network/herds.eu
So, yesterday I eventually fell asleep, was now trying to send ya a notice and this showed up in the logs:
2019-05-31 08:22:15 LOG_ERR: [social.hackersatporto.com:6340.49a4f11e GET /main/public] Salmon (from profile 1) endpoint https://socnet.geniusmusing.com/main/salmon/user/2 returned status 406: <head><title>Not Acceptable!</title></head><body><h1>Not Acceptable!</h1><p>An appropriate representation of the requested resource could not be found on this server. This error was generated by Mod_Security.</p></body></html>
So... if that's a shared hosting you probably can only use the OpportunisticQM plugin (which comes enabled by default). Things like XMPP will only work with queuedaemon, which most likely can't be used in a shared host. If OpportunisticQM doesn't seem to be working, I would suggest you to stop by #social@irc.freenode.net so that we can figure what's wrong :)
ultimately, SNS services like the fediverse are seen as intimate spaces by many. participants are not thinking about the long term consequences of their actions. to an extent, one can legitimately argue that more care should be taken with selecting the audience who receives a given post.
this is of course, compounded by the fact that in typical implementations, there’s only one path to allowing posts to spread to a wider audience: labelling the posts with as:Public.
there are many avenues of leakage in the fediverse, but the binary between as:Public and a user’s followers collection is too wide and leads to users leaking their own posts unintentionally to make them boostable, etc.
if users have a middle ground, then they will use as:Public in a more appropriate way verses how it is presently used.
of course, the scopes system in general is a UX misdesign because it doesn’t really reflect the open world nature of the fediverse well, and we are working on ways to mitigate that, but it will take time, but when you have a choice between only public or private posts, people will get burned as they try to expand their audience without thinking about all consequences.
ultimately what i’m saying here is that i think there is value in what archive team is trying to accomplish, but the fediverse isn’t ready for it yet. it’d be nice if we could find a middle ground until we fix the way audience selection works (even a mitigation like as:Authenticated being widespread would stop most of the bleeding), and i think what i proposed about having archive team make a fediverse bot that allows a user to request their own instance be archived would be a good middle ground for now.
Btw, which desktop and mobile xmpp clients did you recommend?
I've been using Conversations on android and, well, once gajim has worked... But I'm doing XMPP all wrong, as soon as possible I intend to set it properly...
> My prime suspect for the database thrashing was the queue. Sounds like a fair bet...
> My take on that was to port it to postgresql. Can you tell me the big differences between a DBMS and the other? I thought they weren't that much different these days...
TBH, I'm not sure why GS doesn't support PostgreSQL already, it uses PDO so supporting both shouldn't be that hard...? (Despite that, we should move from PEAR/DB modules to something more modern and with active maintenance (there are various non-solved open issues on DB module upstream) anyway)
quick facts: - can be used to leak data between processes, hyperthreads, SGX enclaves, etc - effects core and xeon CPUs - CPUs with meltdown mitigations are less effected, but still vulnerable - this is a hardware issue - OS independent - can be mitigated by disabling hyperthreading - proof of concept - one thread is able to access URLs typed into firefox (a different thread)