Category: howto

Schweiz: Kantonsmittelpunkte

Die Latitude und Longitude der Kantonsmittelpunkte der Schweiz, als .csv:

Aargau, 47.409703, 8.154694                       
Appenzell-Ausserrhoden, 47.366352, 9.36791        
Appenzell-Innerrhoden, 47.317264, 9.416754        
Basel-Landschaft, 47.45176, 7.702414              
Basel-Stadt, 47.564869, 7.615259                  
Bern, 46.823608, 7.636667                         
Fribourg, 46.718391, 7.074008                     
Geneva, 46.220528, 6.132935
Glarus, 46.981042, 9.065751
Graubünden, 46.656248, 9.628198
Jura, 47.350744, 7.156107
Luzern, 47.067763, 8.1102                         
Neuchatel, 46.995534, 6.780126                    
Nidwalden, 46.926755, 8.405302                    
Obwalden, 46.854527, 8.244317                     
Schaffhausen, 47.71357, 8.59167                   
Schwyz, 47.061787, 8.756585
Solothurn, 47.304135, 7.639388                    
St-Gallen, 47.2332, 9.274744                      
Thurgau, 47.568715, 9.091957                      
Ticino, 46.295617, 8.808924                       
Uri, 46.771849, 8.628586
Valais, 46.209567, 7.604659
Vaud, 46.570091, 6.657809
Zug, 47.157296, 8.537294
Zurich, 47.41275, 8.65508

Quellen: https://de.wikipedia.org/wiki/Mittelpunkt_der_Schweiz#Kantonsmittelpunkte und https://tools.wmflabs.org/

howto: self signed ssl certificate for apache2 on debian buster

# create storage location for cert+key
mkdir /etc/apache2/ssl && cd /etc/apache2/ssl

# generate cert+key
openssl req -x509 -newkey rsa:4096 -nodes -subj '/CN=7362cb9e-13a0-4043-87f3-4a176a8aec64' -keyout key.pem -out cert.pem -days 365

# enable ssl
sudo a2enmod ssl

# set up ssl, and redirect non-ssl
cat sites-available/default.conf 
<VirtualHost *:80>
  RewriteEngine On
  RewriteCond %{HTTPS} off
  RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]
</VirtualHost>

<VirtualHost _default_:443>
  DocumentRoot /var/www/default

  ErrorLog ${APACHE_LOG_DIR}/default.ssl.error.log
  CustomLog ${APACHE_LOG_DIR}/default.ssl.access.log combined

  SSLEngine on
  SSLCertificateFile    /etc/apache2/ssl/cert.pem
  SSLCertificateKeyFile /etc/apache2/ssl/key.pem

  <FilesMatch "\.(cgi|shtml|phtml|php)$">
     SSLOptions +StdEnvVars
  </FilesMatch>
  <Directory /usr/lib/cgi-bin>
    SSLOptions +StdEnvVars
  </Directory>
</VirtualHost>

# enable site and restart
a2ensite default
systemctl restart apache2

mostly as a reminder for future-me 🙂