bash 判斷是否由source 方式執行

 (return 0 2>/dev/null) && sourced=1 || sourced=0

CentOS 7 安裝 MariaDB 10.

編輯 /etc/yum.repos.d/MariaDB.repo

# MariaDB 10.1 CentOS repository list - created 2017-01-27 16:31 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

安裝
yum install MariaDB-server MariaDB-client

sudo 傳入環境變數

使用方式
sudo --preserve-env=HOME /usr/bin/env
sudo ZEBRA=true /usr/bin/env

修改 /etc/sudoers
ALL ALL=NOPASSWD:SETENV:/bin/mount

pypi mirror site 建置

安裝
mkdir -p /home/pypi
cd /home/pypi 

apt-get install python3-venv
python3 -m venv bandersnatch
bandersnatch/bin/pip install bandersnatch
bandersnatch/bin/bandersnatch mirror  建立設定檔  /etc/bandersnatch.conf
bandersnatch/bin/bandersnatch mirror  #執行 mirror 工作

可在 /etc/crontab 中增加設定
* */1 * * * root bandersnatch mirror |& logger -t bandersnatch[mirror]

client 設定
~/.pip/pip.conf
[global]
trusted-host=10.10.10.10 
index-url=http://10.10.10.10/simple

lxc 錯誤：mariadb.service: Control process exited, code=exited, status=226/NAMESPACE

 配置選項 nesting

bash ldapsearch 網域帳號認證

#!/bin/bash

_timeout="/usr/bin/timeout 3"
_ldapsearch=/usr/bin/ldapsearch

user=${1%@*}
_dn=${1#*@};
_dbn=$(for i in $(echo $_dn|tr . " ");do t="$t dc=$i";done;echo $t|tr " " ,);

t=$($_timeout $_ldapsearch -D ${1} -w ${2} -b "$_dbn" -h ${_dn} "sAMAccountname=$user"
 2>/dev/null|grep "sAMAccountName: $user");
[ "$t" = "sAMAccountName: $user" ]&&echo -e "OK"&&exit 0;

echo -e "ERR";

sqlite3 查詢筆記

 .tables
.schema(table_name);
PRAGMA table_info('table_name')

rsync: ERROR: cannot stat destination "." (in ): Permission denied (13)

  缺少目的端目錄或權限不足 (chmod 777)

sudo 指令傳入環境變數

 錯誤訊息

sudo: sorry, you are not allowed to preserve the environment

編輯 /etc/sudoers
user  ALL=(ALL)       NOPASSWD:SETENV: /usr/bin

執行方式
sudo var=varvalue 1.sh

Windows AD accountexpires 欄位摘要

1700-01-01  最早時間表示
31241952000000000

1970-01-01
116445312000000000

2020-08-01
132407712000000000

10000000 = 1 秒 

PHP程式計算時間

$time1="2020-08-01 00:00:00";
$time2="2020-08-15 00:00:00";
132407712000000000 + (strtotime($time2) - strtotime($time1)) * 10000000

pipe tar gzip without creating intermediary files

 tar cf - dirname | gzip -9 > file.tar.gz

pipeline 上傳檔案

 cat file|curl -F file=@- http://127.0.0.1/upload.php?a=1

Ubuntu 18.4 capture screen with VLC

安裝

apt install -y vlc vlc-plugin-access-extra

使用
Media-Open capture Device-Capture mode-Desktop-Play-Convert-Browse-Start

How do I allow remote desktop to domain controller?

1.gpedit

2.Computer Configuration - Windows settings - Security Settings - Local policies - User Rights Assignment

resize ext4 partition

1.parted /dev/whatever
2.resize2fs /dev/whatever
3.e2fsck /dev/whatever

bash 由變數轉向

t='1 2 3';

while read a b c;do

echo a=$a b=$b c=$c

done <<< $(echo $t)

echo a=$a b=$b c=$c