ruiteix

## syslog-injection.sh
# Redirect STDOUT/STDERR into syslog
exec > >(logger -p user.info) 2> >(logger -p user.warn)

## stop_old_containers
docker ps -f status=running --format "{{.ID}} {{.CreatedAt}}" | while read id cdate ctime _; do if [[ $(date +%s -d "$cdate $ctime") -lt $(date +%s -d '1 days ago') ]]; then docker stop $id && docker rm $id; fi; done

## postgres_unlogged_tables.sql
-- creation table unlogged
CREATE UNLOGGED TABLE name (
  -- ...
);

-- convertir une table
ALTER TABLE name SET UNLOGGED;


-- Lister les tables unlogged

## Clone repository from github to gitlab
git clone --bare git@github.com:ruiteix/<repo_name_src>.git
git remote add gitlab git@gitlab.com:ruiteix/<repo_name_dst>.git
cd <repo_name_src>.git
git remote add gitlab git@gitlab.com:ruiteix/<repo_name_dst>.git
git push --mirror gitlab

## Ansible Let's Encrypt Nginx setup
Ansible playbook to setup HTTPS using Let's encrypt on nginx.

The Ansible playbook installs everything needed to serve static files from a nginx server over HTTPS.
The server pass A rating on [SSL Labs](https://www.ssllabs.com/).

To use:
 1. Install [Ansible](https://www.ansible.com/)
 2. Setup an Ubuntu 16.04 server accessible over ssh
 3. Create `/etc/ansible/hosts` according to template below and change example.com to your domain
 4. Copy the rest of the files to an empty directory (`playbook.yml` in the root of that folder and the rest in the `templates` subfolder)

## wordpress-domain-migration.sql
SET @oldsite='http://oldsite.com';
SET @newsite='http://newsite.com';
UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

/* only uncomment next line if you want all your current posts to post to RSS again as new */
#UPDATE wp_posts SET guid = replace(guid, @oldsite, @newsite);

## onename.txt
Verifying that +ruiteix is my blockchain ID. https://onename.com/ruiteix
	# Redirect STDOUT/STDERR into syslog
	exec > >(logger -p user.info) 2> >(logger -p user.warn)
	-- creation table unlogged
	CREATE UNLOGGED TABLE name (
	-- ...
	);

	-- convertir une table
	ALTER TABLE name SET UNLOGGED;


	-- Lister les tables unlogged
	git clone --bare git@github.com:ruiteix/<repo_name_src>.git
	git remote add gitlab git@gitlab.com:ruiteix/<repo_name_dst>.git
	cd <repo_name_src>.git
	git remote add gitlab git@gitlab.com:ruiteix/<repo_name_dst>.git
	git push --mirror gitlab
	Ansible playbook to setup HTTPS using Let's encrypt on nginx.

	The Ansible playbook installs everything needed to serve static files from a nginx server over HTTPS.
	The server pass A rating on [SSL Labs](https://www.ssllabs.com/).

	To use:
	1. Install [Ansible](https://www.ansible.com/)
	2. Setup an Ubuntu 16.04 server accessible over ssh
	3. Create `/etc/ansible/hosts` according to template below and change example.com to your domain
	4. Copy the rest of the files to an empty directory (`playbook.yml` in the root of that folder and the rest in the `templates` subfolder)
	SET @oldsite='http://oldsite.com';
	SET @newsite='http://newsite.com';
	UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
	UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
	UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
	UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

	/* only uncomment next line if you want all your current posts to post to RSS again as new */
	#UPDATE wp_posts SET guid = replace(guid, @oldsite, @newsite);