|
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Messages - golfreeze
Pages: 1 2 3 [4] 5 6 ... 146
46
« on: กันยายน 04, 2022, 06:17:29 pm »
==found word="today" or "future" in file test.txt then show number also grep -nw -i -e "today" -e "future" test.txt
47
« on: กันยายน 04, 2022, 06:16:03 pm »
==show line number if found exact word "day" not "today" in file test.txt grep -n -w "day" test.txt
48
« on: กันยายน 04, 2022, 11:57:30 am »
==show verbose "-t" and -n "max-args, --max-args=max-args per command line" and show echo filename ls | cut -d. -f1 | xargs -t -n 1
49
« on: กันยายน 04, 2022, 11:50:40 am »
=== echo all name in "/home" and show as /home/test/{} cd /home/ ls | xargs -I {} echo "/home/test/{}"
50
« on: กันยายน 04, 2022, 11:47:56 am »
=== grep only name of /etc/password and show in 1 line cut -d: -f1 < /etc/passwd | sort | xargs
51
« on: กันยายน 04, 2022, 10:34:02 am »
=== delete all *.txt command with xargs faster than "-exec rm {} \;" find . -type f -name "*.txt" | xargs rm =="-exec rm" more slowly than "xargs rm"  find . -type f -name "*.txt" -exec rm {} \;
52
« on: กันยายน 04, 2022, 10:30:43 am »
== create 10 files with extension .txt with xargs seq 10 | xargs -I {} touch {}.txt
53
« on: กันยายน 04, 2022, 10:25:30 am »
=== text3 ==== store manager total_sales Woodridge,Australia Jon Stephens 33726.77 Lethbridge,Canada Mike Hillyer 33679.79 Bridge,Canada Mike Hillyer 43679.89 Sisaket,Thailand thong 562.22 Pathumthani,Thailand White 992.42 Saimai,Bangkok Packetlove 8229.4
=== text4 === store:manager:total_sales Woodridge,Australia:Stephens:33726.77 Lethbridge,Canada:Hillyer:33679.79 Bridge,Canada:Mike:43679.89 Sisaket,Thailand:thong:562.22 Pathumthani,Thailand:White:992.42 Saimai,Bangkok:Packetlove:8229.4
54
« on: กันยายน 04, 2022, 10:24:46 am »
##show second column contain word "account" awk '$2 ~ account {print} ' filenamel
##show first column start with "e" in file check.sh awk '$1 ~ /^e/ {print } ' check.sh
##show first column start with not contain "e" in file check.sh awk '$1 !~ /^e/ {print } ' check.sh
##search and grep "account" from file awk '/account/ {print } ' check.sh awk '/^account/ {print }' check.sh
##if > < >= <= && || finding $5 more than 2000 and less than 2500 then print awk '$5 > 2000 && $5 <2500 {print $0}' check.sh
##if > < >= <= && || finding $5 more than 2000 or $5 not contain "sal" in line then print awk '$5 > 2000 || $5 !~ /sal/ {print $0}' check.sh
##if need change first line with specific "Start processing" and grep "account" awk 'BEGIN {print "Start processing"} {print $0}' check.sh awk 'BEGIN {print "Start processing"} /account/ {print $0}' check.sh
###if need add BEGIN and END of awk and grep "account" awk 'BEGIN {print "Start processing"} /account/ {print $0} END {print "End processed"}' check.sh
##if need count NR=Number record , NF=Number of field awk '{print NR,$0,NF} END {print "End processed"}' check.sh
##if need print LAST Field $NF awk '{print NR,$0,$NF,FILENAME} ' check.sh
##if need only line4 until line8 in file to show awk 'NR==4,NR==8 {print $0}' check.sh awk 'NR==4,NR==8 {print $0}' check.sh | awk '$3 ~ /username/'
##if substitute space with some character use OFS=output field substitute => if see space " " then replace with "@@" awk 'NR==4,NR==8 {print $0}' check.sh | awk 'BEGIN{OFS="@@"} {print $2,$3}' awk 'BEGIN {print "Start processing"} {print $0}' text3 | awk 'BEGIN{OFS="@"} {print $1,$2".com"}'
##if substitute space with some character use FS=field substitute => if see ":" then replace with space " " awk 'BEGIN{FS=":"} {print $2,$3}' text4
##if substitute space with some character use FS=field substitute => if see ":" then replace with "@@" awk 'BEGIN{FS=":";OFS="@@"} {print $2,$3}' text4
##if substitute last character in file use ORS=":" with : awk 'BEGIN {print "Start processing"} {print $0}' text3 | awk 'BEGIN{OFS="@";ORS=":"} {print $1,$2".com"}' output=> Start@processing.com:store@manager.com:Woodridge,Australia@Jon.com:Lethbridge,Canada@Mike.com:Bridge, Canada@Mike.com:Sisaket,Thailand@Liamthong.com:Pathumthani,Thailand@White.com:Saimai,Bangkok@Packetlove.com:
###if need awk run if condition or run condition on script file awk '{if ($3 > 2000) print $0 }' text3 output=> store manager total_sales Woodridge,Australia Jon Stephens 33726.77 Lethbridge,Canada Mike Hillyer 33679.79 Bridge,Canada Mike Hillyer 43679.89 Saimai,Bangkok Packetlove 8229.4
awk '{if ($3 > 2000) print $0; else print "Low" }' text3 output=> store manager total_sales Woodridge,Australia Jon Stephens 33726.77 Lethbridge,Canada Mike Hillyer 33679.79 Bridge,Canada Mike Hillyer 43679.89 Low Low Saimai,Bangkok Packetlove 8229.4
###if need awk run if condition or run condition on script file awk -f script text4
###toupper=change small character to BIG capital leeter on first column , length=count length of character on $3 awk '{print toupper($1),length($3)} {print $0}' text3
55
« on: สิงหาคม 20, 2022, 03:01:02 am »
===== DB Task ===== run import script in sql testdb=> \copy (select * from param_change_request where id in (161, 162)) TO '/home/testdb/backhour.csv' CSV HEADER;
แล้วสามารถไปดูที่ไฟล์ backhour.csv ได้ครับ
56
« on: สิงหาคม 20, 2022, 02:56:45 am »
ถ้าเรามีการเตรียม สคิปในไฟล์ check_query_alter_update.sql เพื่อทำรายการใน db=testdb เราสามารถรันผ่าน command psql ได้ดังนี้
postgres=> \c testdb testdb=> \i 19aug2022_operation/Script/check_query_alter_update.sql ALTER TABLE
เท่านี้ครับผม
58
« on: เมษายน 14, 2022, 11:15:06 am »
byobu command ctrl+a+c = new window ctrl+a+o = swap window ctrl+a+% = split vertical view
59
« on: เมษายน 12, 2022, 07:42:44 am »
csf lfd stop alert email for nrpe on debian os directadmin กรณีมีอีเมลส่งมาแจ้ง เยอะ alert สามารถแก้ไขเพื่อไม่ให้ส่ง email จาก service csf ที่เป้นหัวข้อ lfd ได้โดย If debian enable “csf” need allow on csf.conf “TCP_in” and “TCP_out” and Disable lfd for resource usage Subject: lfd on packetlove.com: Excessive resource usage: nagios (494190 (Parent PID:494190)) From: < root@packetlove.com> Message-Id: < E1ne3x7-002N0R-7t@packetlove.com> Date: Tue, 12 Apr 2022 07:00:13 +0700 Time: Tue Apr 12 07:00:13 2022 +0700 Account: nagios Resource: Process Time Exceeded: 75567 > 1800 (seconds) Executable: /usr/local/nagios/bin/nrpe Command Line: /usr/local/nagios/bin/nrpe -c /usr/local/nagios/etc/nrpe.cfg -f PID: 494190 (Parent PID:494190) Killed: No --1649721613-eximdsn-849789542-- ==แก้ไขเพื่อไม่ให้ส่ง email ได้โดย vi /etc/csf/csf.pignore user:nagios exe:/usr/local/nagios/bin/nrpe cmd:/usr/local/nagios/bin/nrpe -c /usr/local/nagios/etc/nrpe.cfg -f ==reload csf rule 1 รอบ csf -r
60
« on: เมษายน 03, 2022, 06:23:36 pm »
ในกรณี disk เป็น volume group เราสามารถสั่ง check disk ระบุ partition ได้เลยครับ command[check_disk]=/usr/local/nagios/libexec/check_disk -w 6% -c 3% -p /
Pages: 1 2 3 [4] 5 6 ... 146
|
|
|