Hack The Sec-Leading Resource Of Linux Tutorial: Nodejs

How to Monitor Server Logs in Real-Time with "Log.io"

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; font-style: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;"></span><br />
<div style="background-color: white; orphans: 2; text-align: center; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; widows: 2;">
<span style="background-color: transparent; text-align: left;"><span style="color: #3d85c6; font-family: "verdana" , "geneva" , sans-serif; font-size: medium;"><b><u>Monitor Server Logs in Real-Time with "Log.io"</u></b></span></span></div>
<div style="background-color: white; orphans: 2; text-align: center; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; widows: 2;">
<span style="background-color: transparent; text-align: left;"><span style="color: #3d85c6; font-family: "verdana" , "geneva" , sans-serif; font-size: medium;"><b><u><br /></u></b></span></span></div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Log.io is a small application build on Node.js and Socket.io for monitoring real time Linux server logs through web interface.</span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><u>On RHEL/CentOS 7</u></span></span><br />
<br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Install Epel repositories using the following command.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">yum install http://fedora.mirrors.telekom.ro/pub/epel/7/x86_64/e/epel-release-7-2.noarch.rpm</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><u>On RHEL/CentOS 6</u></span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">--------------------- On RHEL/CentOS 6.x - 32 Bit ---------------------
yum install http://fedora.mirrors.telekom.ro/pub/epel/6/i386/epel-release-6-8.noarch.rpm</span></span></pre>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">--------------------- On RHEL/CentOS 6.x - 64 Bit ---------------------
yum install http://fedora.mirrors.telekom.ro/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">After added the Epel repositories you can do a system upgrade by using following command line.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">yum update</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><b><u>Now Install Node.js and NPM</u></b></span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><a href="https://www.hackthesec.co.in/search/label/Node.Js">Node.js</a> is an open-source, cross-platform JavaScript run-time environment that executes <a href="https://www.hackthesec.co.in/search/label/Java">JavaScript </a>code server-side. Historically, JavaScript was used primarily for client-side scripting, in which scripts written in JavaScript are embedded in a webpage's HTML and run client-side by a JavaScript engine in the user's web browser. Node.js lets developers use JavaScript for server-side scripting—running scripts server-side to produce dynamic web page content before the page is sent to the user's web browser. Consequently, Node.js represents a "<a href="https://www.hackthesec.co.in/search/label/Java">JavaScript </a>everywhere" paradigm, unifying web application development around a single programming language, rather than different languages for server side and client side scripts.now install the nodejs using following command line.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">curl --silent --location https://rpm.nodesource.com/setup_5.x | bash - 
yum install -y nodejs</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><b><u>Install and Configure Log.io Application</u></b></span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Log.io application must be installed through NPM by specifying a valid local system user ( example - root) i recommend install this application through root user. now install the application using following command.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">npm install -g log.io --user "root"</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">after the completed installation the application will create a folder which is hidden the folder name is "Log.io" in centos 7 the folder path is below</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">cd /root/.log.io
ls</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">after that you will see three file</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">harvester.conf, log_server.conf, web_server.conf  </span></span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuP1qRoNyiMnsgPnB-Ow6c5I1pgSS7YbymMqLT9Wj7uLnpBPeeEM8TDIfY81JpkCPL2ZaAu-rTcQ576SeX0QmR4eD8Qht30I1bvvCa7ujwrTOm3Kol2z99Ez0ubbbawS7nslknCIE5WL6Y/s1600/Log-io-hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="227" data-original-width="620" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuP1qRoNyiMnsgPnB-Ow6c5I1pgSS7YbymMqLT9Wj7uLnpBPeeEM8TDIfY81JpkCPL2ZaAu-rTcQ576SeX0QmR4eD8Qht30I1bvvCa7ujwrTOm3Kol2z99Ez0ubbbawS7nslknCIE5WL6Y/s1600/Log-io-hackthesec.co.in.jpg" /></a></div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Now it's time to configure Log.io to monitor local log files in real time.</span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">- The harvester file is for watches the changes in specified local log files declared in its configuration and send new log to the server. - </span></span><b style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">harvester.conf</b><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">First open the </span><b style="font-size: 15px;">harvester.conf</b><span style="font-size: 15px;"> file, by default you will see have some setting the monitor Apache log </span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">nano harvester.conf</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">my harvester.conf file below</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">exports.config = {
    nodeName: "application_server",
    logStreams: {
      apache: [
        "/var/log/httpd/access_log",
        "/var/log/httpd/error_log"
      ],
      SecureLog: [
        "/var/log/secure"
        ],
      MySqlLog: [
        "/var/log/mysqld.log"
        ]
    },
    server: {
      host: '0.0.0.0',
      port: 28777
    }
  }</span></span>
