Hi I am very new to cas, I have already checked out cas-overlay-template-master (5.0.2) from git-hub and changed the cas.properties and pom.xml in order to integrate cas server authentication with oracle database but nothing happened after logging to the login page of cas(Invalid credentials displayed). Also i have no interesting information in my cas.log or cas_audit.log to find out the misconfiguration. I have also created the appropriate table in oracle and inserted username and password (generated by md5 algorithm). Anyway if someone help me to understand i would be so grateful.
This is my cas.properties file : 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 #database connection credentials cas.authn.jdbc.query[0].sql=SELECT password FROM MOB_LOGIN WHERE username=? cas.authn.jdbc.query[0].healthQuery=SELECT 1 FROM dev.MOB_LOGIN cas.authn.jdbc.query[0].isolateInternalQueries=false cas.authn.jdbc.query[0].url=jdbc:oracle:thin:@localhost:1521:orcl 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.OracleDialect 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].user=dev #cas.authn.jdbc.query[0].ddlAuto=create-drop cas.authn.jdbc.query[0].maxAgeDays=180 cas.authn.jdbc.query[0].password=dev cas.authn.jdbc.query[0].autocommit=false cas.authn.jdbc.query[0].driverClass=oracle.jdbc.OracleDriver cas.authn.jdbc.query[0].idleTimeout=5000 cas.authn.jdbc.query[0].credentialCriteria= 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 This is my dependencies added to the pom ( for integrating to oracle) : <dependencies> <dependency> <groupId>org.apereo.cas</groupId> <artifactId>cas-server-webapp</artifactId> <version>${cas.version}</version> <type>war</type> <scope>runtime</scope> </dependency> <dependency> <groupId>org.apereo.cas</groupId> <artifactId>cas-server-support-jdbc</artifactId> <version>${cas.version}</version> </dependency> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>11.2.0</version> </dependency> </dependencies> * I attached all information to this post.* Thanks -- - 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/02244984-d8e3-46a6-962f-7620c6fb34d2%40apereo.org.
cas.properties
Description: Binary data
pom.xml
Description: XML document
2017-02-17 20:44:31,183 INFO
[org.apereo.cas.web.CasWebApplicationServletInitializer] - <The following
profiles are active: native>
2017-02-17 20:44:39,330 INFO
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/cas]] -
<Initializing Spring embedded WebApplicationContext>
2017-02-17 20:44:39,559 WARN
[org.apereo.cas.services.InMemoryServiceRegistryDaoImpl] - <Runtime memory is
used as the persistence storage for retrieving and persisting service
definitions. Changes that are made to service definitions during runtime WILL
be LOST upon container restarts.>
2017-02-17 20:44:39,600 INFO
[org.apereo.cas.services.DefaultServicesManagerImpl] - <Loaded 0 services from
InMemoryServiceRegistryDaoImpl.>
2017-02-17 20:44:45,880 WARN
[org.apereo.cas.config.CasSecurityContextConfiguration] - <[36m>
2017-02-17 20:44:45,885 WARN
[org.apereo.cas.config.CasSecurityContextConfiguration] - <
____ _____ ___ ____ _
/ ___| |_ _| / _ \ | _ \ | |
\___ \ | | | | | || |_) || |
___) | | | | |_| || __/ |_|
|____/ |_| \___/ |_| (_)
CAS is configured to accept a static list of credentials for authentication.
While this is generally useful for demo purposes, it is STRONGLY recommended
that you DISABLE this authentication method (by SETTING 'cas.authn.accept.users'
to a blank value) and switch to a mode that is more suitable for production.
>
2017-02-17 20:44:45,885 WARN
[org.apereo.cas.config.CasSecurityContextConfiguration] - <[0m>
2017-02-17 20:44:46,420 INFO
[org.apereo.cas.services.DefaultServicesManagerImpl] - <Loaded 2 services from
InMemoryServiceRegistryDaoImpl.>
2017-02-17 20:44:55,690 INFO
[org.apereo.cas.configuration.CasConfigurationRebinder] - <Reloaded CAS
configuration cas-org.apereo.cas.configuration.CasConfigurationProperties>
2017-02-17 20:44:57,713 INFO [org.apereo.cas.configuration.support.Beans] -
<Ticket registry encryption/signing is turned off. This MAY NOT be safe in a
clustered production environment. Consider using other choices to handle
encryption, signing and verification of ticket registry tickets, and verify the
chosen ticket registry does support this behavior.>
2017-02-17 20:44:57,719 WARN
[org.apereo.cas.ticket.registry.DefaultTicketRegistry] - <Runtime memory is
used as the persistence storage for retrieving and managing tickets. Tickets
that are issued during runtime will be LOST upon container restarts. This MAY
impact SSO functionality.>
2017-02-17 20:44:57,729 INFO
[org.apereo.cas.config.CasCoreTicketsConfiguration] - <Protocol tickets
generated by CAS are not signed/encrypted.>
2017-02-17 20:44:57,880 WARN
[org.apereo.cas.util.cipher.WebflowConversationStateCipherExecutor] - <Secret
key for signing is not defined. CAS will attempt to auto-generate the signing
key>
2017-02-17 20:44:57,890 WARN
[org.apereo.cas.util.cipher.WebflowConversationStateCipherExecutor] -
<Generated signing key
FqmyGD47NmHQ_mVVLsArmfXNKCyketvOCVN9AkgDV9Bwmn8_tsWgVdLRoT1vy_VWvjzMhqoomAvyCeMhCJjGPw
of size 512. The generated key MUST be added to CAS settings.>
2017-02-17 20:44:57,890 WARN
[org.apereo.cas.util.cipher.WebflowConversationStateCipherExecutor] - <No
encryption key is defined. CAS will attempt to auto-generate keys>
2017-02-17 20:44:57,890 WARN
[org.apereo.cas.util.cipher.WebflowConversationStateCipherExecutor] -
<Generated encryption key FRBshLBlirLjnjJA of size 16. The generated key MUST
be added to CAS settings.>
2017-02-17 20:44:57,952 WARN
[org.apereo.cas.util.cipher.TicketGrantingCookieCipherExecutor] - <Secret key
for encryption is not defined. CAS will attempt to auto-generate the encryption
key>
2017-02-17 20:44:57,953 WARN
[org.apereo.cas.util.cipher.TicketGrantingCookieCipherExecutor] - <Generated
encryption key 2sywbDGu3j2t9QfeVVBx7ZP5urY59SLEkopISEQ6lzw of size 256. The
generated key MUST be added to CAS settings.>
2017-02-17 20:44:57,953 WARN
[org.apereo.cas.util.cipher.TicketGrantingCookieCipherExecutor] - <Secret key
for signing is not defined. CAS will attempt to auto-generate the signing key>
2017-02-17 20:44:57,953 WARN
[org.apereo.cas.util.cipher.TicketGrantingCookieCipherExecutor] - <Generated
signing key
3wmUmnrGsFNRtC2yIGbQ6ZBM7-3Ux-t7mxiYhNgYtmPSJObPdsyAlf_022_3gW4SvT5jkhiS-BuNIf5fgXBcRQ
of size 512. The generated key MUST be added to CAS settings.>
2017-02-17 20:44:58,403 INFO
[org.apereo.cas.web.CasWebApplicationServletInitializer] - <Started
CasWebApplicationServletInitializer in 31.394 seconds (JVM running for 44.529)>
2017-02-17 20:44:58,482 INFO [org.apache.catalina.startup.HostConfig] -
<Deployment of web application archive E:\apache-tomcat-8.5.11\webapps\cas.war
has finished in 42,117 ms>
2017-02-17 20:44:58,483 INFO [org.apache.catalina.startup.HostConfig] -
<Deploying web application directory E:\apache-tomcat-8.5.11\webapps\docs>
2017-02-17 20:44:58,502 INFO [org.apache.catalina.startup.HostConfig] -
<Deployment of web application directory E:\apache-tomcat-8.5.11\webapps\docs
has finished in 19 ms>
2017-02-17 20:44:58,502 INFO [org.apache.catalina.startup.HostConfig] -
<Deploying web application directory E:\apache-tomcat-8.5.11\webapps\examples>
2017-02-17 20:44:58,714 INFO
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/examples]] -
<ContextListener: contextInitialized()>
2017-02-17 20:44:58,714 INFO
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/examples]] -
<SessionListener: contextInitialized()>
2017-02-17 20:44:58,721 INFO [org.apache.catalina.startup.HostConfig] -
<Deployment of web application directory
E:\apache-tomcat-8.5.11\webapps\examples has finished in 219 ms>
2017-02-17 20:44:58,721 INFO [org.apache.catalina.startup.HostConfig] -
<Deploying web application directory
E:\apache-tomcat-8.5.11\webapps\host-manager>
2017-02-17 20:44:58,744 INFO [org.apache.catalina.startup.HostConfig] -
<Deployment of web application directory
E:\apache-tomcat-8.5.11\webapps\host-manager has finished in 22 ms>
2017-02-17 20:44:58,744 INFO [org.apache.catalina.startup.HostConfig] -
<Deploying web application directory E:\apache-tomcat-8.5.11\webapps\manager>
2017-02-17 20:44:58,763 INFO [org.apache.catalina.startup.HostConfig] -
<Deployment of web application directory
E:\apache-tomcat-8.5.11\webapps\manager has finished in 19 ms>
2017-02-17 20:44:58,763 INFO [org.apache.catalina.startup.HostConfig] -
<Deploying web application directory E:\apache-tomcat-8.5.11\webapps\ROOT>
2017-02-17 20:44:58,801 INFO [org.apache.catalina.startup.HostConfig] -
<Deployment of web application directory E:\apache-tomcat-8.5.11\webapps\ROOT
has finished in 38 ms>
2017-02-17 20:44:58,822 INFO [org.apache.catalina.startup.Catalina] - <Server
startup in 42549 ms>
2017-02-17 20:45:10,557 INFO
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/cas]] -
<Initializing Spring FrameworkServlet 'dispatcherServlet'>
2017-02-17 20:45:10,865 INFO [org.apereo.cas.web.flow.InitialFlowSetupAction] -
<Setting path for cookies for warn cookie generator to: /cas/ >
2017-02-17 20:45:10,865 INFO [org.apereo.cas.web.flow.InitialFlowSetupAction] -
<Setting path for cookies for warn cookie generator to: /cas/ >
2017-02-17 20:45:18,391 INFO
[org.apereo.cas.services.DefaultServicesManagerImpl] - <Loaded 2 services from
InMemoryServiceRegistryDaoImpl.>
2017-02-17 20:45:18,430 INFO
[org.apereo.cas.ticket.registry.DefaultTicketRegistryCleaner] - <0 expired
tickets removed.>
2017-02-17 20:45:19,061 INFO
[org.apereo.cas.authentication.PolicyBasedAuthenticationManager] -
<AcceptUsersAuthenticationHandler failed authenticating admin>
2017-02-17 20:45:19,062 WARN
[org.apereo.cas.authentication.PolicyBasedAuthenticationManager] -
<Authentication has failed. Credentials may be incorrect or CAS cannot find
authentication handler that supports [admin] of type
[UsernamePasswordCredential], which suggests a configuration problem.>
2017-02-17 20:45:19,069 INFO
[org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit
trail record BEGIN
=============================================================
WHO: admin
WHAT: Supplied credentials: [admin]
ACTION: AUTHENTICATION_FAILED
APPLICATION: CAS
WHEN: Fri Feb 17 20:45:19 IRST 2017
CLIENT IP ADDRESS: 0:0:0:0:0:0:0:1
SERVER IP ADDRESS: 0:0:0:0:0:0:0:1
=============================================================
>
2017-02-17 20:45:19,069 INFO
[org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit
trail record BEGIN
=============================================================
WHO: admin
WHAT: Supplied credentials: [admin]
ACTION: AUTHENTICATION_FAILED
APPLICATION: CAS
WHEN: Fri Feb 17 20:45:19 IRST 2017
CLIENT IP ADDRESS: 0:0:0:0:0:0:0:1
SERVER IP ADDRESS: 0:0:0:0:0:0:0:1
=============================================================
>
2017-02-17 20:45:19,069 INFO [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - Audit trail record BEGIN ============================================================= WHO: admin WHAT: Supplied credentials: [admin] ACTION: AUTHENTICATION_FAILED APPLICATION: CAS WHEN: Fri Feb 17 20:45:19 IRST 2017 CLIENT IP ADDRESS: 0:0:0:0:0:0:0:1 SERVER IP ADDRESS: 0:0:0:0:0:0:0:1 =============================================================
