SECURESHELL

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

No

AUTHENTICATION

NUMBER

Yes

KEYFILEPATH

VARCHAR2(255)

Yes

PASSPHRASE

VARCHAR2(255)

Yes

PASSWORD

VARCHAR2(255)

No

USERNAME

VARCHAR2(50)

No

WORKCOPYPATHPREFIX

VARCHAR2(512)

No

BUILDARCHIVEPATHPREFIX

VARCHAR2(512)

No

SCRIPTPATHPREFIX

VARCHAR2(512)

No

PHASECATALOGPATHPREFIX

VARCHAR2(512)

Yes

SERVERHOSTNAME

VARCHAR2(255)

Yes

SERVERSSHPORT

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SECURESHELL_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the Secure Shell Transporter.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the Secure Shell Transporter.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

AUTHENTICATION

The Authentication type.

Key NULL Column Type (Size)

No

AUTHENTICATION

NUMBER
Value List

0 = User and Password Authentication

1 = Key Authentication

KEYFILEPATH

The Key File, if Key Authentication is selected.

Key NULL Column Type (Size)

Yes

KEYFILEPATH

VARCHAR2(255)

PASSPHRASE

The Passphrase, if a Passphrase is used to protect your Key Authentication.

Key NULL Column Type (Size)

Yes

PASSPHRASE

VARCHAR2(255)

PASSWORD

The Password, if User and Password Authentication is selected.

Key NULL Column Type (Size)

Yes

PASSWORD

VARCHAR2(255)

USERNAME

The User Name, if User and Password Authentication is selected.

Key NULL Column Type (Size)

No

USERNAME

VARCHAR2(50)

WORKCOPYPATHPREFIX

The prefix for the Work Copy Location (the location where the VCR interface places the checked out sources on the IKAN ALM Server so that it is accessible from a remote IKAN ALM Agent handling a build process). The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Example 1:

An IKAN ALM Server on a Windows machine with an SSH Server supporting the "cygdrive" notation.

System Settings: the Relative Work Copy Location being defined as "workCopy" and the Local FileCopy Work Copy Location as e:/ikan/scm4all/workCopy results in /cygdrive/e/ikan/scm4all as the Work Copy Path Prefix.

The IKAN ALM Agent will try to Secure Copy the sources from a location under /cygdrive/e/ikan/scm4all/workCopy.

Example 2:

An IKAN ALM Server on a Linux machine.

System Settings: the Local FileCopy Work Copy location being defined as /opt/ikan/scm4all/workCopy and the Relative Work Copy Location as "workCopy" results in/opt/ikan/scm4all as Work Copy Path Prefix.

The IKAN ALM Agent will try to Secure Copy the sources from a location under /opt/ikan/scm4all/workCopy.

Key NULL Column Type (Size)

No

WORKCOPYPATHPREFIX

VARCHAR2(512)

BUILDARCHIVEPATHPREFIX

The prefix for the Build Archive Location (the location where the Builds are stored or retrieved from). The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Key NULL Column Type (Size)

No

BUILDARCHIVEPATHPREFIX

VARCHAR2(512)

SCRIPTPATHPREFIX

The prefix for the Script Location. The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Key NULL Column Type (Size)

No

SCRIPTPATHPREFIX

VARCHAR2(512)

PHASECATALOGPATHPREFIX

The prefix for the Phase Catalog Location (the location on the IKAN ALM Server where imported and newly created Phases are stored). When an IKAN ALM Agent/Server needs to install a missing Phase, it will use this prefix and the Relative Phase Catalog Location from SYSTEMSETTINGS to construct a path to copy the missing Phase from.

Key NULL Column Type (Size)

No

PHASECATALOGPATHPREFIX

VARCHAR2(512)

SERVERHOSTNAME

The hostname of the IKAN ALM Server Machine in case it is different from the IKAN ALM Server Machine DHCP name or IP address.

Key NULL Column Type (Size)

Yes

SERVERHOSTNAME

VARCHAR2(255)

SERVERSSHPORT

The Port Number of the SSH Server running on the IKAN ALM Server.

Note: This value will overrule the value specified in the System Settings. If not specified in the System Settings nor on in the SSH Transporter Settings screen, the default SSH Port Number 22 is used.

Key NULL Column Type (Size)

Yes

SERVERSSHPORT

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

SECURESHELL_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

SECURESHELL_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SECURESHELL_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SECURESHELL_AUTHENTICATION_LABEL

English:

Authentication Type

French:

Type d’authentification

German:

Authentifizierungstyp

SECURESHELL_BUILDARCHIVEPATHPREFIX_LABEL

English:

Build Archive Path Prefix

French:

Préf. Empl. Archives Constr.

German:

Präfix des Bereitstellungsarchivverzeichnisses

SECURESHELL_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

SECURESHELL_KEYFILEPATH_LABEL

English:

Key File Path

French:

Chemin du fichier des clés

German:

Schlüsseldateiverzeichnis

SECURESHELL_NAME_LABEL

English:

Name

French:

Nom

German:

Name

SECURESHELL_OID_LABEL

English:

OID

French:

OID

German:

OID

SECURESHELL_PASSPHRASE_LABEL

English:

Passphrase

French:

Phrase de passe

German:

Passphrase

SECURESHELL_PASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

SECURESHELL_PHASECATALOGPATHPREFIX_LABEL

English:

Phase Catalog Path Prefix

French:

Préfixe Chemin du Catalogue des Phases

German:

Präfix für den Phasekatalog

SECURESHELL_SCRIPTPATHPREFIX_LABEL

English:

Script Path Prefix

French:

Préf. Empl. Scripts

German:

Präfix des Skriptverzeichnisses

SECURESHELL_SERVERHOSTNAME_LABEL

English:

Server Hostname

French:

Nom du Serveur

German:

Server Hostname

SECURESHELL_SERVERSSHPORT_LABEL

English:

Server SSH Port

French:

Port du Serveur SSH

German:

Server SSH Port

SECURESHELL_USERNAME_LABEL

English:

User Name

French:

Nom d’utilisateur

German:

Benutzername

SECURESHELL_VERSION_LABEL

English:

Version

French:

Version

German:

Version

SECURESHELL_WORKCOPYPATHPREFIX_LABEL

English:

Work Copy Path Prefix

French:

Préf. Empl. Copies de travail

German:

Präfix des Arbeitskopieverzeichnisses