Building Quassel core with PostgreSQL support on Ubuntu Hardy¶

These instructions tell how to build the latest quassel core for your Ubuntu 8.04 Hardy Heron server. PostgreSQL database backend will be used instead of the default SQLite backend, since it scales better with many users and much of history.

Make sure repositores are up-to-date

sudo apt-get update

Install required dependencies and build tools

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

Pull out source codes

git clone git://gitorious.org/quassel/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

Running Core¶

Screen is a terminal tool which allwos you to leave terminal sessions running background even when you are logged out.

We run quassel in screen so that core keeps running as long as it is killed or the server is restarted

screen
cd quassel
./quasselcore

Now you can shut down your terminal and the quassel core still keeps running.

Later we can reattach to this screen session to check out the quassel core terminal output to see if there has been any problems. Login in and type:

screen -x

Now you should how you left your terminal last time you shut it down.

Starting using it¶

Configuration wizard will guide you through the rest of the setup when you connect to your Quassel core using Quassel client for the first time. Remember to choose PostgreSQL backend instead of SQLite when asked.