let me be the first to suggest that this is for everyone’s benefit
1 Like
we just upgraded our linux version on the server (the previous one was EOL as of April)
i’ll take a look. there’s likely no data loss (and we have backups if so), but it’ll be inaccessible for a bit
cc @Felix
the ic archive is still accessible so i’m not sure what broke with the sb1 archive
2 Likes
iirc that codebase can’t run on newer PHP without a lot of love because of all the weird hacks we did to it. i tried for a weekend once and gave up. maybe that’s it?
2 Likes
I had an older php package with some backported security fixes that I was reasonably happy with keeping running on here, it might’ve gotten bumped accidentally during the most recent upgrade
the ic archive is a static export, the sb1 archive was still running a full lamp stack so it was searchable by logged in users
@doolittle see if there’s a maintained Ubuntu ppa providing php5.6 for 20.04 and try adding that, or I can
1 Like
hmm we appear to be on 5.6?
PHP 5.6.40-65+ubuntu20.04.1+deb.sury.org+1 (cli)
Good then, that actually upgraded gracefully. Is mysql or php-fpm just not running after the reboot?
restarted both services, both are running, but no dice?
Time to check Nginx logs then
oh we need to downgrade mysql too at this point I think, the default version was OK on 18.04 but not on 20.04
it’s only used for this part of the site so I don’t mind doing that, h/o
1 Like
ok the supported older mysql I can find is crashing with a stacktrace so that’s not great, we might need to dockerize it which would entail migrating the sb1 db which I have zero desire to do
I may have just nuked it while trying to downgrade the DB tbh, I haven’t looked at this in a while and this package probably shouldn’t have been upgraded in the first place if we ever planned to downgrade it (databases usually upgrade automatically and don’t downgrade gracefully), but I would most likely not have thought of that myself, might need to restore the sb1 mysql db from the server backup and run a mysql dump then reload it into a fresh environment
2 Likes
someone else can do this but I will not be
can we turn it into a static export like IC easier?
workflow is go into the digitalocean control panel → create a new droplet from the backup → ssh directly into the ip address of that server → run https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html → wipe out all traces of the mysql db on this server → reinstall a fresh 5.7 and hope it doesn’t throw a stacktrace (otherwise you need to dockerize it) → reload the mysql db dump into the fresh mysql 5.7
1 Like
I don’t see the point of keeping it up without search functionality but the DB on here is temporarily broken until being restored anyway so it’s either work from a server backup or learn more about innoDB than anyone wants to actually get it to live temporarily again
1 Like
and someone should at least get the “dump out a working copy of the DB from before the recent migration” step over with before our weekly server backups roll over
1 Like
ok, i’ll get that part done at a minimum. not sure of the cost/benefit on setting up its own but obviously at least some people interested in keeping it up for posterity
2 Likes
speaking of which you’ll probably be stuck paying for the backup droplet that you spin up temporarily to get the mysql dump out but that’s already on my credit card for another month so w/e, just blow it up afterward
1 Like
ok, i’ll try to get to this on the weekend and last thursday’s backup will be available through may 24th.
apologies for the oversight. i didn’t consider the old forum when i checked over the upgrade on sunday
2 Likes
not at all, sorry for the dumb edge case learning experience
if anything I think this is usefully illustrative of how all this shit only hangs together anymore as a labor of love
7 Likes
the irony that i have far more experience with postgres and ruby than mysql and php is also fun. love 2 learn
in the meantime, @L, wayback machine has a good snapshot of the archive crawled at the end of march
https://web.archive.org/web/20230329234248/http://forums.selectbutton.net/
2 Likes