So, you have cas.authn.attributeRepository.jdbc[0].username=email
in *cas.properties*? I didn't see it in the ones you copied/pasted earlier. Dumb question, but if you connect to the database using the same user and password that you have CAS configured to use, and you run SELECT * FROM app_user WHERE [email protected] do you get your attributes? And...assuming you own the database, can you enable query logging on that end? Or make the JDBC library log what it's doing? -- DAVID A. CURRY, CISSP *DIRECTOR OF INFORMATION SECURITY* INFORMATION TECHNOLOGY 71 FIFTH AVE., 9TH FL., NEW YORK, NY 10003 +1 212 229-5300 x4728 • [email protected] [image: The New School] On Tue, May 22, 2018 at 1:18 PM John D Giotta <[email protected]> wrote: > My "username" column is called email, but even with your suggestions I > still get the following DEBUG output in logs. > > Found [0] attributes for principal [[email protected]] from the > attribute repository. > > This is why I think there something wrong with the query. Log level is set > to debug, but I still don't see queries. I even set debug to > org.springframework.orm.jpa > for good measure. > > -- > - 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/27db9e1c-b36c-44ca-acb2-e240f1eea07d%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/27db9e1c-b36c-44ca-acb2-e240f1eea07d%40apereo.org?utm_medium=email&utm_source=footer> > . > -- - 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/CA%2Bd9XAPUpse_XaCa1vwRWmMNBkRk2hUALLhWuQyHvT%3DMpc%2B7%3Dw%40mail.gmail.com.
