We just activated XMPP Housekeeping for the openim.de and openim.eu domains. These two domains joined our server in spring of 2023, so it is time. ;-)
Category: Maintenance
Upgrade to Prosody 0.12
We upgraded the Jabber server to Prosody 0.12 (from 0.11) yesterday, see the changelog.
We did some optimizations in the last few days and also deleted some spammers. It looks like we were successful. The server has no more outages. Hope it stays that way. :-)
XMPP Housekeeping now active!
Finally we got our XMPP Housekeeping scripts up and running. These scripts automatically delete unused XMPP and Spectrum 2 Transport accounts and run daily. Deletion takes place if:
- A XMPP account using one of our public domains was not used (no login occurred) for more than a year. The corresponding Spectrum 2 Transport accounts are deleted as well.
- A new registered XMPP account using one of our public domains was not used (a login never occurred) for more than 31 days.
- A Spectrum 2 Transport account created with an external XMPP account was not used (no login occurred) for more than a year.
After an initial run of the scripts we came down from 300134 XMPP user accounts to only 64624! As we need to exclude jabb3r.de until next spring (here there was a problem how Prosody mod_lastlog saved its timestamps) there was no deletion on this domain. So if we exclude this domain from the numbers, it’s 265049 XMPP accounts before and 34100 accounts after the initial run of our scripts.
You can find our server statistics here.
Wow, the migration of the offline storage from file to database did take very long. I thought one or two hours are enough. No, the scripts ran for 10 hours. Therefore the Jabber/XMPP services were offline for about 10 hours, from ~10:30 pm CEST yesterday to 8:50 am CEST today. We are very sorry about that. Good news: No more big downtimes are planned in the near future.
We need to convert the Prosody offline storage to the new database format. Therefore we need to take the server down. This will happen at between 10 and 11 pm CEST today.
Prosody 0.10 up and running
Everything is done, the server runs on Prosody 0.10 and is up for over an hour now. Thanks to MattJ for his help solving the small issues when upgrading.
No new features like MAM and WebSocket are activated, yet. This will follow. But I had to disable mod_privacy_lists and mod_blocking and enable mod_blocklist. This means that we drop support for XEP-0016 which only older clients used nowadays as XEP-0191 is the newer standard which we still support with mod_blocklist.
Planned upgrade to Prosody 0.10
Prosody 0.10 was finally released yesterday. So today at 8:30 pm CEST (~3 hours from now) we plan to upgrade our Prosody server from 0.9 to 0.10. The XMPP/Jabber services will be offline for about 1 to 2 hours. At least this is our plan. ;-) Please stay tuned!