Twilio Test Application in Node js

First things first – if you have not yet installed Node.js on your system, you can download an installer for your platform from nodejs.org

Next, install the Twilio module using npm, in the same directory as “Twilio.js”

[sudo] npm install twilio
var twilio = require('twilio');
var client = new twilio.RestClient('TWILIO_ACCOUNT_SID', 'TWILIO_AUTH_TOKEN');
 
// REST client will handle authentication and response serialzation for you.
client.sms.messages.create({
 to:'+16512223344',
 from:'TWILIO_NUMBER',
 body:'Hello World'
}, function(error, message) {
 if (!error) {
 // information about the text messsage you just sent:
 console.log('Success! The SID for this SMS message is:');
 console.log(message.sid);
 
 console.log('Message sent on:');
 console.log(message.dateCreated);
 } else {
 console.log('Oops!This number is invalid.');
 }
});

To run this code, return to the terminal and run

node Twilio.js

 

Advertisements

Setup a Mosquitto Password

sudo service mosquitto stop
cd /usr/local/bin
If you already Created a Password & want to change that then using below Command
mosquitto_passwd -D /etc/mosquitto/passwd username
Below Command is for New Password Creation
mosquitto_passwd -c /etc/mosquitto/passwd username
Password
Re-Enter
sudo nano /etc/mosquitto/mosquitto.conf
allow anonymous false
#Default authentication and topic access control

#password_file /etc/mosquitto/passwd
 sudo service mosqquitto start
 sudo service mosquitto status

How to Create a Proxy Layer Between MQTT Broker & AWS IOT Broker

Create Proxylayer.js file and paste the following code into it:

var mqtt = require('mqtt'), url = require('url');
var client = mqtt.connect('mqtt://localhost:1883',
{
username: '<username>',
password: '<password>'
});

console.log("Connected to MQTT Broker:- localhost” + client.toString());
var awsIot = require('aws-iot-device-sdk');
var device = awsIot.device({

keyPath:  Certificate key file path,
certPath: Certificate file path,
caPath:   Certificate root file path,
clientId: AWS Thing Name,
region:   AWS IoT Broker region,
});

device.on('connect', function ()
{
console.log("Connected to AWS IoT Broker:- " + device.toString());
});

client.on('connect', function()
{
//subscribe to a topic (#)
client.subscribe('#', function ()
{
client.on('message', function (topic, message, packet) {
console.log("Received :-" + message + " on " + topic);
device.publish(topic, message);
console.log("Sent :-" + message + " on " + topic);
});
});
});

 

How to Create a TCP Client Server Socket example using Java

*****************************TCPSERVER***********************

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.ServerSocket;
import java.net.Socket;

class TCPServer {
 public static void main(String argv[]) throws Exception {
 ServerSocket ourFirstSocket = new ServerSocket(port);
 while (true) {

Socket connectionSocket = ourFirstSocket.accept();
 BufferedReader messagesFromClient = new BufferedReader(new InputStreamReader(connectionSocket.getInputStream()));
 String clientSentence = messagesFromClient.readLine();
 System.out.println("Received: " + clientSentence);
 }
 }
}

*****************************TCPCLIENT***********************

import java.io.BufferedReader;
import java.io.DataOutputStream;
import java.io.InputStreamReader;
import java.net.*;
class TCPClient {
public static void main(String agrs[]) throws Exception {
Socket clientsocket = new Socket("localhost", port);
DataOutputStream outToServer = new DataOutputStream(clientsocket.getOutputStream());
BufferedReader infromUser = new BufferedReader(new InputStreamReader(System.in));
String sentence = //infromUser.readLine();
outToServer.writeBytes(sentence + '\n');

clientsocket.close();
}
}

How to Open a Port in Windows firewall

Step 1) Choose Start→Control Panel. Click the System and Security link and then click Windows Firewall.

You see the main Windows Firewall control window.

146664.image0.jpg

Step 2) On the left, click the Advanced Settings link.

146666.image2.jpg

Step 3) On the left, click Inbound Rules. Then, on the right, under Actions, click the New Rule link.

Windows Firewall shows you the New Inbound Rule Wizard.

146668.image4.jpg

Step 4) Select the option marked Port and click Next.

The wizard asks you to specify which ports.

Step 5) In the Specific Local Ports box, type the ports you want to open, separated by commas, and then click Next.

For example, in this case, the TCP ports that need to be opened are 8081, 8082, 9001, and 9002. The wizard takes action and opens those ports to receive data.

Step 6) Choose Allow the Connection and click Next.

The New Inbound Rule Wizard wants to know whether it should apply this rule if you’re connected to a domain network, a private network, or a public network. The safest option is to make it only open on your home network.

Step 7)Check the boxes for Private or any other desired network type, and then click Next.

The wizard asks that you give the rule a name and, optionally, a description.

