Kaspar Lonscher kaspar

This gist is to configure a Mosquitto MQTT Broker behind a Traefik reverse-proxy, both in a docker container. Mosquitto will be configuread as a TCP Service.

This is a simple configuration used on the same single server. Probably to be adapted for other cases. Having mosquitto behind a reverse proxy enables you to configure TLS on Traefik (likely you already do that for other applications as well) and to load balance different MQTT instances, but that goes beyond this gist.

As noted in Traefik docs, in the router you must use the rule HostSNI(`*`) when using non-TLS routers like in this example. Ref. https://docs.traefik.io/routing/routers/#rule_1

docker-compose.yml

	// Version 1.3.0
	// 27.11.2021
	//
	// Variables used by Scriptable.
	// These must be at the very top of the file. Do not edit.
	// icon-color: red; icon-glyph: notes-medical;
	// Mit Caching und Fallback
	const cacheMinutes = 60; // 60 min
	const today = new Date();
	const neededTotalVaccinations = 83200000;

	server {
	listen 80;
	server_name my-server.com;

	access_log /var/log/nginx/my-server.com-access.log;
	error_log /var/log/nginx/my-server.com-error.log;

	root /var/www/my-server.com/public;

	index index.php index.html;

	#This is the "site config" for nginx

	upstream django {
	# Distribute requests to servers based on client IP. This keeps load
	# balancing fair but consistent per-client. In this instance we're
	# only using one uWGSI worker anyway.
	ip_hash;
	server unix:/tmp/uwsgi.sock;
	}
	server {

	#!/bin/sh

	# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
	# CREATE block and create them in separate commands _after_ all the INSERTs.

	# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
	# The mysqldump file is traversed only once.

	# Usage: $ ./mysql2sqlite mysqldump-opts db-name \| sqlite3 database.sqlite
	# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase \| sqlite3 database.sqlite