Installing MySQL Python Module on Ubuntu

After tearing through several other Django books and tutorials using sqlite3 as the database, I’m starting to go through the book Beginning Django E-Commerce and it uses MySQL as the database. I use MySQL quite a lot so that side of things isn’t an issue, but I did run into a couple of wrinkles getting MySQL and Django playing nice so I thought I’d share.

Basically if after configuring your database in and running python dbshell you get a bunch of errors, you have a minor amount of installation work to do to get things rolling.

First thing I did was install pip, which is a better version of/replacement for easy_install:
sudo easy_install pip
Next I ran pip upgrade for good measure (probably not necessary but can’t hurt, and worth running if you already had pip installed):
sudo pip install pip –upgrade
On my machine (Ubuntu 12.04 64-bit) I also had to build the dependencies for the python-mysqldb libraries:
sudo apt-get build-dep python-mysqldb
And finally with that in place you can use pip to install the Python MySQL libraries:
sudo pip install MySQL-python
If everything worked you should now be able to run python dbshell from your Django project and have it load up the MySQL console.

Manually Installing the Django Plugin for Eric

If you install Eric (specifically Eric 4) from the Ubuntu software repos, the Eric plugin repository points to a location that’s unavailable:

I’m sure there’s a way to change it but I don’t see how to do it in the app itself (haven’t started poking around to see if there are config files somewhere yet), but luckily Eric plugins are just zip files so you can download them from a repository URL that works, and then add them to Eric.

The working plugin repository is here:

From there just do a ctrl-F to find the plugin you’re looking for, then copy/paste the URL for the plugin’s zip file into your browser (or use wget or whatever floats your boat) to download the plugin.

With the zip file downloaded, in Eric go to Plugins -> Install Plugins, click Add, and then point to the zip file you downloaded.

If someone knows how to change the plugin repository URL in Eric I’d love to learn.

Notes on Practical Django Projects (Part 1)

I’m currently making my way through Practical Django Projects by James Bennett and thought I’d share some notes and errata as I go along. (Side note: If you want a paper copy of this book, it’s dirt cheap at; just make sure to get the second edition which was published in 2008).

I’ve done a small amount with Python here and there in the past (writing some scripts to handle very specific tasks or that used libraries available in Python that were better than what’s available in Java) and always really liked the language, but I haven’t ever looked into building webapps with Python until now.

So far I’m quite impressed. Having worked with Grails a little in the not-too-distant past I’m finding Django to be similar conceptually but a little simpler, and it seems to be extremely well thought-out and strike an excellent balance between forcing a convention on the developer and requiring just enough to configuration to maintain a lot of flexibility.

I’ll save a more thorough review of Django for a future date when I have it under my belt better, but for now I wanted to point out a stumbling block I hit due to a minor lack of specificity in the book.

For those of you even less familiar with Django than I am, Django operates on the concept of a high-level project and within that project are one or more applications. Conceptually this is similar to what other frameworks might call a module, or kinda-sorta-but-not-completely like a Grails plugin. The point is that Django projects are built of multiple modular building blocks, which is a really great way of organizing things.

On my machine I’m building all this stuff in a ~/djangoprojects directory, so inside there I have a cms directory for the simple CMS that you build as one of the projects in the book. So ~/djangoprojects/cms is the project directory, and inside that directory is a cms directory (so ~/djangoprojects/cms/cms) for the CMS application that is part of this project.

This is the way it should be, I believe, since you first run a script to create the project, then navigate into the project directory and run another script to create the first application that will make up the project. (If anyone with Django experience reads this and what I’m saying here isn’t accurate, I’d love to be corrected so I can learn.)

Beginning on page 43 you add a search system to the CMS, and following the modular convention you start things off by running the startapp script from the project directory.

On page 43 it reads:

So let’s make this into its own application. Go to your project [emphasis mine] directory and type the following command: 

python startapp search

The problem is the book gets the terminology a bit wrong (based on my understanding of the terminology thus far at any rate) and this leads to an error which took me a little time to track down, probably largely due to my newbness with Django.

As directed I went into my project directory and created the search application, which means I wound up with a cms directory and a search directory at the same level in the project (which again, I believe is how it’s supposed to be), so specificially I have these directories:

Later you add a URL pattern to the project’s file to tell Django what URL route you want to use to hit the search application:
(r’^search/$’, ‘’)

When I ran the code, I was getting the error “ImportError at /search/ No module named search”

Note the path to the search application in the URL pattern above:

I probably should have noticed that right away since that indicates the search application would be inside the cms application, but since I created search in the project directory instead of the cms application directory, a simple change to the URL pattern to ommit the cms. at the beginning fixed the problem:
(r’^search/$’, ‘’)

As I said above all of this could be my own misunderstanding, and maybe the cms and search applications aren’t supposed to be siblings, so if someone comments with a simple “you’re wrong” that’s a great way for me to learn. I did notice that Phil Gyford who was nice enough to put his completed source for the book online got it “right” so might just be me.

I’ll share more notes/thoughts as I make my way through the rest of this (so far) excellent book, and if you have questions about any of this or thoughts you’d like to share about Python and Django I’d love to hear them.