Andy Jarrett andyj

andyj / nginx.conf

Last active November 16, 2020 01:36 — forked from tonyjunkes/nginx.conf

Server portion for setting up a proxy to Lucee with rewrite to have index.cfm omitted for SES.

	http {

	...
	server {
	listen 80;
	server_name example.com;
	root /var/www/exmaple.com/www/;
	index index.cfm;
	set $lucee_context "example.com";

andyj / Change_all_CHARACTER_SET_in_a_Mysql_database.sql

Last active April 8, 2016 10:15

Change all CHARACTER SETs in a Mysql database.sql

	-- This pull back a list of tables which have NON-UTF8 encoded columns and creates a SQL script to fix them (and the table itself)
	SELECT CONCAT("ALTER TABLE ",t.TABLE_SCHEMA,".",t.TABLE_NAME," CHARACTER SET utf8 COLLATE utf8_general_ci;",
	"ALTER TABLE ",t.TABLE_SCHEMA,".",t.TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;")
	AS sql_to_copy_and_run
	FROM information_schema.TABLES t
	INNER JOIN information_schema.`COLUMNS` c ON t.TABLE_SCHEMA = c.TABLE_SCHEMA
	WHERE
	t.TABLE_SCHEMA = ? -- Replace ? with your Database/Schema name
	AND t.table_type = 'BASE TABLE' AND character_set_name IS NOT NULL AND character_set_name <> 'utf8'
	GROUP BY t.TABLE_SCHEMA, t.TABLE_NAME

andyj / gist:4db2d83e4cccf811099e

Created March 17, 2016 12:47

IP6 IPTables rules

andyj / gist:11eb25b52d4d72df3f80

Last active March 17, 2016 12:45

IP4 IPTable rules

	# Found on https://nodeswat.com/blog/setting-up-a-secure-node-js-web-application/
	# Slightly modified

	*filter

	# Default policy is to drop all traffic
	-P INPUT DROP
	-P FORWARD DROP
	-P OUTPUT DROP

andyj / findSPByDefinition.sql

Created October 26, 2015 22:53

Searching MSSQL database for a Stored Proc by T-SQL Definition

	sp_MSforeachdb 'SELECT "?" AS DB,
	r.SPECIFIC_SCHEMA, r.routine_name, r.ROUTINE_DEFINITION, p.ORDINAL_POSITION, p.PARAMETER_MODE, p.PARAMETER_NAME, p.DATA_TYPE
	FROM [?].INFORMATION_SCHEMA.ROUTINES r
	JOIN [?].INFORMATION_SCHEMA.PARAMETERS p ON r.SPECIFIC_SCHEMA = p.SPECIFIC_SCHEMA AND r.SPECIFIC_NAME = p.SPECIFIC_NAME
	WHERE
	r.ROUTINE_TYPE = ''PROCEDURE''
	AND left(r.ROUTINE_NAME,2) <> ''dt''
	AND r.ROUTINE_DEFINITION LIKE ''%someSQLCode%''
	ORDER BY r.SPECIFIC_NAME ASC, p.ORDINAL_POSITION ASC'

andyj / findSPByName.sql

Created October 26, 2015 22:51

Searching MSSQL database for a Stored Proc by name

	sp_MSforeachdb 'SELECT "?" AS DB,
	r.SPECIFIC_SCHEMA, r.routine_name, r.ROUTINE_DEFINITION, p.ORDINAL_POSITION, p.PARAMETER_MODE, p.PARAMETER_NAME, p.DATA_TYPE
	FROM [?].INFORMATION_SCHEMA.ROUTINES r
	JOIN [?].INFORMATION_SCHEMA.PARAMETERS p ON r.SPECIFIC_SCHEMA = p.SPECIFIC_SCHEMA AND r.SPECIFIC_NAME = p.SPECIFIC_NAME
	WHERE
	r.ROUTINE_TYPE = ''PROCEDURE''
	AND left(r.ROUTINE_NAME,2) <> ''dt''
	AND r.routine_name LIKE ''%yourStoredProcName%''
	ORDER BY r.SPECIFIC_NAME ASC, p.ORDINAL_POSITION ASC'

andyj / find-MSSQL-table-on-server.sql

Created October 26, 2015 22:29

Search all MSSQL databases on a server for a table

 sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name like ''%tableNameYouAreSearchingFor%'''

andyj / isAddressDown-SoundAlarm.sh

Created October 26, 2015 22:25

Terminal script to sound alarm when an IP address is not reachable again

	pingIpAddress=google.com
	while :
	do
	ping -t 2 -o -c 1 $pingIpAddress \|\| say ping to $pingIpAddress failing
	sleep 2
	done

andyj / isAddressUp-SoundAlarm.sh

Created October 26, 2015 22:21

Terminal script to sound alarm when an IP address is reachable again

	pingAddress=google.com
	while :
	do
	ping -t 2 -o pingAddress && say ping $pingAddress working
	sleep 2
	done

andyj / find-and-kill.sql

Created October 13, 2015 08:54

Transaction (Process ID) was deadlocked on lock - find and kill process