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/