Building Quassel core with PostgreSQL support on Ubuntu Hardy¶

Make sure repositores are up-to-date

sudo apt-get update

sudo apt-get install git-core postgresql-8.3 qt4-dev-tools libqt4-dev libqt4-sql-psql

Pull out source codes

git clone git://git.quassel-irc.org/quassel.git

Build it

cd quassel
cmake .

Setup PostgreSQL database master user

Follow these instructions

Setup quassel PostgreSQL database:

sudo -i
sudo -u postgres psql
postgres=# CREATE USER quassel ENCRYPTED PASSWORD 'somepassword';
CREATE ROLE
postgres=# CREATE DATABASE quassel WITH OWNER quassel ENCODING 'UTF8';
CREATE DATABASE

Create SSL certificate:

openssl req -x509 -nodes -days 365 -newkey rsa:1024 -keyout ~/.config/quassel-irc.org/quasselCert.pem -out ~/.config/quassel-irc.org/quasselCert.pem