[cas-user] Re: Cas 5 and problem with jdbc authentication integration

[Hehsni]

I am stuck for 2 weeks trying to run my server case 6 RC3 with a mysql 
database, but nothing works.
I am a novice, I read several tutorial on the web, almost all pages of the 
site apereo but I can not understand several things that blocks me in my 
work.

I try to solve problems as and when but it does not work, at the beginning 
I tested with case v 4.00, then case version 5.2.x and now I decided to 
test with case 6.

I have tomcat 9 and java 11 installed. I cloned master overlay case, then I 
created a folder src / main / resources and in it I copied the folder / etc 
/ config ... containing applications.properties and log4 file ...

I made a ./build.sh package and then I copied paste the cas.war file into / 
opt / tomcat / webapps

Then I typed in my browser https: // myserver: 8443 / case and it works 
fine, with the casusers and Mellon login password. I also have a real 
digicert certificate that I integrated in my keystore and I modified my 
toimcat server.xml, and the ssl works very well.

However, when I try to integrate the information to connect to my mysql 
database which is on another server in my applications.properties file in / 
opt / tomcat / webapps / case / WEB-INF / classes, after have filled in 
some information about my database, I reload tomcat and I get a page 404 ...

Can you help me configure my server please, and especially better 
understand how it works because the documentation on the site apereo is 
horrible or too hard for me.

Sorry for my english, it's a french translation via Google translation ..



Le vendredi 17 février 2017 18:40:32 UTC+1, hadi a écrit :
>
> 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) : 
> 
> 
> org.apereo.cas
> cas-server-webapp
> ${cas.version}
> war
> runtime
> 
> 
> org.apereo.cas
> cas-server-support-jdbc
> ${cas.version}
> 
> 
> com.oracle
> ojdbc6
> 11.2.0
> 
> 
>
>
> * I attached all information to this post.*
> Thanks
>

-- 
- 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+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/fd026da4-a3ad-4339-81b4-552fe61351ca%40apereo.org.

Re: [cas-user] Re: Cas 5 and problem with jdbc authentication integration

[Jihad Talic]

No problem, Mohamad! Glad I could help.

On Saturday, February 25, 2017 at 1:31:15 AM UTC+8, Mohamad Anbari wrote:
>
> Thanks Jihad , I added your extra configuration in application.properties 
> and it works well.
>
> Thanks a lot for your help
>
> On Fri, Feb 24, 2017 at 8:55 AM, Jihad Talic  > wrote:
>
> Thanks, Mohamad. I think you just need to add some required properties in 
> your application.properties file. I am no expert with all these properties 
> but I think it should fix the issue. You can check the default properties 
> in the application.properties of the CAS overlay file at the 
> target/cas/WEB-INF/classes inside you CAS overlay directory,  if you didn't 
> include the application.properties file in the src/main. You can copy them 
> to your current applications.properties file. Or you could just copy this:
>
> ##
> # CAS Server Context Configuration
> #
> server.context-path=/cas
> server.port=8443
>
> server.ssl.key-store=file:/etc/cas/thekeystore
> server.ssl.key-store-password=changeit
> server.ssl.key-password=changeit
> server.max-http-header-size=2097152
> server.max-http-post-size=2097152
> server.use-forward-headers=true
>
> # server.ssl.ciphers=
> # server.ssl.client-auth=
> # server.ssl.enabled=
> # server.ssl.key-alias=
> # server.ssl.key-store-provider=
> # server.ssl.key-store-type=
> # server.ssl.protocol=
> # server.ssl.trust-store=
> # server.ssl.trust-store-password=
> # server.ssl.trust-store-provider=
> # server.ssl.trust-store-type=
> 
> server.tomcat.basedir=build/tomcat
> server.tomcat.accesslog.enabled=true
> server.tomcat.accesslog.pattern=%t %a "%r" %s (%D ms)
> server.tomcat.accesslog.suffix=.log
> server.tomcat.max-threads=5
> server.tomcat.port-header=X-Forwarded-Port
> server.tomcat.protocol-header=X-Forwarded-Proto
> server.tomcat.protocol-header-https-value=https
> server.tomcat.remote-ip-header=X-FORWARDED-FOR
> server.tomcat.uri-encoding=UTF-8
> server.error.include-stacktrace=ALWAYS
> 
> spring.http.encoding.charset=UTF-8
> spring.http.encoding.enabled=true
> spring.http.encoding.force=true
>
> ##
> # CAS Cloud Bus Configuration
> #
> spring.cloud.bus.enabled=false
> # spring.cloud.bus.refresh.enabled=true
> # spring.cloud.bus.env.enabled=true
> # spring.cloud.bus.destination=CasCloudBus
> # spring.cloud.bus.ack.enabled=true
>
> endpoints.enabled=true
> endpoints.sensitive=true
> management.context-path=/status
> endpoints.restart.enabled=false
> endpoints.shutdown.enabled=false
>
>
> ##
> # CAS Web Application Session Configuration
> #
> server.session.timeout=300
> server.session.cookie.http-only=true
> server.session.tracking-modes=COOKIE
>
> ##
> # CAS Thymeleaf View Configuration
> #
> spring.thymeleaf.encoding=UTF-8
> spring.thymeleaf.cache=false
> spring.thymeleaf.mode=HTML
> ##
> # CAS Log4j Configuration
> #
> # logging.config=file:/etc/cas/log4j2.xml
> server.context-parameters.isLog4jAutoInitializationDisabled=true
>
> ##
> # CAS AspectJ Configuration
> #
> spring.aop.auto=true
> spring.aop.proxy-target-class=true
>
> ##
> # CAS Authentication Credentials
> #
> cas.authn.accept.users=casuser::Mellon
>
> That is the default content of the application.properties. Also, don't 
> forget to leave the "cas.authn.accept.users=" blank. Hope this helps!
>
> Cheers,
> Jihad
>
>
> On Friday, February 24, 2017 at 12:14:46 AM UTC+8, Mohamad Anbari wrote:
>
> Hi
>  I have created application.properties in src/main/resources of cas maven 
> overlay template project( i am using cas 5 ) this is my 
> application.properties : 
>
> cas.server.name: https://localhost:8443
> cas.server.prefix: https://localhost:8443/cas
>
> cas.adminPagesSecurity.ip=127\.0\.0\.1
>
> # cas.serviceRegistry.config.location: classpath:/services
>
>
> #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-user] Re: Cas 5 and problem with jdbc authentication integration

