• Issue the following SQL in your Evergreen database

CREATE TABLE money.goods_payment () INHERITS (money.bnm_payment);
ALTER TABLE money.goods_payment ADD PRIMARY KEY (id);
CREATE INDEX money_goods_id_idx ON money.goods_payment (id);
CREATE INDEX money_goods_payment_xact_idx ON money.goods_payment (xact);
CREATE INDEX money_goods_payment_payment_ts_idx ON money.goods_payment (payment_ts);
CREATE INDEX money_goods_payment_accepting_usr_idx ON money.goods_payment (accepting_usr);

1. Download and unpack http://www.open-ils.org/downloads/Evergreen-ILS-1.2.1.0.tar.gz in a temporary directory.
2. Make a backup copy of all your files, but especially the conf directory.
3. Stop Apache. On some systems this can be accomplished by doing 'sudo service apache2 stop'.
4. Stop Evergreen by doing 'sudo -u opensrf /openils/bin/osrf_ctl.sh -c /openils/conf/opensrf_core.xml -a stop_all'. (You may have to change the paths to match your installation.)
5. Perform the server_installation steps relevant to your platform; typically you can skip the prerequisites and go directly to the section that includes 'make config' and ends with 'sudo make install'. WARNING: You will DESTROY your Evergreen database if you supply 'openils_all evergreen_core' for the Build_targets part of 'make config'. Instead, use the following Build_targets:

   openils_core openils_web openils_marcdumper openils_reporter openils_client_xul openils_server_xul

6. Check the files in the conf directory; if they have been overwritten by new versions, copy your old configuration files from the backup you made.
7. Start Evergreen:

   sudo -u opensrf /openils/bin/osrf_ctl.sh -c /openils/conf/opensrf_core.xml -a start_router
   sudo -u opensrf /openils/bin/osrf_ctl.sh -c /openils/conf/opensrf_core.xml -a start_perl
   sudo -u opensrf /openils/bin/osrf_ctl.sh -c /openils/conf/opensrf_core.xml -a start_c

8. Start Apache. On some systems this can be accomplished by doing 'sudo service apache2 start'.

• The IP-redirection (changing the default OPAC location based on client IP) handler has improved. If you wish to enforce IP redirection, configure your IP ranges in /openils/conf/lib_ips.txt and add the following to your Apache startup.pl file:

use OpenILS::WWW::Redirect qw(/openils/conf/opensrf_core.xml);
OpenILS::WWW::Redirect->parse_ips_file('/openils/conf/lib_ips.txt');

• Then, in /etc/apache2/eg_vhost.conf, remove this:

RedirectMatch 301 ^/$ /opac/en-US/skin/default/xml/index.xml

• And add this:

<LocationMatch ^/$>
    SetHandler perl-script
    PerlHandler OpenILS::WWW::Redirect
    PerlSendHeader On
    allow from all
</LocationMatch>