The issue got resolved once I added the postresql library into cas server lib folder.
On Friday, April 6, 2018 at 2:58:02 PM UTC+5:30, Uxío Prego wrote: > > I don't know. > > In Maven environments I would expect the declaration of a postgresql > artifact from the org.postgresql group ID. > > Uxío Prego > > > > Madiva Soluciones > CL / SERRANO GALVACHE 56 > BLOQUE ABEDUL PLANTA 4 > 28033 MADRID > +34 917 56 84 94 > www.madiva.com > www.bbva.com > > The activity of email inboxes can be systematically tracked by colleagues, > business partners and third parties. Turn off automatic loading of images > to hamper it. > > 2018-04-06 6:12 GMT+00:00 Aghil krishna <[email protected] <javascript:> > >: > >> Hi, >> >> I checked the connectivity through my client server (Spring boot) and its >> working fine. Is there any gradle config require for the postgresql ? >> Because I haven't mentioned any gradle config for that. >> >> Regards, >> Aghil T U >> >> On Wednesday, April 4, 2018 at 9:00:15 PM UTC+5:30, Uxío Prego wrote: >>> >>> Can you confirm psql connectivity between the data base and the Java >>> application server (i.e. CAS)? >>> >>> Uxío Prego >>> >>> >>> >>> Madiva Soluciones >>> CL / SERRANO GALVACHE 56 >>> <https://maps.google.com/?q=CL+/+SERRANO+GALVACHE+56&entry=gmail&source=g> >>> BLOQUE ABEDUL PLANTA 4 >>> 28033 MADRID >>> +34 917 56 84 94 >>> www.madiva.com >>> www.bbva.com >>> >>> The activity of email inboxes can be systematically tracked by >>> colleagues, business partners and third parties. Turn off automatic loading >>> of images to hamper it. >>> >>> 2018-04-04 13:17 GMT+00:00 Aghil krishna <[email protected]>: >>> >>>> 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 >>>> >>>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/b5cb2526-b354-42d3-ac8b-eb634af4ddc3%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] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/a/apereo.org/d/msgid/cas-user/a1a7fcb1-ee34-43da-923c-04ff65b4632e%40apereo.org >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/a1a7fcb1-ee34-43da-923c-04ff65b4632e%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/716355ea-6f34-4a78-b3b7-eecbd6fff6c5%40apereo.org.
