For your/future information, if you are using maven , you should add the
following code to your pom.xml to make it works:
* <dependency>*
* <groupId>org.apereo.cas</groupId>*
* <artifactId>cas-server-support-jdbc</artifactId>*
* <version>${cas.version}</version>*
* </dependency>** <dependency>*
* <groupId>org.apereo.cas</groupId>*
* <artifactId>cas-server-support-jdbc-drivers</artifactId>*
* <version>${cas.version}</version>*
* </dependency>*
On Friday, January 6, 2017 at 1:49:42 AM UTC+8, mrcasa bengaluru wrote:
>
> Are you using the gradle or maven overlay method?
>
> If so, you have add the cas jdbc dependencies in your cas/build.gradle of
> pom.xml file
>
> cas-server-support-jdbc
> <https://github.com/apereo/cas/tree/master/support/cas-server-support-jdbc>
> cas-server-support-jdbc-drivers
> <https://github.com/apereo/cas/tree/master/support/cas-server-support-jdbc-drivers>
>
>
> On Tue, Dec 27, 2016 at 8:04 AM, bob <[email protected] <javascript:>>
> wrote:
>
>> Hello MVK, I met the same problem, you solve now ?
>>
>> 在 2016年12月21日星期三 UTC+8上午5:49:51，mvk写道：
>>
>>> Hi All.
>>> I am trying to setup CAS 5.0.0.
>>>
>>> So I installed CAS 5.0.0 per instructions and all works and now I am
>>> trying to add a simple mysql authentication.
>>>
>>> This is the code I added to the application.properties. I tried to run
>>> search function as well as query with and without [], I changed the
>>> password with different encoding options. Nothing seem to make a
>>> difference. Note: the name of the user database is called "user", it is not
>>> a type :)
>>>
>>> cas.authn.jdbc.query.fieldUser=username
>>>
>>> cas.authn.jdbc.query.sql=SELECT password FROM user WHERE username=?
>>>
>>> cas.authn.jdbc.query.healthQuery=SELECT 1 FROM db_example.user
>>>
>>> cas.authn.jdbc.query.tableUsers=user
>>>
>>> cas.authn.jdbc.query.fieldPassword=password
>>>
>>> cas.authn.jdbc.query.passwordEncoder.type=DEFAULT
>>>
>>>
>>>
>>> cas.authn.jdbc.query.url=jdbc:mysql://localhost:3306/db_example
>>>
>>>
>>>
>>> cas.authn.jdbc.query.user=dbuser
>>>
>>> cas.authn.jdbc.query.password=dbpassword
>>>
>>> cas.authn.jdbc.query.driverClass=com.mysql.jdbc.Driver
>>>
>>> This is the error I am getting
>>>
>>> <Authentication has failed. Credentials may be incorrect or CAS cannot
>>> find authentication handler that supports [admin] of type
>>> [UsernamePasswordCredential], which suggests a configuration problem.>
>>>
>>> I am missing something not sure what it is. Any pointers and tips are
>>> greatly appreciated.
>>>
>> --
>> - 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/ef395ee1-0951-4325-94c3-c8541ca9c34e%40apereo.org
>>
>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/ef395ee1-0951-4325-94c3-c8541ca9c34e%40apereo.org?utm_medium=email&utm_source=footer>
>> .
>>
>
>
--
- 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/f01baa75-a1bd-4ae1-89c9-a3bd8a68712b%40apereo.org.
