windows powershell command:
PS C:\Users\test> certutil -hashfile destfile.zip md5
MD5 hash (対象 destfile.zip):
f6cb78afe66b417cd3f79df8d1c86444
CertUtil: -hashfile コマンドは正常に完了しました。
linux command:
> md5sum destfile.zip
f6cb78afe66b417cd3f79df8d1c86444 destfile.zip
git clone -b branchname https://domainname/group/project.git
git clone -b branchname https://userid:token@domainname/group/project.git
$ setfacl --help
&& (AND) : if [ condition1 ] && [ condition2 ]; then || (OR) : if [ condition1 ] || [ condition2 ]; then # uname -a
Linux 6cfa069b60a5 4.14.291-218.527.amzn2.x86_64 #1 SMP Fri Aug 26 09:54:31 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
# cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04.2 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.2 LTS"
VERSION_ID="20.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=focal
UBUNTU_CODENAME=focal
追加: i (insert), a(append) 注意：'中の処理は一つの処理とする'
sed -e '/pattern/ a内容' #pattern行の後ろに、aで内容をappend
sed -e '/pattern/ i内容' #pattern行の先頭に、iで内容をinsert
範囲限定の削除
sed -e '/fromPattern/,/toPattern/ d' #fromPattern行（含む）～toPattern行（含む）まで、ｄで削除する
範囲限定の置換
sed -e '/fromPattern/,/toPattern/ s/pattern/replacement/' #fromPattern行（含む）～toPattern行（含む）まで、sでpatternにmatchする文字列をreplacementで置換する。
1. .* vs .*? :
- LOCK TEST_USER1
ALTER USER TEST_USER1 ACCOUNT LOCK;
1. windows
mkdir c:\my-shared
echo "test" > test.txt
2. add shared folder in virtual Manager like
shared foldername: shared
windows path: c:\my-shared
access auth: full
3. goto linux vm
$ mkdir ~/wk-shared
$ sudo mount -t vboxsf shared ~/wk-shared
$ ll ~/wk-shared
total 1
-rwxrwxrwx 1 root root 63 Sep 21 14:24 test.txt
service mysql start
sudo mysql -u root
MariaDB [(none)]> show databases
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.001 sec)
MariaDB [(none)]> select Host, User, Password from mysql.user;
+-----------+-------------+----------+
| Host | User | Password |
+-----------+-------------+----------+
| localhost | mariadb.sys | |
| localhost | root | invalid |
| localhost | mysql | invalid |
+-----------+-------------+----------+
3 rows in set (0.001 sec)
mysql -u root mysqlFLUSH PRIVILEGES;ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEW_PASSWORD';FLUSH PRIVILEGES;quit
sudo kill `sudo cat /var/run/mysqld/mysqld.pid`login to gitlab-Postgre-db:
gitlab-rails dbconsolegitlab-psql -d gitlabhq_productionpostgres=# \c dvdrental
You are now connected to database "dvdrental" as user "postgres".
\l = SELECT datname FROM pg_database;
gitlabhq_production=> \d
#list all objects of the db. include table, sequence, and so on.
\d = select * from
gitlabhq_production=> \dt
(\dt + :#show size)
(\dt tablename :#show table columns)
#list all tables of the db
--'テーブル名'に存在する列一覧を取得
select * from information_schema.columns
where table_name='テーブル名' order by ordinal_position;# ls -l /etc/gitlab/initial_root_password
gitlab-rake "gitlab:password:reset[root]"
$ gitlab-ctl status
# status of services
/# gitlab-rake gitlab:env:info
System information
System:
Proxy: no
Current User: git
Using RVM: no
Ruby Version: 2.7.5p203
Gem Version: 3.1.6
Bundler Version:2.3.15
Rake Version: 13.0.6
Redis Version: 6.2.7
Sidekiq Version:6.4.0
Go Version: unknown
GitLab information
Version: 15.3.3-ee
Revision: 1615d086ad8
Directory: /opt/gitlab/embedded/service/gitlab-rails
DB Adapter: PostgreSQL
DB Version: 13.6
URL: http://gitlab.wangxg.com
HTTP Clone URL: http://gitlab.wangxg.com/some-group/some-project.git
SSH Clone URL: git@gitlab.wangxg.com:some-group/some-project.git
Elasticsearch: no
Geo: no
Using LDAP: no
Using Omniauth: yes
Omniauth Providers:
GitLab Shell
Version: 14.10.0
Repository storage paths:
- default: /var/opt/gitlab/git-data/repositories
GitLab Shell path: /opt/gitlab/embedded/service/gitlab-shell
root@gitlab:/#
$ free -m
total used free shared buff/cache available
Mem: 4931 699 3260 7 971 3992
Swap: 1023 0 1023
grep can't output all group captures after one grep action.
so. each grep a time.
ex.
input_string= "Caused by: java.io.FileNotFoundException: /tmp/storage/imart/public/storage/default/im_workflow/data/default/transaction/202107/21/16/ma_8g2mm9ovekgierj/result/ep_8g2mo7z76kgrmrj/flow.xml (No such file or directory)"
#I want to get
#[1]=/tmp/storage/imart/public/storage/default/im_workflow/data/default/transaction
#[2]=202107/21/16/
#[3]=ma_8g2mm9ovekgierj
#[4]=ep_8g2mo7z76kgrmrj
#cmd:
a1=$(echo $input_string | grep -ioE "/tmp/.+/transaction")
echo $a1
:/tmp/storage/imart/public/storage/default/im_workflow/data/default/transaction
a2=$(echo $input_string | grep -ioE "[0-9]{6}/[0-9]{2}/[0-9]{2}")
echo $a2
=> 202107/21/16
a3=$(echo $input_string | grep -ioE "[0-9]{6}/[0-9]{2}/[0-9]{2}/\w+" | grep -ioE "\w+$")
echo $a3
:ma_8g2mm9ovekgierj
a4=$(echo $input_string | grep -ioE "\w+/flow" | grep -ioE "^\w+")
echo $a4
:ep_8g2mo7z76kgrmrj
$ echo $input_string | grep -ioE "/tmp/.+/transaction"
#change network info
#first reset a IP
ifconfig eth0 192.168.1.123
#second reset netmask and broadcast for IP.
ifconfig eth0 192.168.1.123 netmask 255.255.0.0 broadcast 192.168.1.255
#before change MAC, stop the network-adapter ethX.
ifconfig eth0 down
#third reset ether MAC for eth0
ifconfig eth0 hw ether 00:11:22:33:44:55
ifconfig eth0 up #restart eth0
#request DHCP server for new IP
dhclient eth0
#linux dns conf
more /etc/resolv.conf
1. sed s/mysql/MySQL/g test.conf >test2.conf
# replace all mysql to MySQL
2. sed s/mysql/MySQL/ test.conf >test2.conf
# replace first mysql to MySQL
3. sed s/mysql/MySQL/2 test.conf >test2.conf
# replace the second found mysql only to MySQL.
1. open setting/setting manager/keyboard.
2. tab to layout
3. add japanese and delete english
4. confirm keyboard layout = Generic 105-key PC (intl.)
5. close window. setting completed.
こどもが３００円までのお菓子を買うこと
# docker save image to tar file
docker save image:version -o imagename.tar
3Q4: https://step-learn.com/article/javascript/124-diff-match-exec.html
JavaScript では、正規表現にマッチした文字列を取得するメソッドとして、 match() メソッドと exec() メソッドがあります。
まず、「どのオブジェクトのメソッドか」という違いがあります。 match() メソッドは String オブジェクトのメソッドで、 exec() メソッドは RedExp オブジェクトのメソッドです。
ですから、書式はそれぞれ次のようになります。
// match()
文字列.match(正規表現)
// exec()
正規表現.exec(文字列)
// 文字列
var str = "cat map cut bat cute cap";
// 正規表現
var ex = /c.t/g;
var arr = str.match(ex);
for (var i = 0, len = arr.length; i < len; i++){
console.log(arr[i]);
}
// 実行結果
cat
cut
cut
// 文字列
var str = "〒 135-0064\n〒 105-7444";
// 正規表現
var ex = /(\d{3})-(\d{4})/g;
var arr = [];
while((arr = ex.exec(str)) != null){
console.log(arr);
console.log('マッチ文字列:', arr[0]);
console.log('lastIndex:', ex.lastIndex);
}
// 実行結果
Array [ "135-0064", "135", "0064" ]
マッチ文字列: 135-0064
lastIndex: 10
Array [ "105-7444", "105", "7444" ]
マッチ文字列: 105-7444
lastIndex: 21
set str=abcdefg
set key=abc
echo "%str%" | find "%key%" >NUL
if not ERRORLEVEL 1 goto OK_FOUND
:NOT_FOUND
echo "NOT FOUND %key% in %str%. "
pause
exit /b
:OK_FOUND
echo "GOOD! FOUND %key% in %str%. "
pauseREF:https://qiita.com/Targityen/items/3d2e0b5b0b7b04963750
現象:
| 実行ポリシー | 署名あり | 署名なし/ローカル | 署名なし/非ローカル | 説明 |
|---|---|---|---|---|
| Restricted | x | x | x | すべてのスクリプトの実行を制限 (初期設定) |
| AllSigned | o | x | x | 署名のあるスクリプトのみ実行可能 |
| RemoteSigned | o | o | x | ローカル上のスクリプトと非ローカル上の署名のあるスクリプトのみ実行可能 |
| Unrestricted | o | o | △ | すべてのスクリプトが実行可能だが非ローカル上のスクリプトは実行時に許可が必要 |
| Bypass | o | o | o | すべてのスクリプトが実行可能 |