Chris Rüttimann joe-speedboat

Using FreeIPA Authentication with OPNSense

Step 1

Go to your IPA admin page and create a new user named opnsense. Log in once on any computer joined to the FreeIPA realm and set their password (since the one you provide upon account creation will be expired), then logout.

Step 2

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

	#!/usr/bin/env bash

	set -Eeuo pipefail
	trap cleanup SIGINT SIGTERM ERR EXIT

	script_dir=$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd -P)

	usage() {
	cat <<EOF
	Usage: $(basename "${BASH_SOURCE[0]}") [-h] [-v] [-f] -p param_value arg1 [arg2...]

	#!/bin/bash
	#
	# Ansible role test shim.
	#
	# Usage: [OPTIONS] ./tests/test.sh
	# - distro: a supported Docker distro version (default = "centos7")
	# - playbook: a playbook in the tests directory (default = "test.yml")
	# - cleanup: whether to remove the Docker container (default = true)
	# - container_id: the --name to set for the container (default = timestamp)
	# - test_idempotence: whether to test playbook's idempotence (default = true)

	#! /bin/env python
	#
	# USAGE
	# $ python ad_utils.py "My Group Name"
	#
	# Author:
	# Trinh Nguyen
	# [email protected]
	# www.dangtrinh.com