Hi List.
New to CAS and installing CAS5.2.4 to kick the tires.
Hit a snag w.r.t attribute resolution -- I have read and re-read the
documentation -- probably there is so much new stuff for me, that it is not
sinking in.
Questions?
-- If I wish to have JDBC lookup on attributes --- upon user authentication
-- I require the following in the 'cas.properties'?
-- how do I handle custom attributes -- we happen to have a few unique ones
only in our institutions --- do I map them like
'cas.authn.attributeRepository.jdbc[0].attributes.eduIdentifier=NETID'?
Withe NETID retrieve from SQL query listed below?
-- How does the CAS-Management know which attributes are being leveraged by
my CAS installation?
Thank you.
cas.authn.attributeRepository.jdbc[0].attributes.eduUsername=LOGIN_NAME
cas.authn.attributeRepository.jdbc[0].attributes.studentNumber=STUDENT_NUMBER
cas.authn.attributeRepository.jdbc[0].attributes.employeeNumber=EMPLOYEE_NUMBER
cas.authn.attributeRepository.jdbc[0].attributes.eduAffiliation=EDU_AFFILIATION
cas.authn.attributeRepository.jdbc[0].attributes.givenName=FIRST_NAME
cas.authn.attributeRepository.jdbc[0].attributes.sn=LAST_NAME
cas.authn.attributeRepository.jdbc[0].attributes.displayName=LOGIN_PREFERRED_NAME
cas.authn.attributeRepository.jdbc[0].attributes.eduIdentifier=NETID
cas.authn.attributeRepository.jdbc[0].attributes.mail=EMAIL
cas.authn.attributeRepository.jdbc[0].singleRow=true
cas.authn.attributeRepository.jdbc[0].order=0
cas.authn.attributeRepository.jdbc[0].requireAllAttributes=true
cas.authn.attributeRepository.jdbc[0].caseCanonicalization=NONE
cas.authn.attributeRepository.jdbc[0].queryType=OR|AND
# Used only when there is a mapping of many rows to one user
#
cas.authn.attributeRepository.jdbc[0].columnMappings.columnAttrName1=columnAttrValue1
#
cas.authn.attributeRepository.jdbc[0].columnMappings.columnAttrName2=columnAttrValue2
#
cas.authn.attributeRepository.jdbc[0].columnMappings.columnAttrName3=columnAttrValue3
cas.authn.attributeRepository.jdbc[0].sql=SELECT
LOGIN_NAME,STUDENT_NUMBER,EMPLOYEE_NUMBER,
EDU_AFFILIATION,FIRST_NAME,LAST_NAME,LOGIN_PREFERRED_NAME,NETID, EMAIL FROM
NET.LOGIN_VW where {0}
cas.authn.attributeRepository.jdbc[0].username=uid
cas.authn.attributeRepository.jdbc[0].healthQuery=SELECT 1 FROM DUAL
cas.authn.attributeRepository.jdbc[0].isolateInternalQueries=false
cas.authn.attributeRepository.jdbc[0].url=SNIP
cas.authn.attributeRepository.jdbc[0].failFastTimeout=1
cas.authn.attributeRepository.jdbc[0].isolationLevelName=ISOLATION_READ_COMMITTED
cas.authn.attributeRepository.jdbc[0].dialect=org.hibernate.dialect.Oracle12cDialect
cas.authn.attributeRepository.jdbc[0].leakThreshold=10
cas.authn.attributeRepository.jdbc[0].propagationBehaviorName=PROPAGATION_REQUIRED
cas.authn.attributeRepository.jdbc[0].batchSize=1
cas.authn.attributeRepository.jdbc[0].user=SNIP
cas.authn.attributeRepository.jdbc[0].ddlAuto=update
cas.authn.attributeRepository.jdbc[0].password=SNIP
cas.authn.attributeRepository.jdbc[0].autocommit=false
cas.authn.attributeRepository.jdbc[0].driverClass=oracle.jdbc.OracleDriver
cas.authn.attributeRepository.jdbc[0].idleTimeout=5000
cas.authn.attributeRepository.jdbc[0].pool.suspension=false
cas.authn.attributeRepository.jdbc[0].pool.minSize=6
cas.authn.attributeRepository.jdbc[0].pool.maxSize=18
cas.authn.attributeRepository.jdbc[0].pool.maxWait=2000
#cas.authn.attributeRepository.jdbc[0].dataSourceName=
cas.authn.attributeRepository.jdbc[0].dataSourceProxy=false
# Hibernate-specific properties (i.e.
`hibernate.globally_quoted_identifiers`)
#
cas.authn.attributeRepository.jdbc[0].properties.propertyName=propertyValue
--
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
---
You received this message because you are subscribed to the Google Groups "CAS
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/2e77edcc-3b52-4728-8671-a4058d6bd74c%40apereo.org.
