INSTALLATION DOCUMENTS BY RAVI

Sunday, June 10, 2018

Creating tenant account in thingsboard

All dashboards and customers in Thingsboard are tied to a Tenant.
Thingsboard support multiple Tenants.
When we logged in as system administrator, Thingsboard can't know which of the tenants to show, so no dashboards or customers are shown.
The system administrator account is for system administration tasks, not for dashboard or customer tasks.

If we want to manage dashboards or customers, login as the Tenant or Customer you want to manage.

Steps for Creating tenant account in  thingsboard:

Login as admin account















Click on Tenants



















Click on + sign to create new tenant















Provide the details and click on Add















Now click on manage tenant admins


















Click on + sign to create new tenant admin user


















Provide the details and click on add















Copy the link and click on ok















Copy and goto the activation link to activate the created tenant user


















Provide the password for tenant user and click on create password
















Installing Talend Open Studio on windows

Download and stage the software





















Right click on the setup file and run as administrator



























Accept the license agreement













Select Create new project and click on finish






































Monday, May 21, 2018

Steps for calling a python script in another python script

We will see how to call one python script in another python
script with a simple example below

Python script 1:

t1.py

























The above script will print the value of "a"

The output of python script 1:





To use this python script in another python script:

Use import package to import the python script in another script as below

t2.py




















In the above script

import t1: will import the python script in t1.py to t2.py
b = str(t1.a): will initialize the output of t1.py to the variable "b"
print (b): Prints the value of "b"

The output of python script 2:





Displaying the output of both python scripts.




Friday, May 18, 2018

Backup and Restoring or Duplicating the HBase Table

Connect  to HBase shell







Use "list" command to list the tables in the HBase database









We are going to backup the table "test1" now

Checking the description of the table test1









Using "snapshot" command to backup the table





Restoring or duplicating the table using "clone_snapshop" command














Sunday, May 13, 2018

Steps for connecting to Hbase using Python

Note: First we need to start the HBase thrift server

Starting the thrift server:

Open putty and run the below command to start the thrift server


/usr/hdp/current/hbase-master/bin/hbase-daemon.sh start thrift

Go to python prompt as below:







Connecting to HBase:

Run the following below in python prompt

import happybase
connection = happybase.Connection('localhost',9090,autoconnect=False)
connection.open()

Note: For connecting HBase "happybase" module must be present in our python



Printing the list of tables in HBase:

Use the below command to  print the list of tables in HBase

print(connection.tables())





Connecting to the table and printing the rows in the table:






Saturday, May 5, 2018

Installing vnc server on centos 7

Installing Gnome Desktop

Connect to the server as root user in putty

Use yum to install Gnome Desktop package




Enter "y" to install all the dependencies and package
















Wait until the package got installed, it  will take some time

Installing Tiger vnc server

Install vnc server as below using yum



















Start the vnc server













Here  vnc session started with session id "1"

Connecting to the server using vnc viewer

Open the vnc viewer and provide server ip and session id











Click on ok








Provide the password and click on ok




















Enabling archive mode in oracle database

Connect to the database as below










Check whether archive log mode is enabled or not as below






It shows there is no archive log mode

To enable archive log mode, follow the below steps

Shutdown the database





Start the database in mount







Alter the database to archive log mode





Open the database




Check for archive log mode








  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...