Move over wiki to osgeo7

[robe]

So far I have create an lxd container by imaging the existing wiki and am in the middle of configuring it to proxy thru the nginx container.

[robe]

Before I go live, I plan to stop the databases on old server, back them up and restore on new server.

I'm see we have a PostgreSQL 9.6 database running with

usermap and wiktionary_wiki databases. Conveniently collated in German (wonder who did that :) )

But I thought we are running mysql but can't get into that database and not sure where mysql stores the database files

[jef]

Replying to robe:

I'm see we have a PostgreSQL 9.6 database running with usermap and wiktionary_wiki databases. Conveniently collated in German (wonder who did that :) )

8.4. 9.6 is apparently empty.

But I thought we are running mysql but can't get into that database

mysql --defaults-file=/etc/mysql/debian.cnf osgeo_wiki

and not sure where mysql stores the database files

/var/lib/mysql/osgeo_wiki

[robe]

Thanks jef. I think the data got messed up when I imaged the machine because mysql was running. So I'll need to reimage again.

In the meantime - I did switch the dns for wiki.osgeo.org to osgeo7, but the proxy in place is just proxying over to the old server - ​https://140.211.15.40 so I could install letencrypt on new.

I'll shut down the mysql and postgres services on next reimagine and will put a flash page on the wiki that it's down for maintenance.

[robe]

I did another migration but given things are so old on this box. I would like to build one from scratch.

[robe]

Just details of how old wiki is and why it should just be rebuilt

1. OS: Wheezy - Debian 7.11
2. Database: MySQL 5.5.60 (I think this EOL'd about 2 years ago)
3. PHP: 5.4.45 - EOL'd I think about a year ago
4. Wiki: 1.25 I'm guessing by the RELEASE file in the folder.

Current version is - ​https://www.mediawiki.org/wiki/Download (1.31.1)

I gather 1.25 EOL'd 2-3 years ago from this - ​https://www.mediawiki.org/wiki/MediaWiki_1.25

[strk]

Can we switch to PostgreSQL on upgrade ?

[wildintellect]

I agree, a clean install with a migration of data would be better.

Is PostgresSQL well supported with MediaWiki and whatever extensions we use? Can we even do a migration between database types, or is that one of those decision you have to make when starting a fresh Wiki?

[robe]

I don't think PostgreSQL is very well supported on wiki sadly. You'd think after all these years, but my reading says it isn't so I think our safest bet is just to move to latest Mariadb and perhaps experiment with a PostgreSQL powered wiki in another container.

[robe]

I'm planning to move osgeo wiki to osgeo7 in about 2 hrs. It is already proxying thru osgeo7 so no dns changes will be needed.

I've also installed dhcp on old server so its one less thing I have to deal with after the lxd2pc migration is done.

While the move is going, the wiki site will be down. I don't expect more than 1 hr downtime while the move is happening.

I think maybe I should rebreak out this task again (have the upgrade be a secondary thing) since for that I plan to rebuild from scratch with newer OS so will be more involved.

[robe]

Okay I've shut down mysql and apache on wiki.osgeo.osuosl.org and repointed the nginx config on osgeo7 to old-wiki.lxd container.

I'll close this out as soon as I've documented the changes.

[robe]

I've updated ​https://wiki.osgeo.org/wiki/SAC_Service_Status#old-wiki_wiki.osgeo.org

and

​https://wiki.osgeo.org/wiki/OSGeo_Wiki

with details of the move.