Oh, thank you, postgreSql didn't have system_users in information_schema. On Tuesday, January 24, 2017 at 12:25:59 AM UTC+9, mrcasa bengaluru wrote: > > 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] <javascript:>> 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] <javascript:>. >> 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/198ddae9-8702-40a9-b984-c148d5d166fd%40apereo.org.
