gg_installation_guide. - Germplasm Resources Information Network

herbunalaskaData Management

Jan 30, 2013 (4 years and 9 months ago)

225 views


GRIN
-
Global
Installation Guide



Revision Date

November
10
, 2010

This guide contains
an overview and
step
-
by
-
step directions for installing the
GRIN
-
Global
programs
,
including the
Curator Tool.












If you will be running the Curator Tool and acc
essing data from a remote server, you will not need to
install the server applications that are explained within these pages. Instead, load the
Updater

program
and the
Curator Tool
; follow the detailed steps which begin on pages
12

(Updater)

and
21

(Curator Tool).


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
3


Table of Contents



Special Notes

................................
................................
................................
................................
.................

4

Security Setti
ngs

................................
................................
................................
................................
........

6

Components of
GRIN
-
Global

................................
................................
................................
.........................

8

Background Information

................................
................................
................................
...........................

8

General Requir
ements When Installing the Database on a Local Host

................................
..................

11

Microsoft Prerequisites

................................
................................
................................
...........................

11

Updater

................................
................................
................................
................................
.......................

12

Step
-
by
-
Step Installation Directions

................................
................................
................................
.......

12

Determining if Your
GRIN
-
Global
Software is Current

................................
................................
............

19

Curator Tool:
Insta
lling (or Updating)

................................
................................
................................
.........

21

Server Components: Installing (or Updating)

................................
................................
.............................

24

Default and Custom Installation Options

................................
................................
................................

25

General Requirements


Installing Microsoft Applications

................................
................................
....

25

Database (Installing)

................................
................................
................................
................................
...

26

Step
-
by
-
S
tep Directions

................................
................................
................................
..........................

26

Notes on Selecting a Database

................................
................................
................................
...............

27

SQL Server (Installing)

................................
................................
................................
.............................

28

Database Setup Wizard

................................
................................
................................
...........................

31

Search Engine (Installing)

................................
................................
................................
............................

34

Adding a User to the Local SQL Server Database Administrator’s Group
................................
...................

37

Step
-
by
-
Step Procedure

................................
................................
................................
..........................

37


Special Notes

P a g e

|
4

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


Special Notes


1.

After
you have installed
everything
and are ready to start the Curator Tool

(CT)

to review and
add data, use the pre
-
bu
ilt test accounts already on the database.


The valid user accounts are
test1
,
test2
,
test3
,
test4
…,
test19
,
test20
. (Passwords are the same
as the user name. User

accounts
test
16

-
20

are set up with languages other than English, the
others are all Engli
sh. See
User Language Settings

on page
7

for details.)


Note that
test1

has the "All Access" permission

let
ting
her
read/write anything in the database.
However,
s
he can't login to Admin Tool wi
th
test1
, because
s
he is not part of the
"Administrators" group. So essentially
s
he has the same rights as an admin
in the
CT, but is not
considered an administrator from the Admin Tool's perspective.

(
admin1

is an
Admin Tool
administrator.)


You will see

a dropdown box in the login dialog labeled “
Connect To:
” below the user name and
password text boxes. You can specify which server the Curator connects to, but for testing
purposes use “localhost.” After you have had a successful experience with one or
more of the
test users, feel free to review the Administrator Tool documentation regarding user account
management and try creating your own users for further testing.

2.

Security is automatically enabled on the RC2 version of the GRIN
-
Global system. We a
re
recommending that you leave security enabled for your testing on RC2 unless your local site
intends to run the GRIN
-
Global system with security disabled in final installation (“production
mode”).


(See
Security Settings

on pag
e
6

for a brief discussion on globally disabling security.)


3.

If you leave security enabled, please remember that all users (except
user
t
est1

which has full
access

rights
) have READ
-
ONLY privileges for all tables. The
t
est1

user

has READ/WRITE
privileges for all tables in the GRIN
-
Global system


