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.
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.
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
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.