MOSS/Distribution Specific Instructions

This document is meant to collect any known distribution-specific instructions for installing MOSS. There are two main parts: installing the prerequisite packages, and setting up the PostgreSQL database. Feel free to add any other notes you may find useful.

Prerequisite Packages

NetBSD pkgsrc

Only PostgreSQL and the autotools are needed. You can build the packages or use the prebuilt packages with pkg_add.

pkg_add automake
pkg_add libtool
pkg_add libpqxx

I recommend starting with libpqxx because it seems to lag the postgresql-client package, and installing libpqxx will get the correct client.

pkg_add postgresqlNN-server

Get the version number to match the client installed for pqxx.

Now follow the instructions:

• copy /usr/pkg/share/examples/rc.d/pgsql to /etc/rc.d/pgsql
• chmod 555 /etc/rc.d/pgsql
• append pgsql=YES to /etc/rc.conf

Database Setup

NetBSD pkgsrc

Copy moss_uuidgen.so to /usr/pkg/lib/postgresql/

The database user is pgsql. It has root access to the DB by default. Connect from localhost (the default).

Create the database:

su -m pgsql -c "psql postgres"
create database moss with encoding='UTF8';
\c moss
create role moss with login;
\q
su -m pgsql -c "psql postgres -f moss.sql"

Then set db_user=moss in moss_backend.cfg.

If you want to connect to the moss DB you can now use "psql -U moss" instead of having to su to the pgsql user.