Hi All, I'm trying to integrate CAS server with my exiting client projects. I'm facing database connection timeout issue.
CAS Version : 4.2.1 Database : PostgreSql In cas.properties, > # == Basic database connection pool configuration == > database.driverClass=org.postgresql.Driver > database.url=jdbc:postgresql://IP-ADDRESS:5432/DBNAME > database.user=username > database.password=password > database.pool.minSize=6 > database.pool.maxSize=18 > > # Maximum amount of time to wait in ms for a connection to become > # available when the pool is exhausted > database.pool.maxWait=10000 > > # Amount of time in seconds after which idle connections > # in excess of minimum size are pruned. > database.pool.maxIdleTime=120 > > # Number of connections to obtain on pool exhaustion condition. > # The maximum pool size is always respected when acquiring > # new connections. > database.pool.acquireIncrement=6 > > # == Connection testing settings == > > # Period in s at which a health query will be issued on idle > # connections to determine connection liveliness. > database.pool.idleConnectionTestPeriod=30 > > # Query executed periodically to test health > database.pool.connectionHealthQuery=select 1 > > # == Database recovery settings == > > # Number of times to retry acquiring a _new_ connection > # when an error is encountered during acquisition. > database.pool.acquireRetryAttempts=5 > > # Amount of time in ms to wait between successive aquire retry attempts. > database.pool.acquireRetryDelay=2000 > > > > # == PDS User record fetch query == # > cas.jdbc.authn.query.sql=select * from user where username = ? > > > After entering login credential from login page, I'm getting the below error. 2018-04-04 17:35:58,718 ERROR [org.jasig.cas.authentication. PolicyBasedAuthenticationManager] - <CustomDatabaseAuthenticationHandler: SQL exception while executing query for testusername (Details: Could not get JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.)> Please update me what has to be done to resolve this. Note : The same cas server setup is working with mysql database but not in postgresql . Regards, Aghil -- - 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/b5cb2526-b354-42d3-ac8b-eb634af4ddc3%40apereo.org.