Step 8) Type a name (usually the name of whatever program required the opening). Click Finish

Your new rule appears in the Inbound Rules list. It takes effect immediately.

146670.image6.jpg

 

How to Clean Order database in magento

Open Putty with your default Username & Copy – Paste the below Script in it.

Run below script to clean the order database in magento

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE TABLE catalogsearch_fulltext;

TRUNCATE TABLE catalogsearch_query;

TRUNCATE TABLE catalogsearch_result;

TRUNCATE sales_bestsellers_aggregated_daily 

TRUNCATE sales_bestsellers_aggregated_monthly 

TRUNCATE sales_bestsellers_aggregated_yearly 

NOTE-Please Use Very Carefully this Script Because TRUNCATE Delete all the Orders from your DB.

TRUNCATE `sales_flat_creditmemo`;

TRUNCATE `sales_flat_creditmemo_comment`;

TRUNCATE `sales_flat_creditmemo_grid`;

TRUNCATE `sales_flat_creditmemo_item`;

TRUNCATE `sales_flat_invoice`;

TRUNCATE `sales_flat_invoice_comment`;

TRUNCATE `sales_flat_invoice_grid`;

TRUNCATE `sales_flat_invoice_item`;

TRUNCATE `sales_flat_order`;

TRUNCATE `sales_flat_order_address`;

TRUNCATE `sales_flat_order_grid`;

TRUNCATE `sales_flat_order_item`;

TRUNCATE `sales_flat_order_payment`;

TRUNCATE `sales_flat_order_status_history`;

TRUNCATE `sales_flat_quote`;

TRUNCATE `sales_flat_quote_address`;

TRUNCATE `sales_flat_quote_address_item`;

TRUNCATE `sales_flat_quote_item`;

TRUNCATE `sales_flat_quote_item_option`;

TRUNCATE `sales_flat_quote_payment`;

TRUNCATE `sales_flat_quote_shipping_rate`;

TRUNCATE `sales_flat_shipment`;

TRUNCATE `sales_flat_shipment_comment`;

TRUNCATE `sales_flat_shipment_grid`;

TRUNCATE `sales_flat_shipment_item`;

TRUNCATE `sales_flat_shipment_track`;

TRUNCATE `sales_invoiced_aggregated`;            # ??

TRUNCATE `sales_invoiced_aggregated_order`;        # ??

TRUNCATE `log_quote`;

ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_comment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;

ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;

ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;

ALTER TABLE `log_quote` AUTO_INCREMENT=1;

 

TRUNCATE `downloadable_link_purchased`;

TRUNCATE `downloadable_link_purchased_item`;

ALTER TABLE `downloadable_link_purchased` AUTO_INCREMENT=1;

ALTER TABLE `downloadable_link_purchased_item` AUTO_INCREMENT=1;

 

TRUNCATE `eav_entity_store`;

ALTER TABLE  `eav_entity_store` AUTO_INCREMENT=1;

TRUNCATE `customer_address_entity`;

TRUNCATE `customer_address_entity_datetime`;

TRUNCATE `customer_address_entity_decimal`;

TRUNCATE `customer_address_entity_int`;

TRUNCATE `customer_address_entity_text`;

TRUNCATE `customer_address_entity_varchar`;

TRUNCATE `customer_entity`;

TRUNCATE `customer_entity_datetime`;

TRUNCATE `customer_entity_decimal`;

TRUNCATE `customer_entity_int`;

TRUNCATE `customer_entity_text`;

TRUNCATE `customer_entity_varchar`;

TRUNCATE `tag`;

TRUNCATE `tag_relation`;

TRUNCATE `tag_summary`;

TRUNCATE `tag_properties`;            ## CHECK ME

TRUNCATE `wishlist`;

TRUNCATE `log_customer`;

ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `tag` AUTO_INCREMENT=1;

ALTER TABLE `tag_relation` AUTO_INCREMENT=1;

ALTER TABLE `tag_summary` AUTO_INCREMENT=1;

ALTER TABLE `tag_properties` AUTO_INCREMENT=1;

ALTER TABLE `wishlist` AUTO_INCREMENT=1;

ALTER TABLE `log_customer` AUTO_INCREMENT=1;

 

TRUNCATE `log_url`;

TRUNCATE `log_url_info`;

TRUNCATE `log_visitor`;

TRUNCATE `log_visitor_info`;

TRUNCATE `report_event`;

TRUNCATE `report_viewed_product_index`;

TRUNCATE `sendfriend_log`;

### ??? TRUNCATE `log_summary`

ALTER TABLE `log_url` AUTO_INCREMENT=1;

ALTER TABLE `log_url_info` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;

ALTER TABLE `report_event` AUTO_INCREMENT=1;

ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1;

ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;

### ??? ALTER TABLE `log_summary` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS=1;