Versions Compared

Old Version 3

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

compared with

New Version 4

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

Key

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

...

Identify the external systems and properties

LDAP connections in grouper-loader.properties

ldap.<connectionId>.attributeName

e.g. ldap.personLdap.url

https://www.ldaptive.org/v1/docs/guide/connections/pooling.html

AttributeTypeDefaultNotes
urlString
required.  Explain that for provisioning the URL 
should point to one node for consistency

user

String
optional

pass

String
encrypted if a password.  Save this like the configuration editor saves

configFileFromClasspath

String

isActiveDirectoryBoolean

tls

Boolean

saslAuthorizationIdString

saslRealmString

batchSizeInteger

countLimitInteger

timeLimitInteger
time limit for search operations in millis
timeoutInteger
timeout to get a connection in millis
minPoolSizeInteger3
maxPoolSizeInteger10
validateOnCheckInBoolean

validateOnCheckOutBoolean
defaults to true if all other validate methods are false
validatePeriodicallyBoolean

validateTimerPeriodStringPT30M
pruneTimerPeriodString

pagedResultsSizeInteger
needs to be equal to or less than the max result size server setting
referralString
set to 'follow' if using AD and using paged results size and need this for some reason (generally you shouldnt)
validatorString
drop down.  validator setup, currently supports CompareLdapValidator and SearchValidator. additional properties below for CompareLdapValidator.
validatorCompareDnString
required for CompareLdapValidator.  check this DN exists when saving connection.  e.g. ou=people,dc=example,dc=com
validatorCompareAttributeString
required for CompareLdapValidator.  e.g. ou    check this DN exists when saving connection
validatorCompareValueString
required for CompareLdapValidator.  e.g. people
searchResultHandlersString
comma-delimited list of classes to process LDAP search results. Useful if AD returns a ranged attribute for large
# groups (e.g., member;range=0-1499); include the GrouperRangeEntryHandler to handle progressive fetching.
searchIgnoreResultCodesString
comma-delimited list of result codes (org.ldaptive.ResultCode) to ignore, e.g. TIME_LIMIT_EXCEEDED, SIZE_LIMIT_EXCEEDED, PARTIAL_RESULTS



Database from grouper-loader.properties

db.<connectionId>.url

e.g. db.warehouse.url

AttributeTypeDefaultNotes
urlString

Required

e.g. mysql:           jdbc:mysql://localhost:3306/grouper?useSSL=false
e.g. p6spy (log sql): [use the URL that your DB requires]
e.g. oracle:          jdbc:oracle:thin:@server.school.edu:1521:sid
e.g. hsqldb (a):      jdbc:hsqldb:dist/run/grouper;create=true
e.g. hsqldb (b):      jdbc:hsqldb:hsql://localhost:9001/grouper
e.g. postgres (a):        jdbc:postgresql://localhost:5432/database
e.g. postgres (b):        jdbc:postgresql://localhost:5432/database?currentSchema=mySchema
e.g. mssql:           jdbc:sqlserver://localhost:3280;databaseName=grouper

userString

passString
Save this like the configuration editor saves
driverString

note: you probably dont have to enter a driver, it will detect from URL. If it cant detect, then specify it here.
If this is not mysql, or postgres, make sure jar is in container.  These are the defaults
e.g. mysql:           com.mysql.jdbc.Driver
e.g. oracle:          oracle.jdbc.driver.OracleDriver
e.g. hsqldb:          org.hsqldb.jdbcDriver
e.g. postgres:        org.postgresql.Driver

c3p0.max_sizeInteger
optional pooling params, these will default to the grouper.hibernate(.base).properties pooling settings
(get that value for the UI from that config)
c3p0.min_sizeInteger

c3p0.timeoutInteger
seconds
c3p0.max_statementsInteger

c3p0.idle_test_periodInteger

c3p0.acquire_incrementInteger

c3p0.validateBoolean

c3p0.debugUnreturnedConnectionStackTracesBoolean
if unreturnedConnectionTimeout is non zero, then if connection takes too long it will be logged as stack
c3p0.unreturnedConnectionTimeoutInteger