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 [email protected].
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.
