Skip to content

Instantly share code, notes, and snippets.

@volkanpaksoy
volkanpaksoy / Backing-Up-MySQL-to-AWS-S3-with-Powershell.ps1
Created October 31, 2019 14:35
Backing-Up-MySQL-to-AWS-S3-with-Powershell
# Make sure you have AWS PowerShell module installed
# Install-Module -Name AWSPowerShell
$ErrorActionPreference = 'Stop'
# MySQL Settings
$server = '.'
$database = '<DB NAME>'
$user = '<DB USER>'
$password = '<PASSWORD>'
@volkanpaksoy
volkanpaksoy / Backing-Up-GitHub-Account-with-Bash.sh
Created October 31, 2019 14:41
Backing-Up-GitHub-Account-with-Bash
#! /bin/bash
backupDir='/repos'
token='{GITHUB USERNAME}:{PERSONAL ACCESS TOKEN}'
base64Token=$(echo -n $token | base64)
cd $backupDir
page=1
perPage=30
url="https://api.github.com/user/repos?page=$page&per_page=$perPage"
CREATE (homer:Character {firstname: "Homer", lastname: "Simpson"})
CREATE (marge:Character {firstname: "Marge", lastname: "Simpson"})
CREATE (lisa:Character {firstname: "Lisa", lastname: "Simpson"})
CREATE (bart:Character {firstname: "Bart", lastname: "Simpson"})
CREATE (maggie:Character {firstname: "Maggie", lastname: "Simpson"})
CREATE (homer)-[:MARRIED_TO]->(marge)
CREATE (marge)-[:MOTHER_OF]->(lisa)
CREATE (marge)-[:MOTHER_OF]->(bart)
CREATE (marge)-[:MOTHER_OF]->(maggie)
CREATE (homer)-[:FATHER_OF]->(lisa)
@volkanpaksoy
volkanpaksoy / Backing-Up-GitHub-Account-with-PowerShell.ps1
Created October 31, 2019 14:36
Backing-Up-GitHub-Account-with-PowerShell
$backupDirectory = '{BACKUP ROOT DIRECTORY}'
$token = '{GIT USERNAME}:{PERSONAL ACCESS TOKEN}'
$base64Token = [System.Convert]::ToBase64String([char[]]$token)
$headers = @{
Authorization = 'Basic {0}' -f $base64Token
};
Set-Location -Path $backupDirectory
$page = 1
@volkanpaksoy
volkanpaksoy / AutomatedEmailLambda.js
Created October 31, 2019 14:33
AutomatedEmailLambda
var targetEmail = '{TARGET_EMAIL_ADDRESS}'
var fromEmail = '{FROM_EMAIL_ADDRESS}'
var bccEmail = '{BCC_EMAIL_ADDRESS-TO_VERIFY}'
var sesAccessKey = '{ACCESS_KEY}'
var sesSecretKey = '{SECRET_KEY}'
exports.handler = function(event, context) {
sendMail(context);
};
@volkanpaksoy
volkanpaksoy / MailAutomationWithSns.js
Created October 31, 2019 14:28
MailAutomationWithSns
var bucketName = "{BUCKET_NAME}";
var fileName = "mail-automation-last-sent-date.txt";
var targetDayOfMonth = 7;
exports.handler = function(event, context) {
var async = require('async');
var AWS = require('aws-sdk');
var s3 = new AWS.S3();
var nodemailer = require('nodemailer');
@volkanpaksoy
volkanpaksoy / AnalyzeNmapOutput.ps1
Created October 31, 2019 14:24
AnalyzeNmapOutput
. "PATH\TO\EMAIL\SCRIPT\send-email.ps1"
$configPath="PATH\TO\CONFIG\config.xml"
$tempFilePath = "C:\Temp\temp.xml"
$nmapBucketAccessKey = "ACCESS KEY"
$nmapBucketSecretKey = "SECRET KEY"
Write-Host "Reading configuration file"
$xdocConfig = [xml] (Get-Content $configPath)
@volkanpaksoy
volkanpaksoy / UpdateSecurityGroup.ps1
Created October 31, 2019 14:21
UpdateSecurityGroup
$urlToCheckIp = "http://check-ip.herokuapp.com"
$accessKey = "{ACCESS KEY}"
$secretKey = "{SECRET KEY}"
$region = "eu-west-1"
$dryRun = $true
$currentIp = Invoke-RestMethod -Uri $urlToCheckIp -Method GET
Write-Host "Current IP address:" $currentIp.ipAddress
$secGroup = Get-EC2SecurityGroup -Region $region -AccessKey $accessKey -SecretKey $secretKey
@volkanpaksoy
volkanpaksoy / SendMailConsumer.ps1
Created October 31, 2019 14:18
SendMailConsumer
. ".\send-email.ps1"
# Get the last uploaded image
$latestImage = Get-S3Object -BucketName {BUCKET} `
-AccessKey {ACCESS KEY} `
-SecretKey {SECRET KEY} `
-Key {SUBFOLDER} `
| Sort-Object LastModified -descending `
| Select -First 1
Write-Host "Last image uploaded at" $latestImage.LastModified
function Send-Mail
{
param(
[string]$emailsubject,
[string]$emailBody
)
$smtpServer = "email-smtp.eu-west-1.amazonaws.com"
$smtpPort = 587
$username = "{ACCESS KEY}"