NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Property NameDescriptionexample

database.type

This value specifies whether a MySQL or an Oracle database is being used.

oracle, mysql

database.re-create

database.drop-schema

One of these properties must be set to true. 

If re-create is true then the install:database target will wipe out the database instance completely and start from scratch. 

If drop-schema is true, then all the schema and data will be wiped out but the database itself will not be removed.

true or false
database.system.user

The username for an administrator of this database. 


This value should correspond to a MySQL username that has full system privileges.

This must correspond to the administrator account defined when MySQL was configured.
For Oracle, this value will be ignored, but the value must be different than the value of database.user.

Depending on how the install is done, or the value of database.re-create this may not be necessary. 
If re-create=true, then this is necessary, otherwise it isn't.

root
database.system.passwordThe password for an administrator of this database that correlates with the value in database.system.user.


For Oracle, this value will be ignored.

Depending on how the install is done, or the value of database.re-create this may not be necessary. 
If re-create=true, then this is necessary, otherwise it isn't.
Someth!ngSecure

database.server

This value must correspond to the domain name of machine that hosts the Oracle/MySQL database server.

Talk to your database administrator to learn the server name and port.

remotehost.org

database.port

This value must correspond to the port for the database.server.

3306 is the default port, but check with your database administrator to be certain.

3306

database.name

Choose a name for the NCIA MySQL database. This must be different than the UPT database name

nciadb

database.user

Give the username to access database.name.

nciaop

database.password

Use a password to access database.name for the username identified in database.user

Someth!ngSecure

database.url

Url for connection to a database. This is the standard implementation style.

This if fixed. No Change Required

jdbc:mysql://${database.server}:${database.port}/${database.name}

database.system.url

Url for connection to a database. This is the standard implementation style.

This if fixed. No Change Required

jdbc:mysql://${database.server}:${database.port}/

database.schemaDatabase Schema for Oraclenciadev

TCIA LDAP Settings

Property Name

Description

Example

ldap.memberOf.attribute.name=isMemberOf

 Because different LDAP software can have different attribute names for mail and isMemberOf attribute, I just make them configurable, so when different LDAP software is used, we only need to change the value of properties for mail and memberOf. 

 

ldap.mail.attribute.name=mail


 

ldap.group.ignore.list=PwmAdmins,devTeam,testGroup

ldap.group.ignore.list is for NBIA to ignore some of groups used in LDAP for administration purpose and the groups in this list will not be synced to database.

Different NBIA instance may give a different name for the group which has users who can access public collection. So I added the property public.collection.access.group.name.

 
public.collection.access.group.name=General User  

product.variation=TCIA

  

LDAP Settings

Property Name

Description

Example

ldap.url

Universal Resource Locator address for LightWeight Directory Access Protocol server.

ldaps://university.edu:636

ldap.basedn

LDAP server holding referrals to other server holding a given distinguished name (DN).

u=nci,o=nih

ldap.userUsed only under ldap-auth, otherwise comment outcn=NCILDAP,ou=nci,o=nih
ldap.passPassword for the authenticated user under ldap-auth, otherwise comment outsomepass

...