Archive for the 'Web and System Administrator' Category

“Nobody” prevented from sending emails

Tuesday, June 23rd, 2009

Forget what I said below, if your webhosting has disabled user “nobody” to sent email, then they should enable suphp. This way, all PHP script executes as user account and not nobody. And will deliver email correctly.

==========

So your webhosting provider activated “Prevent “nobody” from sending mail” which cause your PHP script can’t sent email? You can use PHP classes called XpertMailer or PHPMailer but somehow it’s not working well on my host. Weird… The previous version XPertMailer works like charm but somehow the new one never sent my emails.

So I googling around and found Webmaster World’s Forum, and luckily the ini_set function is not disabled. So I test the script and it works flawlessly. Below is the script
(more…)

SocialTwist Tell-a-Friend

Centering a Div

Monday, June 22nd, 2009

I was working on Knowledge Base using WSNKB Free script and I need to modify the template so it looks good when user see it. And I got stuck, on how to centering a Div, luckily I found AndyBudd’s blog which saves me. So I modified WSNKB like this.
(more…)

SocialTwist Tell-a-Friend

SQL Error: Table ‘mysql.proc’ doesn’t exist

Thursday, June 18th, 2009

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…)

SocialTwist Tell-a-Friend

Read-only file system

Sunday, June 14th, 2009

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…)

SocialTwist Tell-a-Friend

Securing WHMCS

Sunday, June 14th, 2009

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…)

SocialTwist Tell-a-Friend