ruiteix

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

ruiteix

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

ruiteix

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

-- convertir une table
ALTER TABLE name SET UNLOGGED;


-- Lister les tables unlogged

ruiteix

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

ruiteix

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)

ruiteix

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

ruiteix

Verifying that +ruiteix is my blockchain ID. https://onename.com/ruiteix