</pre>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Note - if you don't want to send the harvester output to a remote Log.io server then open harvester.conf </span></span><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;">file and replace 0.0.0.0 address with lookback address(127.0.0.1)</span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">log_server.conf - This configuration is for tell the server on which ip address it should listen.By default it listens on all ip interfaces you can modify the ip address by using the following command </span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;">my log_server.conf file below</span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">nano log_server.conf</span></span></pre>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">exports.config = {
  host: '0.0.0.0',
  port: 28777
}</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><b>web_server.conf</b> - This configuration file is for web interface. by default the web portal is accessible on port 28778(all interface). Also using this file you can increase the security by using HTTP authentication,securing the web interface with SSL, disallow logs from specific ip address and restricting the web interface access to the specific ip. </span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;">my </span><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">web_server.conf file below</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">nano web_server.conf</span></span></pre>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;"> exports.config = {
  host: '0.0.0.0',
  port: 28778,

/*
  // Enable HTTP Basic Authentication
  auth: {
    user: "hackthesec",
    pass: "1234346"
  },
  */

/*
  // Enable HTTPS/SSL
  ssl: {
    key: '/path/to/privatekey.pem',
    cert: '/path/to/certificate.pem'
  },
  */

/*
  // Restrict access to websocket (socket.io)
  // Uses socket.io 'origins' syntax
  restrictSocket: '*:*',
  */

/*
  // Restrict access to http server (express)
  restrictHTTP: [
    "192.168.29.39",
    "10.0.*"
  ]
  */

}</span></span>
</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja29JCqUHeUn2NHEHOZPAz59BnbBqvH3fk7jLffTc6NfIrsZ2eXbW6k6odmEELRQnzsSYyYHmTCJgLLGpaJvJaVseDE2kx86B840v4Hpx8zI_xT6YAkttZmW3ntQSp1X3-Qn_juaETMJmb/s1600/web_server_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="638" data-original-width="772" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja29JCqUHeUn2NHEHOZPAz59BnbBqvH3fk7jLffTc6NfIrsZ2eXbW6k6odmEELRQnzsSYyYHmTCJgLLGpaJvJaVseDE2kx86B840v4Hpx8zI_xT6YAkttZmW3ntQSp1X3-Qn_juaETMJmb/s1600/web_server_hackthesec.co.in.png" /></a></div>
<div>
<br /></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Allow web interface and socket.io in the firewall for receiving the logs from the harvester.</span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">firewall-cmd --add-port=28778/tcp --permanent
firewall-cmd --add-port=28777/tcp --permanent
firewall-cmd --reload</span></span></pre>
</div>
<div>
<span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;"><br /></span></span></div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Start Log.io Application using following command line </span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">------ First start server in background ----
log.io-server &</span></span></pre>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">--- Start log harvester in background -----
log.io-harvester & </span></span></pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRldk28y5_z1TiM28OKiNFnAcKxevfA2ntXReBPpbCg6bg4NIXAgA2qujEtdylCIxukUPN72GkGaxgalxkIKU-2UFF9D3p6UKpnmhcQ4D2OrvioPhymeb_WW3ykaQtfrSA-uQyXmzAGIWW/s1600/Start-Log-io_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="241" data-original-width="447" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRldk28y5_z1TiM28OKiNFnAcKxevfA2ntXReBPpbCg6bg4NIXAgA2qujEtdylCIxukUPN72GkGaxgalxkIKU-2UFF9D3p6UKpnmhcQ4D2OrvioPhymeb_WW3ykaQtfrSA-uQyXmzAGIWW/s1600/Start-Log-io_hackthesec.co.in.jpg" /></a></div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">After the server has been started open your browser and hit enter with your ip and the </span></span><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;">declared </span><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"> port</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">example - http://192.168.2.253:28778</span></span></pre>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBdovh_DU52bpmFN5i3ZAgRhx0sHrL3a1TimO9sLlJnCodSv0oAXXg4lhB_kStNf-kJCGmpbgMXHf-Q7KaG8P-ljSgpUteKiK-t6RoFeJa614ZivaHhUJFU8uPxy12Hx2NMCJ3YTwpoBHk/s1600/screen_detail.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="435" data-original-width="960" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBdovh_DU52bpmFN5i3ZAgRhx0sHrL3a1TimO9sLlJnCodSv0oAXXg4lhB_kStNf-kJCGmpbgMXHf-Q7KaG8P-ljSgpUteKiK-t6RoFeJa614ZivaHhUJFU8uPxy12Hx2NMCJ3YTwpoBHk/s1600/screen_detail.jpg" /></a></div>
<br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">To stop Log.io application run the following command.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">pkill node</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Log.io = https://github.com/NarrativeScience/Log.io</span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">http://logio.org/</span></span></div>

How to Monitor Server Logs in Real-Time with "Log.io"

