We recently updated from 3.0 to 3.2 and we are testing a 3.4 installation. Here are the steps we used to complete the update: 1. Restore data from most recent mysqldump: 30 to 40 minutes Employ the drop table list for koha_pro to batch drop individual tables, or DROP DATABASE koha_pro ; CREATE DATABASE koha_pro ; koha_pro< [path to/] kohamainbakup.sql 2. Run update script to conform database: 20 to 20 minutes installer/data/mysql/updatedatabase.pl 3. [Koha 3.4 UPDATE REQUIRES, not neccessary for earlier version updates!!!] Run data cleanup: misc/maintenance/remove_items_from_biblioitems.pl 4. Modify the zebra configuration to allow enough memory to process MARC xml: koha/koha-dev/etc/zebradb/zebra-biblios.cfg change lines /var/lib/zebradb/biblios/register:4G to 40G var/lib/zebradb/biblios/shadow:4G to 40G (we also raised the RAM allocation from 50M to 120M) 5. Rebuild Zebra indexing. A. Run as koha user, not as root - requires ./ to run script, perl directory is kohaclone. B. [To prevent cronjob conflict, disable cronjobs, create donotindex folder, or run from crontab. Remember to re-enable these on the working server, so that future item changes may be indexed for search.] ./kohaclone/misc/migration_tools/rebuild_zebra.pl -b -x -r [Add a -v for verbose output] ./kohaclone/misc/migration_tools/rebuild_zebra.pl -a -r [Add a -v for verbose output] [Note: The -x rebuilds the xml for the MARC record.] If index does not rebuild correctly, run an additional rebuild_zebra.pl -b to restore the index. Check that items are barcode scanning properly. [Our cronjobs index with the -z switch (only updates selected zebraqueue records), instead of the -x -r, which takes longer, however -z only re-indexes items in the zebraqueue!] 6. Copy over staffglobal.css changes, if customized: /kohaclone/koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css 7. Copy over custom page templates - for example, Acqui template (acqui-home.tmpl) changes: /kohaclone/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/acqui-home.tmpl 8. Copy over koha.pm patch, enables status "Available" when item status list is customized (e.g."MENDING"). /kohaclone/C4/koha.pm (removes "$selected &&" [line 1006 in the koha.pm from v3.2]) 9. Copy modified staff client login logo to /kohaclone/koha-tmpl/intranet-tmpl/prog/img/koha-logo-medium.gif 10. IP addressing: Either 1. New server takes IP address from old server, or 2. Firewall settings need to be adjusted for new server IP address. Apache and MySQL configuration may need to be adjusted in /etc: mysql/bind.cnf, hosts, apache2/koha [Port configuration in koha-conf may need to be adjusted] 11. Update Koha Extras [Applies only to external php custom-script servers hosting kohaextras3] IP address problem: Scripts on the php server are directed to the IP address of the older version of Koha. Either the scripts must be adjusted (search and replace) or the new Koha must take the IP of the old Koha. 12. Lock down security; harden the web server: Restrict access to root account. Limit access to GUI, restrict access to command-line-only. Harden Apache configuration. Test remote access filtering, restricted to specified IP addresses. -- end -- -- View this message in context: http://koha.1045719.n5.nabble.com/Our-Koha-Update-Steps-tp4521037p4521037.ht... Sent from the Koha - Discuss mailing list archive at Nabble.com.