John, The logging file is in /etc/cas/config in your project directory. There are a lot of changes from 5.0.x to 5.2.x with regard to cas.properties. You are probably correct with the original config. I think Michele is correct. You specify how you want to recognize attributes and you specify how to get those attributes.
You can check your sql query by enabling showSql, https://apereo.github.io/cas/5.0.x/installation/Configuration-Properties.html#hibernate--jdbc Ray P.S. It is always better to post to the user list, that way anyone can help and everyone can benefit On Mon, 2019-01-21 at 09:31 +0300, john adz wrote: Hi Rbon, i need very urgent help. I wrote it in the forum, but it's getting a little slow down there. what else should I add into the application.properties file. I'm sending the file. <! - DEBUG Found principal attributes [...] for [username] Attribute policy [???] allows release of [...] for [username] Final collection of attributes allowed are: [...] -> <AsyncLogger name = "org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy" level = "debug" /> You told me to write this. Where should I write this? Can you help me out? I'm using cas 5.0.x. Do I need to replace application.properties entirely with attributerepository? applicaiton.properties cas.authn.accept.users= cas.authn.jdbc.query[0].fieldUser=username cas.authn.jdbc.query[0].sql=SELECT password FROM users WHERE username=? cas.authn.jdbc.query[0].healthQuery=SELECT 1 FROM db.users cas.authn.jdbc.query[0].tableUsers=users cas.authn.jdbc.query[0].fieldPassword=password cas.authn.jdbc.query[0].url=jdbc:mysql://localhost:3306/db cas.authn.jdbc.query[0].user=root cas.authn.jdbc.query[0].password=*** cas.authn.jdbc.query[0].driverClass=com.mysql.jdbc.Driver cas.authn.jdbc.query[0].passwordEncoder.type=DEFAULT cas.authn.jdbc.query[0].passwordEncoder.characterEncoding=UTF-8 cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm=SHA-256 cas.authn.jdbc.query[0].passwordEncoder.secret= cas.authn.jdbc.query[0].passwordEncoder.strength=16 #cas.authn.jdbc.query[0].principalAttributeList=email,mail cas.authn.attributeRepository.jdbc.attributes.uid=mail -- Ray Bon Programmer analyst Development Services, University Systems 2507218831 | CLE 019 | [email protected] -- - 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/1548091177.3605.10.camel%40uvic.ca.
