Please change the following configuration from cas.authn.jdbc.query[0].healthQuery=SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_ USERS
to cas.authn.jdbc.query[0].healthQuery=SELECT 1 On Mon, Jan 23, 2017 at 8:53 PM, Tsogbadrakh Chinzorig < [email protected]> wrote: > My config file as like follows > > > cas.server.name: https://localhost:8443 > cas.server.prefix: https://localhost:8443/cas > > cas.adminPagesSecurity.ip=127\.0\.0\.1 > > logging.config: file:/etc/cas/config/log4j2.xml > # cas.serviceRegistry.config.location: classpath:/services > > # Disabling static users > cas.authn.accept.users= > > # Enablin database authentication > # Query > cas.authn.jdbc.query[0].healthQuery=SELECT 1 FROM INFORMATION_SCHEMA. > SYSTEM_USERS > cas.authn.jdbc.query[0].url=jdbc:postgresql://localhost:5432/cas > cas.authn.jdbc.query[0].user=cas > cas.authn.jdbc.query[0].password=cas > cas.authn.jdbc.query[0].sql=SELECT password FROM users WHERE email=? > cas.authn.jdbc.query[0].driverClass=org.postgresql.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=MD5 > cas.authn.jdbc.query[0].passwordEncoder.secret= > cas.authn.jdbc.query[0].passwordEncoder.strength=16 > cas.authn.jdbc.query[0].isolateInternalQueries=false > cas.authn.jdbc.query[0].failFast=true > cas.authn.jdbc.query[0].isolationLevelName=ISOLATION_READ_COMMITTED > cas.authn.jdbc.query[0].dialect=org.hibernate.dialect.PostgreSQLDialect > cas.authn.jdbc.query[0].leakThreshold=10 > cas.authn.jdbc.query[0].propagationBehaviorName=PROPAGATION_REQUIRED > cas.authn.jdbc.query[0].batchSize=1 > cas.authn.jdbc.query[0].ddlAuto=create-drop > cas.authn.jdbc.query[0].maxAgeDays=180 > cas.authn.jdbc.query[0].autocommit=false > cas.authn.jdbc.query[0].idleTimeout=5000 > cas.authn.jdbc.query[0].credentialCriteria= > > cas.authn.jdbc.query[0].principalTransformation.suffix= > cas.authn.jdbc.query[0].principalTransformation.caseConversion=NONE > cas.authn.jdbc.query[0].principalTransformation.prefix= > > -- > - CAS gitter chatroom: https://gitter.im/apereo/cas > - CAS mailing list guidelines: https://apereo.github.io/cas/ > Mailing-Lists.html > - CAS documentation website: https://apereo.github.io/cas > - CAS project website: https://github.com/apereo/cas > --- > 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/7e18747c-10e6-41bb-8e01- > c8e7d3d60da5%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/7e18747c-10e6-41bb-8e01-c8e7d3d60da5%40apereo.org?utm_medium=email&utm_source=footer> > . > -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- 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/CALpZ%2BOT8y%2BmK5ZQx946-ZHiDm%2BTYXF72V7G9MC%3DY25VmHGbvaw%40mail.gmail.com.
