How to install Python in Ubuntu

• Open the Linux terminal and execute the following command
  
  => sudo apt update

•  Update the available packages
  
  => sudo apt upgrade

• Paste the following command in terminal and execute
  
  => sudo apt install python[version number]

• The following command will be used to start accessing the Repository of the Python Module
  
  => sudo apt install software-properties-common

• Download the Python Package
  
  => sudo add-apt-repository ppa:deadsnakes/ppa

• Install Python
  
  => sudo apt install python[version number]

• Install Python on Ubuntu using the source link

• Browse to official Python Page and copy the  Gzipped source tarball  link foe any version

• Paste link in terminal as following
  
  => sudo wget <Copied Link>

• Extract the downloaded file
  
  => tar -xf <TGZ File Name>.tgz

• Configure Python file
  
  => ./configure --enable-optimizations

• Install Python
  
  => sudo make install

How to remove Protection from Excel 2011

•  Make sure a copy of your excel file before doing any changes
• Right click and rename your excel file to example.xlsx to example.xlsx.zip

• Double click on zip file and go to xl 

• Copy the worksheet folder from zip to another path ( like on your Desktop or Document)

• Then go to the worksheet folder

• Right click and open the sheet file in note pad

• Press ctrl + F and type protect then find it.
• Remove the following script from sheet file.
• Make sure it will be under <to>.

• Do the changes in all your sheet files.
• Then replace the worksheet folder in your zip file.

• Now rename your file .zip to .xlsx
• Open your excel file and check that your protection is removed.

How to install Asterisk on Ubuntu 16.04

• Make sure your server is up-to-date :-

1.   sudo apt-get update
2.   sudo apt-get upgrade

• Install all required packages and dependencies :-

1.   sudo apt-get install build-essential
2.   apt-get install git-core subversion libjansson-dev sqlite autoconf automake libxml2-dev libncurses5-dev libtool

• Download Asterisk :-

1.   cd /usr/src/
2.   sudo wget http://downloads.asterisk.org/pub/telephony/asterisk/asterisk-13-current.tar.gz
3.   sudo tar -zxvf asterisk-13-current.tar.gz

• Compile Asterisk :-

1.   cd /usr/src/asterisk-13.23.1

2.  sudo ./contrib/scripts/install_prereq install

• Once it is completed the output will look like this :-

      Current status: 7 (-2) upgradable.
      #############################################
      ## install completed successfully
      #############################################

• Run the ./configure script which will check your system for missing libraries and dependencies :-

1.   sudo ./configure 

• The output of the successful completion should look like this :-

      configure: Menuselect build configuration successfully completed
      
                     .$$$$$$$$$$$$$$$=..
                  .$7$7..          .7$$7:.
                .$$:.                 ,$7.7
              .$7.     7$$$$           .$$77
           ..$$.       $$$$$            .$$$7
          ..7$   .?.   $$$$$   .?.       7$$$.
         $.$.   .$$$7. $$$$7 .7$$$.      .$$$.
       .777.   .$$$$$$77$$$77$$$$$7.      $$$,
       $$$~      .7$$$$$$$$$$$$$7.       .$$$.
      .$$7          .7$$$$$$$7:          ?$$$.
      $$$          ?7$$$$$$$$$$I        .$$$7
      $$$       .7$$$$$$$$$$$$$$$$      :$$$.
      $$$       $$$$$$7$$$$$$$$$$$$    .$$$.
      $$$        $$$   7$$$7  .$$$    .$$$.
      $$$$             $$$$7         .$$$.
      7$$$7            7$$$$        7$$$
       $$$$$                        $$$
        $$$$7.                       $$  (TM)
         $$$$$$$.           .7$$$$$$  $$
           $$$$$$$$$$$$7$$$$$$$$$.$$$$$$
             $$$$$$$$$$$$$$$$.

     configure: Package configured for:
     configure: OS type  : linux-gnu
     configure: Host CPU : x86_64
     configure: build-cpu:vendor:os: x86_64 : pc : linux-gnu :
     configure: host-cpu:vendor:os: x86_64 : pc : linux-gnu :

• start the compilation process using the make command :-

1.  sudo make

• Once its completed you will see the following message which means that the Asterisk was successfully compiled :-
  

      +--------- Asterisk Build Complete ---------+
      + Asterisk has successfully been built, and +
      + can be installed by running:              +
      +                                           +
      +                make install               +
      +-------------------------------------------+

