asiellb

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';

Host

$ sudo apt update
$ sudo apt install nfs-kernel-server
$ sudo mkdir /mnt/nfs -p
$ sudo chown nobody:nogroup /mnt/nfs
$ sudo chmod 777 /mnt/nfs
$ sudo nano /etc/exports

add something like /mnt/nfs 192.168.1.101(rw,sync,no_root_check,no_subtree_check)

Install ImageMagick for image conversion:

brew install imagemagick

Install tesseract for OCR:

brew install tesseract --all-languages

Or install without --all-languages and install them manually as needed.

Enable LDAP over SSL (LDAPS) for Microsoft Active Directory servers

Microsoft active directory servers will default to offer LDAP connections over unencrypted connections (boo!).

The steps below will create a new self signed certificate appropriate for use with and thus enabling LDAPS for an AD server. Of course the "self-signed" portion of this guide can be swapped out with a real vendor purchased certificate if required.

Steps have been tested successfully with Windows Server 2012R2, but should work with Windows Server 2008 without modification. Requires a working OpenSSL install (ideally Linux/OSX) and (obviously) a Windows Active Directory server.

Create root certificate
Import root certificate into trusted store of domain controller
Create client certificate

PyRFC on Windows 64-bit

Install Python 3.7 64-bit
- download python-3.7.2-amd64.exe
- install, check "Add Python 3.7 to PATH"
Install PyRFC
- download pyrfc-1.9.93-cp37-cp37m-win_amd64.whl
- run pip install Downloads/pyrfc-1.9.93-cp37-cp37m-win_amd64.whl

	//import the selenium web driver
	var webdriver = require('selenium-webdriver');

	var chromeCapabilities = webdriver.Capabilities.chrome();
	//setting chrome options to start the browser fully maximized
	var chromeOptions = {
	'args': ['--test-type', '--start-maximized']
	};
	chromeCapabilities.set('chromeOptions', chromeOptions);
	var driver = new webdriver.Builder().withCapabilities(chromeCapabilities).build();

	{"id":1,"name":"O Brother, Where Art Thou?"}
	{"id":2,"name":"Home for the Holidays"}
	{"id":3,"name":"The Firm"}
	{"id":4,"name":"Broadcast News"}
	{"id":5,"name":"Raising Arizona"}

	/\A[\w+\-.]+@[a-z\d\-.]+\.[a-z]+\z/i full regex
	/ start of regex
	\A atch start of a string
	[\w+\-.]+ at least one word character, plus, hyphen, or dot
	@ literal “at sign”
	[a-z\d\-.]+ at least one letter, digit, hyphen, or dot
	\. literal dot
	[a-z]+ at least one letter
	\z match end of a string
	/ end of regex

	#!/usr/bin/env zsh

	sudo rm -f /usr/bin/node
	sudo rm -f /usr/bin/npm
	sudo ln -s $(which node) /usr/bin/
	sudo ln -s $(which npm) /usr/bin/

	wget --no-check-certificate --content-disposition https://github.com/joyent/node/tarball/v0.7.1
	# --no-check-cerftificate was necessary for me to have wget not puke about https
	curl -LJO https://github.com/joyent/node/tarball/v0.7.1