Društvo LJUDMILA
Rozmanova ulica 12
1000 Ljubljana
Slovenia
Prostori: osmo/za

WDBI Installation

Things you'll have to do before WDBI runs:

get source from sf cvs

cvs -d:pserver:anonymous@wdbi.cvs.sourceforge.net:/cvsroot/wdbi login
cvs -z3 -d:pserver:anonymous@wdbi.cvs.sourceforge.net:/cvsroot/wdbi co -P wdbi

cd wdbi
cvs update

dependencies

apt-get install libipc-shareable-perl libschedule-cron-perl libtext-unaccent-perl \
libapache-session-perl libapache-request-perl libapache-dbi-perl libtext-csv-perl \
libapache-request-perl libxml-libxml-perl graphviz libnet-ssleay-perl \
libcrypt-ssleay-perl libdate-calc-perl libdbd-pg-perl \
libtie-dbi-perl libjson-perl python-feedparser libxml-rss-perl libmailtools-perl

our perl modules

perl Makefile.PL
make install

installs perl modules

make install-mason

installs mason scripts to /usr/share/wdbi/mason/

make install-sql

installs SQL files to /usr/share/wdbi/sql/

configure apache

  • edit etc/httpd.conf (note no leading / !)
ln -s etc/conf.d /etc/apache-ssl/conf.d/wdbi.conf

prepare the database

# su - postgres
$ createlang plperl template0
$ createlang plperlu template0
$ createlang pgsql template0
create group httpd;
create user apache; 
alter group httpd add user apache;
create user "www-data"; 
alter group httpd add user "www-data";
create group wdbi;
create user wdbi createuser createdb; 
alter group wdbi add user wdbi;
create user root createuser createdb;
create schema authorization wdbi;
set search_path=wdbi,pg_catalog;
alter user apache set search_path=wdbi,pg_catalog;
alter user "www-data" set search_path=wdbi,pg_catalog;
\i all.sql

TODO: naloadat sistemske enume

restart web server

Optional

  • configure wdbi/kiki

put file in /etc/wdbi/www.example.org/ ???? commandline needs this