andyj

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

andyj

 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

 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

# 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

#Block all IP6 traffic 
*filter

# Reject all IPv6 on all chains.
-A INPUT -j DROP
-A FORWARD -j DROP
-A OUTPUT -j DROP

COMMIT

andyj

-- 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

http {

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

andyj

# From Andy Jarretts post: 
# http://www.andyjarrett.co.uk/2016/08/02/secured-bash-script-to-backup-a-mysql-rds-dump-to-s3/ 
#!/bin/bash
SQLDUMP="$(date +'%Y%m%d%H%M').sql.gz"

echo "Creating backup of database to $SQLDUMP"
mysqldump --login-path=local --databases YourDatabaseName | gzip -9 > $SQLDUMP

echo "Dump Zipped up"

andyj

/**
 * Amazon Web Services Signature 4 Utility for ColdFusion 
 * Version Date: 2016-04-12 (Alpha)
 *
 * Copyright 2016 Leigh (cfsearching)
 *
 * Requirements: Adobe ColdFusion 10+ 
 * AWS Signature 4 specifications: http://docs.aws.amazon.com/general/latest/gr/signature-version-4.html
 *
 * Licensed under the Apache License, Version 2.0 (the "License");

andyj

MY_IP=127.0.0.1

#Ubuntu
#MY_IP=$(wget -qO- icanhazip.com)

#MAC
#MY_IP=$(ifconfig en0 | grep "inet 1" | awk '/inet/ { print $2 } ')

echo Current IP: $MY_IP