and thus is the only user that can add data
to the GRIN
-
Global system “out
-
of
-
the box.” You will need to use the Administrator Tool to
grant other users WRITE privileges to tables (plea
se see
Administrator
Guide

for instructions on
how to grant users security privileges).



4.

If you have a version of GRIN
-
Global server software installed that is older than 1.5
.1167 we are
recommending that you manually un
-
install the server components using the newest version of
the Updater by clicking the “Uninstall” link on the right
-
hand side of the component list.




(The latest version of the Updater program is available
on

http://test.grin
-
global.org/gringlobal/downloads/default.aspx
).

Special Notes


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
5


After you have manually un
-
installed the legacy server components, you are ready to install the
RC2 version o
f GRIN
-
Global System.


5.

This system has been rigorously tested with the Microsoft SQL Server database engine, but has
had only cursory testing in MySQL, PostgreSQL, and Oracle database engines. Please perform
your primary testing of RC2 with the SQL Se
rver database engine, but feel free to experiment
with the other database engines if you are so inclined.


6.

What you are installing is the Full Server System capable of handling very large datasets and
large user communities. Because you are essentiall
y installing a complete suite of server
components, the complete download and installation requires more than two hours


especially
if some of the Windows OS components required by GRIN
-
Global have not been previously
installed.


7.

For security reasons i
n some organizations, a user’s PC may be setup so that the user does not
have full Windows Administrator rights to his / her PC even though that user may be the primary
(or only) user of the PC. When that is the case, the organization’s PC Administrator,
usually
someone from the organization’s Information Technology or Security group, will need to install
GRIN
-
Global
.


The administrator will also need to perform an additional step if the
GRIN
-
Global
user will be accessing data on her local PC. For complet
e directions on adding the user to the
local SQL Server database administrator’s group, see

Add
ing a “Regular
User
…”

on page
37
.


8
.

Please read the manuals! They will help you install the system and help you understan
d what
the capabilities are as you test GRIN
-
Global. The latest guides are on the wiki training page:
http://www.grin
-
global.org/index.php/Training



Special Notes

P a g e

|
6

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc



Security Settings

1.

Beginning with
Release

Candidate

2 (RC2), security is enabled by default.

If you prefer to globally
disable all security restrictions, in the
Admin Tool
,
select

(1)
Web Application
, (2)
double
-
click

on
DisableSecurity
,
(3) input
True
;
(4)
click
OK
.



Alternatively, if you kee
p security enabled, then individual
test logins cannot create new records
until
you either
add th
e

user
s

to the
Administrators

group or
grant the users “
All
A
ccess


Special Notes


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
7

permission.


User Language Settings

When using UserIDs, note that in this RC2 version th
e UserIDs have been predefined to have a default
language. However, using the Admin Tool, you can easily change the language setting:

(
Users

|
username

|
General

(tab
)

| Language
)



Also, be sure to edit the Language setting for any new user that you cre
ate. The
Enabled

checkbox is
also shown in the screen below; by default it is checked and should remain checked for the user to be
Components of GRIN
-
Global

P a g e

|
8

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


able to use the Curator Tool.


Components of
GRIN
-
Global

Background Information

N
ot all GRIN
-
Global users need to install a
ll
of its
components.

For example, if
a
user’s PC will only access
a GRIN
-
Global database on a remote computer and will not maintain a local database, then only the
Curator Tool needs to be downloaded and installed

on the user’s PC.

Components of GRIN
-
Global


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
9

There are several softw
are components that comprise the GRIN
-
Glob
al germplasm information system:



Updater Program

All

GRIN
-
Global
installations

require the Updater Program to be installed.
(The exception to this is the
case where a user only will be accessing your organizatio
n’s
GRIN
-
Global
Public Website; in that case,
the user only needs her browser to access the website.)

The Updater is then used to install any, or all of, the other

GRIN
-
Global
components.

The installation
directions begin on the page
12
.

A screen image of the Updater is shown on the next page.

Components of GRIN
-
Global