Monitor Server Logs in Real-Time with "Log.io" Log.io is a small application build on Node.js and Socket.io for monitoring r...

How to Send Email from Node.js

<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="post-author" style="-webkit-text-stroke-width: 0px; background-color: white; border: 0px; color: #777777; font-family: 'Roboto Slab'; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; margin: 0px; orphans: auto; outline: 0px; padding: 0px; text-align: start; text-indent: 0px; text-transform: none; vertical-align: baseline; white-space: normal; widows: 1; word-spacing: 0px;"></span><br />
<h1 class="title single-title title20" style="-webkit-text-stroke-width: 0px; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; font-style: normal; font-variant: normal; font-weight: 700; letter-spacing: normal; line-height: 38px; margin: 0px 0px 5px; opacity: 1; orphans: auto; outline: 0px; padding: 0px; text-align: center; text-indent: 0px; text-transform: none; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible; white-space: normal; widows: 1; word-spacing: 0px;">
<u><span style="color: #990000;">Send Email from Node.js</span></u></h1>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Node.js is an open-source, cross-platform runtime environment for developing server-side Web applications. Although <a href="http://www.hackthesec.co.in/search/label/Node.Js">Node.js</a> is not a JavaScript framework, many of its basic modules are written in JavaScript, and developers can write new modules in JavaScript. The runtime environment interprets JavaScript using Google's V8 JavaScript engine.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS_d84hKw7Wbrd45feCZJfc5UzuZmMrKqYVaPQH4-eIyKaI03TQLhnTqrXKqI_29dGvp0lXdCdm-LzYjOLtOJYCam5NGABC8pKYMceCtBB1Ok5xvlkqtjylZXFrpaz78DavDHgahrHBuc0/s1600/sending-email-with-node-js-gmail-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS_d84hKw7Wbrd45feCZJfc5UzuZmMrKqYVaPQH4-eIyKaI03TQLhnTqrXKqI_29dGvp0lXdCdm-LzYjOLtOJYCam5NGABC8pKYMceCtBB1Ok5xvlkqtjylZXFrpaz78DavDHgahrHBuc0/s1600/sending-email-with-node-js-gmail-www.hackthesec.co.in.jpg" /></a></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">First you need to install nodemailer package in your application. Use following command to install this package.</span></span></div>
<div>
<pre style="background-attachment: initial; background-clip: initial; background-color: #363636; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-radius: 7px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; margin-bottom: 15px; margin-top: 15px; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline;"><span style="color: white; font-family: monaco, courier new, dejavu sans mono, bitstream vera sans mono, monospace;"><span style="font-size: 15px; line-height: 19px; white-space: pre-wrap;">$ npm install nodemailer</span></span></pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now add following code in your application to send email. Make sure to update all required values in below code to send email successfully.</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: menlo, monaco, consolas, courier new, monospace;"><span style="line-height: 25.7143px;">var nodemailer = require('nodemailer');

var mailTransport = nodemailer.createTransport('smtps://user%40gmail.com:email_password@smtp.gmail.com');

var mailOptions = {
   from: "Sender Name <sender@example.com>",
   to: "Recipient Name <recipient@example.com>",
   subject: "Hello World",
   text: "Test email with node.js"
   html: '<b>Test email with node.js</b>'
};

mailTransport.sendMail(mailOptions, function(error, info){
    if(error){
        return console.log(error);
    }
    console.log('Message sent: ' + info.response);
});</span></span><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px; white-space: normal;">
</span></span></pre>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you are still facing any issue with sending email through Gmail stmp servers make sure you are using correct login details. For 2 factor authentication enabled account required to generate application specific password and set here. Also you allow <a href="https://www.google.com/settings/security/lesssecureapps" target="_blank">less secure apps</a> in your Gmail account.</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div>
</div>
</div>

How to Send Email from Node.js

Send Email from Node.js Node.js is an open-source, cross-platform runtime environment for developing server-side Web applications. Alth...

