NOTE: Because version 1.2.2.3 is a very minor upgrade, and meant to be a direct replacement for 1.2.2.2 for brand new installations only, a modified set of the 1.2.2.2 upgrade instructions are included below. Take note, however, that there is a new upgrade SQL script that should be run for 1.2.2.3. You do not need to upgrade from 1.2.2.1 to 1.2.2.2 before upgrading to 1.2.2.3 as long as you process the 1.2.2.2-1.2.2.3-upgrade.sql script.

As of 1.2.2.2, the Perl module DateTime::Format::Mail is required to properly format dates in RSS2 feeds.

To install the DateTime::Format::Mail module on Debian or Ubuntu, issue the following command as root:

aptitude install libdatetime-format-mail-perl

To install the DateTime::Format::Mail module on other operating systems, issue the following command as root:

cpan DateTime::Format::Mail

1. Download and unpack http://www.open-ils.org/downloads/Evergreen-ILS-1.2.2.3.tar.gz in a temporary directory.
2. Make a backup copy of all your files, but especially the /openils/conf directory.
3. Stop Apache. On some systems this can be accomplished by doing 'sudo service apache2 stop'.
4. Stop Evergreen:

   su - 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 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_reporter openils_client_xul openils_server_xul evergreen_core

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

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

Two changes to the database, support for importing circ counts from a legacy ILS and improved search term normalization for date ranges, have been added. To facilitate these changes an SQL upgrade script is supplied with the Evergreen source distribution. Database upgrade procedures for version 1.2.2.2 must be in place before running this script. Instructions for upgrading from 1.2.2.1 and before can be found here.

These instructions assume that PostgreSQL is running on the local machine, there is a database called 'evergreen', a database user called 'evergreen' and a database password of 'password'. Modify these settings as required.

1. To upgrade the database schema, issue the following commands against the Evergreen database:

    $ cd Evergreen-ILS-1.2.2.3/Open-ILS/src/sql/Pg/
    $ PGUSER=postgres PGHOST=127.0.0.1 psql evergreen -W -f 1.2.2.2-1.2.2.3-upgrade-db.sql
      Password: [password]

If you encounter any errors with this upgrade script please contact the developers on the open-ils-dev mailing list.

• 1.2.2 feature summary
• Download an Evergreen 1.2.2 release
• Subversion change log for 1.2.2.3