I’ve been trying to get the Tornado Web Server setup on my Mac OS 10.6 Snow Leopard laptop. There are tons of dependencies it has been a pain in the ass.

Install MySQLdb python driver.

Download latest MySQL_python.

tar xzf MySQL-python-1.2.3c1.tar.gz

python setup.py build

Build process may give you an error

EnvironmentError: mysql_config not found

This happens because your mysql installation may be non-standard. Mac OS installations are typically wacky. If you get this error figure out where your mysql_config binary Ressides.

found at /usr/local/mysql/bin/mysql_config vim site.cfg

# The path to mysql_config.
# Only use this if mysql_config is not on your PATH, or you have some weird
# setup that requires it.
mysql_config = /usr/local/mysql/bin/mysql_config

python setup.py build

python setup.py install

SowaCS Consulting’s Amazon Web Service Query Signer. Download the file called awsquerysigner_py.zip

As of August 15, 2009 Amazon required all API queries to have a special authentication signature. SowaCS Consulting has published a simple Python class (Python library?) that does the dirty work to sign your REST calls to the Amazon Product Advertising API. The code is on the website but they also offer a query signing service.

Back Story:

I finally got the gumption to attempt to tie in some AWS (Amazon Web Services) things into some of the websites I’m running because I want the affiliate advertising to blend in with my pages in a cleaner fashion. Unfortunately Amazon made it a lot harder for chumps like me to make API calls because of their newly enforced requirements that all requests be signed with a special hash signature. Steps involved to sign an Amazon REST request

• Take query params, re-order them by byte-value and make them UTF-8.
• url encode each key-value query parameter
• replace any “+” and “~” characters in the strings with url encodings
• add a timestamp
• Build a text string to prepare for hashing
• Encode signature using HMAC and SHA256

• Send request, and receive REST response.

This process sounds easy, but I couldn’t figure it out. I wrestled with Amazon’s Product Advertising API Documentation but the examples mostly uninformative. Thankfully, I came across a helpful post in the developer forums that points to SowaCS consulting. Naturally when looking at the code theirs is much cleaner, more flexible and it actually works. It’s not superb code but it IS way better than anything I would ever write. I really ought to go back to school…

I’m looking for a way to convert RTF files into XHTML but XML would be acceptable. So far I’ve found a converter that goes RTF —> XML.

https://sourceforge.net/projects/rtf2xml/