Installing posterity on debian etch

On this guide we are using a basic debian etch install and mysql as backend database server.

Installing required debian packages

First install all required packages from debian repositories:

  apt-get install python-setuptools subversion mysql-server python-mysqldb

Installing required python libs

Theory says if we run now "easy_install Posterity" posterity will get installed but the real thing is that you will get this errors:

error 1

Installed /usr/lib/python2.4/site-packages/SQLAlchemy-0.4.2cdev_r4028-py2.4.egg
error: Could not find required distribution SQLAlchemy<=0.3.99

error 2

No local packages or download links found for Elixir==0.3.0
error: Could not find suitable distribution for Requirement.parse('Elixir==0.3.0')

So before running "easy_install Posterity" we have to install required dependencies. We can download SQLAlchemy<=0.3.99 from their sourceforge project page http://sourceforge.net/project/showfiles.php?group_id=140060&package_id=153732 or run this command on your terminal:

wget http://belnet.dl.sourceforge.net/sourceforge/sqlalchemy/SQLAlchemy-0.3.11.tar.gz

Then decompress the file and run inside the directory "SQLAlchemy-0.3.11"

python setup.py install

Also download the file Elixir-0.3.0.tar.gz and do the same. I found this file looking for in google. Here you have a direct link;

wget http://gentoo.netnitco.net/distfiles/Elixir-0.3.0.tar.gz

Configuring mysql

Run this comands to create a new database and grant the right permission to the posterity user:

mysqladmin -u root -p create posteritydbname
mysql -u root -p
mysql> grant all on posteritydbname.* to posteritydbuser@localhost identified by 'posteritydbuserpassword';
mysql> flush privileges;
mysql> quit

Installing Posterity

Once installed the dependencies we can run this command on the terminal to get Posterity installed:

easy_install Posterity

Configuration

Run this on the terminal to initialize the posterity database

export POSTERITY_INSTANCE=/opt/posterity/
posterity-admin init --database=mysql://posteritydbuser:posteritydbuserpassword@localhost/posteritydbname

And add users with this:

posterity-admin account --create yourusername --password=xyz

Starting Posterity

Run:

$ posterity-admin serve --port 8080

And you should be able to connect on http://127.0.0.1:8000

If you are using mysql you should apply the fix described in this ticket as this bug hasn´t been patched yet (07/01/2008): http://posterity.edgewall.org/ticket/36

You can find more detailed info on how to configure it on the quick start guide: http://posterity.edgewall.org/wiki/Documentation/quickstart.html#id4