Yeop's IoT world

connecting mysql, mobius, thyme, and Tas

오후 8:00 Unknown 0 Comments Category :

Hi guys. It's so long time for posting. For this time, I am gonna show you how to connect mysql, mobius, Thyme, and Tas. The definition and funtion for each of them is shown in the guidebook on www.iotocean.org. you guys need to download mysql installer, mobius, thyme, tas, and nodejs. I will show you everything how to download them. For this time, I used mobius-yt-2.1.2 and Thyme 1.6.5. Please download them in advance.

1. mysql.
go to mysql website and click the MySQL Community Server.

If you click it, you can see "MySQL Community Server 5.6. If you find it, click it.

I recommend to use 5.6 version because the guidebook also recommend to use it. Download the installer MSI.

When you finish to download it, let's install mysql then. Just follow what I did.
Choose custom option to install what we need.

Set your password for database.

And then just click next and excute. When you finish to install mysql, you can see this one.

Next thing you need to do for database is importing mobius table to database.
Let's go to mysql database and then you can see this one.

On the left side, there are MANAGEMENT, INSTANCE, PERFORMANCE, AND SCHEMAS. In order to import mobius, we need to make another table in Schemas. If you right click in the Schemas section, you can see "create Schemas".

In the mobius configuration, the default name for database is 'mobiusdb'. So name mobiusdb for this table and click apply. If you are done, you can see mobiusdb table and set it as a default schema.

Now, let's import mobius sql file to database.
click 'server->dataimport' and then you can see this one.

In order to import mobiusdb sql file, click 'Import from Self-Contained File' and search mobius sql file in you computer(you need to download this file in iotocean webpage).
Next, you need to select the 'Default Target Schema. Of course, our default target is mobius db so choose it and click start import.

When the importing is done and refresh schemas, you can see mobiusdb table.

Now, the database is ready for everything. Then, Let's connect database and mobius. In order to connect them, you need to use Node.js. It is easy to install it. So if you don't have it, please download and install it.

If you download mobius zip file and unzip it, there are some directories, a JSON, and 3 node.js files. In order to connect mobius to database, you need to set password to let mobius log in to database.

This is mobius.js file and you can see 'global.usedpass' which is your mysql database password. Put the password there and save it.
When you finish save it, implement command window and go to mobius directory.

If you see this one, mobius and mysql are connected each other.

If you follow to this step, now you are going to use raspberry pi3. Before handling Thyme, I will show you how to control rasbian in your PC. We need to install samba, xdrp, nodejs, tightvncserver.
For the first step, type 'sudo apt-get update' and 'sudo apt-get upgrade' to upgrade your raspbian.
In order to install nodejs, we need to remove current installed nodejs in raspbian. follow this one.

After that, let's download nodejs 4.x version. Type 'curl -sL https://deb.nodesource.com/setup_4.x | sudo -E bash -'. I recommand to download 4.x version but if you wanna download 6.x version, just type 6.x instead of 4.x. When the downloading is down, you can see this one.

Just following what it said. Type 'sudo apt-get install nodejs' to install nodejs. And then, type 'sudo atp-get install tightvncserver', 'sudo apt-get install xrdp'.
If you use window OS, there is a 'remote desktop'program. You can control your raspberry pi by using this program.

Samba helps you to upload and download files easily. What you need to do for move file from PC to raspberry pi, just drag a file from PC to raspberry pi. That's all. In order to download it, type 'sudo pat-get install samba samba-common-bin'. Now, you need to set a password for samba.

Type 'sudo sambpasswd -a pi' and set the password and type 'sudo nano/etc/sanba/smb/conf' to configure user(pi)'s options. when you open smb.conf, go to the end of text and put this one.

Now, All done for Thyme and tas. Then. let's move Thyme and TAS files from PC to raspberry pi. I will make a directory in raspberrypi for them.

Let's use samba to move them. Open any directory in window and type '\\raspberry pi's address'. my raspberry pi's address is 192.168.0.23 so I will type \\192.168.0.23

You can see a pi directory and when you double click it, it ask you to put user name and password. You already set them so you should know them. When you log in raspberry pi, you can see many directories. The only things you need to do is copy and paste Thyme directory from PC to raspberry pi.
There is a conf.JSON file in thyme folder. Open it and change 'cbhost' to your database address(which is your PC address).

If you excute mobius in your PC and Thyme in your raspberry pi, this messages should be shewn up.

Then, just Follow what it need, go to conf.json again and change AE-ID to another one started with S or C.

