varnav’s gists

varnav / daterate.py

Created January 24, 2021 20:42

Подстановка курсов валют ЦБ на заданную дату в xlsx файле

	#!/usr/bin/env python3

	import datetime
	import click
	import requests
	import xmltodict
	from openpyxl import load_workbook


	@click.command()

varnav / observium_discover.sh

Last active April 16, 2021 16:23

Observium scan and add

	# apt update && apt install -y braa parallel

	sysctl -w net.core.rmem_max=26214400
	cd /opt/observium
	braa -d 15000 -p 300 'public'@10.240.0.1-10.240.255.254:.1.3.6.1.2.1.1.5.0 \| cut -d ":" -f4 \| parallel ./add_device.php

varnav / windows_winrm_http.tf

Last active January 4, 2024 15:58

Windows VM with HTTPS WinRM Terraform

	resource "azurerm_key_vault_certificate" "main" {
	name = "${terraform.workspace}-winrmcert"
	key_vault_id = var.key_vault_id

	certificate_policy {
	issuer_parameters {
	name = "Self"
	}

	key_properties {

varnav / gist:7aafe0887d39542c9498356456102592

Created April 1, 2020 13:30

Bash log to file

varnav / gist:7522db51b9c17fc7ee3cd6c7162368db

Last active February 25, 2022 18:50

Docker bare metal basics

	Misc:

	apt install mc fail2ban htop openvpn git iotop lsof

	Add to /etc/sysctl.d/70-bufferbloat.conf

	net.core.default_qdisc=fq
	net.ipv4.tcp_fastopen=3
	net.ipv4.tcp_ecn=1
	net.ipv4.tcp_sack=1

varnav / gist:82a545105681753c19aabbbef6435863

Created January 24, 2020 13:38

ZX old directories

XZ_OPT="--threads=4" nohup find . -maxdepth 1 -type d -mtime +1000 -exec tar --remove-files -cJf {}.tar.xz {} \; &

varnav / new_curl_el7.yml

Created December 16, 2019 18:56

New curl for EL7 ansible

	- name: Get curl {{curlver}} packages
	get_url: url={{ item }} dest=/tmp/
	with_items:
	- https://mirror.city-fan.org/ftp/contrib/sysutils/Mirroring/curl-{{ curlver }}-2.0.cf.rhel7.x86_64.rpm
	- https://mirror.city-fan.org/ftp/contrib/sysutils/Mirroring/libcurl-{{ curlver }}-2.0.cf.rhel7.x86_64.rpm
	- https://mirror.city-fan.org/ftp/contrib/libraries/libmetalink-0.1.3-9.rhel7.x86_64.rpm
	- https://mirror.city-fan.org/ftp/contrib/libraries/c-ares-1.15.0-4.0.cf.rhel7.x86_64.rpm
	- https://mirror.city-fan.org/ftp/contrib/libraries/libssh2-1.9.0-3.0.cf.rhel7.x86_64.rpm
	- https://mirror.city-fan.org/ftp/contrib/libraries/libidn-1.34-3.0.el7.x86_64.rpm
	tags: curl

varnav / pagespeed_optimize_images.sh

Last active June 14, 2022 07:46 — forked from julianxhokaxhiu/pagespeed_optimize_images.sh

Recursively optimize all PNG and JPG files

	#!/bin/bash

	# https://code.luasoftware.com/tutorials/linux/command-line-optimize-image/

	find . -type f -iname '*.png' -exec pngquant --skip-if-larger --ext .png --force 256 {} \;
	find . -type f -iname "*.png" \| xargs optipng -o2 -strip all
	find . -name '*.png' -print0 \| xargs -0 -n1 -I{} sh -c 'zopflipng {} output.png; [ -f output.png ] && mv output.png {};'

	# Using -print0 to deal with spaces
	find . -print0 -type f -name ".jpg" -o -name ".JPG" \| xargs -0 jpegoptim

varnav / wifimon.sh

Last active May 14, 2019 22:56

Monitor and restart WiFi for Raspbian

	#!/bin/bash

	ping -c4 192.168.1.1 > /dev/null

	if [ $? != 0 ]
	then
	d=`date`
	echo "$d No network connection, restarting wlan0" >> /var/log/wifimon.txt
	ifconfig wlan0 down
	sleep 5

varnav / gist:0e87701d4b6113aed3c938a1c7f1259e

Last active July 13, 2019 18:08

Merge devel to master and reset it

Evgeny Varnavskiy varnav