How to find a string or text in a file on Linux

How to find a string or text in a file on Linux 

 grep -r --include=\*.forward 'andre'

Remark : Find a sting "andre" on file .forward

Select first name from column in firebird.

How To select firstname from employee name in firebird.


SELECT IIF(POSITION(' ' IN column_name) > 0, SUBSTRING(column_nameFROM 1 FOR POSITION(' ' IN column_name) ), column_name) First_name from Table_name

How to sort du -h output by size

How to sort du -h output by size


du -hs * | sort -h

Running file .js on server linux using pm2

Using  "pm2":

https://github.com/Unitech/pm2

Install Application :
- install pm2 "npm install pm2 -g"

- cd  folder/app/server.js

- Runing  " pm2 start server.js"



* gunakan command "pm2 list" untuk melihat seluruh process yang ada
* "pm2 <stop | start | delete | restart> <app_name | id> " untuk mengontrol process


* "pm2 logs <app_name | id>" untuk mendapatkan log file

Datediff on databse firebird

Datediff on databse firebird


datediff (hour from current_timestamp to timestamp '12-Jun-2059 06:00')
datediff (minute from time '0:00' to current_time)
datediff (month, current_date, date '1-1-1900')
datediff (day from current_date to cast(? as date))


example :

select datediff(day from current_date to cast('2018-11-01' as date)) from  rdb$database

How to Postfix Flush the Mail Queue

Under Postfix MTA,

just enter the following command to flush the mail queue:
# postfix flush
OR
# postfix -f

To see mail queue, enter:
# mailq

To list all mail of queue, use one of the following commands.
# postqueue -p

To remove all mail from the queue, enter:
# postsuper -d ALL

To remove all mails in the deferred queue, enter:
# postsuper -d ALL deferred

SSL Library Error: -8181 Certificate has expired on centos server

SSL Library Error: -8181 Certificate has expired
Unable to verify certificate 'Server-Cert'. Add "NSSEnforceValidCerts off" to nss.conf so the server can start until the problem can be resolved


# vim /etc/httpd/conf/httpd.conf

add text "NSSEnforceValidCerts off"

and then save.

For reference How to know certification expiration date
Please execute command below.

# certutil -L -d /etc/httpd/alias -n Server-Cert

Restart service nss
# service nscd restart


Restart Service apache
# service httpd restart



Reff : https://ecl.ntt.com/en/news/2016122801/

how to auto mounting samba from fstab

How to auto mounting samba from fstab

#vim /etc/fstab

put this script :

//192.168.18.6/backup1 /mnt/backup1 cifs username=xxxxx,password=xxxxx 0 0

and then 

# mount -a

check result :

# df -h

How to synchronize file server without password root with SSH keygen on Centos 6

# ssh-keygen

ssh-keygen
Generating public/private rsa key pair.
Enter file in which to save the key (/root/.ssh/id_rsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 

NB: Please dont put password (Only Enter)

Your identification has been saved in /root/.ssh/id_rsa.
Your public key has been saved in /root/.ssh/id_rsa.pub.
The key fingerprint is:
41:71:f3:9b:14:tc:6f:de:fa:m1:05:c5:0d:65:b6:b7 root@svr7.server.co.id
The key's randomart image is:
+--[ RSA 2048]----+
|        o.oo. .+*|
|       . ..o.. ++|
|        .  .o ...|
|         . .oo .o|
|        x  oo. w.|
|            .... |
|             .o  |
|            .  . |
|             ..  |
+-----------------+



Copy id_rsa to server destination

# ssh-copy-id -i ~/.ssh/id_rsa.pub 192.9.18.25




Synchronize Script

# rsync -avz --delete /mnt/test/ root@192.9.18.25:/mnt/test/

Unwanted Attachments sent, named Part 1.2.2

please read here 

Find data by lastupdate beween two date

find /home/kusdi/Downloads/ -newermt 20170301 \! -newermt 20170310 > iso_doc.txt

script terminal delete file more then 7 day

find -P /home/data/mysql_backup -mtime +7 -delete