[Suman Das]

Hi Mohammad ,

I have used Database Authentication on Postgres.

Please find the below details that i have used in application.properties.


##
# CAS Authentication
#
cas.authn.jdbc.encode[0].numberOfIterations=5
cas.authn.jdbc.encode[0].numberOfIterationsFieldName=hash_iteration
cas.authn.jdbc.encode[0].saltFieldName=salt
cas.authn.jdbc.encode[0].staticSalt=STATIC_SALT
cas.authn.jdbc.encode[0].sql=select * from users where username=?
cas.authn.jdbc.encode[0].algorithmName=SHA-512
cas.authn.jdbc.encode[0].passwordFieldName=password
cas.authn.jdbc.encode[0].healthQuery=SELECT 1
cas.authn.jdbc.encode[0].isolateInternalQueries=false
cas.authn.jdbc.encode[0].url=jdbc:postgresql://localhost:5432/casdb
cas.authn.jdbc.encode[0].failFast=true
cas.authn.jdbc.encode[0].isolationLevelName=ISOLATION_READ_COMMITTED
cas.authn.jdbc.encode[0].dialect=org.hibernate.dialect.PostgreSQLDialect
cas.authn.jdbc.encode[0].leakThreshold=10
cas.authn.jdbc.encode[0].propagationBehaviorName=PROPAGATION_REQUIRED
cas.authn.jdbc.encode[0].batchSize=1
cas.authn.jdbc.encode[0].user=postgres
cas.authn.jdbc.encode[0].ddlAuto=update
cas.authn.jdbc.encode[0].maxAgeDays=180
cas.authn.jdbc.encode[0].password=postgres
cas.authn.jdbc.encode[0].autocommit=false
cas.authn.jdbc.encode[0].driverClass=org.postgresql.Driver
cas.authn.jdbc.encode[0].idleTimeout=5000

##
# CAS Authentication Attributes
#
cas.authn.attributeRepository.attributes.uid=username
#cas.authn.attributeRepository.attributes.displayName=displayName
#cas.authn.attributeRepository.attributes.cn=commonName
#cas.authn.attributeRepository.attributes.affiliation=groupMembership
cas.authn.attributeRepository.attributes.last_name=last_name
cas.authn.attributeRepository.attributes.first_name=first_name
cas.authn.attributeRepository.attributes.user_role=user_role




On Friday, February 17, 2017 at 11:10:32 PM UTC+5:30, Mohamad Anbari wrote:
>
> 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) : 
> 
> 
> org.apereo.cas
> cas-server-webapp
> ${cas.version}
> war
> runtime
> 
> 
> org.apereo.cas
> cas-server-support-jdbc
> ${cas.version}
> 
> 
> com.oracle
> ojdbc6
> 11.2.0
> 
> 
>
>
> * 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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/2f451d28-81c2-4120-9728-2b4e6a1a60c9%40apereo.org.

[cas-user] Re: Cas 5 and problem with jdbc authentication integration

[Jihad Talic]

Thanks, Mohamad. I think you just need to add some required properties in 
your application.properties file. I am no expert with all these properties 
but I think it should fix the issue. You can check the default properties 
in the application.properties of the CAS overlay file at the 
target/cas/WEB-INF/classes inside you CAS overlay directory,  if you didn't 
include the application.properties file in the src/main. You can copy them 
to your current applications.properties file. Or you could just copy this:

