Eugen Rochko Gargron

Removing local copies of unreferenced external posts

SQL exapmle that deletes local copies of external posts flowing from the FTL or relays and that are not referenced long time by local users.

Note: It is "reduction" of data increase , not "to be able to operate infinitely with a fixed disk capacity".

Register a domain name. Buy a cert for it.
Spin up Ubuntu Trusty 14.04 on AWS & point DNS at the instance. Don't bother making user accounts or anything; only somebody with your key should be able to ssh in. Add security group rules allowing https from anywhere, or maybe http if you want to redirect.
Make an EBS volume or raid up some instance stores and mount them on /mnt/mastodon, owned by ubuntu.
Download all the files in this gist to your local controlling host, e.g., your laptop.
Make a file named inventory with [general]\nyour-host.tld in it.
Put all of the *.conf files in this gist into a subdirectory named files.
Put your certs somewhere in the directory & make sure the ansible playbook services.yml is pointing to them.
Run ansible-playbook -i inventory host-setup.yml
Run ansible-playbook -i inventory mastodon.yml
you might get ruby 2.3.3 instead of 2.3.1 in which case you should just edit the Gemfile.

Two awsome things were released yesterday :

Compare this to the pricing of : dropbox pro

	# Validates that MX record exists for domain to prevent typos and also block by MX servers
	# Use by adding to app/models/user.rb
	# validates_with EmailMXValidator, if: :email_changed?

	# frozen_string_literal: true
	require 'resolv'
	class EmailMXValidator < ActiveModel::Validator
	def validate(user)
	domain = user.email.split('@', 2).last
	mxs = Resolv::DNS.new.getresources(domain, Resolv::DNS::Resource::IN::MX).to_a.map { \|e\| e.exchange.to_s }

	#!/usr/bin/env bash
	#
	# Make a backup file of a Mastodon instance. The backup file is a TGZ containing
	# the Postgres dump as well as the /public/system (media) files and the
	# .env.production file. For loading the dump file contents, see:
	# https://github.com/tootsuite/documentation/blob/master/Running-Mastodon/Migration-guide.md
	#
	# Usage: ./mastodon_backup.sh my_dump_file.tgz
	#
	# Advanced usage: MASTODON_LIVE_DIRECTORY=/path/to/live ./mastodon_backup.sh my_dump_file.tgz

	/* Read this comment first: https://gist.github.com/tonious/1377667#gistcomment-2277101
	* 2017-12-05
	*
	* -- T.
	*/

	#define _XOPEN_SOURCE 500 /* Enable certain library functions (strdup) on linux. See feature_test_macros(7) */

	#include <stdlib.h>
	#include <stdio.h>

	<!doctype html>
	<html><head>
	<script type="text/javascript" src="Microphone/swfobject.js"></script>
	<script type="text/javascript" src="ulaw.js"></script>
	<script type="text/javascript" src="Microphone/microphone.js"></script>
	<script type="text/javascript" src="sockjs-0.1.min.js"></script>
	<script type="text/javascript">
	Microphone.debug = true;
	bsock = new SockJS("/broadcast");
	Microphone.initialize({ swfLocation: "Microphone/MicrophoneMain.swf" });

	#! /bin/sh
	# ------------------------------------------------------------------------------
	# SOME INFOS : fairly standard (debian) init script.
	# Note that node doesn't create a PID file (hence --make-pidfile)
	# has to be run in the background (hence --background)
	# and NOT as root (hence --chuid)
	#
	# MORE INFOS : INIT SCRIPT http://www.debian.org/doc/debian-policy/ch-opersys.html#s-sysvinit
	# INIT-INFO RULES http://wiki.debian.org/LSBInitScripts
	# INSTALL/REMOVE http://www.debian-administration.org/articles/28

	God.watch do \|w\|
	w.uid = "git"
	w.gid = "git"
	w.name = "camo"
	w.pid_file = "/data/camo/tmp/camo.pid"
	w.interval = 30.seconds

	w.env = {
	"PORT" => '8080',
	"CAMO_KEY" => '0x24FEEDFACEDEADBEEFCAFE'