Today, on a production system errors started arising from a Django based application that made use of PostGIS features. All SQL queries that included any geo data were failing. This was on PostgreSQL 9.6 on Centos 7.
Welcome to my blog
As I discover new things in my field and solve troublesome problems, I will attempt to document my finds here.
If you ever find yourself using Apache as a frontend server or reverse proxy, as opposed to one Nginx, for example. You may want to be sure to pass the actual host IP and scheme information back to your application so that it may function properly. By default, mod_proxy sets the
X-Forwarded-For header. But that header is a list, and is used by other types of proxies. You may want to set the
X-Real-IP as well. The following entries into your
VirtualHost or similar should do the job:
Working with SSL certificates in Openfire are surprisingly troublesome, at least as compared to popular web servers (Apache hTTPd, Nginx, IIS).
I recently needed to update an expiring certificate (having once, previously, figured out how to successfully import a purchased, SSL certificate.
This time I found a nice tutorial: https://alpha-labs.net/2014/12/openfire-and-ciphers/. Thanks to Christian for that.
I’ve made some slight modifications to his Shell script, and I just wanted to share:
Every now and again I find myself having to rebuild DNS entries for a client who has Google Apps hosted email. Googling for the appropriate queries gets me there, but in a round about fashion, so I’ve decided to collect the relevant pages here.