varnav’s gists

varnav / adusers_weblist.php

Last active January 7, 2024 10:24

Web table listing active directory users

	<!doctype html>
	<html>
	<head>

	<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
	<title>Список сотрудников</title>

	<style>
	a {text-decoration : none}
	a:link {color : #000000}

varnav / queryhhjobs.php

Last active December 22, 2016 16:07

Get amount of jobs with given salaries from hh.ru

	#!/usr/bin/php

	<?php

	// Get amount of jobs with given salaries from hh.ru
	// Add this to /etc/cron for every 2 hours check and record:
	// 00 /2 * * user /home/user/queryhhjobs.php >> /home/user/jobs.csv
	// or use user-level crontab with "crontab -e"

	function getjobcount($salary_from = -1)

varnav / asterisk_no_international.dialplan

Created January 15, 2016 10:46

	; Disallow international with exceptions
	exten => _9810800.,1,Goto(outbound-allroutes,${EXTEN},1) ; Toll free ok!
	exten => _9810.,1,GotoIf($["${CALLERID(num)}" = "335"]?outbound-allroutes,${EXTEN},1) ; Allow 8-10
	exten => _9810.,1,GotoIf($["${CALLERID(num)}" = "336"]?outbound-allroutes,${EXTEN},1) ; Allow 8-10
	exten => _9810.,n,Playback(feature-not-avail-line) ; Disallow 8-10
	exten => _9810.,n,Hangup()
	exten => _900.,1,Playback(feature-not-avail-line) ; Disallow 00
	exten => _900.,n,Hangup()

varnav / install_zabbix_agent.cmd

Last active July 18, 2016 08:23

	mkdir "c:\program files\zabbix\"
	copy zabbix_agentd.conf "c:\program files\zabbix\"
	copy zabbix_agentd.exe "c:\program files\zabbix\"
	"c:\program files\zabbix\zabbix_agentd.exe" --config "c:\program files\zabbix\zabbix_agentd.conf" --install
	"c:\program files\zabbix\zabbix_agentd.exe" --config "c:\program files\zabbix\zabbix_agentd.conf" --start
	netsh advfirewall firewall add rule name="Zabbix agent" dir=in action=allow program="c:\program files\zabbix\zabbix_agentd.exe" profile=domain enable=yes
	netsh advfirewall firewall add rule name="Zabbix agent" dir=in action=allow program="c:\program files\zabbix\zabbix_agentd.exe" profile=private enable=yes

varnav / get-windows-key.ps1

Created January 15, 2016 10:53

	function Get-WindowsKey {
	## function to retrieve the Windows Product Key from any PC
	## by Jakob Bindslet ([email protected])
	param ($targets = ".")
	$hklm = 2147483650
	$regPath = "Software\Microsoft\Windows NT\CurrentVersion"
	$regValue = "DigitalProductId4"
	Foreach ($target in $targets) {
	$productKey = $null
	$win32os = $null

varnav / zabbix.cnf

Last active October 1, 2020 14:58

MariaDB 10.1 config file for Zabbix 3.0

	# MariaDB 10.1 config file for Zabbix 3.0
	#
	# MariaDB programs look for option files in a set of
	# locations which depend on the deployment platform.
	# You can copy this option file to one of those
	# locations. For information about these locations, do:
	# 'my_print_defaults --help' and see what is printed under
	# Default options are read from the following files in the given order:
	# More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
	#

varnav / asterisk_easy_backup.sh

Created March 28, 2016 17:31

	#!/bin/sh
	#
	MyBackup="mysql.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
	MyBackup2="etcdir.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
	MyBackup3="wwwdir.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
	MyBackup4="varlib.backup.`date +%Y.%m.%d.at.%H.%M.%S`.tbz"
	rm -f /astdb/backups/backup.sql
	/usr/bin/mysqldump -udump -pdump --skip-add-drop-table --single-transaction --all-databases > /astdb/backups/backup.sql
	cd /astdb/backups/
	tar cjf $MyBackup backup.sql

varnav / make_openvpn_client_certs.sh

Last active June 7, 2016 08:57

varnav / slack_jenkins_build_trigger_proxy.php

Created July 18, 2016 15:46

Will receive web hook from slack and trigger build job at Jenkins

	<?php
	if (!($_REQUEST['token'] == '')) die('I`m afraid, Dave, I can`t do that.');

	$jenkins_url = 'http://jenkins.local';

	$job_name = str_replace($_REQUEST['trigger_word'].' ', '', $_REQUEST['text']);
	$job_name = str_replace('/', '', $job_name); // Anti-injection
	//$job_name = preg_replace('/[^A-Za-z0-9\-]/', '', $job_name); // Remove special chars

	$url=$jenkins_url.'/job/'.$job_name.'/build';

varnav / gist:20ecf935a2e109fe92ec98e14d2b4d49

Created August 26, 2016 11:03

Sipura/Linksys/Cisco SPA phones BLF line for FreePBX

	To add BLF enter in Line Key -> Extended Function

	fnc=blf+sd+cp;sub=123@$PROXY;ext=123@$PROXY

	where 123 is number to watch.

	No additional settings in recent FreePBX versions needed.

Evgeny Varnavskiy varnav