#2290: Move over wiki to osgeo7
---------------------------+-------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Keywords:
---------------------------+-------------------------------------
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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
Comment (by 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
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:1>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
Comment (by jef):
Replying to [comment:1 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
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:2>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:3>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
Comment (by robe):
I did another migration but given things are so old on this box. I would
like to build one from scratch.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:4>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7 and upgrade it
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:5>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7 and upgrade it
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
Comment (by 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
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:6>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7 and upgrade it
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
Comment (by strk):
Can we switch to PostgreSQL on upgrade ?
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:7>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7 and upgrade it
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------
Comment (by 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?
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:8>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7 and upgrade it
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2019-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Changes (by robe):
* milestone: Website rebranding 2017 => Sysadmin Contract 2019-II
Comment:
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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:9>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7 and upgrade it
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2019-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:10>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2019-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:11>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Sysadmin Contract 2019-II
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+----------------------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:12>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2290: Move over wiki to osgeo7
---------------------------+----------------------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: closed
Priority: normal | Milestone: Sysadmin Contract 2019-II
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+----------------------------------------
Changes (by robe):
* status: new => closed
* resolution: => fixed
Comment:
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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2290#comment:13>
OSGeo <https://osgeo.org/>
OSGeo committee and general foundation issue tracker.