[SAC] [OSGeo] #2004: Upgrade MediaWiki version

#2004: Upgrade MediaWiki version
--------------------------+-------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Keywords:
--------------------------+-------------------
- current installed version: 1.25.3
(https://wiki.osgeo.org/wiki/Special:Version)
  - will also likely likely PHP and MySQL upgrades
  - must take care of extensions

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by strk):

Would it be too risky to also try migrating from MySQL to PostgreSQL ?
https://www.mediawiki.org/wiki/Manual:PostgreSQL

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:1&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by martin):

[https://www.mediawiki.org/wiki/Release_notes/1.29#Compatibility] says:

"MediaWiki 1.29 requires PHP 5.5.9 or later."

The Wiki VM is running on Debian6 which has PHP 5.3.3.1. Thus, upgrading
MediaWiki requires upgrading the OS beforehand, Debian8 would be minimum.
Given the fact that upgrading the OSGeo VM's just to Debian7 is pretty
tricky - due to the disk layout they probably refuse to boot afterwards -
I wonder, wether it's worth the trouble. Of course we can move the entire
Wiki to Osgeo6 or some other VM/machine.

Suggestions, opinions ?

Aside from that, personally I'd be very much in favour of away from MySQL
....

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:2&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by robe):

Away from MySQL sounds good to me though do we know if there is anything
we are using not supported in the PostgreSQL support. Sounds like MySQL
is still more battery tested.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:3&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by christian):

I would not go for PostgreSQL, almost no MW Extensions support PostreSQL
as well as MySQL/MariaDB. You will certainly have more trouble maintaining
a PostgreSQL based MW with Extensions compared to a MariaDB/MySQL.

And for Semantic MW the PostgreSQL support seems to be broken:

*https://www.semantic-mediawiki.org/wiki/PostgreSQL

*https://phabricator.wikimedia.org/T44659

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:4&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by msmitherdc):

This is just a comment so feel free to ignore but perhaps it might be time
to think about dockerization (or insert your favorite container solution)
so that all the dependencies can be kept together and not impact other
operations.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:5&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by Jeff McKenna):

I always use the recommended backend for
trac/mediawiki/joomla/wordpress/plone. In this case MySQL has served us
well for the wiki. I'm very familiar with maintaining these backends, so
MySQL is not an issue. +1 to keep same backend.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:6&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by robe):

Sounds like it's not worth switching without some serious testing. Oh
well I'm okay with a MariaDb/MySQL solution then. Preferably MariaDb.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:7&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2004: Upgrade MediaWiki version
--------------------------+--------------------
Reporter: Jeff McKenna | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Wiki | Resolution:
Keywords: |
--------------------------+--------------------

Comment (by strk):

More reasons to upgrade are written in #1819, which I'm closing in favour
of this newer one.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2004#comment:8&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.