Anton Kvashenkin jugatsu

People

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

This script will let you make backups of live VMs running on KVM, using libvirt.

The backup job will suspend the VM for the time it takes to copy the RAM to disk.

I've made some minor adjustments.

	require("lsqlite3")

	-- Igmar: Wanneer closen we dat DB object eigenlijk ?
	db = sqlite3.open('/etc/asterisk/users.sqlite')

	--CONSOLE = "Console/dsp" -- Console interface for demo
	--CONSOLE = "DAHDI/1"
	--CONSOLE = "Phone/phone0"

	TRUNK = "DAHDI/G1"

	# {{ ansible_managed }}

	# This file describes the network interfaces available on your system
	# and how to activate them. For more information, see interfaces(5).

	# The loopback network interface
	auto lo
	iface lo inet loopback

	{% if ansible_interfaces\|length > 2 %}

	# -- mode: ruby --
	# vi: set ft=ruby :

	# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
	VAGRANTFILE_API_VERSION = "2"

	Vagrant.configure(VAGRANTFILE_API_VERSION) do \|config\|
	# All Vagrant configuration is done here. The most common configuration
	# options are documented and commented below. For a complete reference,
	# please see the online documentation at vagrantup.com.

	. . .
	Messages {
	Name = Standard
	mailcommand = "/usr/local/bin/sendEmail-backup \"[BACKUP] %t %e of %n %l\" \"%r\""
	operatorcommand = "/usr/local/bin/sendEmail-backup \"[BACKUP] Intervention needed for %j\" \"%r\""
	mail = [email protected] = all, !skipped
	operator = [email protected] = mount
	console = all, !skipped, !saved
	append = "/var/log/bacula/bacula.log" = all, !skipped
	catalog = all

	# A commented nginx configuration file for Ruby on Rails
	#
	# Author: Tommaso Pavese
	# [email protected]
	# http://tommaso.pavese.me
	#
	# License: http://www.wtfpl.net/
	#
	#
	# Tested with:

	# Remote Gateway Node to Login to App Servers - 192.168.1.1
	Host app_proxy1
	Hostname 192.168.1.1
	LocalForward 8080 192.168.1.100:8080
	LocalForward 8081 192.168.1.101:8080
	LocalForward 8082 192.168.1.102:8080

	Host app_proxy2
	Hostname 192.168.1.1
	LocalForward 8090 192.168.1.100:8081

	Configuration SCCMDistributionPoint
	{
	# Create NO_SMS_ON_DRIVE.SMS file on C:\ drive
	File NoSmsOnDrive
	{
	DestinationPath = "C:\NO_SMS_ON_DRIVE.SMS"
	Contents = [System.String]::Empty
	Type = "File"
	Ensure = "Present"
	}