Installing fpdb

From git sources

This will grab a bleeding edge copy from one of the developer's repositories. There is no compilation involved.

$ sudo apt-get install git-core
$ git clone git://git.assembla.com/fpdb.git fpdb

will plonk it in a subdirectory of your current directory.

Installing and configuring postgresql

Note that by default fpdb will use mysql. If you want to use postgresql, there are quite a few dependencies:

$ sudo apt-get install postgresql, python-psycopg2, pgadmin3
$ sudo -u postgres psql postgres
Welcome to psql 8.3.5, the PostgreSQL interactive terminal.           

Type:  \copyright for distribution terms
       \h for help with SQL commands    
       \? for help with psql commands   
       \g or terminate with semicolon to execute query
       \q to quit                                     

postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'Your_New_Postres_Root_Password_Here';
ALTER ROLE                                                            
postgres=# \q

$ pgadmin3

Click connect (top left; a plug) and fill in:

name: name you give to this connection
host: localhost
password: Your_New_Postres_Root_Password_Here

You may choose to store the password, if you do you will be warned that it will be stored in plaintext in ~/.pgpass

You should now be connected to postgres on localhost. Expand the + next to it. Add a user called fpdbuser by right clicking on Login Roles->New Login Role. Just enter the name 'fpdbuser' and a password.

Now create the fpdb database by right clicking 'Databases->New Database'. Call it fpdb and set the owner to fpdbuser.

Now you need to tell fpdb about the database. Open 'HUD_config.xml.example' in a text editor. First, save a copy as 'HUD_config.xml', which fpdb will read in preference to the example.Find the section

    <supported_databases>
        <database db_name="fpdb"         db_server="mysql"      db_ip="localhost" db_user="fpdb"   db_pass="YOUR MYSQL PASSWORD" db_type="fpdb">    </database>
    </supported_databases>

and alter it to

    <supported_databases>
    <database db_ip="localhost" db_name="fpdb" db_pass="your_fpdbuser_pass" db_server="postgresql" db_type="fpdb" db_user="fpdbuser">    </database>
    </supported_databases>

OK, change directory to fpdb/pyfpdb and run fpdb.py (you may need to add execute permission with chmod u+x fpdb.py). If it works and connects to the fpdb database you created, you'll be told you need to create the tables.. follow the instructions!