Let's see how far down the rabbit hole we can get! We published the first real manuscript for the Ontological Discovery Environment in 2009: https://www.sciencedirect.com/science/article/pii/S0888754309002067 … So it fits the 10 year challenge pretty closely, and I still have access to the code!
-
-
Prikaži ovu nit
-
Just to give myself a date, I'm going to use the date we submitted the manuscript: June 3rd, 2009 We used a lot of different data sets for the first analysis, I wonder how many have archives that far back?
Prikaži ovu nit -
In 2009 I was still a graduate student, and we were using SVN for version control. We wouldn't switch to git until another year later. First lucky break though: I was such a pendant (ok, still am...) that I preserved all the svn history during the switch to git.
Prikaži ovu nit -
Based on commit messages, it looks like June 3rd I had started a transition to smarty templates. It looks like this took about a week of refactoring, doing a page at a time... so I think it will be safe to start with the codebase just before that: 07c249f on June 2ndpic.twitter.com/zalu4hmNrw
Prikaži ovu nit -
OK What software do I need to dig up... luckily, we did include some of the version information in the manuscript. I like to think we did insulate fairly well, it's still going today!pic.twitter.com/3JQzwIURNt
Prikaži ovu nit -
It looks like the oldest "official" version of php we can get on docker is 5.4, but there's a tag that even include apache! I see the old favicon! but alas there doesn't seem to be postgres support. That would have been too easypic.twitter.com/MhsryQDNWo
Prikaži ovu nit -
I'll spare you the details, but let's just say the official php5 docker images make it impossible to add the pgsql extension... So I went back to a debian jessie container and started from scratch. Success! (well... no more missing extensions at least)pic.twitter.com/6vqZs84OZs
Prikaži ovu nit -
This was a fun bug to track down... sometime in the php5 era, the default for so-called "short open tags" switched from "on" to "off" in php.ini. Essentially, if you have code that starts with "<?" instead of "<?php" then it won't even execute. Handy! Now for the missing DB...pic.twitter.com/yMAs1VRvef
Prikaži ovu nit -
Instead of dealing with container linking... we'll just install postgres inside the same container with php. I did the default postgresql that came with jessie, 9.4.25, since I know that there weren't any major backwards-compatibility issues going from 8 to 9.
Prikaži ovu nit -
There's a file named "ode_schema.sql" in the filesystem root... could it be that easy? Other than a few errors trying to lock down permissions (we can safely ignore those for now), it went without a hitch! However, it looks like we didn't include a session storage table...pic.twitter.com/NlrOyYWr2t
Prikaži ovu nit -
Luckily, documentation saves the day again: when I added sessions.php I included the source URL at the top: https://www.csh.rit.edu/~jon/projects/pgsql_session_handler/pgsql_session_handler.phps … within the comments is a table schema!
Prikaži ovu nit -
It's running! (sorta) Seems like a good place to stop for the day. In the next installment we'll actually try to get some data loaded in...pic.twitter.com/vnBcV6NZpD
Prikaži ovu nit
Kraj razgovora
Novi razgovor -
Čini se da učitavanje traje već neko vrijeme.
Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.