[cas-user] JDBC Connection time out

[Li]

Hi, every one, I'm new about CAS. Recently, I'm working on configure CAS to 
authenticate mysql Database. But the JDBC connect database always time out. 
I had changed database connection time from 151 to 15000. The attached file 
are some useful information.

One more question is do I need change below six parameters in 
cas.properties if I set database in another database server.

Thanks

Happy new year~


server.name= http://localhost:8080   

server.prefix=${server.name}/cas


cas.securityContext.status.access=hasIpAddress('127.0.0.1')

cas.securityContext.statistics.access=hasIpAddress('127.0.0.1')

cas.themeResolver.defaultThemeName=cas-theme-default


host.name=cas01.example.org




-- 
- 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/1d0098a9-8ba3-4a0f-9e17-eb56aeaa2cbe%40apereo.org.

catalina.out.rtf
Description: RTF file

deployerConfigContext.rtf
Description: RTF file

{\rtf1\ansi\ansicpg1252\cocoartf1504
{\fonttbl\f0\fnil\fcharset0 Monaco;}
{\colortbl;\red255\green255\blue255;\red0\green0\blue0;\red180\green36\blue25;\red64\green11\blue217;
\red242\green242\blue242;}
{\*\expandedcolortbl;\csgray\c100000;\csgenericrgb\c0\c0\c0;\cssrgb\c76410\c21699\c12524;\cssrgb\c32309\c18668\c88228;
\csgray\c95825;}
\margl1440\margr1440\vieww14360\viewh8400\viewkind0
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural\partightenfactor0

\f0\fs20 \cf2 \CocoaLigature0 server.name= http://localhost:8080   \
server.prefix=$\{server.name\}/cas\cf3 \
\
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural\partightenfactor0
\cf4 # Spring Security's EL-based access rules for the /status URI of CAS that 
exposes health check information\cf5 \
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural\partightenfactor0
\cf2 cas.securityContext.status.access=hasIpAddress('127.0.0.1')\cf5 \
\
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural\partightenfactor0
\cf4 # Spring Security's EL-based access rules for the /statistics URI of CAS 
that exposes stats about the CAS server\cf5 \
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural\partightenfactor0
\cf2 cas.securityContext.statistics.access=hasIpAddress('127.0.0.1')\cf5 \
\
\cf2 cas.themeResolver.defaultThemeName=cas-theme-default\cf3 \
\
\cf2 host.name=cas01.example.org\cf3 \
\
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural\partightenfactor0
\cf4 # == Basic database connection pool configuration ==\cf5 \
    \cf2 database.driverClass=com.mysql.jdbc.Driver\
    database.url=jdbc:mysql://xx.xxx.xxx.xxx/database_name\
    database.user=user\
    database.password=user_password\
    database.pool.minSize=6\
    database.pool.maxSize=1800\cf5 \
\
\cf4     # Maximum amount of time to wait in ms for a connection to become\cf5 \
\cf4     # available when the pool is exhausted\cf5 \
    \cf2 database.pool.maxWait=10000\cf5 \
\
\cf4     # Amount of time in seconds after which idle connections\cf5 \
\cf4     # in excess of minimum size are pruned.\cf5 \
    \cf2 database.pool.maxIdleTime=120\cf5 \
\
\cf4     # Number of connections to obtain on pool exhaustion condition.\cf5 \
\cf4     # The maximum pool size is always respected when acquiring\cf5 \
\cf4     # new connections.\cf5 \
    \cf2 database.pool.acquireIncrement=6\cf5 \
\
\cf4     # == Connection testing settings ==\cf5 \
\
\cf4     # Period in s at which a health query will be issued on idle\cf5 \
\cf4     # connections to determine connection liveliness.\cf5 \
    \cf2 database.pool.idleConnectionTestPeriod=30\cf5 \
\
\
\cf4     # == Database recovery settings ==\cf5 \
\
\cf4     # Number of times to retry acquiring a _new_ connection\cf5 \
\cf4     # when an error is encountered during acquisition.\cf5 \
    \cf2 database.pool.acquireRetryAttempts=5\cf5 \
\
\cf4     # Amount of time in ms to wait between successive aquire retry 
attempts.\cf5 \
    \cf2 database.pool.acquireRetryDelay=2000}