How To Control Output Formatting Via The MySQL Shell CLI

Author: , May 26th, 2021

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-output-formats.html Multiple Formats Available: Table Format – use –result-format=table, alias –table Tab Separated Format – use –result-format=tabbed, alias –tabbed Vertical Format – use –result-format=vertical, alias –vertical JSON Format Output – use –result-format=VALUE, alias –json[=pretty|raw|off] VALUE may be one of: json or json/pretty – These options both produce pretty-printed JSON. ndjson or json/raw – These options […]

How To Read Multiple Lines of User Input from the Command Line in Perl

Author: , October 9th, 2019

Use Case: Export Apple Reminders from MacOS application to cleaned plain text, i.e. remove unwanted spaces, blank lines and square brackets PROCEDURE Click on a single item in the MacOS Reminders app list Select All (either Command-a or use Edit->Select All) Copy (either Command-c or use Edit->Copy) Open Terminal Run cleanme Paste the copied reminders […]

How To Enable SASL Authenticated Email Relay In Postfix

Author: , December 17th, 2010

Below info copied from http://www.postfix.org/SASL_README.html#server_sasl_enable Make sure saslauthd is running first. Edit /etc/postfix/main.cf: smtpd_sasl_type = cyrus smtpd_sasl_auth_enable = yes broken_sasl_auth_clients = yes smtpd_sasl_security_options = noanonymous smtpd_sasl_authenticated_header = yes smtpd_recipient_restrictions = permit_sasl_authenticated {other options that were already there} # postfix reload To test (you supply the items in bold): % telnet server.example.com 25 … 220 server.example.com […]