Password Protected Google Spreadsheet

Password Protected Google Spreadsheet

The best solution to this problem would be to have Google Drive ask for a password each time you open a document. Unfortunately, Google doesn't provide such a protection feature in-built. But you can achieve the same using the password protected Google Spreadsheet which uses Google Scripts. Here's how to use it.

1. Open and make a copy of ProtectedSheet Google spreadsheet. You can rename it to any name you want.
2. Next select "Tools->Script Editor". This will bring up a script in a new window or tab.
3. In this window, select "File->Manage Versions" and click on "Save a new version". You can leave all fields blank. A new row for version 1 will appear. Just click "OK" button.
4. Now select "Publish->Deploy as webapp" and click on the "Deploy" button.
5. You will now be shown a confirmation that you app has been deployed as a web app.

1. Now close this window and come back to the spreadsheet tab or window. You will find a new menu item "Protect File" in the spreadsheet. Select "Protect File->Initialize" and provide required permissions.
   
   All the above steps are one time only. You have now fully setup your password protected document.
2. Now you can add what ever you want to store securely into the document. Just make sure you leave the first two colored rows intact.
3. To secure the document, select "Protect File -> Encrypt File". You will be asked to enter a password. Once done, this will scramble the content each cell in the document. Now your data is fully password protected and nobody can read it without having the password you have set.
   NOTE: This password is not your Google account password, but any password you can choose. The first time you run "encrypt", you will be asked to set a password which will be used for all further encrypt/decrypt requests. 
4. When ever you want to decrypt your document, open it and select "Protect File -> Decrypt File". You will be again asked for the password giving which it will decrypt and bring back the cell contents which you can read or edit.

This works well if you are opening the spreadsheet in a PC. But if you are opening it from a phone, Google always loads the phone version and you won't get the "Protect File" menu. To encode/decode your spreadsheet from a phone, click on the encrypt/decrypt URL which will be present in the first row. This URL gets created and added once you deploy the web app in step 4 above.





References:

1. http://www.skipser.com/p/2/p/password-protect-google-drive-document.html

Software Installation in Ubuntu

-

Java Environment Set Up:

Firstly check, java is installed or not. For checking using bellow command:

→ “java –version”

Then go to following step:

Using Oracle Java 7 is not formally supported by Ubuntu. There's plenty solutions for installing it, listed on https://help.ubuntu.com/community/Java .

The simplest one listed is this one:

        sudo add-apt-repository ppa:webupd8team/java
        sudo apt-get update
        sudo apt-get install oracle-java7-installer

It'll keep your java 7 installation up to date.
To automatically set up the Java 7 environment variables JAVA_HOME and PATH:

        sudo apt-get install oracle-java7-set-default

Reference:

1. http://stackoverflow.com/questions/16263556/installing-java-7-on-ubuntu

Android Studio Set Up:

Firstly, you have to set up java environment. Firstly check, java is installed or not. For checking using bellow command:

→ “java –version”

If java environment is not ready in pc then you can see java environment set up command:

then follow the following commands:

1. Download Android Studio from here, use All Android Studio Packages
   
2. Extract the archive file into an appropriate location for your applications, eg: /opt. Use the filename of your downloaded archive, in my example android-studio-ide-141.2178183-linux.zip
   

   sudo unzip android-studio-ide-141.2178183-linux.zip -d /opt

3. To launch Android Studio, navigate to the /opt/android-studio/bin directory in a terminal and execute ./studio.sh. Or use a desktop file, see below.
   You may want to add /opt/android-studio/bin to your PATH environmental variable so that you can start Android Studio from any directory.
   

Create short cut of Android Studio:

• Run the android studio
• go to Tool option in android studio.
• Then you get create desktop entry option and clicked
• tick the check box and click the ok button
• finally restart the pc.

Reference:

2. http://askubuntu.com/questions/634082/how-to-install-android-studio-on-ubuntu
3. http://stackoverflow.com/questions/16263556/installing-java-7-on-ubuntu

IpTux Instrallation:

just click on the “available on the software center”. And just follow the next instruction.

Reference:

1. https://apps.ubuntu.com/cat/applications/precise/iptux/

freeRDP (Remort Desktop Protocol)

FreeRDP:

