September 2017Monthly Archives

How to install SQL management Studio on plesk server Date Posted: 29-09-2017 Sql management studio is a management tool used to connect to your MSSQL server from your windows server. Assumption: Windows Server MSSQL Server. Implementation: Login to server using RDP. Download the SQLManagementStudio_x64_ENU.exe from the below URL. http://www.microsoft.com/en-us/download/details.aspx?id=29062 Double click… Continue Reading How to install SQL management Studio on plesk server

ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci” Date Posted: 04-10-2017 Recently, when we tried to resource the dump which we had taken on one server and tried to restore it on another server. The restore failed with an error: ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci”… Continue Reading Unknown collation: utf8mb4_unicode_520_ci

How to make MSSQL to Listen on Port(1433) on MSSQL Server Date Posted: 29-09-2017 After installing MSSQL, it was not listening to default port 1433. In this post, we will explain on how to make mssql to listen on default port 1433. Resolution: Open Sql Configuration Manager. Click on Sql Server Management… Continue Reading How to make MSSQL to Listen on Port(1433) on MSSQL Server

How to install mylittleadmin on plesk windows Date Posted: 29-09-2017 Mylittleadmin is used to manage MSSQL database in a hosting environment. In this post, we will explain on how to install mylittleadmin on plesk windows server. Assumption: RDP Access to the server Plesk panel access Implementation: Login to the server… Continue Reading How to install mylittleadmin on plesk windows

Fix for Cpanel installation error (FATAL): The system could not fetch the TIERS file: During the installation of CPanel or WHM on CentOs 7, you may encounter an error as shown below, 2017-09-24 13:24:41 1173 ( INFO): The installation process will now import GPG keys for yum. 2017-09-24 13:24:41 1068… Continue Reading Fix for Cpanel installation error (FATAL): The system could not fetch the TIERS file.

Fix for Cpanel installation error “The system detected an installer lock file: (/root/installer.lock)”: Scenario: If the installation of Cpanel or WHM is interrupted because of an unexpected system restart or internet disconnect and if you start the installation by typing sh latest from the command line, you may experience the below error,… Continue Reading Fix for Cpanel installation error The system detected an installer lock file: (/root/installer.lock)

How to set a Static IP address in CentOs7 Minimal Server: For certain type of servers , it is mandatory to assign a static IP address especially if they are serving the internet or if they are running any mission critical business applications. Ex: web server , Application server ,… Continue Reading How to set a Static IP address in CentOs7 Minimal Server.

How to find default gateway in CentOs7 Minimal Server: IP addr  is the command used to check the IP address of a CentOs7 minimal server . Sample Output: In order to find the default gateway of CentOs7 minimal server, Use the command route -n  Sample Output: [root@CentOs7]# route -n Kernel IP… Continue Reading How to find default gateway in CentOs7 Minimal Server.

How to set Permanent or static hostname for CentOs7 Minimal Server: This article help you set Permanent or static hostname for CentOS 7 Minimal server. Prerequisites: CentOs 7 Minimal Server installed – May it be Physical or VPS or a VM. hostname abc.abc.com  Entering hostname abc.abc.comwill change the hostname temporarily.… Continue Reading How to set Permanent or Static hostname for CentOs7 Minimal Server.

How to check IP address in CentOS 7 minimal Server -Ifconfig not working. Prerequisites: CentOS 7. Introduction: How to check IP address in CentOs7 Minimal Server when Ifconfig command not working and returns an error “Command not Found” . Also when entering inet addr , getting “Command Not found”.  … Continue Reading How to check IP address in CentOS 7 minimal Server -Ifconfig not working.