am3n portfolio

Today I upgraded my HeidiSQL into version 4, but when I am running it on the MySQL server 5.0 I got error

"SQL Error: Table 'mysql.proc' doesn't exist"

After googling around, found that this error caused HeidiSQL requires table Mysql.proc which is not exist. Table Mysql.proc is used to store procedure. But wait, I am using MySQL 5.0.x which already support Procedures and Views!! so How come this error show up??

After some tought, the are several reason why this error came up although you are using MySQL 5.

1. You are upgrading from MySQL 4.x
2. Your MySQL 5.x installation didn’t smooth

And in my case, it was reason no. 1, as I am remember I was once upgrade mysql server a year ago. So how to fix it? (more…)

Once upon a time when I tried to create a folder using ftp client on the server, I get error "cant create directory gallery: read-only filesystem".

After googling a while I found the solution on Always Hosting Forum. And the only way to resolve it permanently is by running fsck utility on linux single mode before mounting the harddrive. Yes there is a temporarily solution by restarting the server, but when the system is about to write into failed inode it will freeze, daemons stop responding, connections rejected, etc to make sure it wont cause more broken inode will lead into data corruption.
(more…)

From WHMCS: WHMCS is a complete all-in-one client management, billing & support solution primarily designed for Web Hosts but also applicable to many other types of online businesses. Packed with features but with a core focus on remaining easy to use and customise, WHMCS enables you to easily and effectively manage your business while automating many routine tasks.

Many Hoster use WHMCS, to manage billing and support because ease of use and simplicity. But WHMCS need to be secured, using SSL so all the information key in by clients and admins can’t be tap by others. Btw you should have done security steps explained on http://wiki.whmcs.com/Further_Security_Steps to tighten up your WHMCS installation.

The steps for Securing WHMCS using SSL is summarize from WHMCS Forum, and I am using url http://clients.hoster.com for example, so lets get start!! (more…)

After you delete some big files on your cpanel hosting server, the Disk Space Usage information may not showing the correct size, usually the next day after the crontab running, it will then shows the correct size.

But if it is not, then you should ask your webhoster to fix it.

As for the hoster, you need to run this command to fix it:

 /scripts/fixquotas