cPanel MySQL Performance Tuning

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

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

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

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

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

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