Mysql Database showing 0MB disk usage

If your Mysql DB are showing 0MB disk usage in cPanel then do the following things.

vi /var/cpanel/cpanel.config

find "disk_usage_include_sqldbs"

change the value from 0 to 1

and run
#/scripts/update_db_cache

Issue should be fixed :)

Regards
Ninad

IndianVPS | UK & US SERVERS | 24X7 SUPPORT | Free Transfer

Indian VPS is one of the world's top web hosting companies with large number of hosted domains. We have dedicated staff to provide you superior support around the clock.

cPanel and Plesk
Free Transfer
24X7 Support
99.9% Uptime Guarantee
Location available :: London and Washington DC

15% Discounts on all VPS Plans.

www.indianvps.com

Increase inodes from virtuozzo node

vzctl set VE_ID --diskinodes BARRIER:LIMIT --save

Where VE_ID is your VPS ID and BARRIER:LIMIT will be the limit of your inodes.


Regards,
Ninad


How To Add An IP Address from SSH

cd /etc/sysconfig/network-scripts

In this directory, you will find some files that begin with “ifcfg-”. There will be one file for each of your physical network adapters and one file for each of your virtual adapters. In my case, the existing script files are:

• ifcfg-lo => this is the loopback interface
• ifcfg-venet0 => this is my one and only physical adapter
• ifcfg-venet0:0 => virtual adapter #1
• ifcfg-venet0:1 => virtual adapter #2
• ifcfg-venet0:2 => virtual adapter #3
• ifcfg-venet0:3 => virtual adapter #4

So now what you need to do is to either copy an existing configuration file (if you have one of course) or create a new one. The new configuration file name must include the number of the virtual adapter. So supposing you want to add a fifth IP address from an existing script, you would issue:

# cp ifcfg-venet0:3 ifcfg-venet0:4

Next you will need to edit this file so that it contains your new IP address. You can use “vi” to do so.

DEVICE=venet0:4
ONBOOT=yes
IPADDR=192.168.0.4

Now you’ve got a new IP address and cPanel is running fine but there’s one more step to go.

Although you’ve added a new IP address at the operating system level, you now have to make it available for cPanel. Log in WHM as root (http://www.yourserver.com:2086) and click on Add a new IP address from the IP Functions menu.

Now simply enter the new IP address with the subnet mask 255.255.255.255 and hit the “Submit” button.

So that’s it! You’ve now got an additionnal IP address available for your web server.

NETMASK=255.255.255.255

Of course you’ll have to change 192.168.0.4 for your new IP. Save the file when you’re done.

To activate the new virtual adapter, issue this command:

# /etc/init.d/network restart

To make sure your new virtual adapter has been activated, use the “ifconfig” command. You should see the new adapter configuration details at the end.

At this point, the new IP address should be working but now cPanel will be deactivated. To re-activate it, simply issue this command:

/usr/local/cpanel/cpkeyclt

ip_conntrack table full, dropping packet error

If you are getting error
kernel: ip_conntrack: CT 87726*: table full, dropping packet.

Generally, the ip_conntrack_max is set to the total MB of RAM installed multiplied by 16.

You need to increase

ip_conntrack


# echo 37072 > /proc/sys/net/ipv4/ip_conntrack_max
This will increase ip_conntrack number to 37072

Command to check the current count
# cat /proc/sys/net/ipv4/ip_conntrack_max

To make this persistent you have to add a line like
 ‘net.ipv4.ip_conntrack_max=37072′ to /etc/sysctl.conf


Thanks
Ninad

How to increase quotaugidlimit in a vps from NODE

# vzctl set 100 --save --quotaugidlimit 1000

101 will be your VPS ID

To apply changes it is required to restart VE:

# vzctl restart 100




Thanks
Ninad


Install YUM from VZ Node

Run this command from node
#vzpkg install VEID -p yum

VEID will be your VPS ID.



Thanks
Ninad