Stefan Matić stefan-matic
stefan-matic
/ InstallPowerToys.ps1
Created
September 7, 2020 07:32
Download and Run Latest PowerToys Release
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Credits to MarkTiedemann for providing the original script and Splaxi for improving it | |
| # https://gist.github.com/MarkTiedemann/c0adc1701f3f5c215fc2c2d5b1d5efd3 | |
| $repo = "microsoft/PowerToys" | |
| $filenamePattern = "*.msi" | |
| $innerDirectory = $true | |
| $preRelease = $false | |
| if ($preRelease) { | |
| $releasesUri = "https://api.github.com/repos/$repo/releases" |
stefan-matic
/ docker-compose.yaml
Created
May 28, 2020 11:44
Runs mysql under docker and enables automatic backups
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| version: '3.5' | |
| volumes: | |
| mysql_data: | |
| external: true | |
| driver: local | |
| services: | |
| mysql: | |
| container_name: mysql |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| New-NetFirewallRule -DisplayName "Unifi Controller TCP" -Direction Inbound -LocalPort 8080, 8443, 8880, 8843, 6789, 27117 -Protocol TCP -Action Allow | |
| New-NetFirewallRule -DisplayName "Unifi Controller UDP" -Direction Inbound -LocalPort 3478, 5656-5699, 10001, 1900 -Protocol UDP -Action Allow |
stefan-matic
/ s3uploader.bat
Created
November 14, 2019 08:47
Allows uploading to S3 using AWS CLI. Create folder "s3-upload" on your C:\ (root), and inside create the folder "files". Place the bat inside "s3-upload"
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @echo off | |
| color 02 | |
| SETLOCAL EnableDelayedExpansion | |
| set s3-folder=C:\s3-upload | |
| set test=specific-test-folder/ | |
| set demo=specific-demo-folder/ | |
| set prod=specific-production-folder/ | |
| set test-link=https://bucket-name.s3.eu-central-1.amazonaws.com/Path/To/S3/Folder | |
| set demo-link=https://bucket-name.s3.eu-central-1.amazonaws.com/Path/To/S3/Folder |
stefan-matic
/ dbbackup.bat
Created
November 11, 2019 12:20
DB backup script using mysqldump.exe and S3 storage. Check variables to set your environment correctly.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @echo off | |
| call "%LOCALAPPDATA%\Apps\Apps\nutcracker.bat" | |
| :: Get data and time. | |
| for /f "skip=1" %%d in ('wmic OS GET LocalDateTime') do (set ldt=%%d & goto PARSELDT) | |
| :PARSELDT | |
| set date=%ldt:~0,8%_%ldt:~8,4% | |
| SETLOCAL EnableDelayedExpansion |
stefan-matic
/ AllowCloudFlareIPsOnly-80-443.ps1
Last active
September 4, 2019 10:56
This will allow only CloudFlare IPs to access your webserver in order to limit origin IP leaks. Be sure to compare the IPs with the current CloudFlare list: (https://www.cloudflare.com/ips/)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| New-NetFirewallRule -DisplayName "CloudFlare IPs" -Direction Inbound -LocalPort 80, 443 -Protocol TCP -Action Allow -RemoteAddress 173.245.48.0/20, 103.21.244.0/22, 103.22.200.0/22, 103.31.4.0/22, 141.101.64.0/18, 108.162.192.0/18, 190.93.240.0/20, 188.114.96.0/20, 197.234.240.0/22, 198.41.128.0/17, 162.158.0.0/15 ,104.16.0.0/12 ,172.64.0.0/13 ,131.0.72.0/22, 2400:cb00::/32, 2606:4700::/32, 2803:f800::/32, 2405:b500::/32, 2405:8100::/32, 2a06:98c0::/29, 2c0f:f248::/32 |
NewerOlder