squadrun/django-log-analyser

Simple app for Django to run pgbadger on logs downloaded from RDS

Log Analyser

Install django-log-analyser

Via pip:

pip install django-log-analyser

Install pgbadger in Ubuntu

1. Open your source list file:

   sudo nano /etc/apt/sources.list

2. Modify the file to include "yakkety universe" as a source:

   deb http://us.archive.ubuntu.com/ubuntu yakkety universe

3. Update your system:

   sudo apt-get update

4. Install pgbadger:

   sudo apt-get install pgbadger

Quick start

1. Add apps from "log_analyser" to your INSTALLED_APPS setting like this:

   INSTALLED_APPS = [
       ...
       'log_analyser',
   ]

2. Include the log_analyser URLconf in your project urls.py like this:

   url(r'', include('log_analyser.urls')),

3. "log_analyser" needs you to add a few constants to your settings:

   AWS_REGION = "aws-region"
   BUCKET_LOG_ANALYSER = 'bucket-name'
   RDS_DB_INSTANCE_IDENTIFIER = ['rds-db-instance-identifier-1', 'rds-db-instance-identifier-2' ...]
   RDS_TEMP_LOG_FILE_LOCATION = "/var/tmp/"
   AWS_ACCESS_KEY_ID = "aws-access-key"
   AWS_SECRET_ACCESS_KEY = "aws-secret-access-key"

4. Run python manage.py migrate to create the log_analyser models.