##
# CAS Server Context Configuration
#
server.context-path=/cas
server.port=8443

server.ssl.key-store=file:/etc/cas/thekeystore
server.ssl.key-store-password=changeit
server.ssl.key-password=changeit
server.max-http-header-size=2097152
server.max-http-post-size=2097152
server.use-forward-headers=true

# server.ssl.ciphers=
# server.ssl.client-auth=
# server.ssl.enabled=
# server.ssl.key-alias=
# server.ssl.key-store-provider=
# server.ssl.key-store-type=
# server.ssl.protocol=
# server.ssl.trust-store=
# server.ssl.trust-store-password=
# server.ssl.trust-store-provider=
# server.ssl.trust-store-type=

server.tomcat.basedir=build/tomcat
server.tomcat.accesslog.enabled=true
server.tomcat.accesslog.pattern=%t %a "%r" %s (%D ms)
server.tomcat.accesslog.suffix=.log
server.tomcat.max-threads=5
server.tomcat.port-header=X-Forwarded-Port
server.tomcat.protocol-header=X-Forwarded-Proto
server.tomcat.protocol-header-https-value=https
server.tomcat.remote-ip-header=X-FORWARDED-FOR
server.tomcat.uri-encoding=UTF-8
server.error.include-stacktrace=ALWAYS

spring.http.encoding.charset=UTF-8
spring.http.encoding.enabled=true
spring.http.encoding.force=true

##
# CAS Cloud Bus Configuration
#
spring.cloud.bus.enabled=false
# spring.cloud.bus.refresh.enabled=true
# spring.cloud.bus.env.enabled=true
# spring.cloud.bus.destination=CasCloudBus
# spring.cloud.bus.ack.enabled=true

endpoints.enabled=true
endpoints.sensitive=true
management.context-path=/status
endpoints.restart.enabled=false
endpoints.shutdown.enabled=false


##
# CAS Web Application Session Configuration
#
server.session.timeout=300
server.session.cookie.http-only=true
server.session.tracking-modes=COOKIE

##
# CAS Thymeleaf View Configuration
#
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.cache=false
spring.thymeleaf.mode=HTML
##
# CAS Log4j Configuration
#
# logging.config=file:/etc/cas/log4j2.xml
server.context-parameters.isLog4jAutoInitializationDisabled=true

##
# CAS AspectJ Configuration
#
spring.aop.auto=true
spring.aop.proxy-target-class=true

##
# CAS Authentication Credentials
#
cas.authn.accept.users=casuser::Mellon

That is the default content of the application.properties. Also, don't 
forget to leave the "cas.authn.accept.users=" blank. Hope this helps!

Cheers,
Jihad


On Friday, February 24, 2017 at 12:14:46 AM UTC+8, Mohamad Anbari wrote:
>
> Hi
>  I have created application.properties in src/main/resources of cas maven 
> overlay template project( i am using cas 5 ) this is my 
> application.properties : 
>
> cas.server.name: https://localhost:8443
> cas.server.prefix: https://localhost:8443/cas
>
> cas.adminPagesSecurity.ip=127\.0\.0\.1
>
> # cas.serviceRegistry.config.location: classpath:/services
>
>
> #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
>
> #cas.authn.jdbc.query[0].principalTransformation.suffix=
>
> #cas.authn.jdbc.query[0].principalTransformation.caseConversion=NONE|UPPERCASE|LOWERCASE
> #cas.authn.jdbc.query[0].principalTransformation.prefix=
>
> cas.authn.accept.users=
> cas.authn.accept.passwordEncoder.type=DEFAULT
> cas.authn.accept.passwordEncoder.characterEncoding=UTF-8
> cas.authn.accept.passwordEncoder.encodingAlgorithm=MD5
> cas.authn.accept.passwordEncoder.secret=
> 

[cas-user] Re: Cas 5 and problem with jdbc authentication integration

[Jihad Talic]

Hi Mohamad. I think you should put the properties in your 
application.properties file. Also, ensure that the property 
"cas.authn.accept.users" 
blank, or like this:

cas.authn.accept.users=


in order for CAS to utilize your JDBC authentication configuration, and not 
the default static list of users.

On Saturday, February 18, 2017 at 1:40:32 AM UTC+8, Mohamad Anbari wrote:
>
> 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) : 
> 
> 
> org.apereo.cas
> cas-server-webapp
> ${cas.version}
> war
> runtime
> 
> 
> org.apereo.cas
> cas-server-support-jdbc
> ${cas.version}
> 
> 
> com.oracle
> ojdbc6
> 11.2.0
> 
> 
>
>
> * 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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/743c264a-d498-4d39-b592-51a1650313cc%40apereo.org.