P a g e

|
10

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc



Updater Window


Admin Tool

This tool handles many important administrative “behind the scenes” functions such as adding users,
assigning security privileges, creating data views, and the
bulk importing of data.

Database

When the
GRIN
-
Global Database

component is selected, a local copy of the GRIN
-
Global database is
installed on the user’s PC.

Search Engine

The GRIN
-
Global
Search
Tool

Engine
functions
within the Curator Tool and the Publ
ic Website. The
Search Engine is used to perform “google
-
like” searches on the GRIN
-
Global database.

Web Application (Middle
-
Tier code and the Public Website)

The “Web Application” contains the
actual business layer code

and
hosts
the
web services to acce
ss
the
business layer code
. T
he
middle tier,
web site
, and
web services are all
in
the same
code, hence the
name “
Web Application


instead of

middle tier / web site / web services.



The GRIN
-
Global
Web Application
is the heart of the GRIN
-
Global Applica
tion Suite. It has several
primary features:


the “M
iddle
T
ier


p
rovide
s

end points to which clients can connect, regardless of
Components of GRIN
-
Glo
bal


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
11

which programming language or operating system that client requires
, r
etrieve
s

and update
s

data
;
p
rovide
s

an infrastructure for
reading, creating, or manipulating updatable views of data without code
changes
, w
ork
s

with several different back
-
end database engines transparently
, and e
nforce
s

business
logic (e.g. an accession must belong to a specific taxonomy)
.

The
GRIN
-
Global
Publ
ic Website is a browser
-
based application
that
provides “public” user access to the
database. Users are able to
search and view accession information and will be able to order germplasm
using a browser cart approach.

Web services provide a standard means o
f interoperating between different software applications,
running on a variety of platforms and/or frameworks.

Curator Tool

The
GRIN
-
Global

Curator Tool

is used by curators and users who
creat
e
and manag
e

genebank

data.

Microsoft Tools / Prerequisites

In
order to run the complete
GRIN
-
Global
’s
suite of applications
on a user’s PC, there are additional
(free)
tools
that
originate from
Mi
cro
s
oft

and must be installed. If the user will be using the
Curator Tool

to access data stored on a server,
or will be us
ing only the Public Website,
then the Microsoft tools do
not need to be installed.

(Additional details on the Microsoft prerequisites

are included below
.)


General Requirements

When Installing the Database on a Local Host



T
he user installing
GRIN
-
Global
mu
st have administrator rights to the PC



Requires an Internet browser: Windows Internet Explorer and Mozilla Firefox are supported;
the PC’s browser must be Active
-
X enabled

Hardware requirements:



2

GB Hard drive

space



2

GB RAM

Operating Systems



Windows X
P Service

Pack 3



Windows Vista (Home,

Ultimate; 32
-

or 64
-

bit
)



Windows 7 (
Home, Ultimate; 32
-

or 64
-

bit)

Microsoft Prerequisites

Several Microsoft components are required.
A
t appropriate times
, you will be guided by the installation
wizard to download th
ese Microsoft programs
,

which
will be downloaded from Microsoft’s website
if
they are not already installed on the PC
.
T
hey do not need to be reinstalled
; h
owever,
when
the PC
has
an older version than what is recommended
, you should update to the recommen
ded version
.
(Alternatively, at any time, you can manually download these from Microsoft’s site.)

The Microsoft “Prerequisites”

Component

Function

Windows Installer 4.5


Windows Powershell 1.0


Updater

P a g e

|
12

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


Visual Studio
Tools for Applications
2
.
0


Crystal Repo
rts for Visual Studio 2008


SQL Server 2008


.NET
Framework
3.5

(Service Pack
1
)




Sometimes when installing a Microsoft application, you may be required to reboot. After
rebooting, the Microsoft application will finish installing, but

the
GRIN
-
Global

Updater

program
will not automatically launch and continue. Therefore, when a reboot is involved, you will need
to launch
Updater

