Mayur Patel

Sunday, May 25, 2025

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.

Friday, May 23, 2025

How to install Asterisk on Ubuntu 16.04

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

sudo apt-get update
sudo apt-get upgrade

Install all required packages and dependencies :-

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

Download Asterisk :-

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

Compile Asterisk :-

cd /usr/src/asterisk-13.23.1

 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 :-

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 :-

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:-

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 :-

```
  sudo make samples
```

Install the initialization script :-

```
  sudo make config
```

You can also install the logrotation script :-

```
  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 :-

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"

Tuesday, May 13, 2025

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:

Sunday, January 14, 2024

Can not mount Windows 11 partition in Ubuntu Linux

Note:- It happens when you are using Windows and Linux dual booting environment.

Firstly check that you have not hibernate your Windows 11. if you are hibernating your windows then your drive will not mount on Linux, because its encrypted.

Then check BitLocker is not enabled on your Windows System, If its enabled then your drive partition is encrypted so you have to disable your BitLocker in your Windows System.