2010 juin | Le blog d'Étienne Pouliot

can’t adapt type ‘Decimal’ error with Django + Apache + PostgreSQL + Psycopg2

29 juin 2010 — Étienne Pouliot

One of my Django installation was running fine for a few months. Last week I had to add a new Django project to this server.

My setup was : CentOS 5.5, Apache, mod_wsgi and psycopg2 2.2.0.x

After I added the new project, I started getting random errors « can’t adapt ». It would work perfectly for a few hours than my users would start getting an annyoying 500 error.

I searched the web, this seems to be a rather common error…but everything I found was related to another issue or something that was fixed in the Django release that I’m using.

Read the rest of this entry »

Posted in Apache, Django, Linux. 2 Comments »

A minimal and secure CentOS 5.5 64 bits virtual appliance

6 juin 2010 — Étienne Pouliot

This virtual appliance is ideal of you want to deploy a CentOS server. It’s only about 600MB compressed as I only included the defaults packages in a CentOS minimal installation. I also did some basic best practice configuration to make it more secure . Of course I could have hardened it a lot more, but I wanted to keep it easy to deploy an use.

It’s an ovf file, so you can use it with pretty much any hypervisor, including VMware, Virtual Box, Xenserver and Hyper-V.

To login, use the following credentials :

user : root

password : secure

To download my CentOS 5.5 x64 virtual appliance, use one of the followings links :

CentOS 5.5 64 bits withouts VMware Tools

CentOs 5.5 64 bits with VMware tools

Here are the details of the configuration :

Read the rest of this entry »