Tinu Cleatus hackedunit

Note

For every body who using Win10/11 with new Office that you need to know:

to active Office without crack, just follow https://github.com/WindowsAddict/IDM-Activation-Script,

you wiil only need to run

irm https://massgrave.dev/ias | iex

Run SonarQube with a PostgreSQL database

Requirements

Docker Engine 1.9
Docker Compose 1.6

Compose file

Create this docker-compose.yml file:

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

brew doctor
brew update

psql: FATAL: Peer authentication failed for user “postgres” (or any user)

The connection failed because by default psql connects over UNIX sockets using peer authentication, that requires the current UNIX user to have the same user name as psql. So you will have to create the UNIX user postgres and then login as postgres or use sudo -u postgres psql database-name for accessing the database (and psql should not ask for a password).

If you cannot or do not want to create the UNIX user, like if you just want to connect to your database for ad hoc queries, forcing a socket connection using psql --host=localhost --dbname=database-name --username=postgres (as pointed out by @meyerson answer) will solve your immediate problem.

But if you intend to force password authentication over Unix sockets instead of the peer method, try changing the following pg_hba.conf* line:

from

Boldport, one of the interwebs better known hardware design guys went on a rant on how prototyping is so very different from production. If you have ever held a solder gun, or intend to, you should read this.

Why did your "hardware startup" Kickstarter fail? Because none of your prototyping skills are required for production. source

Skill	Prototyping	Production
coding	sloppy	efficient

Brew upgrade...

Run the usual brew update, and brew upgrade to get the latest 9.4 version of PostgreSQL.

After upgrading PG from 9.3 to 9.4 with brew, the server will not start as is. If you value your database contents, and configuration, pg_upgrade is here to migrate those.

Do not delete the old binaries at once: do not run brew cleanup, because you need 9.3 binaries to migrate.

	# Install Ubiquiti Unifi Controller on Ubuntu 20.04.
	# As tested on a fresh install of ubuntu-20.04.1-live-server, August 22nd 2020.
	# Thanks to https://gist.github.com/tmuncks for posting the updated install steps.

	sudo apt update
	sudo apt install --yes apt-transport-https

	echo 'deb https://www.ui.com/downloads/unifi/debian stable ubiquiti' \| sudo tee /etc/apt/sources.list.d/100-ubnt-unifi.list
	sudo wget -O /etc/apt/trusted.gpg.d/unifi-repo.gpg https://dl.ui.com/unifi/unifi-repo.gpg

	#!/bin/bash
	# Force outbound traffic through the attached floating IP

	NET_INT="eth0"
	CURL_TIMEOUT=3

	echo -n "Setting floating IP as the default gateway: "

	# Check there's a floating IP attached to this droplet
	if [ "$(curl -s --connect-timeout $CURL_TIMEOUT http://169.254.169.254/metadata/v1/floating_ip/ipv4/active)" != "true" ]; then


	# 1) Create your private key (any password will do, we remove it below)

	$ cd ~/.ssh
	$ openssl genrsa -des3 -out server.orig.key 2048


	# 2) Remove the password

	$ openssl rsa -in server.orig.key -out server.key