======Upgrading from Evergreen 1.2.2.2 to 1.2.2.3 ======

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


=====New prerequisite=====
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**:<code bash>
aptitude install libdatetime-format-mail-perl
</code>

To install the ''DateTime::Format::Mail'' module on other operating systems, issue the following command **as root**:<code bash>
cpan DateTime::Format::Mail
</code>

=====Installing the new version=====

  - Download and unpack http://www.open-ils.org/downloads/Evergreen-ILS-1.2.2.3.tar.gz in a temporary directory.
  - Make a backup copy of all your files, but especially the ''/openils/conf'' directory.
  - Stop Apache.  On some systems this can be accomplished by doing 'sudo service apache2 stop'.
  - Stop Evergreen:<code bash>
su - opensrf
/openils/bin/osrf_ctl.sh -c /openils/conf/opensrf_core.xml -a stop_all</code>  (You may have to change the paths to match your installation.)
  - Perform the [[zzz_archive: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: <code>openils_core openils_web openils_reporter openils_client_xul openils_server_xul evergreen_core</code>
  - Start Evergreen: <code>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</code>
  - Start Apache.  On some systems this can be accomplished by doing 'sudo service apache2 start'.



=====Database Schema Upgrade=====

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 [[zzz_archive:upgrading:1.2.2.0_to_1.2.2.1|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.

  - To upgrade the database schema, issue the following commands against the Evergreen database:<code>
 $ 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]
</code>

If you encounter any errors with this upgrade script please contact the developers on the [[http://open-ils.org/listserv.php|open-ils-dev]] mailing list.

=====More 1.2.2.3 information=====
  * [[history:feature_list_1_2_2|1.2.2 feature summary]]
  * [[http://open-ils.org/downloads.php|Download an Evergreen 1.2.2 release]]
  * [[http://open-ils.org/downloads/ChangeLog-1.2.2.2-1.2.2.3|Subversion change log for 1.2.2.3]]