Want to Block an IP Address? Here a Solution…

want-to-block-an-ip-address-here-a-solution

You might sometimes need to block a specific IP address from accessing your server for several reasons. Follow the simple instructions below which include creating an IPSec Security Policy specifying to block access to specific IP address –

Step 1 – Hover your mouse to Start Menu and click on Run.

Step 2 – Type “secpol.msc” in the run window and click OK.

Step 3 – The Local Security Settings window will open. Click on “IP Security Policies on Local Computer”.

Step 4 – Go to the right window pane, right-click and select “Create IP Security Policy”.

read more

Posted in FAQs, Web Hosting | Tagged , | Comments Off on Want to Block an IP Address? Here a Solution…

Secure Your Database Server in 10 Simple Ways

secure-your-database-server-in-10-simple-ways

It may be the health records or your credit card details; everything is stored in the form of database today. Database is similar to a goldmine for hackers. The main purpose behind any cyber-attack is simply getting an access to a database server.

This indicates that the security of the database servers needs to be strengthened and that completely depends on network security, operating system hardening and physical security. It continues to be a big list but it’s important to learn how to secure your database server first –

read more

Posted in Web Hosting | Tagged , | Comments Off on Secure Your Database Server in 10 Simple Ways

Installing and Uninstalling Easy Apache4 with Simple Commands

EasyApache4

EasyApache 4 Migration can be used in cPanel or WHM version 58 or higher.

Pre-requisites –

Operating Systems –

EasyApache 4 supports the below operating systems –

  • CentOS 6 or 7
  • CloudLinux 6 or 7
  • Red Hat Enterprise Linux 6 or 7

Note:
EasyApache 4 only supports CloudLinux in cPanel & WHM version 56 or later. This feature is a beta release.

Apache and PHP –

  • EasyApache 4 only supports Apache version 2.4.
  • EasyApache 4 supports PHP versions 5.4, 5.5, 5.6, and 7.0.

Settings –
If you install EasyApache 4, activate the rpm_up setting on your system as below –

  • Open the /etc/cpupdate.conf file and set the RPMUP key’s value to daily.
  • Go to Update Preferences interface in WHM (Home >> Server Configuration >> Update Preferences) and set the Operating System Package Updates setting to Automatic.

Steps to Install EasyApache 4 –

Run the following command –

/scripts/migrate_ea3_to_ea4 –run

read more

Posted in Control Panels | Tagged , | Comments Off on Installing and Uninstalling Easy Apache4 with Simple Commands

How to save a MySQL Database quickly with MySQLDump in Linux?

quick-tips-To-Save-MySQL-Database-via-Linux-Command-Line

Summary:

In a previous tutorial, we have seen how to save a MySQL Database with MySQLDump in Windows (WAMP). Today, we will see the quickest way to save a MySQL Database in Linux. For information database, the backup can also be done through a script which allows saving a database or set of databases. But the script can be a little too complex for easy to use tool for backup, natively available in MySQL. So here, we are going to see how to save a MySQL database by using Linux command line.

So we will use the command line for mysqldump that can save a database to store it in a .sql file that can be back later as well. In short, the sql file will contain a set of commands that, when it will be read by MySQL and will present the data to its original state (when it was backed up). MySQLDump is directly included in the installation of a MySQL Server. Suppose I want to save the database “bod007” face-wink in the file “bod007_nil84aug.sql”, I will use the following command:

read more

Posted in FAQs | Tagged , , , | Comments Off on How to save a MySQL Database quickly with MySQLDump in Linux?

4 Steps to Get IP Address of all VMs in Hyper-V

4-Steps-to-Get-IP-Address-of-all-VMs-in-Hyper-VIn this short & sweet tutorial we will try to make our system admins job easier to manage Hyper-V platform, at least I hope. Whether for export, to find who own an IP address or to find an available IP address, etc… You may need to know quickly what are the IP addresses used by your VM on a Hyper-V host.

For this, we will rely on the Hyper-V module for PowerShell and specifically the Get-VM cmdlets.

So let’s see how to get VM IP with PowerShell

1. Open a PowerShell console (run as administrator) and enter the following command:

2. The widespread property of “NetworkAdapters” benefits us, so we will select:

3. Again if we remade a Get-Member about this command, you will get a number of important sub-properties, we will select a few:

read more

Posted in FAQs | Tagged | Comments Off on 4 Steps to Get IP Address of all VMs in Hyper-V

How to Save a Database with MySQLDump in WAMP?

Let's-Learn-to-Save-a-Database-with-MySQLDump-in-WAMPSummary

Today, we will learn how to save a MySQL database on Windows environment, after installing a web server WAMP. We will use a native tool that comes with MySQL i.e. MySQLDump.

In this tutorial, we are going to use WAMP 2.5 and will name the backup as “mydb”.

Database Saving

We will have to open a Windows command prompt. Building on the executable “mysqldump” then can quickly backup a database.

We jump by assigning the directory where the executable file is located and then mysqldump.exe with the –u option to the user name, –p option to be asked the password and following your options as it is necessary to indicate the name of the database. Then the end of the line to record the output to a file named “mabase.sql” and located the directory “C:\Backup”.

read more

Posted in FAQs | Tagged , , | Comments Off on How to Save a Database with MySQLDump in WAMP?

How to Generate a CSR and Install an SSL in Plesk 12?

Your-5-min-Guide-To-Generate-CSR-and-SSL-installation-in-Plesk-12

Let’s learn to generate a Certificate Signing Request and Install a standard SSL certificate or a Windows server running Plesk.

