Saturday, February 22, 2014

The following table lists Microsoft Office features and their LibreOffice equivalents.


    Microsoft Office XP   =>  LibreOffice
  • AutoShapes  =>  Gallery Objects
  • Change Case  =>  Case/Characters
  • Click and Type  =>  Direct Cursor
  • Compare and Merge Documents  =>  Compare
  • Document Map  =>  Navigator
  • Formula Auditing  =>  Detective
  • Lines and Page Breaks  =>  Text Flow
  • Page setup  =>  Format - Page
  • Mail Merge  =>  Form Letter
  • Markup  =>  Changes - Show
  • Refresh Data (in Excel)  =>  Refresh Range
  • Replace text as you type  =>  AutoCorrect
  • Show/Hide  =>  Nonprinting Characters, Hidden Paragraphs
  • Spelling and Grammar  =>  Spellcheck
  • Track changes  =>  Changes - Record
  • Validation  =>  Validity
  • Workbook  =>  Spreadsheet
  • Worksheet  =>  Sheet
  • Shared Workbooks  =>  Collaboration

Friday, January 17, 2014

Passwordless SSH tuthorization on Linux


  • Delete all files from => rm -rf  root/.ssh/ *
  • Generate Key => ssh-keygen -t rsa -N “”
  • Cope script on Second Server => scp root@192.168.1.3:/root/
  • cd /root/.ssh
  • cat /root/id_rsa.pub > authorized_keys 

Install LAMP on Ubuntu Server


  • sudo apt-get update
  • sudo apt-get install openssh-server
  • sudo apt-get install apache2
  • sudo apt-get install php5
  • sudo apt-get install mysql-server
  • sudo apt-get install libapache2-mod-php5
  • sudo apt-get install php5-mysql
  • sudo apt-get install mysql-client
  • sudo apt-get install php5-curl
  • sudo apt-get install php5-gd
  • sudo apt-get install php5-idn
  • sudo apt-get install php5-imagick
  • sudo apt-get install php5-imap
  • sudo apt-get install php5-mcrypt
  • sudo apt-get install php5-memcache
  • sudo apt-get install php5-mhash
  • sudo apt-get install php5-ming
  • sudo apt-get install php5-ps
  • sudo apt-get install php5-pspell
  • sudo apt-get install php5-recode
  • sudo apt-get install php5-snmp
  • sudo apt-get install php5-sqlite
  • sudo apt-get install php5-tidy
  • sudo apt-get install php5-xmlrpc
  • sudo apt-get install php5-xsl
  • sudo apt-get install php5-json
  • sudo apt-get install php5-cli
  • sudo apt-get install php-pear
  • sudo apt-get install php-apc
  • sudo apt-get install phpmyadmin
  • sudo apt-get install curl
  • sudo apt-get install sendmail
  • sudo apt-get install ethtool
  • sudo apt-get install nfs-kernel-server
  • sudo apt-get install nfs-common
  • sudo apt-get install portmap
  • sudo apt-get install perl
  • sudo apt-get install libnet-ssleay-perl
  • sudo apt-get install openssl
  • sudo apt-get install libauthen-pam-perl
  • sudo apt-get install libpam-runtime
  • sudo apt-get install libio-pty-perl
  • sudo apt-get install htop

Thursday, December 26, 2013

Update Java 1.6 to 1.7 in Ubuntu

Open Terminal and run the following commands;-



  • sudo apt-get install python-software-properties
  • sudo apt-add-repository ppa:openjdk/ppa
  • sudo apt-get update
  • sudo apt-get install openjdk-7-jdk
  • sudo update-alternatives --config java (Type the Version number and press Enter)
  • sudo java -version



Wednesday, September 11, 2013

Ubuntu 4GB Ram Limitation and Solution


Q. I've total 8 GB RAM installed in my dual boot Ubuntu Linux 8.10 (32 bit) version HP workstation. But free -m command only shows 3291 (3G) memory. How do I use 8GB RAM under Ubuntu Linux?

A. You need to install Physical Address Extension (PAE) aware kernel under 32 bit Ubuntu Linux. It is a feature of x86 and x86-64 processors that allows more than 4 Gigabytes of physical memory to be used in 32-bit systems.
Without PAE kernel, you should see something as follows:

Check your present Memory
$ free -m
Sample output:
           total       used       free     shared    buffers     cached
Mem:          3291        801       2489          0         95        342
-/+ buffers/cache:        363       2927
Swap:         1906          0       1906

Install PAE enabled kernel

Open terminal and type the following command if you are using Ubuntu version Ubuntu v9.04 and earlier:

