CAS and database

icoundoul

unread,

Jan 7, 2020, 5:23:12 AM1/7/20

to CAS Community

Hello,

I have clone this project https://github.com/casinthecloud/cas-pac4j-oauth-demo and it build sucessfully.
So I would to know how to modify it for using my database for validating users credentials.

Thanks.

Ray Bon

unread,

Jan 7, 2020, 11:35:27 AM1/7/20

to cas-...@apereo.org

Ibrahima,

Take a look at https://dacurry-tns.github.io/deploying-apereo-cas/introduction_overview.html

Ray

--

Ray Bon

Programmer Analyst

Development Services, University Systems

2507218831 | CLE 019 | rb...@uvic.ca

I respectfully acknowledge that my place of work is located within the ancestral, traditional and unceded territory of the Songhees, Esquimalt and WSÁNEĆ Nations.

Andy Ng

unread,

Jan 7, 2020, 8:44:03 PM1/7/20

to CAS Community

Hi,

I would highly recommend following https://dacurry-tns.github.io/deploying-apereo-cas/introduction_overview.html and read through it so you get a better idea of how CAS works in generaal.

However, if you just want your database to setup and don't want to dive deep, you might follows this:

https://apereo.github.io/cas/6.1.x/configuration/Configuration-Properties.html#query-database-authentication

So, put the below in the application.properties

===================================================

cas.authn.jdbc.query[0].url: jdbc:mariadb://your.database.url/database?useSSL=true

cas.authn.jdbc.query[0].user: db_admin

cas.authn.jdbc.query[0].password: dbAdminSecretpa33w0rd

cas.authn.jdbc.query[0].driverClass: org.mariadb.jdbc.Driver

cas.authn.jdbc.query[0].dialect: org.hibernate.dialect.MariaDBDialect

cas.authn.jdbc.query[0].sql=SELECT * FROM table WHERE name=?

cas.authn.jdbc.query[0].fieldPassword=password

===================================================

And this to your pom.xml, in the <dependencies> section

<dependency>
    <groupId>org.apereo.cas</groupId>
    <artifactId>cas-server-support-jdbc</artifactId>
    <version>${cas.version}</version>
</dependency>

And... your should be be able to login using database.

See if the above helps you..

Cheers!

- Andy

Ibrahima Coundoul

unread,

Jan 8, 2020, 4:44:31 AM1/8/20

to cas-...@apereo.org

Hello,

Ray, Andy, thansks a lot for your responses, I study them quietly.

Regards

Ibrahima

--
- 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 cas-user+u...@apereo.org.
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/8e1c5a01-f2a4-4b0d-b13e-b35841602511%40apereo.org.

--

Cordialement,

Ibrahima COUNDOUL

JAVA / JEE Senior Developper & DevOps
Oracle Certified Professional, Java EE 5 Web Component Developer (2012)
Oracle Certified Professional, Java SE 6 Programmer( 2012)

Ibrahima Coundoul

unread,

Jan 9, 2020, 12:23:55 PM1/9/20

to cas-...@apereo.org

Hi Ray, Andy,

At the step "Adding a service registry" , the buid faillure when I add this dependency:

<dependency>
        <groupId>org.apereo.cas</groupId>
        <artifactId>cas-server-support-json-service-registry</artifactId>


        <version>${cas.version}</version>
</dependency>

ERRORs Message:
 
[DEBUG] -----------------------------------------------------------------------
[DEBUG] Goal:          org.apache.maven.plugins:maven-war-plugin:2.6:war (default-war)
[DEBUG] Style:         Regular
[DEBUG] Configuration: <?xml version="1.0" encoding="UTF-8"?>
<configuration>
  <archive>
    <compress>false</compress>
    <manifestFile>D:\projects\cas-sso\cas-overlay-template\target/war/work/org.apereo.cas/cas-server-webapp-tomcat/META-INF/MANIFEST.MF</manifestFile>
  </archive>
  <archiveClasses default-value="false">${archiveClasses}</archiveClasses>
  <attachClasses default-value="false"/>
  <cacheFile default-value="${project.build.directory}/war/work/webapp-cache.xml"/>
  <classesClassifier default-value="classes"/>
  <classesDirectory default-value="${project.build.outputDirectory}"/>
  <containerConfigXML>${maven.war.containerConfigXML}</containerConfigXML>
  <escapeString>${maven.war.escapeString}</escapeString>
  <escapedBackslashesInFilePath default-value="false">${maven.war.escapedBackslashesInFilePath}</escapedBackslashesInFilePath>
  <failOnMissingWebXml default-value="true">false</failOnMissingWebXml>
  <filteringDeploymentDescriptors default-value="false">${maven.war.filteringDeploymentDescriptors}</filteringDeploymentDescriptors>
  <includeEmptyDirectories default-value="false"/>
  <outputDirectory default-value="${project.build.directory}"/>
  <overlays>
    <overlay>
      <groupId>org.apereo.cas</groupId>
      <artifactId>cas-server-webapp-tomcat</artifactId>
    </overlay>
  </overlays>
  <primaryArtifact default-value="true">${primaryArtifact}</primaryArtifact>
  <project default-value="${project}"/>
  <recompressZippedFiles default-value="true">false</recompressZippedFiles>
  <resourceEncoding default-value="${project.build.sourceEncoding}">${resourceEncoding}</resourceEncoding>
  <session default-value="${session}"/>
  <supportMultiLineFiltering default-value="false">${maven.war.supportMultiLineFiltering}</supportMultiLineFiltering>
  <useCache default-value="false">${useCache}</useCache>
  <useJvmChmod default-value="true">${maven.war.useJvmChmod}</useJvmChmod>
  <warName default-value="${project.build.finalName}">cas</warName>
  <warSourceDirectory default-value="${basedir}/src/main/webapp"/>
  <warSourceIncludes default-value="**"/>
  <webXml>${maven.war.webxml}</webXml>
  <webappDirectory default-value="${project.build.directory}/${project.build.finalName}"/>
  <workDirectory default-value="${project.build.directory}/war/work"/>