manually again
. (Click the Windows
Start button
; select
GRIN
-
Global
Updater
.)


R
eselect the respective
GRIN
-
Global
applicati
on(s) to install; click Download/Install.


When installing
SQL

S
erver
E
xpress
on a Windows 7 64
-
bit operating system
, if you do not have
Windows
Service Pack 1 installed,

a message will warn you
that th
e SQL Server Express
software has a known problem w
ith th
e

operating system. Rather than abort
the installation,
proceed
with the install
,

and then update to
Windows 7
S
ervice
P
ack
1.

Updater

In order to install any
GRIN
-
Global application
,

you first install t
he
GRIN
-
Global
Updater

program.

Step
-
by
-
S
tep Installation Directions

Step 1

Using your browser, such as Microsoft’s Internet Explorer or Mozilla Firefox, download and install the
Updater program from:
http://test.grin
-
glob
al.org/gringlobal/downloads/default.aspx

Updater


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
13

Click the link under the
Installers

section:



Depending on which browser you are using, your next step will vary slightly. Since most browsers
emulate either Microsoft’s Internet Explorer or the Mozilla Firefox b
rowser, steps 2A and 2B were
written to accommodate the differences.



Proceed with
step 2A

if you are using Internet Explorer



Skip to
step 2B

if you are using Firefox or a similar browser

Step 2A: (Using Micro
soft’s Internet Explorer)

The
File Download

window displays. Unless you want to postpone initiating setup, click on the
Run

button to proceed.


Updater

P a g e

|
14

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


An Internet Explorer Security Warning window displays; click
Run
.


The
GRIN
-
Global Updater Setup

window displ
ays:



Proceed to
Step 3

on page
16
.

Step 2
B: (Using Mozilla Firefox)

At the
Open
ing GRIN
-
Global_Updater_Setup.exe

window, click the
Save File

button.


Updater


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
15

Save the file.



Launch the file. (Double
-
click its fil
ename if in Windows Explorer, or if in your
b
rowser, click on the
filename. Click
OK
.)



Updater

P a g e

|
16

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


Click the
Run

button.


Step 3

At the
Setup
-

Security Warning

window, click the
Run

button.



Step
4

For many of the
Updater

windows, just click the
Next

button to
continue.


Updater


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
17

Step
5

On the
Select Installation Folder

window you can change the default folder location and who will have
access to the GRIN
-
Global programs (all users or the current user). Generally, you can accept the
defaults. If a different location is
desired, click
Browse
. (Another option is the
Disk Cost

button which
can be used to determine if you have enough space on your drive. The complete installation requires
less than 1 GB.)

Click
Next

to accept the defaults and continue.



(Optional Step Whe
n the Disk Cost Button is
Selected
)

The
Updater Disk Space

window, indicating available and required space, is displayed when the
Disk
Cost

button on the
Select Installation Folder

window is clicked. Click
OK

to continue.


Updater

P a g e

|
18

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


Step
6

Click
Next

to continue wi
th the Installation process.



Step
7

Click
Close
. Note: If you need to stop, this is a good stopping point.


Updater


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
19

Step
8

[Note: if you interrupt the installation process, you can return to this point via the Windows
Programs

menu by selecting
Start | All Pr
ograms | GRIN
-
Global | GRIN
-
Global Updater
.]


Determining if Your
GRIN
-
Global
Software is Current

The
Updater

window
is
used to check for both server and client updates.
If you are installing only the
Curator Tool client on your PC
, you do not need to d
ownload any of the
server
components
(
listed in the
top half of the
Updater

window
)
.



In this example, the database is outdated. When you initially invoke the Updater, all of the components
will not be current.

Updater

P a g e

|
20

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc



Local vs. Remote


If you do not load th
e server components, then you cannot run the
Curator Tool
locally

using
data stored
i
n your PC’s hard drive. Instead,
you must have a network/Internet connection to
connect to a remote server.

