Michaël Ferrand e7d

Install needed packages:

sudo dnf install qt5-qtbase-devel openssl-devel qtkeychain-qt5-devel -y

# create a symlink to /usr/bin/qmake, if needed
sudo ln -s /usr/lib64/qt5/bin/qmake /usr/bin/qmake

cd ~/tools
git clone https://github.com/theinvisible/openfortigui.git

If you want to use the latest available version of Squid, you can Build a Squid anonymous proxy from source code

Setup a Squid anonymous proxy

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

If you don't want to build Squid from scratch, you can simply Setup a Squid anonymous proxy

Build a Squid anonymous proxy from source code

Please note that this whole manual refers to the version 3.5.23 of Squid. You probably would have to adapt some commands to the version you will actually download.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

	#!/bin/bash

	wget https://dl.pstmn.io/download/latest/linux64 -O postman-linux-x64.tar.gz
	sudo tar xvzf postman-linux-x64.tar.gz -C /opt
	sudo ln -s /opt/Postman/Postman /usr/bin/postman

	cat << EOF > ~/.local/share/applications/postman2.desktop
	[Desktop Entry]
	Name=Postman
	GenericName=API Client

	@ECHO OFF
	SETLOCAL
	GOTO:MAIN

	REM
	REM Info functions start
	REM

	REM Display version and copyright information
	:VERSION

	#!/usr/bin/env bash

	# names of latest versions of each package
	export NGINX_VERSION=1.15.5
	export VERSION_NGINX=nginx-$NGINX_VERSION
	export VERSION_LIBRESSL=libressl-2.8.1
	export VERSION_PCRE=pcre-8.42
	#export NPS_VERSION=1.9.32.10
	#export VERSION_PAGESPEED=v${NPS_VERSION}-beta

	#!/bin/bash
	# bash generate random alphanumeric string
	#

	# bash generate random 32 character alphanumeric string (upper and lowercase) and
	NEW_UUID=$(cat /dev/urandom \| tr -dc 'a-zA-Z0-9' \| fold -w 32 \| head -n 1)

	# bash generate random 32 character alphanumeric string (lowercase only)
	cat /dev/urandom \| tr -dc 'a-z0-9' \| fold -w 32 \| head -n 1