Saturday, February 22, 2020

How to install Cisco VPN client on Window 10

From 2011 it's have been discontinued, Cisco VPN client is not supported by Windows 10. Cisco itself has stated in the past that the last supported operating system for its VPN client was Windows 7.

Download and install below setups.

First Install DNE update from below location





After DNE setup installation completed, 
Install Cisco VPN client

Follow the next steps by default no other changes require.

Extract the setup  and run as administrator vpnclient_setup and proceed the next steps and finish the setup.

Once installation done. Start the Cisco VPN application and add pcf profiles using imported button.

After all this, connect the profile that just added, it will prompt for user and password. Enter your credentials.





Follow the below steps: -
Open your Windows Registry Editor by typing regedit in the Window run.
From the window on right, select and right -click on Display Name and choose Modify from the menu. Alternatively, Double-click on Display Name.




Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\CVirtA
For Windows 10 64bit (x64) operating systems, change the value data from @oem8.inf,%CVirtA_Desc%;Cisco Systems VPN Adapter for 64-bit Windows
to
Cisco Systems VPN Adapter for 64-bit Windows       (shown below):


The registry key now shows the correct DisplayName value data:




You should be able to connect to your VPN Router or Gateway without any problems.

Friday, August 30, 2019

Check SQL Server system Date and Time


Using below commands you can check SQL server date and time.

Open query browser and type the following commands. And when you execute it output will come out.

Command : 1

Select CURRENT_TIMESTAMP;


Command : 2

Select SYSDATETIME();



In below Results column its show the current Date and Time.


Current TIME in Various Formats
Below are the examples of current TIME in various formats:

  1. Current TIME in the 24-hour format hh:mi:ss

SELECT CONVERT(VARCHAR(8), GETDATE(), 108) 'hh:mi:ss'


  1. Current TIME in the 24-hour format hh:mi:ss:mmm

SELECT CONVERT(VARCHAR(12),GETDATE(),114) 'hh:mi:ss:mmm'


  1. Current TIME in the 12-hour format hh:mi:ss:mmmAM

SELECT RIGHT(CONVERT(VARCHAR(26), GETDATE(), 109),14)
          'hh:mi:ss:mmmAM (or PM)'


Tuesday, August 27, 2019

Microsoft Excel Keyboard Shortcuts

Now, these days excel shortcuts is necessary for maintain day to day reports. So, we are sharing with you the basic excel shortcuts with you.

General Program Shortcuts

First, let’s take a look at some general keyboard shortcuts for manipulating workbooks

Open Excel using Run

Open Run > Type Excel then enter. It will open excel sheet.



Command's

Descriptions

Alt or F10

Turn key tips on or off

Alt+ F4       

Close Excel

Alt+A

Go to the Data tab

Alt+Enter

Insert a hard return within a cell (while editing a cell)

Alt+F

Open the File tab menu

Alt+F1

Create an embedded bar chart based on select data (same sheet)

Alt+F11

Open the Microsoft Visual Basic For Applications Editor

Alt+F8

Create, run, edit, or delete a macro

Alt+H

Go to the Home tab

Alt+H+B

Add a border

Alt+H+D+C

Delete column

Alt+H+H

Select a fill color

Alt+M

Go to the Formulas tab

Alt+N

Open the Insert tab

Alt+P

Go to the Page Layout tab

Alt+Page Up/Down

Move one screen to the right or left in a worksheet


Alt+R

Go to the Review tab

Alt+W

Go to the View tab

Alt+X

Go to the Add-ins tab

Alt+Y

Go to the Help tab

Ctrl+0

Hide the selected columns

Ctrl+1

Open the Format Cells dialog box

Ctrl+5

Apply or remove strikethrough

Ctrl+9

Hide the selected rows

Ctrl+Alt+V

Open the Paste Special dialog box

Ctrl+B

Add or remove bold to the contents of a cell, selected data, or selected cell range

Ctrl+C or Ctrl+Insert

Copy contents of a cell, selected data, or selected cell range

Ctrl+End

