Saturday, February 22, 2020
How to install Cisco VPN client on Window 10
Friday, August 30, 2019
Check SQL Server system Date and Time
- Current TIME in the 24-hour format hh:mi:ss
- Current TIME in the 24-hour format hh:mi:ss:mmm
- Current TIME in the 12-hour format hh:mi:ss:mmmAM
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
- Email integration capability.
- Optimized, well-structured and secure system.
- Easily remember your searches using advanced query tool.
- Easily edit user profiles.
- Comprehensive permission based system.
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:
# 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 ...

-
Method 1 : To turn on the option for storing chat history: Open Skype for Business/Lync and sign in. Click Show Menu arrow nex...
-
SD5 monitors target nodes hardware's system health or availability in data centers in real-time and provide alerts to administrators. Su...
-
Prerequisite Make sure that you have Java (JRE) installed on your system Installation Download the Linux binary zip (no JRE) from http://...