Install MySQL-python on Cygwin

After pulling my hairs and scavenging the Google, finally I succeeded installed the MySQL-python on Cygwin.

• Build MySQL on Cygwin

• Download MySQL source package from here. I was using mysql-5.0.76.tar.gz
• configure && make && make install

• Install MySQL-python on Cygwin
• Download MySQL-python . I was using 1.2.2. Unzip it.
• ./setup.py install, if you run into any problem, please have look on the readme file of the MySQL-python package. You may need to update threadSafe=False in the site.cfg file.
  

PIL error: IOError: decoder jpeg not available

After installing PIL on Cygwin, I ran into the following error while I am trying to load data from a JPEG file.
IOError: decoder jpeg not available
To solve this problem I did the following steps:
Remove the installed PIL from Cygwin:
rm -rf /usr/lib/python2.5/site-packages/PIL
rm /usr/lib/python2.5/site-packages/PIL.pth

Install libjpeg by using Cygwin setup.exe

Rerun PIL setup.py install.

unable to remap C:\cygwin\bin\tk84.dll

While installing PIL(Python Imaging Libary) on Cygwin, I ran into the following error:
5 [main] python 4388 C:\cygwin\bin\python.exe: *** fatal error - unable to remap C:\cygwin\bin\tk84.dll to same address as parent(0x410000) != 0
x700000
22 [main] python 4636 fork: child 4388 - died waiting for dll loading, errno 11
error: Resource temporarily unavailable

Fortunately, with the help of Google, it is easy to find an existing solution from Datahammer's blog:
c:\cygwin\bin\ash
cd /bin
./rebase -b 0x100000000 tk84.dll

Rerun the PIL setup.py install in Cygwin shell.

Update: If you run into remap error on Cygwin, you could try rebaseall
c:\cygwin\bin\ash
cd /bin
./rebaseall

Unix commands help on diagnosing Weblogic problems

While working on diagnosing the Weblogic problems, I found the unix commands help me a lot, here they are:

• Apache error_log files BackEnd errors: grep -r -h --include=error_log Backend . | awk '{print $2 " " $3}'| sort | uniq -c
  
  
• Oracle connections: while true; do netstat -an|grep 1521; netstat -an|grep 1521|wc -l; echo "+++++++++++++++++++"; sleep 4; done;
  
  

Google App Engine for Java Rocks!!!

I signed up GAE yesterday, and the account was activated today. It is time to play with it:
* Create Application ID
* Download and install Eclipse plugin
* Create new Web application
* Deploy application to GAE

Done!!!
It is just so easy.
More will come on this topic.

How to remote debug JMeter?

Want to remote Debug JMeter? Here I show you how I did it?

1. Download JMeter binary package and source package, unzip them into the same directory.
2. Rename the eclipse.classpath file to .classpath and open the project with IDEA.
3. Open a shell, set JVM_ARGS=-Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005
4. Start JMeter in the previous shell.
   
5. Setup remote debug in IDEA and start debug.
   

Setup JMeter JMS Publisher Sampler

Even though there are documentations on how to setup and use JMeter JMS publisher sampler, it seems all of them are either inaccurate or out of date. After pulling my hair for almost two hours, I finally made it work. To avoid headache for anybody who want to set up JMeter JMS publisher sampler, I recorded the procedure as following.

We choose ActiveMQ as our JMS provider.

1. Copy activemq-core-5.2.0.jar, jms-1.1.jar, and geronimo-j2ee-management_1.0_spec-1.0.jar into JMeter's lib directory.
2. Create a jndi.properties file and jar it into a jar file, put the jar file into JMeter's lib directory.
3. Confiture the JMS publisher sampler with the following settings in the JMeter GUI.

• Check use jndi.properties
• Connection Factory: ConnectionFactory
• Topic: MyTopic
  
• Number of messages to aggregate: 1

Here is the content of the jndi.properties file:
java.naming.factory.initial=org.apache.activemq.jndi.ActiveMQInitialContextFactory
java.naming.provider.url=tcp://hostname:61616
topic.MyTopic=topic

There are a few catches during the setting up process:
* The ActiveMQInitialContextFactory package name must have the apache.
* ConnectionFactory can not contain any trailing space.
* The Topic JNDI name must be prefixed with topic in the jndi file.
* You must put in the Number Of messages to aggregate, otherwise there will be no messages published.