Currently there is a “test” server running in
Beltsville
,
Mary
land, USA
.
The RC2 address
that
should be in the
Download From Server

address box is
:

http://test.grin
-
global.org/gringlobal/gui.asmx



In th
e following window
,
one

of the
s
erver components ha
s

an “Outdated” Status and ha
s

not been
updated
,

whereas the
lower, client panel indicates that the
Curator Tool
has a “Current” status
. If you
will be storing and maintaining a local GRIN
-
Global data on your PC, then you should update the four
server components.


During this initial, testing phase of the GRIN
-
Glob
al project,
we recommend that you load the
entire set of server components including the database onto your PC and run the Curator Tool
locally.

You would then not be dependent on Internet connections to the
Beltsville

servers, etc.

The one disadvantage in

this approach is that the initial downloading/installing takes longer, up
to several hours. Part of this time is due to the downloading of a sample database, as well as the
installation of any prerequisite Microsoft components.





Curator Tool: Installing (or Updating)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
21


Curator Tool:
Insta
lling
(or Updating)

To ensure you have the current version of the Curator Tool, use the
GRIN
-
Global Updater

program. Click
the Windows
Start

button.

On the Start Menu’s recent programs list, click on
GRIN
-
Global Updater
. If
that selection is not displayed,

click on
All Programs | GRIN
-
Global | GRIN
-
Global Updater

.



-
or
-


C
lick the

Check for

Client Updates

button. If the
GRIN
-
Global Curator Tool
Status

is “Outdated,” click the
Download / Install

button.

(In this example, the
GRIN
-
Global
Curator Tool
comp
onent
has
a “Current”
status
;

hence the
Download/Install

button is
not active, since there is no need to download.
)



When the
GRIN
-
Global Curator Tool
component has an “Outdated” status,
click the

bottom

Download/Install

button
;
t
he
Client Installer

prog
ram will
proceed to

download.

Curator Tool: Installing (or Updating)

P a g e

|
22

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc




After the download completes, follow through with the installation wizard; you will be prompted by a
series of screens to continue with the installation. On the
Select Installation Folder

screen, you can keep
the default f
older as listed or indicate a different location to store the Curator Tool. We recommend that
you keep the folder information as it is listed.



Curator Tool: Installing (or Updating)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
23

Click the
Close

button

on the
I
nstallation Complete

screen; this completes a successful installation.




The

Updater window will display the status for the Curator Tool as “Current.”



Server Components: Installing (or Updating)

P a g e

|
24

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc



To Start Up the Curator Tool

After
installing, select
the
GRIN
-
Global

Curator Tool

from the Windows program menu.



or…





You can also add the shortcut to
the
Start menu
or the desktop.
Select
Start | All Programs |
GRIN
-
Global;

h
ighlight the GRIN
-
Global
Curator Tool
program, then right
-
click. Select either
Pin
to Start menu
, or
Create Shortcut

(desktop shortcut), or both.

During the testing phase of GRIN
-
Global, there is

a remote server in
Beltsville
,

Maryland
; the address for
this test server is
http://test.grin
-
global.org/gringlobal/downloads/default.aspx
.



Server Components:
Installing (
or

Up
dating
)


There are four main server components in the
GRIN
-
Global
suite:


GRIN
-
Global
Server
Components Installed via the Updater

Component

Purpose

Admin

Tool for GRIN
-
Global administrators to create new logins (users), new
cooperators, data views, and as
sign security levels

Database

A local copy of the database on the PC

Search Engine

This is the middle tier search engine that performs the actual search
processing against the database

Web Application

The middle tier web services, shopping cart, etc.

[
Curator Tool
]

[
Note:
this
is the
client program
and
will eventually be removed from th
e
Updater
window
,

but for now, during testing
, it is shown at the bottom half
of the Updater window
.

Th
e CT
a
pplication

is
designed primarily for curators
and managers of

genebanks for viewing and manipulating GRIN
-
Global data.
]

