Found the root cause, the thin JDBC URL to my database was incorrectly
formatted (not shown below for privacy).
For others reading this post to use as a reference: the settings are
otherwise correct below (also corrected for a '|'):
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
# 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
On Friday, May 18, 2018 at 3:22:03 PM UTC-7, mynharry wrote:
>
> 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
>
> # 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/12232641-12ae-4997-830d-9735d7454a26%40apereo.org.
