Updating Zabbix mysql tables with wrong collation

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

Adding IEEE copyright notice on bottom margin

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

before \begin{document}

\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


Run SSTP VPN Client

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

Configure IEEE mail in thunderbird

  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

Force Matlab to use UTF8

In file  lcdata.xml within “lcdata” add block:

     <locale name="lv_LV" encoding="UTF-8" xpg_name="lv_LV.UTF-8">
         <alias name="lv"/>
         <alias name="lv_LV"/>


RTL SDR dongle installation in MATLAB

su sc
sudo adduser user sudo

sudo -s
vim /etc/modprobe.d/blacklist.conf

blacklist dvb_usb_rtl28xxu
blacklist rtl2832

depmod -a
update-initramfs -u

-insert SDR dongle
rmmod dvb_usb_rtl28xxu rtl2832

search RTL in addons
add RTL

mv /home/user/Documents/MATLAB/SupportPackages/R2016b/toolbox/shared/sdr /usr/local/MATLAB/R2016b/toolbox/shared
deluser user sudo

-fix matlab path-

Sharelatex e-mail config

settings.email =
fromAddress: "arturs@droid.lv"
replyTo: process.env["SHARELATEX_EMAIL_REPLY_TO"] or ""
host: "dockerhost"
port: 25
secure: false
ignoreTLS: true