</configuration>
[DEBUG] =======================================================================
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 0.699 s
[INFO] Finished at: 2020-01-08T16:08:35+01:00
[INFO] Final Memory: 13M/155M
[INFO] ------------------------------------------------------------------------
[ERROR] 31659
java.lang.ArrayIndexOutOfBoundsException: 31659
        at org.codehaus.plexus.util.xml.pull.MXParser.parsePI(MXParser.java:2502)
        at org.codehaus.plexus.util.xml.pull.MXParser.parseEpilog(MXParser.java:1604)
        at org.codehaus.plexus.util.xml.pull.MXParser.nextImpl(MXParser.java:1434)
        at org.codehaus.plexus.util.xml.pull.MXParser.next(MXParser.java:1131)
        at org.apache.maven.model.io.xpp3.MavenXpp3Reader.read(MavenXpp3Reader.java:3856)
        at org.apache.maven.model.io.xpp3.MavenXpp3Reader.read(MavenXpp3Reader.java:595)
        at org.apache.maven.model.io.DefaultModelReader.read(DefaultModelReader.java:109)
        at org.apache.maven.model.io.DefaultModelReader.read(DefaultModelReader.java:82)
        at org.apache.maven.model.building.DefaultModelProcessor.read(DefaultModelProcessor.java:81)
        at org.apache.maven.model.building.DefaultModelBuilder.readModel(DefaultModelBuilder.java:535)
        at org.apache.maven.model.building.DefaultModelBuilder.readParentExternally(DefaultModelBuilder.java:1097)
        at org.apache.maven.model.building.DefaultModelBuilder.readParent(DefaultModelBuilder.java:829)
        at org.apache.maven.model.building.DefaultModelBuilder.build(DefaultModelBuilder.java:331)
        at org.apache.maven.repository.internal.DefaultArtifactDescriptorReader.loadPom(DefaultArtifactDescriptorReader.java:321)
        at org.apache.maven.repository.internal.DefaultArtifactDescriptorReader.readArtifactDescriptor(DefaultArtifactDescriptorReader.java:199)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.resolveCachedArtifactDescriptor(DefaultDependencyCollector.java:544)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.getArtifactDescriptorResult(DefaultDependencyCollector.java:528)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:418)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:372)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.process(DefaultDependencyCollector.java:360)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.doRecurse(DefaultDependencyCollector.java:513)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:467)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:372)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.process(DefaultDependencyCollector.java:360)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.doRecurse(DefaultDependencyCollector.java:513)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:467)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:372)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.process(DefaultDependencyCollector.java:360)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.doRecurse(DefaultDependencyCollector.java:513)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:467)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:372)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.process(DefaultDependencyCollector.java:360)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.doRecurse(DefaultDependencyCollector.java:513)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:467)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:372)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.process(DefaultDependencyCollector.java:360)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.doRecurse(DefaultDependencyCollector.java:513)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:467)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.processDependency(DefaultDependencyCollector.java:372)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.process(DefaultDependencyCollector.java:360)
        at org.eclipse.aether.internal.impl.DefaultDependencyCollector.collectDependencies(DefaultDependencyCollector.java:263)

Andy Ng

unread,

Jan 12, 2020, 1:47:06 AM1/12/20

to CAS Community

Hi there,

If you look at the file here: https://github.com/casinthecloud/cas-pac4j-oauth-demo/blob/master/pom.xml

You will see that the repo you use, are using the SNAPSHOT version of 6.2.0-RC1-SNAPSHOT.

The SNAPSHOT version doesn't make stability a high priority, so you are better sticking to version that are not SNAPSHOT.

For example, you can use the 6.1.x branch in the repo: https://github.com/casinthecloud/cas-pac4j-oauth-demo/tree/6.1.x

You can try that first, if it didn't work as well, then post here and see if there are other problems :)

Cheers!

- Andy

Ibrahima Coundoul

unread,

Jan 14, 2020, 5:04:23 AM1/14/20

to cas-...@apereo.org

Hi all,

Thanks a lot for your usefuls responses ;-). I also really like this page https://dacurry-tns.github.io/deploying-apereo-cas/introduction_overview.html.

Now I have a fearture to implements, I'll create new topic in the chanel;-)

regards.

--

- 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 cas-user+u...@apereo.org.

To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/7e04b3c3-7816-412c-ac6b-4f49073ed483%40apereo.org.

Reply all

Reply to author

Forward