Server Components: Installing (or Updating)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
25


Default and Custom Installation Options

When installing any of the GG components, you will first be prompted with an
Install Mode

window in
which you can select either
Default Installation

or
Cus
tom Installation
. Default is recommended and is
the simplest to do; you will not be prompted to confirm intermediate screens. Use the Custom
installation when it is necessary to indicate a specific folder, etc.



General Requirements



In
stalling Microsof
t Applications

When the respective acceptance window displays

for a Microsoft prerequisite program
, click
Accept

to
proceed with the installation.



Sometimes when installing a Microsoft application, you may be required to reboot. After
rebooting, the M
icrosoft application will finish installing, but the
GRIN
-
Global
Updater

program
will not automatically launch and continue. Therefore, when a reboot is involved, you will need
to launch
Updater

manually again. (Click the Windows
Start button
; select
GRIN
-
Global
Updater
.) Reselect the respective
GRIN
-
Global
application(s) to install; click Download/Install.


Database (Installing)

P a g e

|
26

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc



Database

(Installing)

When the
GRIN
-
Global Database

component

is selected
,
a local copy of the GRIN
-
Global database
will
be

installed
on your PC

s hard

d
rive
.

[Note to
RC
2

testers
: we recommend that you follow through with these directions and
install the GRIN
-
Global database on your local PC
. You would then not be dependent on Internet connections to the
Beltsville

servers, etc.]

Step
-
by
-
S
tep Dire
ctions

Step 1

Select
Start | All Programs | GRIN
-
Global | GRIN
-
Global Updater


Step 2

First c
lick the
Check for Server Updates

button.
Use
http://test.grin
-
global.org/gringlobal/gui.asmx

for
the address.

The
Updater

screen displays

the versions and statu
ses for each of the server components.

To run the
Curator Tool
from your local PC, select
all of the C
omponents
listed in the top section (“Server
Database (Installing)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
27

Updates.”)


Notes on
Selecting a Database

When running the Curator Tool locally on your PC’s hard drive, a
database engine is required. The CT has
been tested on the following four database products:



Microsoft SQL Server



MySQL



PostgreSQL



Oracle

If you are installing the Database, Search Engine, or Web App, and a local database engine is not found,
a database e
ngine dialog is shown which prompts you to choose which engine you intend to use.

Database (Installing)

P a g e

|
28

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


SQL Server

(Installing)

The screens that follow reflect the installation of Microsoft SQL Server. When the other engines are
installed, similar screens will display:



As pa
rt of the installation, Microsoft will install its “Web Platform” installer. Click on the
Get the
Microso
f
t Web Platform

button to proceed.



Database (Installing)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
29

The SQL Server 2008 Express installation window will display; click on the
Install

button.



Click the
I Accept

button.



Database (Installing)

P a g e

|
30

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc



When prompted for authentication

mode
, select
Windows Integrated Authentication
.

However, in the screen shown
below
, the server administrator option
is being
selected
. This
generally
is
the recommended
option
for the other three database engi
nes.

(The requested password is the
password

associated with the database engine
administration
program such as
pgAdmin when working
with PostgreSQL
.
)


Input the password (twice); c
lick
Continue
.



Database (Installing)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
31

Database Setup Wizard

The initial database window prompts

for some specific connection information.


Background

All database engines require some kind of authentication to determine what rights you have to various
operations. Some allow you to use the credentials with which you login to Windows
--

this is know
n as
“Windows Authentication.” For this to work properly, your Windows login must be configured in the
database engine as a valid user. Other database engines require you to enter a username and password
that is specific to the database
--

similar to log
ging in to a website.

To visit a website, all you need is the web address, such as http://www.grin
-
global.org/. In this example,
the server name is grin
-
global.org.
Also, t
here is an implicit port number of 80. Written explicitly, the
address would be:
http://www.grin
-
global.org:80/. This will work for any of your favorite web sites, go
ahead and try it! At a bare minimum, a web address consists of a server and a port.