Generate a Certificate Signing Request in Plesk.

  • Sign in to Plesk Panel.
  • Go to Websites & Domains tab and select the domain you want to secure.
  • Now click on Secure Your Sites.
  • Click on Add SSL Certificate
  • Move to the next page and enter the Certificate Name for easy recognition of the certificate among the others on the server and provide the required information for the CSR code –

read more

Posted in Control Panels | Tagged , | Comments Off on How to Generate a CSR and Install an SSL in Plesk 12?

Install and configure your SSL Certificate on Windows Server 2012 with IIS

Windows-Server

Have you created a Certificate Signing Request (CSR)? If no then you need to create it and order your certificate.
Below are the steps to create CSR request –

  • Open the Internet Information Services (IIS) Manager by pressing the command Win+R > “inetmgr” > Enter.
  • Double-click the Server Certificates icon on the Home page.

csr_iis8_1

  • Click on the Create Certificate Request from Actions menu on the right which will open the Request Certificate.

csr_iis8_2

  • In the Distinguished Name Properties window enter the below information –

csr_iis8_3

  1. Common Name – It is the name through which certificate will be accessible. It is usually the completely-qualified domain name. e.g. www.domain.com or mail.domain.com.
  2. Organization – The legally registered name of your company/organization.
  3. Organizational Unit – The department name within the company (this entry will be listed as “Web Security”, “IT” or can be simply left blank.)
  4. City/Locality – The place where your organization is located.
  5. State/Province – The state in which your organization is settled.
  6. Country/Region – The country where your company is located.
  • Click Next.
  • Enter the below information in Cryptographic Service Provider Properties and click Next
  1. Cryptographic Service Provider – Select Microsoft RSA Channel from the drop-down list or if you have a specific cryptographic provider select the name from the list.
  2. Bit Length – Select 2048 (or higher) in the drop-down list.

csr_iis8_4

  • In the File Name window, you will need to specify the name of the file to which a newly generated CSR code will be saved and a place where the file would be stored. You can type in the path to the field or use “…” button to browse the file system.
  • csr_iis8_5

  • After specifying the file name and location, click the Finish button.
  • It’s easy to locate the CSR file on the computer, open it with a text editor and use the CSR for SSL certificate activation.

Steps to install SSL Certificate on Windows Server 2012 from IIS

  • Open the ZIP file that contains your certificate and save the file named cer to the web server’s desktop which you are securing.
  • Start the Internet Information Services (IIS) Manager.
  • Double-click the Server Certificates icon from the Home.
  • install_iis8_1

  • Hover the mouse to Actions panel on the right-side and click on Complete Certificate Request which will open the Complete Certificate Request.
  • The screen will display Specify Certificate Authority Response which contains 3 fields.
  1. File name containing the certification authority’s response – browse through the file system to the certificate file which you have received from the certificate authority.
  2. Friendly name – It helps the server administrator to easily find a particular certificate You can provide the domain name of the certificate in this field.
  3. Select a certificate store for the new certificate – Select Personal from the drop-down list.

install_iis8_3

  • Click OK button once all the fields are set properly.
  • The certificate is uploaded to the server and should appear in the storage now.

Steps to configure your SSL certificate on Windows Server 2012 R2 – IIS

  • Once the successful installation of SSL certificate is done on your server, you will require assigning it to the appropriate website by using IIS.
  • Hover the mouse to the Connections panel on the left side of Internet Information Services (IIS) Manager and select the website from the Sites subfolder.
  • install_iis8_5

  • Navigate to the Actions menu and click on Bindings on the right side to open the Site Bindings.
  • install_iis8_6

  • Now click Add to open AddSiteBinding window in the Site Bindings and modify the below fields here –

install_iis8_7

  1. Type – Choose https from the drop-down menu.
  2. IP address – Select the IP address or if same IP is going to be used for multiple SSL’s on different sites then SNI has to be enabled as well.
  3. Port – Specify the port number for a secure connection. The default post number is443.
  4. SSL Certificate – Select the certificate that was installed needs to be specified.

install_iis8_8

  • Now click OK.

Your SSL certificate is now installed and the website is configured to permit secure connections. Once SSL installed on Domain, Please check domain on below link for verification -https://www.sslshopper.com/ssl-checker.html

read more

Posted in Web Hosting | Tagged , | Comments Off on Install and configure your SSL Certificate on Windows Server 2012 with IIS

Which SSL Certificate is good for your website?

SSL Certificate

SSL Certificates are necessary for those sites where a user is supposed to submit highly private and confidential information. It augments the website’s security and prevents imposters from doing fraud under your website’s name.

These certificates are of different types. Some organizations need SSL certificate for encryption only, while others need to exhibit their integrity and want to build a stable and reliable relationship with customers. So which SSL certificate will be best for your website? Here are the three different types of SSL Certificates which can help you determine the right choice for your website.

read more

Posted in Web Hosting | Tagged , , , , | Comments Off on Which SSL Certificate is good for your website?

How to Resolve MySQL High Memory Usage?

MySQL memory usage

What is MySQL?

MySQL is the most popular database used in web applications. It’s free, easy to administer and is supported by all hosting providers. There’s a common issue that MySQL servers face and that is high server load due to high memory issue.

Why does MySQL consume high memory?

  1. Application software like Python, PHP, JAVA threads utilize more memory when configured improperly or un-optimized queries, complex coding, etc.
  2. Due to improper configuration of MySQL, it leads to inefficient memory or wastage of memory.
  3. If the memory is lower than, required by the processes on the server.

Resolutions to fix MySQL high memory usage –

  1. Optimization of MySQL settings –

MySQL uses memory in two ways:

  • One is the memory permanently reserved for its use –

Known as Global Buffers category, it is obtained from the operating system during server boot-up and isn’t released to another process.

read more

Posted in Web Hosting | Tagged , | Comments Off on How to Resolve MySQL High Memory Usage?