Go to the most bottom right used cell

Ctrl+F

Search in a spreadsheet, or use Find and Replace

Ctrl+F1

Show or hide the ribbon

Ctrl+F11

Insert a new Excel Macro sheet

Ctrl+F2

Open Print Preview

Ctrl+F4       

Close Excel sheet

Ctrl+F9

Minimize the workbook window

Ctrl+Home

Move to the beginning of a worksheet

Ctrl+I

Add or remove italics to the contents of a cell, selected data, or selected cell range

Ctrl+Left/Right Arrow

Move to the farthest cell left or right in the row

Ctrl+N       

Create a new Excel

Ctrl+O       

Open an older workbook

Ctrl+Page Up/Down

Move to the previous or next worksheet

Ctrl+S       

Save Excel workbook

Ctrl+Shift+$

Apply currency format

Ctrl+Shift+%

Apply percent format

Ctrl+Shift+&

Apply outline border

Ctrl+Shift+_ (Underline)

Remove outline border

Ctrl+Shift+Space

Select the entire worksheet

Ctrl+Shift+U

Expand or collapse the formula bar

Ctrl+Space

Select the entire column

Ctrl+Tab

Switch between open workbooks

Ctrl+U

Add or remove underline to the contents of a cell, selected data, or selected cell range

Ctrl+Up/Down Arrow

Move to the top or bottom cell in the column

Ctrl+V or Shift+Insert

Paste contents of a cell, selected data, or selected cell range

Ctrl+W       

Close a Excel sheet

Ctrl+X

Cut contents of a cell, selected data, or selected cell range

Ctrl+Y

Redo an action

Ctrl+Z

Undo an action

Delete

Remove the contents of a cell, selected data, or selected cell range

Enter

Complete an entry in a cell or the formula bar

Esc

Cancel an entry in a cell or the formula bar

F1

Open the Help page

F11

Create a bar chart based on selected data (on a separate sheet)

F12       

Open the Save As dialog box

F2

Edit a cell

F3

Paste a cell name (if cells are named in the worksheet)

F5

Go to any cell by pressing F5 and typing the cell coordinate or cell name.

F7

Check spelling

F9

Calculate all worksheets in all Open workbooks

Home

Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)

Left/Right Arrow

Move one cell to the left or right

Page Up/Down

Move one screen up or down in a worksheet

Shift+F11

Insert a new Excel worksheet in existing Excel

Shift+F2

Add or edit a cell comment

Shift+F3

Insert a function

Shift+F9

Calculate active worksheets

Shift+Left/Right Arrow

Extend the cell selection to the left or right

Shift+Space

Select the entire row

Shift+Tab

Go to the previous cell

Tab

Go to the next cell

Up/Down Arrow

Move one cell up or down


Practice more make you learn quickly.

Tuesday, July 23, 2019

