Osgeo6

Osgeo6 is a Debian 9 machine administered by SAC, hosted on OSU OSL servers since August 2015 (see also Hardware plan 2014).

It hosts several critical resources, projects web sites mail-transport and -lists, it is the successor of the ProjectsVM and the MailVM (this machine runs NO VMs instead).

The host is reachable by ssh at osgeo6.osgeo.osuosl.org.

= Shell access =

Anyone in the https://www.osgeo.org/cgi-bin/auth/ldap_shell.py has ssh access, and anyone in this group can add new people via the link. Sudo access can be provided by existing sudoer's by adding folks to the sudoers group in /etc/group, though it is normal practice to try and only extend sudo access to one user per project.

It is a shared environment and it is important that folks making changes on the system be aware of the impact they might have on other hosted services. Apache changes should be made carefully and needfully. Think about security!

See SAC in case of troubles or quick questions

= Services hosted on osgeo6 =

Websites
All websites are served by Apache

MySQL server
* used for GRASS CMS ? now on grass container on osgeo7
 * used for GRASS GIS Wiki (maintained by Martin Landa and Markus Neteler)
 * backed up via bacula in BackupOg6 job (see /osgeo/backup)
 * admin user credentials found in ~root/.my.cnf

Postfix SMTP server

 * Central OSGeo MX running Postfix (includes @osgeo.org aliases in /etc/aliases)

Setting up mail alias

 * 1) edit /etc/aliases
 * 2) git diff # and git commit (please set GIT_AUTHOR_NAME/GIT_AUTHOR_EMAIL envs)
 * 3) newaliases
 * 4) postfix reload

Mailman

 * SAC:Mailing Lists - mailman configuration for lists.osgeo.org.

Mailman subscriber statistics

 * monthly cronjob "OSGeo mailman server unique subscribers", run as root user with scripts in /home/neteler/osgeo_mailman_stats/*.sh (operated by M. Neteler)

PostgreSQL server
As of April 2017 PostgreSQL 9.6 is installed from pgdg packages and a new cluster was added to host the database for the Drone service (in progress)

Drone service
See SAC::Drone No longer hosted on this

= SSL certificates =


 * LetsEncrypt was configured by Jeff McKenna on 2018-07-27 for mapserver.org, gdal.org, grass.osgeo.org, grasswiki.osgeo.org, drone.osgeo.org, and lists.osgeo.org using certbot-auto
 * careful: check the conf files in /etc/apache2/sites-enabled/ to make sure that the VirtualHost settings do not include something like  and instead should point to the IP such as  or else the certificate loaded will always default to mapserver.org
 * certbot-auto lives in /usr/local/sbin.
 * to add more sites, run the command:"certbot-auto --apache -d mapserver.org -d www.mapserver.org"
 * a cronjob (certbot-auto renew) was created to check for renewal twice a day
 * also enabled for geos.osgeo.org on by Jeff McKenna on 2018-10-01

= Backup strategy =

As of Feb 2017 backup is performed by bacula, with the BackupOg6 job, which includes the whole /var/www, /etc, /osgeo, /var/lib/mysql and more files (see SAC:Backups for info about figuring out more).

A dump of each mysql database is also stored as a separate file under /osgeo (created during the backup phase).

= Hardware =

Details: CPU: 2 x Intel Xeon E5-2620v3, 2.4 GHz (6-Core, HT, 15MB Cache, 85W) 22nm RAM: 128GB (8 x 16GB DDR4-2133 ECC Registered 2R 1.2V DIMMs) Operating at 2133 MT/s Max NIC: Dual Intel i210 Gigabit Ethernet Controllers - Integrated Management: Integrated IPMI 2.0 & KVM over LAN Controller: 10 Ports 6Gb/s SATA (Intel C612 Chipset) PCIe 3.0 x8: No Item Selected NOTE: Hot-swap and fixed drives will be connected to SATA3 controller (C612) unless otherwise specified Hot-Swap Drive - 1: 80GB Intel DC S3500 Series MLC (6Gb/s, 0.3 DWPD) 2.5" SATA SSD    Hot-Swap Drive - 2:  80GB Intel DC S3500 Series MLC (6Gb/s, 0.3 DWPD) 2.5" SATA SSD Hot-Swap Drive - 3: 480GB Intel DC S3500 Series MLC (6Gb/s, 0.3 DWPD) 2.5" SATA SSD    Hot-Swap Drive - 4:  480GB Intel DC S3500 Series MLC (6Gb/s, 0.3 DWPD) 2.5" SATA SSD Hot-Swap Drive - 5: 480GB Intel DC S3500 Series MLC (6Gb/s, 0.3 DWPD) 2.5" SATA SSD    Hot-Swap Drive - 6:  480GB Intel DC S3500 Series MLC (6Gb/s, 0.3 DWPD) 2.5" SATA SSD Optical Drive: No Item Selected

3 year warranty starting on May 4,2015 ending on May 4,2018