English

20060506-chequeAfter blogging for 4 months, I have finally got my first earning from  program. It is not as much as my income but it is enough to run this site for 2 years.

Some might say that many successors had been blogging as their main job. They usually get earning from Google AdSense and other affiliate programs. I don’t want to blog as my main job. I love my job. I love programming. Actually, I must say that I only blogged about my day-to-day experiences. If I don’t have my job, I may not have anything to blog. As you might see slogan of this site, "Share Know-How". I just want to share my experience and also my open-source works. In other words, Google AdSense indirectly sponsors me to contribute open-source programs.

How to fix MySQL errno: 145 Can't open file

I have got repeated error message like "Can’t open file: ’accesslog.MYD’. (errno: 145)". Actually, I can’t access the table named accesslog for any purposes including read or write. This table is not so important for me but it’s a kind of some annoying. I can’t even dump the database to back it up. I tried to search for this similar problem in Google using keyword "". There are about 900,000 search results. Great! What is the cause of this problem? The host that I got that error message is FreeBSD. I also got it in Linux. OS might not be the problem. So the problem seems to be MySQL itself. I don’t know.

Developing drupal module with customizable views

I was assigned a task to add more reports to casetracker module. This module is powerful. Anyway, it is not mature yet. There are only a few default reports. They are not enough at least for me and my colleage. In particular, the default reports just offer me to view list of all projects, my projects, all cases, my cases and advanced search. Well, what we want is all open cases, all resolved cases and a block to show my open cases.

Applying Grid in E-Military

Army also needs the power of Grid. Army usually is the largest organization in all countries. Army has lots of branch. General usually wants to command all army under-control just-in-time in face-to-face manner. So Access Grid would fit this requirement perfectly. Many armies have their own high-speed private network channels so they don’t need to care about quality and bandwidth. Army has its own spies and agencies. They produce high-volume of information. These information must be mined to analyze confident, accuracy, and probability. In short, all information must be prioritized and rearranged as fast as possible. Historical is essential here. Data Grid could be used to store images captured by private satellites for further mentioning. Computational Grid also fits in purpose to simulate how to deal with a war correctly. War is just a kind of complex chess.

Multisite Drupal with clean urls in subdirectories

Today, I was assigned a task to setup a new website as fast as possible. I’m not a web designer. I just know the contents. Fortunately, I have a Drupal already installed as intranet site. Anyway, it is just an intranet site so it is located in subdirectory of the main web, says http://www.sample.com/intranet. And then I would like to have http://www.sample.com/conf2006. I cannot use the same database of intranet because the intranet is completely private site. I don’t want anyone to read my secret contents. So I decided to use multisite feature officially provided by Drupal. As a result, I have 3 sites as follows.

Upgrading to Drupal 4.7.0

As you might notice, howforge.com has just been upgraded to Drupal 4.7.0. This is a big move because I had no time to upgrade since Drupal 4.7.0 beta 6. Anyway, I did it so smooth like before. In addition, I also reorganized all third-party modules to store in specific sites only. Since my development machine is running inside VMware player, I modified a few configurations to make it compatible with this hosting machine.