woof woof
Linux
cPanel: MySQL Databases Show As 0MB
Apr 15th
This issue has been plaguing me ever since we moved to a VPS (at least I think so). The problem is when you go to view your MySQL databases in cPanel they appear as 0.00MB which is not correct (at least if you’ve got data & records in them)! Initially I thought either running /script/upcp –force or /scripts/fixquotas would resolve this, but it doesn’t. I sort of gave up after that, not sure why since I was able to resolve it within 5 minutes tonight. I ran a quick Google search and came across a cPanel forums post which linked to this blog article.
Essentially you just need to update a configuration option in the cPanel configuration file, then run a script, and you should be set!
Just open this file with your favorite text editor:
[~]# nano /var/cpanel/cpanel.config
Locate this line:
disk_usage_include_sqldbs=0
and change it to:
disk_usage_include_sqldbs=1
Then run this command:
[~]# /scripts/update_db_cache
Check your cPanel and it should be resolved!
Jolicloud: Netbook OS
Apr 15th
I bought a netbook about a year ago, mostly because of their size but also because with a bit of work you can get Mac OS X running on them. Of course, this article isn’t about OS X, it’s about another operating system which is a bit easier to install and made just for netbooks.
A lot of these netbook OS’ are really just regular distributions of Linux which have had their UI updated for the smaller screens found on netbooks, Jolicloud is no different. It’s based on Debian and has some UI tweaks which makes navigating around the system a bit easier. More >
Gentoo: iptables Multiport Module
Feb 10th
After finally talking myself into re-doing iptables on all of our servers, I came across an issue where the options “-m multiport --dports 80,443” wouldn’t work. It kept spitting back “iptables: No chain/target/match by that name.”
What you need to check for is the that the multiport module within the kernel has been selected and compiled in. You can find this option under:
Networking support —>
Networking options —>
Network packet filtering framework (Netfilter) —>
Make sure “Advanced netfilter configuration” is turned on, and then it’ll be under:
Core Netfilter Configuration —>
“multiport” Multiple port match support
I ended up having to recompile my kernel, but I’m glad I was able to figure this one out. The people in the #netfilter channel on Freenode were as helpful as usual (and by that I mean they were completely useless). The multiport module is great when you want to open multiple ports without having to use multiple commands, or for organizational purposes want to group multiple ports open. As from my example above you can see I’ve set port the HTTP and HTTPS port in the same line.
