Install open jdk 7 java in Ubuntu 14

Follow instructions from below links

open jdk 7 installation	sudo apt-get install openjdk-7-jdk	http://askubuntu.com/questions/141073/installation-of-openjdk-7
	(the above command installs jdk and jre)	http://openjdk.java.net/install/

:-)

Connect to mySQL using tunnel in PuTTY

Hi guys..
The below posts gives you how to connect mySQL server using tunnel in PuTTY.

References
1) https://support.krystal.co.uk/entries/23275362-Connect-to-a-MySQL-database-using-an-SSH-Tunnel

2) https://library.linode.com/databases/mysql/mysql-ssh-tunnel

Sadakar
BI developer

Find tomcat version installed in linux using PUTTY

Some times we need to know what's the version of installed tomcat in linux machine.

Simply go to the tomcat's bin folder and type this command  sh version.sh

Sadakar
BI developer

Putty commands... Tips

1) To find os

 cat /etc/*-release

2) Write Permission

sudo chmod +W /home/Sadakar

(sudo=superuser)

3) Read Permission

sudo chmod +X /home/Sadakar

4) PSFTP- file transfer command.

syntax:

psftp>put source destination

where

source=your local file location

destination=server location to store(copy the file)

Ex:

psftp> put d:\Softwares\BI\Pentaho\test.txt /home/Sadakar/test.txt

6) Yum command
Usage: It is a default package manager
Yum= Yellowdog Updater Modifier
Examples: 
1) yum search java|grep 'java-'
2) yum install java-1.7.0-openjdk.x86_64

http://www.thegeekstuff.com/2011/08/yum-command-examples/

7)  removing direcorty
http://www.thegeekstuff.com/2009/06/how-to-linux-delete-directory-using-rmdir-rm-command/

8) sudo su
sudo - superuser do
su= switch user
http://kb.iu.edu/data/amyi.html
http://aplawrence.com/Basics/sudo.html


9) down load 

  postgreSQL driver 
 wget jdbc.postgresql.org/download/postgresql-9.2-1003.jdbc4.jar

 pentaho bi server 4.8 using putty
 wget http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/4.8.0-stable/biserver-manual-ce-4.8.0-stable.zip



10) Setting JAVA_PATH

export JAVA_HOME=/home/clinet/jasperreports-server-cp-5.2.0/java
export PATH=$PATH:$JAVA_HOME/bin
[sadakar@ip-12-34-567-890 as400Files]$ cd /etc/
[sadakar@ip-12-34-567-890 etc]$ vi bashrc


ps -ef
ps program (short for "process status") displays the currently-running process
ps commonly runs with the options -ef, where "-e" selects every process and "-f" chooses the "full" output format. Another common option on these systems is -l, which specifies the "long" output format.

1.ps -ef| grep tomcat           To find which port is running 2 kill -9 2061                      To  kill a process 3  Execute postgreSQL  script from command prompt . C:\Program Files\jasperreports-server-cp-4.7\postgresql\bin>psql.exe -U postgres -p 5434 -d mabuhay63 -a -f C:\Helical\Create_table_f5540m31all.sql

http://www.cyberciti.biz/faq/copy-folder-linux-command-line/

Example :

cp -avr /home/vivek/letters /usb/backup

• -a : Preserve the specified attributes such as directory an file mode, ownership, timestamps, if possible additional attributes: context, links, xattr, all.

• -v : Explain what is being done.

• -r : Copy directories recursively.

How do I quit the vi editor without saving my changes?
To quit the vi editor without saving any changes you've made:

1. If you are currently in insert or append mode, press Esc.
   

1. Press  :  (colon). The cursor should reappear at the lower left corner of the screen beside a colon prompt.
   

1. Enter the following: q! This will quit the editor, and all changes you have made to the document will be lost. 

 Connecting to mySQL from PUYYT command
Syntax: mysql -uUsernName -h HostNumber -pPassword
Example
mysql -udbm -h186.202.132.106 -pa7cq1kSolLZ