Django "SMTPServerDisconnected Connection unexpectedly closed"

1. Check mail server by "telnet servername port(25)"
2. Check IMAP server (e.g. deovecot)

How To Install Python JCC

Ubuntu 8.04 Server

• sudo install  sun-java6-jdk python-distutils-extra build-essential
• svn co http://svn.apache.org/repos/asf/lucene/pylucene/trunk/jcc jcc (revision 1090549)
• cd jcc/jcc
• sudo python setup.py build install

Windows

• require Python2.5.2, Visual Studio 2003, Java-JDK1.6.0u17
• add Path
• C:\Program Files\Java\jdk1.6.0_17\bin
• C:\Program Files\Java\jdk1.6.0_17\lib
• C:\Program Files\Java\jdk1.6.0_17\jre\bin\client
• C:\Python25
• checkout jcc from subversion http://svn.apache.org/repos/asf/lucene/pylucene/trunk/jcc (revision 1090549)
• open command prompt
• in jcc directory >>> python setup.py build install

How to Change JOptionPane font

Use JTextArea component to render in JOptionPane.
Example:
JTextArea txtArea = new JTextArea(errMsg);
txtArea.setFont(GuiUtils.getThaiFont(Font.BOLD, 22));
txtArea.setOpaque(false);
txtArea.setEditable(false);
txtArea.setBorder(BorderFactory.createEmptyBorder(10, 10, 10, 10));
JOptionPane.showMessageDialog(this, txtArea);

SQL History in Django

Use django.db.connection to get SQL history.
Example:
from django.db import connection
connection.queries

Certificate expired when package AIR appication

Solution: Change your date and time formats on your computer to US format before create certificate file.

Add datetime in MySQL

Example: plus datetime 31 days;

• update table_name set datetime_field = ADDDATE(datetime_field, 31);

Example: minus datetime 31 days;

• update table_name set datetime_field = ADDDATE(datetime_field, -31);

Calculate DPI for Monitor

Use this formula.
dpi = sqrt(resolutionWidth ^ 2 + resolutionHeight ^ 2) / inches