User:Bourke/Sandbox

Richard Bourke Sandbox

Pubman 628 Local Installation Setup

Purpose of Document This Document is written to give fuller information on the steps to set up a locally running Pubman 6.2.8 Server on your Local Machine, together with all the complicated software stack on which it depends. "Installation Verification Checks" at each stage are provided, and some links to further useful documentation.

Intended Audience of this Document Developers, Administrators or Archivists / Librarians with reasonable PC skills, who wish to see for themselves what Pubman and EsciDoc may offer for benefits, and look behind the scenes at the infrastructure involved.

Scope and dependencies of this Document This Document is written in July/August 2011 and is based on the then current tested Pubman Production and Demonstration Environment. Pubman Release: 6.2.8 EsciDoc Core-Services: 1.2 Oracle Java 6 SDK: 1.6_24 JBoss Application Server: 4.2.2 Postgres: 8.4.8

Limits of this Document Time constraints prevent the documentation of a installation instructions for all tested Pubman and Escidoc Environment. Specifically, this document only describes installation of Pubman 6.2.8 with two tested operating systems environments (Linux (Distribution: Ubuntu 10_04 Desktop 32 Bit) and Windows (Windows 7 Professional 32 Bit) and one tested Database environment (Postgres 8.4).

Current Documentation

Here is the at time of writing current documentation on Pubman and Escidoc standalone installation, upon which this document attempts to expand.

Pubman Download Page retrieved July 2011

which makes reference to the EsciDoc Core-Services Installation page. Regrettably at time of writing the dependencies listed on the first page are out of date. Pubman 6.2.8 has a prerequisite of ESciDoc Core-Services Release 1.2, not Release 1.1.3 / 1.1.4 as stated there. The downloads listed on the page are, however, correct and up to date.

Installation of Oracle/Sun Java 6 JDK

Installation on Windows

Download the latest version of the JDK (alternative names, Java SE) from the Oracle Download Site and install to for example under c:\dev. Note that the download runs through twice. Once to install the Java Developer Kit, once to install the Java Runtime Environment.

Here are some screenshots of this (use of highlighting indicates that default options were changed) :

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

Choice of Download

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

Location of JDK

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

JDK OPtions to install

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

location of JRE

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

Options

Please note that the registration of the product is not in fact necessary, it works without registration too.

Verification of JDK Installation

Open a command window / shell and verify that the following command returns a valid java version

 java -version

Installation of PostgreSQL 8.4

Installation on Linux

The exact syntax varies depending on Linux Distribution. In the case of Ubuntu 10_04 (Lucid Lynx) the following installs and creates the PostgreSQL Server, clients, and graphical clients, and creates the initial database.

 user@hostname:~$ sudo apt-get install postgresql pgadmin3 postgresql-contrib

The Ubuntu Community Documentation gives further tips. At an absolute minimum, you will need to set the database password of the postgres DB-User to a known value for the later installation steps

Installation on Windows

The "Postgres Plus" 8.3 or 8.4 Download from EnterpriseDB.com contains a good graphical installer. Pubman is not yet tested with the newer Version PostgreSQL 9.0

Notes on the following screenshots. Postgres uses both an OS Userid (Machinename)\postgres on windows and a DB-internal userid postgres.

On some Windows machines, the graphical creation of the initial postgres database under the OS-Userid will fail unless the windows service "Secondary Login" is running.

File:Pg 1.PNG

Language selection

File:Pg 2.PNG

Install everything

File:Pg 3.PNG

Add OS User and Password

File:Pg 4.PNG

Do not install EnterpriseDb addons

File:Pg 5.PNG

Do create the initial DB

File:Pg 6.PNG

And if it fails, start the secondary logon service

File:Pg 7.PNG

installation is ready to start

Verification of PostgreSQL Installation

On both Windows and Linux, the graphical query and managementclient pgAdmin III is now installed. You can use this to connect via the postgres DB-User and the password you set for this. you will see a range of example and catalog databases installed

Caution: Use of SQL to change either catalog or Escidoc or Pubman data will work, will leave your Postgresql Server in an inconsistent state, and will lead to us telling you to reinstall the whole product stack.

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

the connection properties to connect to the catalog

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

The catalog tables under pg_catalog expanded

Troubleshooting the Installation

missing pubman.properties in jboss/server/default/conf

Software Development Kit

Open source Java EE-based application server

Enhanced Scientific Documentation

Java Development Kit

Java Runtime Environment

Operating System

Structured Query Language

Enterprise Archive File Formate