Skip to content

Instantly share code, notes, and snippets.

@mkubenka
mkubenka / rpi-kiosk.md
Created September 3, 2017 10:44
RPi Kiosk

RPi Kiosk

$ sudo apt-get update
$ sudo apt-get install unclutter
$ vim.tiny ~/.config/lxsession/LXDE-pi/autostart
@mkubenka
mkubenka / isohybrid.pl
Created November 21, 2018 09:51 — forked from jsarenik/isohybrid.pl
isohybrid.pl from Syslinux-6.03
#!/usr/bin/perl
## -----------------------------------------------------------------------
##
## Copyright 2002-2008 H. Peter Anvin - All Rights Reserved
## Copyright 2009 Intel Corporation; author: H. Peter Anvin
##
## This program is free software; you can redistribute it and/or modify
## it under the terms of the GNU General Public License as published by
## the Free Software Foundation, Inc., 53 Temple Place Ste 330,
## Boston MA 02111-1307, USA; either version 2 of the License, or
@mkubenka
mkubenka / get_snds_data.py
Created April 18, 2016 17:14
Download Outlook Smart Network Data Service Data for last 90 days
# Enable automated data access under https://postmaster.live.com/snds/auto.aspx
import datetime
import requests
import shutil
DATA_URL = 'https://postmaster.live.com/snds/data.aspx?key=xx'
for i in range(90):
date = datetime.datetime.now() + datetime.timedelta(-i)
@mkubenka
mkubenka / install-parallel-centos-6.sh
Created March 24, 2017 11:28
Install GNU Parallel on CentOS 6
#!/bin/bash
# Install GNU parallel on CentOS 6.
# http://software.opensuse.org//download.html?project=home%3Atange&package=parallel
cd /etc/yum.repos.d/
wget http://download.opensuse.org/repositories/home:tange/CentOS_CentOS-6/home:tange.repo
yum install parallel
# Alternative:
@mkubenka
mkubenka / search_mysql.md
Last active May 24, 2021 20:52
How to search whole MySQL database for a particular string

How to search whole MySQL database for a particular string

https://dba.stackexchange.com/a/37041/7994

SELECT
    CONCAT('SELECT ',QUOTE(db),',',QUOTE(tb),',',QUOTE(col),',COUNT(1) FieldHasIt
    FROM `',db,'`.`',tb,'` WHERE \`',col,'\` LIKE ''%',SearchString,''%';') SearchSQL
FROM
(
@mkubenka
mkubenka / install.sh
Created April 23, 2016 19:28
OpenVPN Access Server Letsencrypt
#!/bin/sh
apt-get -y install git bc
git clone https://github.com/letsencrypt/letsencrypt /opt/letsencrypt
mkdir /etc/letsencrypt
@mkubenka
mkubenka / Vagrantfile
Last active October 12, 2022 05:34
Windows on AWS with Vagrant
require 'inifile'
require 'date'
Vagrant.configure("2") do |config|
config.vm.box = "dummy"
config.vm.guest = "windows"
config.vm.boot_timeout = 600
config.vm.provider :aws do |aws, override|
@mkubenka
mkubenka / centos_php_fpm_coredumps.md
Created March 23, 2020 16:03
How to enable CentOS PHP-FPM coredumps.

CentOS PHP-FPM coredumps

https://wiki.archlinux.org/index.php/Core_dump

Enabling core dumps for PHP-FPM on CentOS 7 require several steps.

Set the rlimit_core directive in /etc/php-fpm.d/pool.conf and /etc/php-fpm.conf to unlimited:

rlimit_core = unlimited
@mkubenka
mkubenka / sparsecheckout.yml
Created December 1, 2018 17:43
Ansible Sparse Checkout
---
- hosts: all
vars:
repo_url: ssh://git@github.com/user/repo.git
base_dir: /var/www
sparse_checkout:
- folder1