FreeRDP - a Linux cmd line tool that supports RemoteApp & RemoteFX protocols. You can visit this freeRDP Websit(http://www.freerdp.com/).

WinConn:

WinConn - a GUI front-end to FreeRDP.

There was recently released an open source GUI application that makes running RemoteApps via FreeRDP almost too simple.

This application is called WinConn.

WinConn simplifies creation, management and desktop integration of remote windows applications in Ubuntu.  WinConn uses RemoteApp technology, implemented by the FreeRDP Project to provide a seamless user experience with Windows Applications on your Ubuntu system.

Each RemoteApp application runs in its own “window” on your Ubuntu Desktop.

This means the RemoteApp application can be used like any other locally installed Ubuntu application, without bringing the full windows desktop to the user.

You can download WinConn from the website:     http://stanev.org/winconn/

RemoteApp?

RemoteApp enables you to make programs that are accessed remotely through Remote Desktop Services appear as if they are running on the end user's local computer. These programs are referred to as RemoteApp programs.

RemoteFX:

Microsoft RemoteFX is a Microsoft brand name that covers a set of technologies that enhance visual experience of the Microsoft-developed remote display protocol Remote Desktop Protocol (RDP).[1] RemoteFX was first introduced in Windows Server 2008 R2 SP1.

Important YouTube Link:

1. https://www.youtube.com/watch?v=lMue5lPht_A
2. https://www.youtube.com/watch?v=zmNWxOltGzk
3. https://vimeo.com/44984895
4. https://bmullan.wordpress.com/2012/09/17/howto-integrate-windows-apps-into-the-ubuntu-linux-desktop-using-windows-remoteapp/

References:

1. http://appguppy.blogspot.com/2012/01/how-to-setup-freerdp-from-linux-ubuntu.html
2. http://android-amit.blogspot.in/2015/01/compiling-freerdp-project-for-android.html
3. http://www.ilwc.nl/?p=255
4. https://github.com/FreeRDP/FreeRDP/wiki/Compilation
5. https://bmullan.wordpress.com/2012/09/17/howto-integrate-windows-apps-into-the-ubuntu-linux-desktop-using-windows-remoteapp/
6. https://en.wikipedia.org/wiki/RemoteFX
7. http://stanev.org/winconn/
8. https://technet.microsoft.com/en-us/library/cc755055.aspx?tduid=(2d3769c246c0940c326f6e6b843a4a5b)(256380)(2459594)(TnL5HPStwNw-mXJ42PexGTGSTKSmdL8oEw)()

Why use port number after URL?

Port Number:
In computer networking, port numbers are part of the addressing information used to identify the senders and receivers of messages. 

Port numbers are associated with TCP/IP network connections. They allow different applications on the same computer to share network resources simultaneously.

As computers and internet became popular and offered many services, it became necessary to identify each service uniquely, and hence in computer networks the term port was introduced.

The port number is a 16 bit binary number in the TCP. Therefore the port number is in the range of 0-65535.The port numbers are divided into three ranges.

• Well Known ports.
• Registered Ports.
• Dynamic Ports/Ephemeral ports

Well known Ports

The port numbers ranging from 0-1023.They are assigned to standard server processes such as FTP, Telnet. most of the popular services are under these range only such as 21 for FTP,80 for HTTP,443 for HTTPS, 23 for TELNET and 22 for SSH.

Registered Ports:

The ports ranging from 1024 - 49151 are to be registered with IANA to prevent duplicating. They can be used for proprietary server processors or nay client process. Registered ports; meaning they can be registered to specific protocols by software corporations.

Dynamic Ports:

49152 to 65536 - Dynamic or private ports; meaning that they can be used by just about anybody.

How to Find an IP Address and Port Number

• Type “ipconfig” and press “Enter.” Your IP address should be listed
• Type “netstat -a” and press “Enter.” A list of all your active TCP/IP connections will populate. The port numbers appear after the IP address with a colon separating the two. For example, if your IP address is 192.168.1.1 and you see an entry for 192.168.1.1:2869, it means port 2869 is open. If you see port numbers listed after “0.0.0.0,” it means that all network adapters on your computer have the listed ports open and in the state indicated in the “State” column on the right. Port numbers listed after “127.0.0.1” are open on your computer’s loopback address only. The loopback address is a virtual network interface mainly used for connectivity testing purposes. 
  
  
  
  
  
  
  
  

  References:

  
  

  1. https://www.quora.com/What-is-port-number-and-port-address
  2. https://www.lifewire.com/port-numbers-on-computer-networks-817939
  3. http://www.ipaddressfinder.info/whatisportnumber.html
  4. http://smallbusiness.chron.com/ip-address-port-number-55788.html
  5. http://www.webopedia.com/quick_ref/portnumbers.asp
  6. https://www.techopedia.com/definition/15702/port-number