Attila Gulyas toraritte

Django and PostgreSQL 15, the rules have changed

Postgres 15 is just out, and while there is a lot to love about this new release, you're in for a surprise if you try to set it up with Django following tutorials like this one.

The reason is stated in the release announcement:

Remove PUBLIC creation permission on the public schema (Noah Misch) The new default is one of the secure schema usage patterns that Section 5.9.6 has recommended...

Provided your web app doesn't access your database as a superuser (it shouldn't) and uses a dedicated user, it is not allowed to use the public schema anymore. You have to create one for this specific user, and the next section will

Installing FreeSWITCH 1.10.X on Ubuntu 18.04 | 20.04 | 22.04 LTS

Introduction

FreeSWITCH is a software defined telecom stack that runs on any commodity hardware. FreeSWITCH can handle voice, video and text communication and support all popullar VoIP protocols. FreeSWITCH is flexible and modular, and can be used in any way you can imagine

This guide demonstrates how to get it install FreeSWITCH and get it up and running on a Ubuntu 20.04 LTS machine

Prerequisites

To follow along with this guide, you need one Ubuntu 20.04 LTS server which has prerequisite packages installed and configured. In order to install required packages issue following command

Vim Sort with RegEx

Vim Manual

See :help :sort.

:[range]sor[t][!] [b][f][i][n][o][r][u][x] [/{pattern}/]

git --version

git version 2.17.1

sudo apt-get install libsecret-1-0 libsecret-1-dev
cd /usr/share/doc/git/contrib/credential/libsecret
sudo make
git config --global credential.helper /usr/share/doc/git/contrib/credential/libsecret/git-credential-libsecret
Next time Git asks for your GitHub username and password, just write your username and paste your token and they'll be stored in your keyring.

	#!/bin/bash
	## Script for building/installing FreeSWITCH from source.
	## URL: https://gist.github.com/mariogasparoni/dc4490fcc85a527ac45f3d42e35a962c
	## Freely distributed under the MIT license
	##
	##
	set -xe
	FREESWITCH_SOURCE=https://github.com/signalwire/freeswitch.git
	FREESWITCH_RELEASE=master #or set this to any other version, for example: v1.10.5
	PREFIX=/usr/share/freeswitch

	abajgat
	abakusz
	abál
	abált
	abaposztó
	abárol
	abba
	abbahagy
	abbahagyat
	abbahagyogat

	I once read an https://bit-booster.com/doing-git-wrong/2017/01/02/git-init-empty/ , about why
	you should start with an empty commit for a new repo. The page has since then dissapperard but I got
	some of it out of the wayback machine and archive it here:

	Always Start With An Empty Commit
	Whenever you start a new git repo, pop an empty commit onto it before you do anything else!

	git init new-repo
	cd new-repo
	git commit -m 'initial empty commit' --allow-empty

	This works with the package manager [Nix](https://nixos.org/nix/), available on NixOS and working on most linux distros and macOS (theoretically also BSD and Windows).

	1. search for package definition on GitHub, for example ansible

	https://github.com/NixOS/nixpkgs/search?p=1&q=ansible&unscoped_q=ansible

	it is here https://github.com/NixOS/nixpkgs/blob/master/pkgs/tools/admin/ansible/default.nix

	2. search the history for the last commit with your preferred version, for example 2.5

	{ pkgs, lib, ... }:

	with lib;

	{
	config = {
	i18n.defaultLocale = "de_DE.UTF-8";
	time.timeZone = "Europe/Paris";

	services = {

	with import <nixpkgs> {};

	let
	path = ./mwe;
	string = "./mwe";
	pathPath = path + /test/file.nix;
	pathString = path + "/test/file.nix";
	pathStringPath = path + "/test" + /file.nix;
	stringPath = string + /test/file.nix;
	stringPathWorking = string + /nix/var/nix/db/schema;