Diego, When setting multiple authentications, CAS will try each one until authentication success. If the database name is different for each user, below should work. If you want each CAS server to use a different user but same database (auditing?), then each CAS server will need its own unique config file.
Ray On Fri, 2018-09-14 at 15:32 -0700, Diego Andres carvajal Ruiz wrote: Hi everyone, I've CAS v5.1.5 in Wildfly 10. Actually I have only 1 node of CAS, but I want to create more nodes with differents users to connect to the database but I don't know how to do it. It's possible in the cas.properties file add the follow lines and will it work?: cas.authn.jdbc.query[0].sql=SELECT ****** cas.authn.jdbc.query[0].driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver cas.authn.jdbc.query[0].url=jdbc:sqlserver://ip:port ;databaseName=*** cas.authn.jdbc.query[0].user=user cas.authn.jdbc.query[0].password=user_passwd cas.authn.jdbc.query[1].sql=SELECT ****** cas.authn.jdbc.query[1].driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver cas.authn.jdbc.query[1].url=jdbc:sqlserver://ip:port ;databaseName=*** cas.authn.jdbc.query[1].user=user1 cas.authn.jdbc.query[1].password=user1_passwd cas.authn.jdbc.query[2].sql=SELECT ****** cas.authn.jdbc.query[2].driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver cas.authn.jdbc.query[2].url=jdbc:sqlserver://ip:port ;databaseName=*** cas.authn.jdbc.query[2].user=user2 cas.authn.jdbc.query[2].password=user2_passwd Or can you give me your opinions about mi topic. Thanks! -- 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/1537202988.2751.6.camel%40uvic.ca.