This connection method is exactly the same regardless of what kind of software the we
b server is
running. To connect to a database a similar approach is used
--

you must tell it some details about the
server to which you are trying to connect.

However, unlike a web server, different database engines require different information when
conn
ecting. All require a server name, but some may require a specific "port" or "instance name
.
"
Think of this as somewhat similar to the "80" portion of the web address example from above.

Examples of connecting to the various database engines supported by

GRIN
-
Global (assuming the server
name is "localhost"):



SQL Server:

localhost
\
SQLExpress



Oracle:

localhost:1521



PostgreSQL:

localhost:5432



MySQL:

localhost:3306

As you can see, they are all similar, but slightly different.

Database (Installing)

P a g e

|
32

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc



The wizard takes you thr
ough the installation steps. To proceed, click
Next
.


Generally the defaults on this window will be adequate for most users. If you need to change something
on this window, do so, otherwise click
Next
.


Database (Installing)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
33

Click
Next
.


Several screens will display in suc
cession.


The final window will indicate that the database “has been successfully installed;” click
Close
.


Search Engine (Installing)

P a g e

|
3
4

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


Search Engine
(
Install
ing)

The steps for installing the Search Engine
are
straight forward. When you complete this installation
procedure, the Se
arch Engine will be installed on your PC.

Step 1

S
electing
Start | All Programs | GRIN
-
Global | GRIN
-
Global Updater


Step
2

If desired, you can
exclude the other components from being installed



in that case,
uncheck all
boxes
except for the
GRIN
-
Global
Search Engine
; click the
Download/Install

button.

(Use
http://test.grin
-
global.org/gringlobal/gui.asmx

for the address.)


Search Engine (Installing)


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
35

The
Install Mode

window displays.


Note: the following screens display when you select
Custom Installation

on the
Install Mode

windo
w.

Step 3

Click
Next

to proceed.


Step
4

On the
Select Installation Folder

window you can change the default folder location and who will have
access to the GRIN
-
Global programs (all users or the current user). Generally, you can accept the
defaults. If a

different location is desired, click
Browse
. (Another option is the
Disk Cost

button which
can be used to determine if you have enough space on your drive. The complete installation requires
less than 1 GB.)

Search Engine (Installing)

P a g e

|
36

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


Click
Next

to accept the defaults and continue
.


Step 5

Click
Next

to proceed.


Step
6

Click
Close
.



Adding a User to the Local SQL Server Database Administrator’s Group


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
37

Add
ing a
User
t
o
the
Local
SQL

Server Database Administrator’s Group

In some organizations, the usual user/”owner” of the PC is not granted Windows administrator
privileges. When that is the situat
ion, this user must be added to the SQL Server
BUILTIN
\
Users

group so
that the user can update the SQL Server database.

Step
-
by
-
Step Procedure

1.

Start SQL Server Management Studio from the Windows Start menu
;
when prompted with the
following dialog

box click

the “Connect” button:



2.

Navigate to the
Security
|
Server Roles
|

sysadmin

object in the treeview as shown below.
Right
-
click on
sysadmin
;

select
Properties
.



Adding a User to the Local SQL Server Database Administrator’s Group

P a g e

|
38

herbunalaska_1ed20057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc


3.

From the
Server Role Properties

window,
click
Add…



4.

In the
Select Logins

window, c
lick
Brow
se…



Adding a User to the Local SQL Server Database Administrato
r’s Group


herbunalaska_1ed2
0057
-
cd70
-
434b
-
90e0
-
bf30aabb6512.doc

P a g e

|
39


5.

Select
the
[BUILTIN
\
Users]

name to check
-
mark it
. C
lick
the
OK

button
s

on each dialog box until
you
are
return
ed

to the main window.



6.

Exit from the SQL Server Management Studio
;
reboot your computer. You should now be able
to use the Curator To
ol as a non
-
administrator user.