Thanks a lot Ray!
El lunes, 17 de septiembre de 2018, 11:49:55 (UTC-5), rbon escribió: > > 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] <javascript:> > > -- - 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/fe1bcd13-5285-4ccb-927a-fbc64b244a36%40apereo.org.
