Hi Alexander, On Nov 24, 2014, at 3:04 AM, Wagner, Alexander <[email protected]> wrote: > There's an upgrade guide on the website defining the actions you need to do. > One point you may have missed is, that you should dump and upload your old DB > to the new box. Invenio has some functions to upgrade the db and you're with > your data then on the new sytem.
Thanks! I may have missed the guide, but everything I've found so far seems specific to upgrading an existing installation (as opposed to migration to a new installation). A link to any instructions I may have missed would be greatly appreciated. My first attempt: - mysqldump database from old server, and import to new mysql server - rsync .../var/data over from old 1.0.1 server to the new 1.1.4 server Failed with: OperationalError: (1054, "Unknown column 'sequenceid' in 'field list'") (connections.py:36:defaulterrorhandler) I then tried: - starting with a clean installation of 1.0.1 on the new server and db. - mysqldump database from old server, and import to new mysql server - rsync .../var/data over from old 1.0.1 server to the new 1.0.1 server - run through the normal Upgrade notes (http://invenio-software.org/blog/invenio-1.1.4) "make check-upgrade" is now complaining that bibsched is running, even though I'm sure it isn't. /usr/bin/python ./modules/miscutil/lib/inveniocfg_upgrader.py . --upgrade-check >>> Following upgrade(s) have not been applied yet: >>> * invenio_release_1_1_0 (Invenio 1.0.x to 1.1.0 upgrade) >>> * invenio_2012_11_21_aiduserinputlog_userid_check (Check existence of >>> aidUSERINPUTLOG.userid column) >>> * invenio_2013_09_10_new_param_websubmit_function (New 'prefix', 'suffix', >>> 'button_label', 'button_prefix' and 'dates_conversion' parameters for >>> Create_Modify_Interface WebSubmit function) >>> * invenio_2012_11_01_lower_user_email (Lowering user.email values) >>> * invenio_2013_11_12_new_param_websubmit_function (New >>> 'deferRelatedFormatsCreation' parameter for Create_Upload_Files_Interface >>> WebSubmit function) >>> * invenio_2013_10_25_new_param_websubmit_function (New >>> 'directRelationshipMARC', 'reverseRelationshipMARC' and 'bibuploadMode', >>> parameters for Link_Records WebSubmit function) >>> * invenio_2012_11_15_hstRECORD_marcxml_longblob (Increase of >>> hstRECORD.marcxml storage to longblob) >>> * invenio_2012_10_31_tablesorter_location (Standardisation of the jQuery >>> tablesorter location) >>> Running pre-upgrade checks... >>> pre_check_custom_templates: Checking custom templates... >>> pre_check_bibsched: Checking bibsched process... >>> invenio_release_1_1_0: Invenio version v1.0.0 detected. >>> ERROR: Pre-upgrade check for pre_check_bibsched failed with the following >>> errors: (-) Bibsched is running. Please stop bibsched using the command: /mnt/documents/invenio-1.1.4/bin/bibsched stop >>> ERROR: Upgrade check failed. Aborting. make: *** [check-upgrade] Error 1 Any more suggestions would be greatly appreciated. Thanks again, Devin > We're attempting to upgrade our Invenio installation from 1.0.1 on 32-bit SL5 > to 1.1.4 on a new 64-bit SL6 host. > > OLD > Invenio v1.0.1 > 32-bit SL5 > mysql 4.1.22 > > NEW > Invenio v1.1.4 > 64-bit SL6 > mysql 5.1.73 > > How would you recommend we proceed with this upgrade? We're able to get a > clean installation running fine on SL6, but so far haven't succeeded in > porting over our existing collections and documents. > > Many thanks, > Devin > > -- > Kind regards, > > Alexander Wagner > > Deutsches Elektronen-Synchrotron DESY > Library and Documentation > > Building 01d Room OG1.444 > Notkestr. 85 > 22607 Hamburg > > phone: +49-40-8998-1758 > fax: +49-40-8994-1758 > e-mail: [email protected]