If you set them perfectly and re-execute mobius and thyme, you can see this command line in your PC and raspberry pi.

mobius

Thyme

There is a message that "TCP SErver for TAS is listening on port 7622" meant that now this thyme is waiting for TAS.

Finally, only TAS is left. if you unzip TAS, you can see conf.xml file. You need to edit this file.

This is default value in the conf.xml file and we need to upload some message to thyme.
If you see the app.js file in TAS, it ask you upload's Id and ctname. So we need to make upload's ctname and id in conf.xml file. and this ctname must be matched with cnt's name in conf.json in thyme. like this.

In these conf files(left one is Thyme and the other is TAS), both ctnames are matched. Moreover, app.js in TAS ask you the upload's id. there are 'If' phrase that 'if(upload.id == timer) which let you upload data to Thyme if this if phrase is satisfied. That's why I set id as timer.

If you set everything, Let's execute mobius, thyme, and TAS.

As you can see, TAS send message to Thyme, and Thyme send answer to TAS.

In the mobius terminal, you can see mobius can get date from thyme correctly.

This my MySQL database which received data from mobius and you can see these data in cin in database's table

Thank you for reading and when you have some question, please email me.

Zigbee networking among arduinoes

오전 2:24 Unknown 0 Comments Category :

Hi everyone. In this time, I will show you how arduinoes with zigbee transfer data each others. In the last time, I shew you how to set up zigbee to connect each other. In order to transfer Zigbee each other, make sure that the PAN ID and destination address high and low are set properly.

Before upload code to arduino, make sureyour Zigbee is connected each other or not. you can check it in X-CTU consoles working mode tap. If you checked it, It's ready for transfering data each Zigbees. Let's go to arduino sketch.

you need 2 codes that one of them is for sender and the other is for receiver.

This is the sender code:

This sender send ramdom number to receiver every 1 second.

and this is the receiver code:

This code receive a data in every 1 second.

If you followed to this step, you can see the received data in the receiver's serial monitor like this

This is communication between 2 Zigbee. In next time, I will show you communication between arduino and raspberry pi. Thank you.

Zigbee networking

오전 6:19 Unknown 0 Comments Category :

Hi everyone. Happy new year. It is long time for posting. You guys also know how much busy in the end of semester haha. I had some project in my courses and in one of them, I used Zigbee to transfer data from devise to devise. There are so much information about Zigbee. So, in the time, I will let you know how you set the Zigbee module.
In order to connect Zigbees each others, you need to set some address in the Zigbee module.

A. go to this website https://www.digi.com/products/xbee-rf-solutions/xctu-software/xctu and download X-CTU software.

There are some X-CTU version depends on your OS.

B. connect your Zigbee module with Arduino or Raspberry pi(in this time, I used xbee s2). There are two way to connect xbee with Arduino or Raspberry.

Using shield to connect them.
Xbee shield is one of the modules to connect with arduino and raspberry pi.

P.S. There should be a switch on the shield to control trasnferring data or code from arduino to xbee. If there isn't switch like mine, you need to find Tx and Rx pin. There should be 3 pins which are Din, Dout, and digital pin. Depends on connecting Rx and Tx's pin with Din or Dout, the on and off will be different.
You can connect them without shield too. But you need a adapter to connect xbee with arduino or raspberry pi.

P.S. you need to connect module's Rx with Tx in arduino and module's Tx with Rx in arduino.
You can connect xbee with raspberry pi by using xbee module.

C. make your arduino empty which means upload empty code like this.

D. Go to X-CTU and fine your xbee. In order to find xbee in X-CTU, you should connect xbee with shield and put the shield on the arduino which has empty code.

go to the add module, click port what you connect with arduino and find xbee like this:

If you succeed to find xbee, you can see your xbee in the right side like this:

For you information, if there is a code in the arduino, you can see this screen

When you succeed to find it, click your module and let's set your module. The most important option is PAN ID, Destination address high and destination address low. PAN ID means personal area network that share date with other modules which has same PAN ID. Destination address high and low are the address to find other modules from low address to high address(such as maxium address to minimum address).

set the same PAN ID among your xbee which means that put your xbees in the same network area. And then set the Destination address High to 13A200 and Destination address Low to the other xbee's serial number's low. If you use more than 2 xbees, fine the lowest one and put it there(the serial number is hexademical).

if you finish all the setting, you need to check that the connection is working or not, Let's go to console working mode.

If you can see this screen, your xbee can communicate each other. This is the end of setting for xbee. Next time, I will show you how to transfer data from arduino to arduino. Thanks.

Communication among devices in JSON message through MQTT

