Project

General

Profile

Test » History » Version 5

Version 4 (miohtama, 05/17/2009 12:58 PM) → Version 5/8 (miohtama, 05/17/2009 01:02 PM)

h1. Building Quassel core with PostgreSQL support on Ubuntu Hardy

Make sure repositores are up-to-date
<pre>
sudo apt-get update
</pre>

<pre>
sudo apt-get install git-core postgresql-8.3 qt4-dev-tools libqt4-dev libqt4-sql-psql
</pre>

Pull out source codes
<pre>
git clone git://git.quassel-irc.org/quassel.git
</pre>

Build it
<pre>
cd quassel
cmake .


</pre>

Setup PostgreSQL "Setup postgres database master user

"Follow these instructions":https://help.ubuntu.com/community/PostgreSQL

Setup quassel PostgreSQL database:

<pre>
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
</pre>

Create SSL certificate:

<pre>
openssl req -x509 -nodes -days 365 -newkey rsa:1024 -keyout ~/.config/quassel-irc.org/quasselCert.pem -out ~/.config/quassel-irc.org/quasselCert.pem
</pre>
user":https://help.ubuntu.com/community/PostgreSQL