my *cas.properties*:
## Database Authentication
## ================================================================
cas.authn.accept.users=
cas.authn.jdbc.query[0].sql = SELECT * FROM users WHERE email=?
cas.authn.jdbc.query[0].healthQuery = SELECT 1
cas.authn.jdbc.query[0].driverClass = com.mysql.jdbc.Driver
cas.authn.jdbc.query[0].url = jdbc:mysql:
//localhost:3306/casdb?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
cas.authn.jdbc.query[0].user = root
cas.authn.jdbc.query[0].password = ******
cas.authn.jdbc.query[0].dialect = org.hibernate.dialect.MySQLDialect
cas.authn.jdbc.query[0].fieldPassword = password
cas.authn.jdbc.query[0].passwordEncoder.type = DEFAULT
cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm = MD5
cas.authn.jdbc.query[0].passwordEncoder.characterEncoding = UTF-8
cas.authn.attributeRepository.jdbc[0].sql = SELECT * FROM user_attributes
WHERE {0}
cas.authn.attributeRepository.jdbc[0].healthQuery = SELECT 1
cas.authn.attributeRepository.jdbc[0].driverClass = com.mysql.jdbc.Driver
cas.authn.attributeRepository.jdbc[0].url = jdbc:mysql:
//localhost:3306/casdb?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
cas.authn.attributeRepository.jdbc[0].user = root
cas.authn.attributeRepository.jdbc[0].password = ******
cas.authn.attributeRepository.jdbc[0].dialect = org.hibernate.dialect.
MySQLDialect
cas.authn.attributeRepository.jdbc[0].singleRow = false
cas.authn.attributeRepository.jdbc[0].username = email
cas.authn.attributeRepository.jdbc[0].columnMappings.key=value
cas.authn.attributeRepository.jdbc[0].attributes.firstname=firstname
cas.authn.attributeRepository.defaultAttributesToRelease=firstname
my *pom.xml*
<!--
...Additional dependencies may be placed here...
-->
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-json-service-registry</artifactId>
<version>${cas.version}</version>
</dependency>
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-jdbc</artifactId>
<version>${cas.version}</version>
</dependency>
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-jdbc-drivers</artifactId>
<version>${cas.version}</version>
</dependency>
When use Laravel with *phpCAS*
@foreach(cas()->getAttributes() as $attribute)
{{ $attribute }}<br>
@endforeach
HTML Result is:
UsernamePasswordCredential
false
2018-10-12T11:32:35.265+07:00[Asia/Jakarta]
QueryDatabaseAuthenticationHandler
QueryDatabaseAuthenticationHandler
false
Based on the configuration above, the attribute does not display data.
Please give me a solution about this problem. Thank you.
--
- 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/23a9e25d-849f-4881-b0ca-7cb068743c15%40apereo.org.
