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.
Arthur
Pemberton
Full-stack web applications developer
Welcome to my blog
As I discover new things in my field and solve troublesome problems, I will attempt to document my finds here.
Backend request heades with an Apache reverse proxy (frontend server)
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-Forwarded-Proto and X-Real-IP as well. The following entries into your VirtualHost or similar should do the job:
Openfire certificate import
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:
Read More
got an unexpected keyword argument ‘server_hostname’
If you’re seeing this exception, you’re probably using some combination of the Python requests library, and gevent.
Read More
Google Apps DNS Entries
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.