$ sudo apt-get update

$ sudo sudo apt-get install linux-headers-server linux-image-server linux-server


If you are using Ubuntu v9.10 (Karmic Koala) and above, enter:

$ sudo apt-get install linux-generic-pae linux-headers-generic-pae

Once kernel images installed, just reboot your workstation, type:
$ sudo reboot
After reboot, login into your system and type the following command to verify memory usage:
$ free -m
Sample output:
           total       used       free     shared    buffers     cached
Mem:          8105       1292       6812          0         38        483
-/+ buffers/cache:        770       7334
Swap:         1906          0       1906

Tuesday, July 2, 2013

Install JAVA on Ubuntu 9.04


=> cp /etc/apt/sources.list /opt/sources.list.orig

=> Change following settings in /etc/apt/sources.list

deb http://old-releases.ubuntu.com/ubuntu natty main
deb http://old-releases.ubuntu.com/ubuntu natty main restricted universe multiverse
deb http://old-releases.ubuntu.com/ubuntu natty-updates main restricted universe multiverse
deb http://old-releases.ubuntu.com/ubuntu natty-security main restricted universe multiverse

=> apt-get update

=> mv /var/lib/apt/lists /opt/lists.orig

=> mkdir -p /var/lib/apt/lists/partial

=> apt-get update

=> cd /var/cache/apt/archives

=> tar -cvf /opt/archives.tar *.deb

=> apt-get clean

=> apt-get install default-jre --no-install-recommends

NOTE :- In my case packages were just downloaded but not installed. so in such case do as following:-

=> cd /var/cache/apt/archives

=> dpkg -i *.deb

Saturday, June 1, 2013

The Differences Between PPTP, L2TP/IPSec, SSTP and OpenVPN Connection


PPTP

Point-To-Point-Tunneling Protocol (PPTP) is the most popularly VPN protocol and is supported by the most devices. PPTP stands for point to point protocol, is by far the easiest to configure and has low overhead that makes it faster than other VPN protocols. Firewalls such as ISA Server, Cisco PIX and Sonic Wall recognize the protocol.
PPTP encrypts data using a 128-bit key which puts it in the “weakest” category of VPN protocols. It has also had other weaknesses in the past, such as clear-text authentication prior to a connection being established and as such it is rarely used in sensitive business environments. However, the most recent implementations of this protocol have resolved some of the security issues – for example, the implementation of EAP authentication.

L2TP/IPSec

Layer 2 Tunneling Protocol (L2TP) came about through a partnership between Cisco and Microsoft with the intention of providing a more secure VPN protocol. L2TP is considered to be a more secure option than PPTP, as the IPSec protocol which holds more secure encryption algorithms, is utilized in conjunction with it. It also requires a pre-shared certificate or key. L2TP’s strongest level of encryption makes use of 168 bit keys, 3 DES encryption algorithm and requires two levels of authentication.
L2TP has a number of advantages in comparison to PPTP in terms of providing data integrity and authentication of origin verification designed to keep hackers from compromising the system. However, the increased overhead required to manage this elevated security means that it performs at a slower pace than PPTP.

SSTP

Secure Socket Tunneling Protocol (SSTP) is viewed as the VPN protocol with the highest security due to authenticating with 2048 bit key certificates and encrypting with 256 bit key. SSTP can be used in place of other VPN protocols (PPTP, L2TP), and is effective in locations where network access is restricted as it uses TCP port 443, the same port used by Secure Socket Layer (SSL) transmissions.
SSTP VPN is viewed as quicker and more reliable than OpenVPN. However, your operating system needs to be relatively up to date in order for it to function properly with SSTP.
The major disadvantage of SSTP is that since it was developed by Microsoft it only functions on Windows Vista / Windows 7 / Windows 8. Currently, there are no intentions to make the protocol available to users of Mac OS, Linux and older versions of Windows.

OpenVPN

OpenVPN was developed by Open Source software as a free alternative to Microsoft’s SSTP protocol. One major advantage of this particular protocol is that it functions on a variety of operating systems, such as, Mac OS, Windows, Linux and some IP phones. Similar to SSTP, OpenVPN has a higher encryption level than L2TP as it operates on both Layer 2 and Layer 3. Furthermore, it is accompanied with extra features such as transporting Ethernet frames, IPX packets and providing NETBIOS functionality.
A minor disadvantage with OpenVPN is that it provides insufficient support for mobile devices and the requirement to install a 3rd party client. This is not the case for SSTP.
A major disadvantage with VPN is the high overhead associated with the protocol due to its level of encryption. It may also be quite challenging to configure.