Send Apache 2.4 access log to Graylog over TCP

Graylog accepts a format called GELF. GELF is short for Graylog Extended Log Format. GELF appears like a straightforward JSON. Apache 2.4 logs are not in JSON format. This short blog helps explain two things: Configure Apache 2.4’s /etc/apache2.conf to log GELF Configure Apache 2.4’s site /etc/apache2/sites-enabled/000-default.conf to pass new log lines to a custom […]

Configure PgBouncer to authenticate against PostgreSQL and rely less on userlist.txt

PgBouncer is a lightweight connection pooler. When a user connects to PgBouncer, the user’s username and password is checked against userlist.txt file. If you haven’t installed PostgreSQL, see Install PostgreSQL 9.6 on Ubuntu 16.04 and reset postgres password Disadvantage of userlist.txt The disadvantage is whenever new user is added to PostgreSQL, the user’s username and password […]

Install PostgreSQL 9.6 on Ubuntu 16.04 and reset postgres password

PostgreSQL is really easy to install on Ubuntu 16.04 LTS. This example uses command line to install PostgreSQL and vim to edit files. These settings are for non-production use. Set source to get PostgreSQL Set up the right source so that we can install PostgreSQL with apt-get. Enter sudo vim /etc/apt/sources.list.d/pgdg.list Type i to go to INSERT […]

Install MySQL 5.7 on Windows 10

Download MySQL There are several ways to install MySQL. This article focuses on utilizing MySQL Installer for Windows to install MySQL. You will need administrative rights to install MySQL. Press Windows-key + Pause on your keyboard to open System Properties. System Type will indicate whether your computer is x86 (32-bit) or x64 (64-bit). Remember system […]

Fixing CVE-2014-6271 remote code execution through bash on Ubuntu and CentOS

Fixing CVE-2014-6271 In many common configurations, this vulnerability is exploitable over the network. Chet Ramey, the GNU bash upstream maintainer, will soon release official upstream patches. Issue with CVE-2014-6271 http://seclists.org/oss-sec/2014/q3/649 Stephane Chazelas discovered a vulnerability in bash, related to how environment variables are processed: trailing code in function definitions was executed, independent of the variable name. […]

Address to latitude/longitude using Google Maps API v3 Geocoding

Google Maps API v3 Geocoding Google Maps API v3 has several services, of which one is Geocoding service. This service allows conversion of an address to a latitude and longitude. Along with this information, a lot of good information about the geocoding process is returned. This article highlights how to geocode an address to latitude/longitude […]