Author: arturs

First run this

mysql -B -u zabbix -pxxx zabbix -e 'SELECT CONCAT("ALTER TABLE ", TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;") AS ExecuteTheString
FROM information_schema.`COLUMNS`
WHERE table_schema = "zabbix" AND COLLATION_NAME = "utf8_general_ci";'

After that paste command output to another

mysql -B -u zabbix -pxxx zabbix -e '<paste here>'

openssl req -newkey rsa:2048 -new -nodes -x509 -days 3650 -keyout key.pem -out crt.pem

Notice: key.pem is in private folder, whereas crt.pem is in the certs folder.

To put notice on the margin (not in first column as many does) following latex code can be used:

before \begin{document}

 \usepackage{fancyhdr}
 \fancypagestyle{firststyle}
 {
 \fancyhf{} % sets both header and footer to nothing
 \fancyfoot[LO]{978-1-xxxx-xxxx-4/21/\$31.00~\copyright2021 IEEE}
 \renewcommand{\headrulewidth}{0pt} % remove horizontal rule
 }

after \maketitle

 \thispagestyle{firststyle}

sudo sstpc server.com --user arturs --password "-" usepeerdns require-mschap-v2 noauth noipdefault defaultroute refuse-eap noccp --log-stderr --cert-warn debug

1. Tools->Account settings
2. Create acccount
3. mail address xxx@ieee.org
4. Select “manual config”
5. Username: xxx@ieee.org
6. Incoming: imap.gmail.com, 993 (SSL), normal password
7. Outgoing: smtp.gmail.com, 465 (SSL), normal password
8. Re-test (fails), but button “Advanced config” at the bottom becomes available
9. Open “Advanced config” at the bottom
10. Change authorization to OAuth2

cd /Applications/Xcode.app/Contents/Developer/Toolchains
sudo ln -s XcodeDefault.xctoolchain OSX10.13.xctoolchain