오전 7:41 Unknown 0 Comments Category :

This time, I made 3 layer which are device, gateway and server. The device publishes a JSON message to gateway, the server gets a message from gateway and sends a message to gateway, and the gateway gets message from both device and server and sends a message what device sent to server. This is a structure for this code.

pi 1 is a device, pi2 is a gateway and PC is a server as I said.

This is device(pi1) code:
---------------------------------------------------------------------------------------------------

var mqtt = require('mqtt');

var pi3_01 = mqtt.connect('mqtt://192.168.0.11');

var num = 0;

var count = 0;

var frequency = 5000;

function setPub(frequency)

{

setInterval(function() {

setNum();

count++;

console.log('frequency--->'+ frequency);

pi3_01.publish('pi3_02', JSON.stringify({From: 'pi3_02', seq: + count, data: +num}));

console.log('-------------------');

console.log(JSON.stringify({From: 'pi3_01', seq: + count, data: +num}));

}, frequency);

}

function setNum()

{

num = Math.floor(Math.random() *100) +1;

}

pi3_01.on('connect', function() {

console.log('pi3_01 on');

setPub(frequency);

});

---------------------------------------------------------------------------------------------------

This is gateway(pi2) code:

---------------------------------------------------------------------------------------------------

pi3_01.on('message', function(topic, message)

{

var jsontext = JSON.parse(message);

if(topic =='pi3_02')

{

PC.publish('pi3_01', JSON.stringify({seq: +jsontext.seq,

From: jsontext.From, data: +jsontext.data}));

console.log(jsontext);

}

if(topic =='PC')

console.log(jsontext)

});

function sub()

{

pi3_01.subscribe('pi3_02');

pi3_01.subscribe('PC');

}

function unsub()

{

pi3_01.unsubscribe('pi3_02');

pi3_01.unsubscribe('PC');

console.log('+++++++++++++++++++++++++++++++++++++++++');

}

loop();

--------------------------------------------------------------------------------------------------

This gateway opens and closes subscribe frequently( every 5seconds ) so that gateway can save power when it closes subscribe.

This is server(PC) code:

--------------------------------------------------------------------------------------------------

var mqtt = require('mqtt');

var PC = mqtt.connect('mqtt://192.168.0.15'); //PC Broker ip

var pi3_01 = mqtt.connect('mqtt://192.168.0.11'); //Gateway Broker ip

PC.subscribe('pi3_01');

PC.on('message', function(topic, message) {

var jsontext = JSON.parse(message);

console.log(jsontext);

pi3_01.publish('PC', JSON.stringify({From: 'PC', Message: 'I got it'}));

});

--------------------------------------------------------------------------------------------------

The result is followed:

devices

Device send JSON which has a device's name, sequence number and data(random number).

Gateway

Gateway sends a message what it get from device and get a message from server. The server send a message that there was no problem.

server

This server shows what it got from gateway and send a message to gate that it

So, there are 3 layers(device, gateway, and server) that communicate each other.

sending JSON file through MQTT protocol in node.js

오전 8:49 Unknown 0 Comments Category :

This time, I made some codes for end devices and gateway. For end devices, I made a code to transport a JSON message to gateway. JSON message has a random number, sequence number, and device name so that the gateway can know where this data come from. I put the sequence number because the gateway need to know each of data that gateway just got is right data or late one. This is the code what I made.

Function json_data() makes a json message which has a device name, data, and sequence number. function setNum() is for random number by using Math package. On the mqtt, we can transport only buffer or string message not JSON. So we need to change JSON to string by using 'stringify'. In result, this code send a JSON message per 3 seconds.

In gateway, there is a switch to turn on and off the subscribe. The 'count' is a switch to turn on and off subscribe per 3 seconds. When gateway get a JSON message, it checks a sequence number with count so that gateway know this data is right one or not. And then publish a JSON message after changing JSON to string. The code is followed:

This below picture shows that the network structure between end devices and gateway.

End devices sends a JSON message to gateway and gateway check weather this data is right or wrong one. Gateway gathers all JSON message and send to server(Will make it soon). It was hard to syncronize time between end device and gateway and this code is not perfect yet. I will make it up percectly as possible as I can. Thanks..

Older Posts

Yeop's IoT world

프로필

블로그 보관함

connecting mysql, mobius, thyme, and Tas

Zigbee networking among arduinoes

Zigbee networking

Communication among devices in JSON message through MQTT

devices

Gateway

server

sending JSON file through MQTT protocol in node.js

Popular Posts

ads

recent posts