Install Bugzilla on Linux 7

    Bugzilla is a free and open source web-based bug tracker and testing software tool developed by the Mozilla Foundation. It is written in Perl, and uses MySQL as its database back-end. Key features of Bugzilla are listed below:

    1. Email integration capability.
    2. Optimized, well-structured and secure system.
    3. Easily remember your searches using advanced query tool.
    4. Easily edit user profiles.
    5. Comprehensive permission based system.

    # sudo yum update -y



    Install LAMP

    Let us install the Apache web server, MariaDB, and other required packages on the system.

    You can install all of them by running the following command:

    # sudo yum install httpd mariadb mariadb-server httpd-devel mod_ssl mod_ssl mod_perl mod_perl-devel mariadb-devel php-mysql gcc gcc-c++ graphviz graphviz-devel patchutils gd gd-devel wget perl* -y

    Once all the packages are installed including their dependencies, start the Apache and MariaDB services and enable them to start on boot with the following commands:

    # sudo systemctl start httpd

    # sudo systemctl start mariadb

    # sudo systemctl enable httpd

    # sudo systemctl enable mariadb

    Configure MariaDB Database

    Our MariaDB installation needs to be secured. To do so, run the mysql_secure_installation script:

    # sudo mysql_secure_installation

    # mysql -u root –p

    Enter the root password when asked, then create a new database for Bugzilla:

    MariaDB [(none)]> CREATE DATABASE bugzilla;

    Create a database user and password for Bugzilla:

    MariaDB [(none)]>CREATE USER bugs@'localhost' IDENTIFIED BY 'Password';

    MariaDB [(none)]>GRANT ALL PRIVILEGES ON bugzilla.* TO 'bugs'@'localhost' IDENTIFIED BY 'Password' WITH GRANT OPTION;

    MariaDB [(none)]>FLUSH PRIVILEGES;

    MariaDB [(none)]>exit;

    Make a soft where we download or copy the setup

    # mkdir dir

    Give permission to the folder

    # chmod 777 dir/

    # cd /dir/

    Once you are done, you can proceed to install Bugzilla.

    Install Bugzilla

    You can download the latest version of the Bugzilla with the wget command:

    # wget http://ftp.mozilla.org/pub/webtools/bugzilla-5.0.tar.gz

    Once the download is complete, extract the downloaded archive with the tar command:

    # tar -xvzf bugzilla-5.0.tar.gz

    Move the extracted directory into the Apache web root directory:

    # sudo mv bugzilla-5.0 /var/www/html/Bugzilla

    Set proper permissions on the bugzilla directory:

    # sudo chown -R apache:apache /var/www/html/Bugzilla

    You will also need to install all necessary Perl modules in your system.

    Change into the bugzilla directory:

    # cd /var/www/html/bugzilla/

    Install all the required Perl modules with the following command:

    # sudo /usr/bin/perl install-module.pl –all

    Now, Run

    ./checksetup.pl

    Prompt to edit

    Please edit the file ./localconfig and then re-run checksetup.pl

    you will need to edit localconfig file:

    # vi /var/www/html/Bugzilla/localconfig

    Change the file as shown below:

    $db_host = 'localhost';

    $db_name = 'bugzilla';

    $db_user = 'bugs';

    $db_pass = 'Password';

    Save and close the file when you are finished.

    Run the checksetup.pl perl script to install Bugzilla:

    # sudo ./checksetup.pl

    “Enter the e-mail address of the administrator: email ID

    Enter the real name of the administrator: name

    Enter a password for the administrator account:

    Please retype the password to verify:

    email ID is now set up as an administrator.

    Creating initial dummy product 'TestProduct'...

    Now that you have installed Bugzilla, you should visit the 'Parameters'

    page (linked in the footer of the Administrator account) to ensure it

    is set up as you wish - this includes setting the 'urlbase' option to

    the correct URL.

    checksetup.pl complete.“

    Comment out a line in the .htaccess file that the Bugzilla installation script created:

    # sudo sed -i 's/^Options -Indexes$/#Options -Indexes/g' ./.htaccess

    Configure Apache for Bugzilla

    Let's create a new virtualhost directive for Bugzilla. You can do this by creating the file /etc/httpd/conf.d/bugzilla.conf:

    # vi /etc/httpd/conf.d/bugzilla.conf

    Add the following lines:

    <VirtualHost *:80>

    DocumentRoot /var/www/html/bugzilla/

    </VirtualHost>

    <Directory /var/www/html/bugzilla>

    AddHandler cgi-script .cgi

    Options +Indexes +ExecCGI

    DirectoryIndex index.cgi

    AllowOverride Limit FileInfo Indexes

    </Directory>

    Save the file and restart Apache's httpd service for the changes to take effect:

    # sudo systemctl restart httpd

    Disable and stop Firewall

    # systemctl disable firewalld.service

    # systemctl stop firewalld.service

    Disable selinux

    # vi /etc/syscofig/selinux

    Access Bugzilla

    Once everything is setup properly, it is time to access Bugzilla.

    Open your favourite web browser and type the URL http://localhost, you should see the Bugzilla welcome page as below:

    Click on the Log In button and provide your username and password. You should see the Bugzilla Main page as below:

Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is ...