OpenPsa 2 installation

OpenPsa 2 is currently in preview state. It can be used for production setups, but some problems and errors may appear. Your mileage may wary. For critical setups, please install OpenPsa 1 instead.

Midgard installation

Install latest Midgard 1.7.3 or newer and set up a fresh database with datagard

Fix the broken repligard table:

alter table repligard add column author int(11) not null default 0;

MidCOM installation

Install latest CVS version of MidCOM

Import the SQL files from lib/midcom/config/mgdschema/sql/ into your MySQL:

# mysql midgard < midcom-head/lib/midcom/config/mgdschema/sql/midcom_dbobjects_full.sql

create file includes.xml to MIDGARD_PREFIX/share/midgard/schema

<?xml version="1.0" encoding="UTF-8"?>
<Schema xmlns="http://www.midgard-project.org/repligard/1.4">
<!--
    <include name="/full/path/to/schemafile" />
-->
</Schema>

Include the MidCOM components schemafiles, in MIDGARD_PREFIX/share/midgard/schema/includes.xml (inside ) add lines:

<include name="MIDGARD_PREFIX/share/midgard/midcom-head/lib/midcom/config/mgdschema/midcom_dbobjects.xml" />
<include name="MIDGARD_PREFIX/share/midgard/midcom-head/lib/net/nehmer/branchenbuch/config/mgdschema.xml" />
<include name="MIDGARD_PREFIX/share/midgard/midcom-head/lib/net/nehmer/jobmarket/config/mgdschema.xml" />
<include name="MIDGARD_PREFIX/share/midgard/midcom-head/lib/net/nehmer/mail/config/mgdschema.xml" />
<include name="MIDGARD_PREFIX/share/midgard/midcom-head/lib/net/nehmer/marketplace/config/mgdschema.xml" />

in your Apache virtualhost config for openpsa host add line:

MidgardSchema "MIDGARD_PREFIX/share/midgard/schema/includes.xml"

Install the MidCOM indexer

Switch your Virtual Host to use the correct MidCOM static directory

# ln -s  MIDGARD_PREFIX/share/midgard/midcom-head/static /var/lib/midgard/vhosts/YOUR_HOST_NAME/80/midcom-static

OpenPSA installation

Install the layout-openpsa.xml style file using datagard
Install the OpenPSA components
- best way to keep up to date is to make a CVS export of the OpenPSA source tree and symlink MIDCOM_ROOT/lib/org/openpsa to src/fs-midcom/openpsa directory of OpenPSA. For example:
```
# ln -s PATH_TO_OPENPSA_CHECKOUT/src/fs-midcom/openpsa/ MIDGARD_PREFIX/share/midgard/midcom-head/lib/org/openpsa
```

Import the SQL files (though not the _delete ones, they're for backtracking) from org.openpsa.core to your Midgard database. For example:

# mysql -f midgard < midcom-head/lib/org/openpsa/core/sql/org_openpsa_contacts.sql
# mysql -f midgard < midcom-head/lib/org/openpsa/core/sql/org_openpsa_calendar.sql
# mysql -f midgard < midcom-head/lib/org/openpsa/core/sql/org_openpsa_documents.sql
# mysql -f midgard < midcom-head/lib/org/openpsa/core/sql/org_openpsa_projects.sql
# mysql -f midgard < midcom-head/lib/org/openpsa/core/sql/org_openpsa_queries.sql
# mysql -f midgard < midcom-head/lib/org/openpsa/core/sql/org_openpsa_spammer.sql
# mysql -f midgard < midcom-head/lib/org/openpsa/core/sql/metadata_tmp.sql

Include OpenPSA schemafile, in MIDGARD_PREFIX/share/midgard/schema/includes.xml (again, inside ) add line:

<include name="MIDGARD_PREFIX/share/midgard/midcom-head/lib/org/openpsa/core/org_openpsa_mgschema.xml" />

After this you can proceed to OpenPsa 2 setup.