mysql: видалити усі записи з таблиці, окрім останніх N

DELETE FROM `table`
WHERE id NOT IN (
  SELECT id
  FROM (
    SELECT id
    FROM `table`
    ORDER BY id DESC
    LIMIT 10 -- keep this many records
  ) foo
);

глюк phpmyadmin: - count(): Parameter must be an array or an object that implements Countable

файл /usr/share/phpmyadmin/libraries/sql.lib.php 613 лінія

|| (count($analyzed_sql_results['select_expr'] == 1)

 заміна на

|| ((count($analyzed_sql_results['select_expr']) == 1)

tcpdump сніфер з гарним виводом

tcpdump -n -A -i interface src or dst host.com | perl -ne 'if(/\d\d:\d\d:\d\d\.\d{6} IP (\d+\.\d+\.\d+\.\d+)\.(\d+) > (\d+\.\d+\.\d+\.\d+)\.(\d+)\:.*length (\d+)/) { $preamble="$1:$2->$3:$4 "; } else { print "$preamble$_"; }'

ffmpeg стрім в icecast2

ffmpeg -ac 1 -f alsa -i hw:0,0 -acodec libmp3lame -ab 32k -ac 1 -content_type audio/mpeg -f mp3 icecast://source:str3am@35.237.210.58:8000/domlive

http://www.streamingmediaglobal.com/Articles/Editorial/Featured-Articles/DIY-Live-Audio-Streaming-Using-Icecast-with-FFmpeg-125665.aspx

Активація простої аутентифікації для WebDav

Computer\HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\WebClient\Parameters\BasicAuthLevel

встановити в 2

network - network.c:lxc_ovs_attach_bridge:1887 - Failed to attach "lxcbr0" to openvswitch bridge "vethHW3XSF"

# sudo systemctl stop lxc-net.service
# sudo systemctl start lxc-net.service

автозапуск сервіс в Ubuntu 18

# cd /etc/systemd/system/
# touch some.service
# mcedit some.service

[Unit]
Description=Some site service
[Service]
ExecStartPre=
ExecStart=/sbin/runuser -l asuser -c '/some/script/start.sh'
Restart=always
KillSignal=SIGQUIT
Type=notify
NotifyAccess=all
[Install]
WantedBy=multi-user.target

# sudo systemctl enable some