I developed IP to Country module for Drupal last year. The original purpose was to see who visited my site through Search Keywords module. Anyway, it is also possible to use ip2cc module for automatically display information based on geo location.

Developing web applications on Apache Tomcat is very easy including ones interact with DBMS or even SAP. The key component is JDBC driver and SAP JCo. However, common problem is about deploying the application. If you installed JDBC driver or SAP JCo improperly on Apache Tomcat, you may run it as long as you don't redeploy the application again. Whenever you redeploy the application or deploy another application using the same driver, all applications will crash immediately because the driver was not loaded properly (it was already loaded).

Pure-FTPd supports various authentication source. I have an application to offer a private storage to Drupal user. In particular, every users share the same data storage since they are all friends. The scenario is that I would like to limit number of concurrent connection for each user to prevent parallel fetching by FlashGet or its friends. So I gave an individual user and limited the concurrent connection instead.

Anyway, I don't want to have duplicated accounts for both Drupal and Pure-FTPd. It would be nice if the account is shared among the two system so users may change their password by themselves.

Last night I saw something weird at Codenone. Actually, it was just a blank page returned from Drupal. PHP was set maximum memory limit to 64MB. It should be sufficient for a small site like Codenone. I noticed that the blank page often occurred on pages with comments. Below are my investigations.

1. Blank page will occur only on some nodes with some amount of comments.
2. There was no logs in Drupal.
3. There was no logs in virtualhost level.

One of the most wonderful thing in Drupal 5 is Garland theme. It is very flexible and simple to modify. In addition, Garland theme is really usable in production site. However, the very first step to make it usable in production site is to change logo and favicon to match what you have. If you notice the header area, Garland allows us to set gradiant from top to bottom of that region. This feature is a good and a bad. It looks good but the question is how to produce the logo to match this gradiant.

As far as I know, transparent PNG is not supported in IE6 and earlier version. The transparent color will be displayed as white. As a result, transaprent PNG must not be used for production site that visitors may use IE to browse the site. In other words, we should produce a logo with the gradiant as its background. The next problem is how to make it align. Actually, Garland theme doesn't provide the template to produce the logo.

The secret is that changing logo in Garland theme is very simple and template is absolutely unnecessary.

I am a Thai leaving in Thailand. However, I usually work on English locale. Only few times I worked with Thai locale and rarely involving in buddhist calendar. The time has come. I have to understand what Thai locale is and how to use it efficiently. I found a good document written by IBM and another one by Sun.