Node.js with MySQL Examples

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000;"><i><u>Node.js with MySQL Examples</u></i></span></h2>
<div>
<br /></div>
<div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Node.js is an popular programming language like PHP & JAVA for web applications. Also MySQL is most popular database used for storing values. MySQL database driver for Node.js is available under NPM repository. In this tutorial you will learn to how to connect MySQL database using node.js and do INSERT, UDATE, SELECT and DELETE operations on MySQL database table.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTiGXAXsRvpsw8iYpufgMngnkmNxjVpPqzvIeBtCj25i1oc9vDHNczzfVtFvsCAUTpT4tkw4MQO4qxM3UqPg0z7Crmh2YoJcrM2vr6vexURbdaa27vO9nJ4FezEioaeXJ3LAAqsecSYHmA/s1600/node-with-mysql_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTiGXAXsRvpsw8iYpufgMngnkmNxjVpPqzvIeBtCj25i1oc9vDHNczzfVtFvsCAUTpT4tkw4MQO4qxM3UqPg0z7Crmh2YoJcrM2vr6vexURbdaa27vO9nJ4FezEioaeXJ3LAAqsecSYHmA/s1600/node-with-mysql_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; font-stretch: normal; font-weight: normal; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<ul style="text-align: left;">
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-connect-nodejs-with-mysql.html" target="_blank"><span style="color: red;">How to Connect Node.js with MySQL</span></a></li>
</ul>
</h2>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">1. Create MySQL Database and Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">First create a database and user in mysql for your applications. For testing purpose, we are creating mydb database and use it.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> CREATE DATABASE mydb;
mysql> USE mydb;<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now create a example tables for doing insert, update and delete operations.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> CREATE TABLE users ( 
  id int(11) NOT NULL AUTO_INCREMENT,
  firstname varchar(30),
  lastname varchar(30),
  email VARCHAR(50),
  creation_date TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<span style="font-size: 0.9em;">

</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Arial, Helvetica, sans-serif;">Also create a mysql user for accessing database from application.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> GRANT ALL on mydb.* to 'myusr'@'localhost' identified by '123456';
mysql> FLUSH PRIVILEGES;<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">2. Install Node.js MySQL Module</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">MySQL driver for node.js is available under node package manager (NPM). Use the following command to install it.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo npm install mysql
</pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">3. Simple App to Connect MySQL</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Below is sample node.js program which will connect node.js application with MySQL server. It will show success and error messages according to connections results and close the connection at the end of program. Create a JavaScript file <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">app.js</span>.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ cd myApp
$ vim app.js<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">and add the following content to above file.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">var mysql  = require('mysql');
var dbconn = mysql.createConnection({
  host     : 'localhost',
  user     : 'myusr',
  password : '123456',
  database : 'mydb'
});

dbconn.connect(function(err){
  if(err){
    console.log('Database connection error');
  }else{
    console.log('Database connection successful');
  }
});

dbconn.end(function(err) {
  // Function to close database connection
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now execute above script using nodejs and make sure that database is connecting properly or not.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ node app.js

Database connection successful<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">3. Insert Data in MySQL Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now add the code in above script to insert data in <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">users</span> table in <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">mydb</span> database.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">var mysql  = require('mysql');
var dbconn = mysql.createConnection({
  host     : 'localhost',
  user     : '<DB_USER>',
  password : '<DB_PASSWORD',
  database : '<DB_NAME>'
});

dbconn.connect(function(err){
  if(err){
    console.log('Database connection error');
  }else{
    console.log('Database connection successful');
  }
});

<span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
var record= { firstname: 'hackthe', lastname: 'sec', email: 'abc@hackthesec' };

dbconn.query('INSERT INTO users SET ?', record, function(err,res){
  if(err) throw err;

console.log('Last record insert id:', res.insertId);
});
</span>
dbconn.end(function(err) {
  // Function to close database connection
}<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now execute app.js script using command line and make sure that data is properly inserted in database. Repeat this step few more times with updating values in above script.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ node app.js

Database connection successful
Last record insert id: 5<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Also check the record added in users table under mydb database using mysql command line.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> select * from users;

console.log('Data received from Db:\n');
  console.log(records);
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">or you can customize search by selection values basis of specific conditions.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">dbconn.query('SELECT * FROM users WHERE id = ?' [5] ,function(err, records){
  if(err) throw err;

console.log('Data received from Db:\n');
  console.log(records);
});<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">5. Update Data from MySQL Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now if you required to update existing data in mysql table, use following code.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">dbconn.query('SELECT users SET email = ? WHERE id = ?', ['new@hackthesec.co.in', 6], function(err, result){
  if(err) throw err;
  
  console.log('Record Updated ' + result.changedRows + ' rows');
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now check values in database table.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> select * from users;

+----+-----------+----------+----------------+---------------------+
| id | firstname | lastname | email          | creation_date       |
+----+-----------+----------+----------------+---------------------+
|  5 | hackthe   | sec      | abc@hackthesec | 2016-01-22 17:16:19 |
|  6 | payel     | sec      | new@<span style="line-height: 1.3em;">hackthesec</span><span style="line-height: 1.3em;"> | 2016-01-22 17:16:55 |</span>
+----+-----------+----------+----------------+---------------------+
2 row in set (0.01 sec)<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">6. Delete Data from MySQL Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now if you delete some record from table, add following code in your node.js application code.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">dbconn.query('DELETE FROM users WHERE id = ?', [6], function(err, result){
  if(err) throw err;
  
  console.log('Record Updated ' + result.affectedRows + ' rows');
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now check values in database table.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> select * from users;

Node.js with MySQL Examples

Node.js with MySQL Examples Node.js is an popular programming language like PHP & JAVA for web applications. Also MySQL is most p...