Hello,
I used my own MD5 encoder method to populate my database and I thought the
issue could come from here but I ended up creating three users with
password as such:
username : "test1" password : "test"
username : "test2" password
: "09-8F-6B-CD-46-21-D3-73-CA-DE-4E-83-26-27-B4-F6"
username : "test3" password : "098f6bcd4621d373cade4e832627b4f6"
And I'm testing all three users each time to make sure it's not an encoder
problem...
Regardless of this possible issue, which log would you need to know more ?
And where would it be located ?
Thank you,
Valentine
Tuesday 19 April 2016 12:38:20 UTC+2, Dmitriy Kopylenko wrote :
>
> I'm just speculating here since you did not provide any detailed logs: are
> you storing the password values in the password column for your users in
> plain text? If so, the DB authn handler delegates to the password encoder
> to hash the provided credentials and compare it to the password value
> stored in DB resulting in a rightful comparison failure, etc.
>
> Cheers,
> D.
>
> On Tue, Apr 19, 2016 at 03:02, Valentine Rouzaud <[email protected]
> <javascript:>> wrote:
>
> I've recently taken interest in the CAS system for a work project using
> ASP.NET MVC applications. So I made a simple test project following MVC
> and I am now trying to link my MSSQL database (generated with Entity
> Framework of Visual Studio 2015 Pro) and my CAS so that the CAS server can
> check my project's database for users when they try to log in.
>
> I am using CAS 4.0.1 so I've followed this tutorial:
> https://jasig.github.io/cas/4.0.x/installation/Database-Authentication.html
> which ends up looking like the following code:
>
> In the "deployerConfigContext.xml"
>
> <bean id="authenticationManager"
>> class="org.jasig.cas.authentication.PolicyBasedAuthenticationManager">
>> <constructor-arg>
>> <map>
>> <entry key-ref="primaryAuthenticationHandler" value-ref="dbAuthHandler"/>
>> </map>
>> </constructor-arg>
>> <property name="authenticationPolicy">
>> <bean class="org.jasig.cas.authentication.AnyAuthenticationPolicy" />
>> </property>
>> </bean>
>> <bean id="passwordEncoder"
>> class="org.jasig.cas.authentication.handler.DefaultPasswordEncoder"
>> c:encodingAlgorithm="MD5"
>> p:characterEncoding="UTF-8" />
>> <bean id="dbAuthHandler"
>>
>> class="org.jasig.cas.adaptors.jdbc.SearchModeSearchDatabaseAuthenticationHandler"
>> p:dataSource-ref="dataSource"
>> p:passwordEncoder-ref="passwordEncoder"
>> p:tableUsers="Users"
>> p:fieldUser="Username"
>> p:fieldPassword="PassWord"/>
>> <bean id="dataSource"
>> class="org.apache.tomcat.jdbc.pool"
>> p:driverClass="${database.driverClass}"
>> p:jdbcUrl="${database.url}"
>> p:user="${database.user}"
>> p:password="${database.password}" />
>
>
> In the "cas.properties" file
>
> database.driverClass=com.microsoft.jdbc.sqlserver
>>
>> database.url=jdbc:sqlserver://localhost:59228;DatabaseName=ConnectionTest.Models.DatabaseContext
>> database.user=casAdmin
>> database.password=casPwd
>
>
> And in the pom.xml file
>
> <dependencies>
>> <dependency>
>> <groupId>org.jasig.cas</groupId>
>> <artifactId>cas-server-webapp</artifactId>
>> <version>${cas.version}</version>
>> <type>war</type>
>> <scope>runtime</scope>
>> </dependency>
>> <dependency>
>> <groupId>org.jasig.cas</groupId>
>> <artifactId>cas-server-support-jdbc</artifactId>
>> <version>${cas.version}</version>
>> </dependency>
>> <dependency>
>> <groupId>com.microsoft.sqlserver</groupId>
>> <artifactId>sqljdbc4</artifactId>
>> <version>4.0</version>
>> </dependency>
>> <dependency>
>> <groupId>c3p0</groupId>
>> <artifactId>c3p0</artifactId>
>> <version>0.9.1.2</version>
>> </dependency>
>> <-- I tried with Tomcat JDBC driver instead of C3P0
>> but it didn't seem to have changed anything -->
>> <dependency>
>> <groupId>org.apache.tomcat</groupId>
>> <artifactId>tomcat-jdbc</artifactId>
>> <version>9.0.0.M4</version>
>> </dependency>
>> </dependencies>
>> <properties>
>> <cas.version>4.0.1</cas.version>
>> </properties>
>
>
> I'm not getting any errors when building with Maven (3.3.9) nor when
> deploying with Tomcat (9.0.0.M4) but when I try to log in on the CAS with
> some of my DB's credentials it just tells me that my crendentials are
> invalid. After some advice, I've found what seems to be the correct MSSQL
> driver but I'm still not sure about the exact formatting given that I still
> cannot log in with users from my DB. I'm suspecting the database URL to
> be written with the wrong syntax but I'm not sure how to write it
> otherwise.
>
> Any help is appreciated, thanks.
> Regards,
>
> Valentine
>
> --
> 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 post to this group, send email to [email protected] <javascript:>.
> Visit this group at https://groups.google.com/a/apereo.org/group/cas-user/
> .
> To view this discussion on the web visit
> https://groups.google.com/a/apereo.org/d/msgid/cas-user/a3771230-f565-4821-a0f1-50f5dfab3ef6%40apereo.org
>
> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/a3771230-f565-4821-a0f1-50f5dfab3ef6%40apereo.org?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/a/apereo.org/d/optout.
>
>
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/a/apereo.org/group/cas-user/.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/860f9127-f19b-4f54-9302-bf5494dc6687%40apereo.org.
For more options, visit https://groups.google.com/a/apereo.org/d/optout.
