cPanel Recover InnoDB table Corruption

by Posted in Cpanel Leave a comment

InnoDB force Recovery, There are many reasons available to get database corrupted. Make sure that you maintain a good backup schedule by running a cpanel backup in case of serious corruption or data loss issue or refer with Mysql knowledgebase.

InnoDB corruption can cause all of the databases running on that server to be inaccessible. Unfortunately some times you need to recover MySQL data from ibdata1. It’s many reasons why your getting corrupted Innodb files that cannot automatically be restored of the mysqld daemon. We can recover innodb table corruption in your  cpanel server.

 

Read More

cPanel MySQL Performance Tuning

by Posted in Cpanel Leave a comment

MySQL Performance Tuning Shell Script, This script takes information from “SHOW STATUS LIKE…” and “SHOW VARIABLES LIKE…” then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and above.

In your huge traffic cPanel server you can use the following MySQL performance tuning script to optimize the mysql performance.

Read More

Cpanel Database Automatic backup Shell script

by Posted in Cpanel Leave a comment

We can backup our databases using different methods, Here is the shell script used for automatic backup MySQL databases using mysqldump in your cpanel server. The following instruction can be used to backup any database. The only requirement is that you are using a Linux server to host your files and mysql user privileges. Use this Database Automatic backup Shell script  via cron job.
Read More

Files tab is not shown in Control Panel

by Posted in Linux, Plesk Leave a comment

Symptoms

Cannot manage the subscription. The plesk agent exception are thrown when accessing subscription management options:

  1. When opening the ‘Files’ tab: 
    Error message or description of the request: In response to the HTTP-request to the agent at 'https://203.0.113.2:8443/agent.cgi' An invalid HTTP-code '502 '
File JsonRpc.php
File    JsonRpc.php
Line    273
Type    Service_Agent_Exception

Read More

POODLE Attack Exploiting SSL 3.0 Fallback

by Posted in Plesk Leave a comment

Information
A CVE-2014-3566 vulnerability in the SSLv3 protocol was identified by the Google security team. There is an additional whitepaper available from OpenSSL that also describes this vulnerability.

You can check if you are vulnerable using the following script. For the parameter, specify your server IP:

# wget http://kb.odin.com/Attachments/kcs-40007/poodle.zip
# unzip poodle.zip
# chmod +x poodle.sh
# for i in `echo 21 587 443 465 7081 8443 993 995 `; do /bin/sh /root/poodle.sh $i; done
Read More

How to change shared IP address to dedicated IP in Plesk PPA

by Posted in Plesk Leave a comment

Information
Parallels Plesk Automation (PPA) version 11.1 does not have direct way to change shared IP address to dedicated IP address for the domain on customer’s subscription.
Dedicated IP address can be assigned on the subscription only during creation.

The article describes workaround which can be used for assigning dedicated IP address on the existing subscription without recreating it.

Read More

Resetting OS X Password

by Posted in Linux Leave a comment

The simplest way is by Restarting Setup Assistant

Restart the Setup Assistant and create a new Administrator account, then use that account to reset the password to the original account.

You can restart the Setup Assistant by performing the following:

Boot into Single User Mode (hold ⌘ cmd + S at boot).

Read More