inertz.org

Category: Cpanel

Restore database from *.frm for corrupted database

Posted on by admin

Recently on of my client have problem with the database corruption in Cpanel. The website trowing error related with database. We check our daily MySQL backup and found there is no data in the client MySQL database. To make thing worst our weekly and monthly backup also doesn’t have the database. According to client the last access to the website is in March.

Our daily MySQL backup does not contain data in the SQL query. This indicate data corruption.

We try to repair it using below command, but none helps.

mysqlcheck --auto-repair --optimize databasename
find /var/lib/mysql/databasename -name "*.MYI" -exec myisamchk -r -f {} \;
find /var/lib/mysql/databasename -name "*.ibd" -exec innochecksum {} \;
mysqlcheck --repair --use-frm databasename

After researching in the Internet we found that we can reconstruct the database from *.frm files using MySQL utilities called mysqlfrm

First you need to install mysql-utilities.

yum install mysql-utilities

Then cd to /var/lib/mysql and using below command to dump the database.

mysqlfrm --diagnostic databasename > /root/databasename.sql

The sql will give you tables but not the data but it is sufficient.

Backup /var/lib/mysql/databasename to somewhere or just rename it to something.

Restore the database.

mysql databasename < /root/databasename.sql

Restore the permission because the ownership is root.

chown -R mysql:mysql /var/lib/mysql/databasename

Stop the MySQL

Copy the data from databasename folder that you just rename or resync using command. Example;

rsync -arvh --progress /root/databasename/ /var/lib/mysql/databasename/

Start the MySQL

Supposed you have a working database and website now.

Remove Billing And Support Integration CPanel

Posted on by admin
Billing and support integration Cpanel
Billing and support integration Cpanel

Sometime for some reason we may need to remove billing and support integration in Cpanel. The purpose of the integration is to easily manage billing and support from CPanel particularly for provider who is using WHMCS as a hosting billing software.

For example you are allowing your developer to access Cpanel but you don’t want them to access your billing info in WHMCS.

The simplest step is just disable Single Sign On in the WHMCS members area in the billing site. But how about you want to mass disable completely the features form server.

You can do this by using below command;

cd /var/cpanel/users

for user in *; 
do /usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_knowledgebase; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_announcements; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_tickets; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_emails; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_downloads; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_product_details; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_shopping_cart_domain_register; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_invoices; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_upgrade; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_submit_ticket; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_shopping_cart_domain_transfer; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_profile; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_billing_info; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_knowledgebase; 
/usr/local/cpanel/bin/whmapi1 remove_integration_link version=1 user=$user app=WHMCS_clientarea_network_status;  
done

And of course you must have full access to the server.

Softaculous causing server overload

Posted on by admin

Recently there are few of our server overloaded because of Softaculous.

Not sure what trigger the overload but reinstall the software seem managed to solve the issue.

We have install our server with process monitoring script. When ever there are many process running exceeded define volume the notification will be sent to our report email.

In this case our server load sky rocket from normal to 100 in a matter just seconds.

It this case our report will be look like this;

SERVER OVERLOAD: ‘svr56.com.com’ having process more than ‘11396’
SERVER OVERLOAD: ‘sifu.com.com’ having process more than ‘10472’

Report similar like ;

shafiq 1355850 0.0 0.0 144312 10952 ? S 15:24 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php 49c2609a636a3a97d00ca61044239e8b
shafiq 1355852 0.0 0.0 144312 10952 ? S 15:24 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php 0b8425de8f3b9268855a3bea26266d64
shafiq 1355854 0.0 0.0 144312 10948 ? S 15:24 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php 9eef96ede0c95373355fe2d7a1ec2923
shafiq 1355856 0.0 0.0 144312 10948 ? S 15:24 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php d124777156229ad549114a2e97296cfa

unidustr 79433 0.0 0.0 144312 5544 ? S 15:32 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php 8f5ee467a84393bbd8a0cc3dae340071
unidustr 79435 0.0 0.0 144312 5552 ? S 15:32 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php df456ff6bcfc9d932586216279a8b63f
unidustr 79439 0.0 0.0 144312 5544 ? S 15:32 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php c841bd3f41f95dacc8aed5c7059e580c
unidustr 79441 0.0 0.0 144312 5548 ? S 15:32 0:00 /usr/local/cpanel/3rdparty/bin/php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/index.live.php cd873125ef0043106a2e6948a2b52b4f

What we do first is to rename Softaculous folder.

mv /usr/local/cpanel/whostmgr/docroot/cgi/softaculous /usr/local/cpanel/whostmgr/docroot/cgi/softaculousx

Then install again Softaculous

wget -N http://files.softaculous.com/install.sh
chmod 755 install.sh
./install.sh

The last steps is to copy configuration file from last setting.

mv /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/categories.ser /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/categories.serx
mv /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/iscripts.php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/iscripts.phpx
mv /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/universal.php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/universal.phpx

cp /usr/local/cpanel/whostmgr/docroot/cgi/softaculousx/enduser/categories.ser /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/categories.ser
cp /usr/local/cpanel/whostmgr/docroot/cgi/softaculousx/enduser/iscripts.php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/iscripts.php
cp /usr/local/cpanel/whostmgr/docroot/cgi/softaculousx/enduser/universal.php /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/enduser/universal.php

The server no longer have overload issue with Softaculous.