sysboss

#!/usr/bin/env python3
#
# Query AWS Athena using SQL
# Copyright (c) Alexey Baikov <sysboss[at]mail.ru>
#
# This snippet is a basic example to query Athen and load the results
# to a variable.
#
# Requirements:
# > pip3 install boto3 botocore retrying

sysboss

#!/usr/bin/python
#
# Removes grafana_rule_* clients from Sensu
# Copyright (c) Alexey Baikov <sysboss[at]mail.ru>
#
# This script cleans up "successful" grafana rules
# that left in Sensu clients list.

import sys
import json

sysboss

#!/bin/bash
# Bash code injection into bash script
# Copyright (c) Alexey Baikov <sysboss [at] mail.ru>
#
# This script will inject multiline code from 'injection.sh' file
# before or after a certain line in 'script.sh' file
#
# target_script    - Script to inject into
# injection_script - Code lines to inject
# patern           - Line to inject the code (before/after)

sysboss

#!/bin/bash
#
# EC2 tags to variables
# Copyright (c) Alexey Baikov <sysboss[at]mail.ru>
#
# Description:
# Gets all EC2 tags and converts them to Bash variables
# Based on 'jq' (https://stedolan.github.io/jq/)

INSTANCE_REGION="$(curl -s http://169.254.169.254/latest/dynamic/instance-identity/document | grep region | tr -d ' ' | cut -f2 -d: | tr -d '"' | tr -d ',')"

sysboss

#!/bin/bash
# Provide key uid from `gpg --list-keys`
# Based on: https://blog.tersmitten.nl/how-to-ultimately-trust-a-public-key-non-interactively.html

KEY_NAME=""

echo "$( \
  gpg --list-keys --fingerprint \
  | grep "${KEY_NAME}" -B 1 | head -1 \
  | tr -d '[:space:]' | awk 'BEGIN { FS = "=" } ; { print $2 }' \

sysboss

#!/bin/bash
# AWS Instance Termination Notice Handler
# Based on: https://blog.fugue.co/2015-01-06-spot-termination-notices.html

while true; do
    # get meta-data HTTP headers
    HEADER=$(curl -Is http://169.254.169.254/latest/meta-data/spot/termination-time)

    # HTTP 404 - not marked for termination
    if [ -z $(echo $HEADER | head -1 | grep 404 | cut -d \  -f 2) ]; then

sysboss

#!/bin/bash
#
# Keeps latest X tags of every Docker Image

KEEP_IMAGES_BACK=2

echo Retrieving local images available

# get all images
IMAGES=$(docker images | sort | awk '{print $1}' | uniq | grep -v "")

sysboss

This article will briefly describe how to install SonarQube as Docker container on Amazon EC2 and integrate it with Jenkins.

Create database instance and user

Go to RDS > Parameter Groups
Create a new Parameter Group with the following parameter:

max_allowed_packet = 268435456

We need to create a new RDS database for SonarQube (you may use an existing MySQL instance)

1. Go to RDS Instances