Difference between revisions of "MOSS/Distribution Specific Instructions"

From OpenUru
Jump to: navigation, search
m (NetBSD pkgsrc)
m (Undo revision 982 - forgot this was in the Setup page)
Line 43: Line 43:
Then set db_user=moss in moss_backend.cfg.
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.
== Additional Notes ==
== Additional Notes ==

Revision as of 23:11, 4 April 2011

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;
su -m pgsql -c "psql postgres -f moss.sql"

Then set db_user=moss in moss_backend.cfg.

Additional Notes