Cybervitexus Vitexus

Loading variables from .env files in Ansible

Ansible has various ways of looking up data from outside sources, including plain text password files, CSV files and INI files. But it doesn't seem to have a lookup for .env files, as used in Laravel projects, also available for PHP, Ruby, Node.js, Python and others.

One option is to launch Ansible with the Ruby dotenv command line script... But that requires Ruby, which seems like overkill to me.

So here is a simpler solution that I use. It consists of:

The .env file itself
A small shell script that loads the .env file into environment variables - ansible-playbook.sh

How to enable the MySQL/MariaDB general query logs

Enter to MySQL/MariaDB server command-line tool (change root with your username and password):

mysql -u root -proot

Set the general log file path:

SET GLOBAL general_log_file='/var/log/mysql/mycustom.log';

Tuning Intel Skylake and beyond for optimal performance and feature level support on Linux:

Note that on Skylake, Kabylake (and the now cancelled "Broxton") SKUs, functionality such as power saving, GPU scheduling and HDMI audio have been moved onto binary-only firmware, and as such, the GuC and the HuC blobs must be loaded at run-time to access this functionality.

Enabling GuC and HuC on Skylake and above requires a few extra parameters be passed to the kernel before boot.

Instructions provided for both Fedora and Ubuntu (including Debian):

Note that the firmware for these GPUs is often packaged by your distributor, and as such, you can confirm the firmware blob's availability by running:

	/*
	* This is free and unencumbered software released into the public domain.
	*
	* For more information, please refer to <https://unlicense.org>
	*/

	//Regular text
	#define BLK "\e[0;30m"
	#define RED "\e[0;31m"
	#define GRN "\e[0;32m"

	# SQL Sever & firewall : https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access
	# New-NetFirewallRule : https://docs.microsoft.com/en-us/powershell/module/netsecurity/new-netfirewallrule?view=win10-ps

	New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow
	New-NetFirewallRule -DisplayName "SQLServer Browser service" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow

	$ clj -Sdeps '{:deps {org.clojure/tools.nrepl {:mvn/version "0.2.12"}}}'
	Clojure 1.9.0
	user=> (use '[clojure.tools.nrepl.server :only (start-server stop-server)])
	nil
	user=> (defonce server (start-server :port 7888))
	#'user/server
	;; now connect to port 7888. there's probably a way to do this in one line.

	# Apache configuration file
	# httpd.apache.org/docs/2.2/mod/quickreference.html
	# Note .htaccess files are an overhead, this logic should be in your Apache
	# config if possible: httpd.apache.org/docs/2.2/howto/htaccess.html
	# Techniques in here adapted from all over, including:
	# Kroc Camen: camendesign.com/.htaccess
	# perishablepress.com/press/2006/01/10/stupid-htaccess-tricks/
	# Sample .htaccess file of CMS MODx: modxcms.com
	# This is the free sample of .htaccess from 6GO s.r.l.
	# @author Claudio Ludovico Panetta (@Ludo237)

	[Unit]
	Description=GlassFish Server
	After=syslog.target network.target

	[Service]
	Type=forking

	ExecStart=/opt/glassfish4/bin/asadmin start-domain domain1
	ExecStop=/opt/glassfish4/bin/asadmin stop-domain domain1
	TimeoutSec=180

	input[type=time]::-webkit-datetime-edit-ampm-field {
	display: none;
	}

	---

	- name: trigger jenkins job
	shell: "{{ lookup('template', 'trigger-jenkins.j2') }}"
	delegate_to: localhost

	- name: wait for job to complete
	wait_for:
	path: {{ lockfile }}
	timeout: 600