Entry Under Construction

Contents of this page may be incomplete or temporarily inaccurate.
Also, this process involves new features.

Overview

This installation procedure can be used to install the BizTalk People Ingest application on a Debian Lenny operating system by a system administrator. This utility must be installed on the same server as the Harvester in order to function. This installation includes instructions for configuring the Harvester to allow for DSR harvesting.

Installation

Prerequisites

  • Debian Lenny Operating System (Linux OS)
  • VIVO 1.2.x installed and configured to use MySQL as a back end
  • MySQL user configured properly for localhost access
  • Harvester 1.3.x Installed and configured to communicate with the VIVO database
  • Mail transfer agent configured for outbound mail

Harvester Configuration

  • Ensure that /usr/share/vivo/harvester/example-scripts/example-peoplesoft-biztalk/vivo.model.xml settings match setting in vivo deploy.properties (see VIVO Installation Documentation).
  • nano ../harvester/example-scripts/example-peoplesoft-biztalk/jdbcfetch.config.xml
  • jdbc:jtds:sqlserver://IPADDRESS:PORT/DATABASENAME
  • USERNAME
  • PASSWORD

Download Peoplesoft-Biztalk Reproducible Harvest

Configure peoplesoft-biztalk.sh

  • sudo nano peoplesoft-biztalk/bin/peoplesoft-biztalk.sh
  • EMAIL_RECIPIENT = your_email_address@example.com
  • HARVESTER_INSTALL_DIR = “/usr/share/vivo/harvester”
  • Configure Indexing
    • Enter local admin login credentials in the indexing section under ADMINNAME and ADMINPASS for the web interface
    • Enter the Vivo address base for the local installation into VIVOBASE. Be sure to include the trailing /.
  • cntrl-O (writes out the edited script)
  • cntrl-X (exits the nano editor)

Harvest the data by executing the Peoplesoft-Biztalk shell script

  • cd /usr/share/vivo/vivo-auto-harvest/peoplesoft-biztalk/bin
  • ./peoplesoft-biztalk.sh
  • Wait for console output to state “End People Ingest Run” (This may take several hours depending on the size of the harvest)
  • Wait for the email log shortly thereafter
  • Review data in VIVO web application
  • Review Harvester log file in /usr/share/vivo/harvester/logs/peoplesoft-biztalk.DATETIME.harvester.1.1.x.log

Watch logs

  • tail -f /usr/share/vivo/vivo-auto-harvest/peoplesoft-biztalk/log/peoplesoft-biztalk... (append the date of your log file)

Schedule cron job in root’s crontab

  • Copy example from /usr/share/vivo/vivo-auto-harvest/peoplesoft-biztalk/bin/example.cron
  • Enter root’s crontab using sudo su -m
  • Paste example cron entry, which should look like:
  • After unpacking, a directory called “peoplesoft-biztalk” should be created inside the “vivo-auto-harvest” directory. Inside this directory are the following folders and files:
    • Directory Structure
      • ---- bin (folder, storage for scripts to be executed)
      • -------- peoplesoft-biztalk.sh (file, shell script executed)
      • -------- example.cron (example entry to be placed in root’s crontab)
      • ---- log (folder, storage for log output)
  • No labels

All content on the LYRASIS Wiki is licensed under the CC BY (Attribution) license, unless otherwise noted.