Skip to content

Instantly share code, notes, and snippets.

View Voronenko's full-sized avatar
turning coffee into code since late 90s

Vyacheslav Voronenko

turning coffee into code since late 90s
View GitHub Profile
@Voronenko
Voronenko / keyscan yet unknown box
Created September 2, 2016 20:17
keyscans box by ip and adds to list of the known hosts
echo keyscan jump box
ssh-keyscan -t rsa,dsa $JUMP_BOX 2>&1 | sort -u - ~/.ssh/known_hosts > ~/.ssh/tmp_hosts
mv ~/.ssh/tmp_hosts ~/.ssh/known_hosts
@Voronenko
Voronenko / z
Created September 5, 2016 06:56
/usr/bin/z - launch your aliases from alt-F2 via z ALIASNAME
#!/usr/bin/zsh -i
eval "$@"
@Voronenko
Voronenko / root_via_ssh_key
Last active September 21, 2016 10:15
DO NOT DO THIS ON PRODUCTION SYSTEM!!!
sudo nano /etc/ssh/sshd_config
Change
PermitRootLogin without-password
StrictModes yes
to set of
@Voronenko
Voronenko / route53_delete_zone.py
Created October 11, 2016 15:22
Route53 delete zone
def delete_zone(domain):
""" Deleting a hosted zone in AWS is a real pain if you have any number of
resource records defined because you must first delete all RR's in order to
remove the zone. This is a one-stop script to do all of that in one command.
"""
import boto
from boto.route53.record import ResourceRecordSets
PROTECTED_DOMAINS = ['foo.com', 'bar.net']
@Voronenko
Voronenko / downgrademysql.md
Last active June 25, 2020 11:45
Downgrade mysql to mysql 5.6 on xenial

Install MySQL 5.6 in Ubuntu 16.04

Ubuntu 16.04 only provides packages for MySQL 5.7 which has a range of backwards compatibility issues with code written against older MySQL versions.

Oracle maintains a list of official APT repositories for MySQL 5.6, but those repositories do not yet support Ubuntu 16.04. However, the 15.10 repos will work for 16.04.

Uninstall existing mysql 5.7 if any

sudo apt remove mysql-client mysql-server libmysqlclient-dev mysql-common
@Voronenko
Voronenko / idempotent_ansible_cron.yml
Created November 3, 2016 10:59
Idempotent random cron expression for ansible
expr $((16#`echo "user_command" | md5sum | cut -c 1-4`)) % 59
@Voronenko
Voronenko / regenerate_pub.sh
Created November 7, 2016 10:41
Regenerate pub key from private
ssh-keygen -y -f ~/.ssh/id_rsa > ~/.ssh/id_rsa.pub
@Voronenko
Voronenko / check_postgres_db_DBNAME_exists.sh
Created November 17, 2016 13:10
Check postgres db DBNAME exists
psql -lqt | cut -d \| -f 1 | grep -qw DBNAME
"""
"""
from __future__ import (absolute_import, division, print_function)
from ansible.errors import AnsibleError
from ansible.plugins.lookup import LookupBase
__metaclass__ = type
class LookupModule(LookupBase):
@Voronenko
Voronenko / wine-ttf-mscorefonts-installer.txt
Created December 12, 2016 09:10
Fix wine popup "ttf-mscorefonts-installer"
Install the package ttf-mscorefonts-installer, we need some things from the package ater
sudo apt-get install ttf-mscorefonts-installer
Download and install the fonts
TMP=$(mktemp -d)
cd "$TMP"
awk '/Url/ {system("wget "$2)}' /usr/share/package-data-downloads/ttf-mscorefonts-installer
sudo /usr/lib/msttcorefonts/update-ms-fonts "$TMP"/*