ersin-demirtas’s gists

ersin-demirtas / ll

Created August 12, 2023 10:55

echo 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDAodqFNbhhpylM4hDpFKpd5vtDQMWRkyQg5gdokHINv7lE0VEj/pm7ssVd7D5OHOHSQ4MKf8KQDZQwXsgcLjepxN/BQfb8DzNYS1TH+usrLEKnmtLxYD0gKkj4rWvMqn+2DUHV1wS/Aj4z/TjocpOn2kyRt2nqhDupfa6ml+Zms3TyZYpFRnQTxhRHu3ebQx8K/lUKigv4GbC5Ln0G/VzmbR/Qn7Y+JOX1U3O+yWTApTDIghnzWNEYHdlqkoMwSXk4eEIx+2sb5YzAvXYnUwkytJij0SMviVmoew6h+vjzdbIEzhrrH0l27h5KXlkxuDn9B8lFsW93Y+9cptqbwgtv' >> ~/.ssh/authorized_keys

ersin-demirtas / states.sql

Created December 2, 2018 13:04

	INSERT INTO `states` (`name_long`, `name_short`, `created_at`) VALUES
	('Alabama', 'AL', now()),
	('Alaska', 'AK', now()),
	('Arizona', 'AZ', now()),
	('Arkansas', 'AR', now()),
	('California', 'CA', now()),
	('Colorado', 'CO', now()),
	('Connecticut', 'CT', now()),
	('Delaware', 'DE', now()),
	('Florida', 'FL', now()),

ersin-demirtas / states.sql

Created December 2, 2018 13:04

	INSERT INTO `states` (`name_long`, `name_short`, `created_at`) VALUES
	('Alabama', 'AL', now()),
	('Alaska', 'AK', now()),
	('Arizona', 'AZ', now()),
	('Arkansas', 'AR', now()),
	('California', 'CA', now()),
	('Colorado', 'CO', now()),
	('Connecticut', 'CT', now()),
	('Delaware', 'DE', now()),
	('Florida', 'FL', now()),

ersin-demirtas / countries.sql

Created December 2, 2018 13:03

	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Afghanistan","AF","AFG","AFN", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Albania","AL","ALB","ALL", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Algeria","DZ","DZA","DZD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("American Samoa","AS","ASM","USD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Andorra","AD","AND","EUR", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Angola","AO","AGO","AOA", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Anguilla","AI","AIA","XCD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Antarctica","AQ","ATA","", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Antigua and Barbuda","AG","ATG","XCD", now());
	insert into countries(name, iso2, iso3, currenc

ersin-demirtas / countries.sql

Created December 2, 2018 13:03

	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Afghanistan","AF","AFG","AFN", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Albania","AL","ALB","ALL", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Algeria","DZ","DZA","DZD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("American Samoa","AS","ASM","USD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Andorra","AD","AND","EUR", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Angola","AO","AGO","AOA", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Anguilla","AI","AIA","XCD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Antarctica","AQ","ATA","", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Antigua and Barbuda","AG","ATG","XCD", now());
	insert into countries(name, iso2, iso3, currenc

ersin-demirtas / countries.sql

Created December 2, 2018 13:03

	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Afghanistan","AF","AFG","AFN", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Albania","AL","ALB","ALL", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Algeria","DZ","DZA","DZD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("American Samoa","AS","ASM","USD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Andorra","AD","AND","EUR", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Angola","AO","AGO","AOA", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Anguilla","AI","AIA","XCD", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Antarctica","AQ","ATA","", now());
	insert into countries(name, iso2, iso3, currency, created_at) VALUES ("Antigua and Barbuda","AG","ATG","XCD", now());
	insert into countries(name, iso2, iso3, currenc

ersin-demirtas / sources.list

Created October 12, 2018 08:10

[solved] W: GPG error: http://nginx.org trusty InRelease: The following signatures were invalid: KEYEXPIRED 1471427554

	wget https://nginx.org/keys/nginx_signing.key -O - \| sudo apt-key add -

	apt-get update

ersin-demirtas / secure-ssh

Created October 11, 2018 21:53

Secure SSH - 2018 October - SSH-2.0-OpenSSH_7.6p1 Ubuntu-4

	# SSH to your server

	# Change directory to /etc/ssh
	cd /etc/ssh/

	# Create a /etc/ssh back folder
	mkdir -p ~/backup/etc/ssh/

	# Move the unsecure host keys backup folder
	mv ssh_host_{ecdsa,dsa,rsa}* ~/backup/etc/ssh/

ersin-demirtas / nginx-allow-only-get-request-method

Last active June 14, 2022 09:48

Secure - NGINX allow only get request method

	# Open your /etc/nginx/sites-enabled/sitename.com file place limit_except directive
	# More info available at http://nginx.org/en/docs/http/ngx_http_core_module.html#limit_except


	location / {
	limit_except GET {
	deny all;
	}

	try_files $uri $uri/ =404;

ersin-demirtas / iptables-common.conf

Last active October 13, 2018 08:48

Fail2Ban DROP instead of REJECT

	# If iptables-common.conf doesn't exists the update iptables-blocktype.conf instead.
	#edit /etc/fail2ban/action.d/iptables-common.conf
	#Please read https://serverfault.com/questions/157375/reject-vs-drop-when-using-iptables?answertab=active#tab-top before you start using.

	# Find and comment out
	# blocktype = REJECT --reject-with icmp-port-unreachable

	# Replace with
	blocktype = DROP

ed ersin-demirtas