[OSGeo] #3405: Move mapserver.org to mapserver container

#3405: Move mapserver.org to mapserver container
----------------------+---------------------------
Reporter: robe | Owner: sac-tickets@…
     Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: SysAdmin | Keywords:
----------------------+---------------------------
In reviewing osgeo6 Vicky noticed mapserver is still running on OSGeo6.

We had discussed a while back that it should be running on mapserver
instance on osgeo7 where demo.mapserver.org is running.
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+----------------------------
Reporter: robe | Owner: sac-tickets@…
     Type: task | Status: new
Priority: major | Milestone: Unplanned
Component: SysAdmin | Resolution:
Keywords: |
----------------------+----------------------------
Comment (by Jeff McKenna):

Hi all, I manage both instances (demo.mapserver.org on OSGeo7, and
mapserver.org on OSGeo6) - hmm I wasn't aware of an earlier discussion to
move mapserver.org to OSGeo7, but maybe we had that discussion in another
ticket that I forget - no problem, I'll move mapserver.org to OSGeo7 as
well, and will use this ticket to track progress.
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+----------------------------
Reporter: robe | Owner: sac-tickets@…
     Type: task | Status: new
Priority: major | Milestone: Unplanned
Component: SysAdmin | Resolution:
Keywords: |
----------------------+----------------------------
Changes (by cvvergara):

* priority: normal => major

Comment:

OSUOSL is moving servers to a new physical location and not all servers
will be moved: osgeo3, osgeo4 and osgeo5 are the physical equipment we are
losing.

Their contents will be moved to osgeo6, which will be reformatted and used
to setup containers, and basically the containers of osgeo3, osgeo4 and
osgeo5 will be moved to osgeo6.

osgeo6 has the mailserver and the mailserver will containerized in osgeo9,
but it has mapserver.org between other stuff, that have to do anything
with the mailserver.
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+---------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Unplanned
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------
Changes (by Jeff McKenna):

* owner: sac-tickets@… => Jeff McKenna
* status: new => assigned

--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+---------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Unplanned
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------
Comment (by cvvergara):

There is a cron job also on your user, with this content:

{{{
01 00,13 * * * /usr/local/sbin/certbot-auto renew >> /home/jmckenna/le-
renew.log
}}}
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+---------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Unplanned
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------
Comment (by Jeff McKenna):

Updates:
- moved all `mapserver.org` files to OSGeo7's `mapserver` cointainer
- removed cron job from OSGeo6
- mapserver.org virtualhost is now running on port 8082 on the `mapserver`
container (whereas demo.mapserver.org is running on port 8081)

Now I need the domain mapserver.org to point to OSGeo7 (currently it
points to: osgeo6.osgeo.osuosl.org (140.211.15.3)

@cvvergara @robe I believe you control the Nginx proxy settings to route
traffic on OSGeo7, please update it so: https://mapserver.org ​routes to
the `mapserver` container with port 8082

thanks

PS. I now see where I committed to moving mapserver.org files back in
ticket #2459 oops
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+---------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Unplanned
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------
Comment (by Jeff McKenna):

updates:

- @cvvergara and I worked on this this afternoon
- mapserver.org is now running on OSGeo7 'mapserver' container
- note to self, for next time:
   - verify that the 'mapserver' container is listening on port 8082, to
match the settings in the virtualhost
     - `sudo netstat -tulpn`
       - response should contain:
         - `tcp6 0 0 :::8082 :::*
LISTEN 174651/apache2`
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+---------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Unplanned
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------
Comment (by cvvergara):

Announce that there will be downtime on website.

On pair domains change the
A wwq3
A @

to new IP address: 140.211.15.30 (osgeo7)

On osgeo7/nginx:

* Created a site-available for mapserver.org based on demo.mapserver.org
   * `proxy_pass http://mapserver.lxd:8082;`
   * `server_name mapserver.org www.mapserver.org`;
* certbot --nginx -d mapserver.org -d www.mapserver.org
   * Creates the certificate but does not install it
* Create the symlink to sites-enabled
* test: `nginx -t`
* Continue when test pass, other wise trouble shoot
* `systemctl reload nginx`

Within container:

* Make sure the ports are listening (`netstat`)

Testing:

- Browser
- curl
- ping

TODO:

Verify with @robe in osgeo6:
- what is best for `/var/www/mapserver.org/`: delete the directory or
ingore from rsync
- mapserver.org is no longer enabled on osgeo6
- Add to ansible the final configuration
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+------------------------------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Sysadmin Contract 2025-II (vicky)
Component: SysAdmin | Resolution:
Keywords: |
----------------------+------------------------------------------------
Changes (by cvvergara):

* milestone: Unplanned => Sysadmin Contract 2025-II (vicky)

--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+------------------------------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Sysadmin Contract 2025-II (vicky)
Component: SysAdmin | Resolution:
Keywords: |
----------------------+------------------------------------------------
Comment (by Jeff McKenna):

Regarding /var/www/mapserver.org/ on OSGeo6: I had made an archive of
that, I copied it to the OSGeo7 'mapserver' container, and I downloaded a
local copy here. I believe that we can now safely delete that directory
(up to you).
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+------------------------------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Sysadmin Contract 2025-II (vicky)
Component: SysAdmin | Resolution:
Keywords: |
----------------------+------------------------------------------------
Comment (by cvvergara):

On osgeo6:

Removed `/var/www/mapserver.org`
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+------------------------------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: closed
Priority: major | Milestone: Sysadmin Contract 2025-II (vicky)
Component: SysAdmin | Resolution: fixed
Keywords: |
----------------------+------------------------------------------------
Changes (by cvvergara):

* resolution: => fixed
* status: assigned => closed

--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+------------------------------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: closed
Priority: major | Milestone: Sysadmin Contract 2025-II (vicky)
Component: SysAdmin | Resolution: fixed
Keywords: |
----------------------+------------------------------------------------
Comment (by cvvergara):

Forgot to mention added it to osgeo7-nginx repository
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+------------------------------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: assigned
Priority: major | Milestone: Sysadmin Contract 2025-II (vicky)
Component: SysAdmin | Resolution:
Keywords: |
----------------------+------------------------------------------------
Comment (by cvvergara):

On osgeo6:

Removing from sites-enabled:
- mapserver.org.conf
- mapserver.org-le-ssl.conf

Removing from sites available:
- mapserver.org.conf
- mapserver.org-le-ssl.conf
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3405: Move mapserver.org to mapserver container
----------------------+------------------------------------------------
Reporter: robe | Owner: Jeff McKenna
     Type: task | Status: closed
Priority: major | Milestone: Sysadmin Contract 2025-II (vicky)
Component: SysAdmin | Resolution: fixed
Keywords: |
----------------------+------------------------------------------------
Comment (by strk):

For the record: it looks like Jeff reported all osgeo7 mapserver activity
on MapServer at osgeo7 - OSGeo - Thank you !
--
Ticket URL: <Making sure you're not a bot!;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.