• Run the make install:-

1.   sudo make install

• After the successfully Asterisk installation you will see the following message :-

       +---- Asterisk Installation Complete -------+
       +                                           +
       +    YOU MUST READ THE SECURITY DOCUMENT    +
       +                                           +
       + Asterisk has successfully been installed. +
       + If you would like to install the sample   +
       + configuration files (overwriting any      +
       + existing config files), run:              +
       +                                           +
       + For generic reference documentation:      +
       +    make samples                           +
       +                                           +
       + For a sample basic PBX:                   +
       +    make basic-pbx                         +
       +                                           +
       +                                           +
       +-----------------  or ---------------------+
       +                                           +
       + You can go ahead and install the asterisk +
       + program documentation now or later run:   +
       +                                           +
       +               make progdocs               +
       +                                           +
       + **Note** This requires that you have      +
       + doxygen installed on your local system    +
       +-------------------------------------------+

• After that install the Asterisk sample configuration files :-

1.   sudo make samples

• Install the initialization script :-

1.   sudo make config

• You can also install the logrotation script :-

1.   sudo make install-logrotate
   

• You will see the following output indicating :-

      ● asterisk.service - LSB: Asterisk PBX
         Loaded: loaded (/etc/init.d/asterisk; bad; vendor preset: enabled)
         Active: active (running) since Wed 2018-07-18 03:36:23 CDT; 5s ago
           Docs: man:systemd-sysv-generator(8)
        Process: 15427 ExecStart=/etc/init.d/asterisk start (code=exited, status=0/SUCCESS)
         CGroup: /system.slice/asterisk.service
                └─15440 /usr/sbin/asterisk

• Enable the asterisk service :-

1.    systemctl enable asterisk

• 
  

How to Install Asteisk GUI in Ubuntu

• Go to your installation directory :- 

      ==>  cd /usr/src

• Download the latest version of Asterisk-GUI :-   

      ==>  sudo svn checkout http://svn.digium.com/svn/asterisk-gui/trunk asterisk-gui

•  Enter in Asterisk-GUI folder :- 

      ==>  cd asterisk-gui/

•  Then you need to configure :-

      ==>  sudo ./configure

• Then you need to compile the sources :-

      ==>  sudo make

• Then distribute the compiled code :-

      ==>  sudo make install

• Back up your configuration files before you continue :-

      ==>  sudo cp -r /etc/asterisk /etc/asterisk.backup

• Edit manager.conf in /etc/asterisk :-

      ==>  sudo nano /etc/asterisk/manager.conf

• Do the following settings :-

     ==>  [general]
              enabled - yes
              webenabled =yes

• For add new user add the this in manager.conf

     ==>  [admin]
              secret = admin123
              read = system,call,log,verbose,command,agent,user,config
              write = system,call,log,verbose,command,agent,user,config

• Now edit http.conf  from /etc/asterisk :-

     ==>  sudo nano /etc/asterisk/http.conf

• Do the following settings :-

     ==>  enabled=yes
               enablestatic=yes
               bindaddr=0.0.0.0

• After that :-

     ==> sudo make checkconfig

• For running Asterisk-GUI Enter :-

     ==>  sudo reload

• Add user and group and create a link :-

     ==> sudo adduser asterisk

     ==> cd /usr/share

     ==> sudo mkdir asterisk

     ==> sudo ln -s /var/lib/asterisk/static-http /usr/share/asterisk/static-http

     ==> sudo chown -R asterisk:asterisk /etc/asterisk/ /var/lib/asterisk /usr/share/asterisk

• You can use the asterisk-gui from these addresses :-

     ==>  http://127.0.0.1:8088/static/config/index.html
     ==> http://127.0.0.1:8088/asterisk/static/config/cfgbasic.html

     ==>  http://127.0.0.1:8088/asterisk/static/config/cfgadvanced.html

• For troubleshooting :-

     ==>  http://127.0.0.1:8088/asterisk/static/config/cfgbasic.html

     ==>  chown -R asterisk:asterisk /etc/asterisk/ /var/lib/asterisk /usr/share/asterisk # if asterisk runs as the user "asterisk"

Excel 2003 Protection

 Press ALT +  F11 or click on View Code in Developers Tabs

In the Above White Space Enter the below Code. Do not change the code just copy paste:

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

Now Click on the Run Button or press F5: