Hi Cas Community,
I am currently setting up a cas server (v5.1.4) for multiple services. All users are saved in a postgres database shared by all the services and the cas server. Each user in the database is identified by the combination of the service_id and the email. So I want to change the SQL query depending on the requested service. For example: SELECT * FROM users WHERE users.service_id = '1' AND WHERE email = ? The problem is that I am not able to retrieve the current service within authentication handler QueryAndEncodeDatabaseAuthenticationHandler which allows me to change the query. So then I looked at the custom properties <https://apereo.github.io/cas/5.1.x/installation/Configuring-Service-Custom-Properties.html> of a service but those where also not available in the authentication handler. My last resort was the requiredHandlers options of the service. So I added a second jdbc encode handler like this: cas.authn.jdbc.encode[0].sql=SELECT * FROM users WHERE users.service_id = '1' AND WHERE email = ? cas.authn.jdbc.encode[1].sql=SELECT * FROM users WHERE users.service_id = '2' AND WHERE email = ? I then hoped I could select the handler for each service, however you can only select the handler class like this { "@class" : "org.apereo.cas.services.RegexRegisteredService", "serviceId" : "^http://localhost:3000/.*";, "name" : "Development", "id" : 1, "requiredHandlers" : [ "java.util.HashSet", [ "QueryAndEncodeDatabaseAuthenticationHandler" ] ] } So if I add more services, the QueryAndEncodeDatabaseAuthenticationHandlers are not distinguishable and the service is still not linked to a specific query. I hope my problem is clear and that you have some nice ideas to fix this! Thanks, Stef -- - 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/4ff2fda4-9355-4157-a4c6-89063f3efd55%40apereo.org.
