The following things related to Offentlig konst should be migrated to new a Glesys server:
https://github.com/Wikimedia-Sverige/ODOK
https://se.wikimedia.org/wiki/Offentligkonst.se/Om_projektet/Teknisk_dokumentation
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Sebastian_Berlin-WMSE | T206772 Enable https for offentligkonst.se | |||
| Resolved | Lokal_Profil | T233927 Clean up old WMSE server environment | |||
| Resolved | Lokal_Profil | T234796 BUS donations | |||
| Resolved | Sebastian_Berlin-WMSE | T207824 Migrate Offentlig konst | |||
| Resolved | Sebastian_Berlin-WMSE | T207821 Figure out how to run services on Bahnhof |
An update on the glesys server. It is not even receiving security updates anymore and git is so broken that it fails to do a git fetch (bug in the gnutls handler).
I created a server called "sites" on Glesys. It's currently small (1 CPU/1 GB RAM/5 GB disk).
Installed unattended-uppgrades following https://www.cyberciti.biz/faq/set-up-automatic-unattended-updates-for-ubuntu-20-04/. Server will reboot at 02:00 if needed.
I have gotten the site up and running on http://new.offentligkonst.se using the repo.
@Lokal_Profil, on the old server, the current branch ("dialog") doesn't exist in the repo. It also has some uncommitted changes. Do you know off the top of your head if these are things we want to have on the new server? There seems to be at least a bit of overlap with the repo, e.g. Matomo things.
This shouldn't be hard to check with Git, but I got an error when I tried to pull master. Guessing that one or more things are broken because they're out of date (Git itself is one major version beyond the current one😬). I can still check this by juggling diffs, but it will take a bit more work.
Also @Lokal_Profil: could you add what components (api, database, site, tools) we want? We talked about this earlier, but I've already forgotten and I think it's best to write it down somewhere.
IIRC dialog is related to the pop-up about the lawsuit.
Components wise. All of them should be migrated but "tools" is not critical. Note that there is the /solna subpage and data file as well which only exists on the server.
There should be a repo directory on the server with site then symlinking into it.
PhpMyAdmin we can skip
The API is up at http://new-api.offentligkonst.se/api.php, tough it's giving PHP errors.
The initial error was that a function wasn't defined as static. I'm guessing that worked in whatever PHP on the old server, but not anymore.
I ran a deprecation detection tool and it found 56 instances of deprecated calls, all of them for Mysql.
Imported ODOK database from old server. Added Mysql user "odok_user" with SELECT privileges to it.
The Google maps API appears to have changed since the ODOK API was written. It doesn't understand the requests, both on old and new server.
There were some DEFINER statements in the database dump that were causing issues. Specifically "andre" was definer in some places. I removed those statements and re-imported the database, as suggested in https://stackoverflow.com/a/19707173.
I've gone through the examples on the API documentation and fixed any errors and warnings.
When this goes live we should update https://se.wikimedia.org/wiki/Offentligkonst.se/Om_projektet/Teknisk_dokumentation/Api/apiurl with the new api url
The local files related to http://offentligkonst.se/Solna.html do not need to be migrated (should be html, js and geojson)
Snapshot of the code as it was before migrating saved as branch https://github.com/Wikimedia-Sverige/ODOK/tree/old-server.
Redirected www.offentligkonst.se and api.offentligkonst.se to the new server. Changed URL on wiki (T207824#8036244) and redirected /api to api. subdomain.