Test » History » Version 5
  miohtama, 05/17/2009 01:02 PM 
  
| 1 | 1 | miohtama | h1. Building Quassel core with PostgreSQL support on Ubuntu Hardy  | 
|---|---|---|---|
| 2 | 1 | miohtama | |
| 3 | 3 | miohtama | Make sure repositores are up-to-date  | 
| 4 | 1 | miohtama | <pre>  | 
| 5 | 3 | miohtama | sudo apt-get update  | 
| 6 | 1 | miohtama | </pre>  | 
| 7 | 1 | miohtama | |
| 8 | 3 | miohtama | <pre>  | 
| 9 | 3 | miohtama | sudo apt-get install git-core postgresql-8.3 qt4-dev-tools libqt4-dev libqt4-sql-psql  | 
| 10 | 3 | miohtama | </pre>  | 
| 11 | 3 | miohtama | |
| 12 | 3 | miohtama | Pull out source codes  | 
| 13 | 3 | miohtama | <pre>  | 
| 14 | 3 | miohtama | git clone git://git.quassel-irc.org/quassel.git  | 
| 15 | 3 | miohtama | </pre>  | 
| 16 | 3 | miohtama | |
| 17 | 3 | miohtama | Build it  | 
| 18 | 3 | miohtama | <pre>  | 
| 19 | 3 | miohtama | cd quassel  | 
| 20 | 3 | miohtama | cmake .  | 
| 21 | 5 | miohtama | </pre>  | 
| 22 | 3 | miohtama | |
| 23 | 5 | miohtama | Setup PostgreSQL database master user  | 
| 24 | 5 | miohtama | |
| 25 | 5 | miohtama | "Follow these instructions":https://help.ubuntu.com/community/PostgreSQL  | 
| 26 | 5 | miohtama | |
| 27 | 5 | miohtama | Setup quassel PostgreSQL database:  | 
| 28 | 5 | miohtama | |
| 29 | 5 | miohtama | <pre>  | 
| 30 | 5 | miohtama | sudo -i  | 
| 31 | 5 | miohtama | sudo -u postgres psql  | 
| 32 | 5 | miohtama | postgres=# CREATE USER quassel ENCRYPTED PASSWORD 'somepassword';  | 
| 33 | 5 | miohtama | CREATE ROLE  | 
| 34 | 5 | miohtama | postgres=# CREATE DATABASE quassel WITH OWNER quassel ENCODING 'UTF8';  | 
| 35 | 5 | miohtama | CREATE DATABASE  | 
| 36 | 3 | miohtama | </pre>  | 
| 37 | 1 | miohtama | |
| 38 | 5 | miohtama | Create SSL certificate:  | 
| 39 | 5 | miohtama | |
| 40 | 5 | miohtama | <pre>  | 
| 41 | 5 | miohtama | openssl req -x509 -nodes -days 365 -newkey rsa:1024 -keyout ~/.config/quassel-irc.org/quasselCert.pem -out ~/.config/quassel-irc.org/quasselCert.pem  | 
| 42 | 5 | miohtama | </pre>  |