Hi Krishna,
finally we found problem, it was regarding tls protocol to use. Forcing use 
of 1.2 works.

Thanks
Bye

Il giorno lunedì 17 ottobre 2022 alle 05:19:45 UTC+2 Krishna Prasad ha 
scritto:

> Hi Andera,
>
> Please try to reproduce with simple jdbc program if possible. This mostly 
> because of driver url format and driver version of it.
>
> On Fri, 14 Oct, 2022, 16:44 Andrea Colajacomo, <andrea.c...@alecsandria.it> 
> wrote:
>
>> Hello guys,
>> we are facing a strange issue.
>> We have cas running on GCP 
>> After starting our instance we can see this error in the logs
>>
>> 2022-10-14 10:56:39,178 INFO 
>> [org.apereo.cas.configuration.DefaultCasConfigurationPropertiesSourceLocator]
>>  
>> - <Configuration files found at [/etc/cas/config] are [[file 
>> [/etc/cas/config/cas.properties]]] under profile(s) [[standalone]]>
>> Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver 
>> class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered 
>> via the SPI and manual loading of the driver class is generally unnecessary.
>> 2022-10-14 10:57:05,008 WARN [com.zaxxer.hikari.util.DriverDataSource] - 
>> <Registered driver with driverClassName=com.mysql.jdbc.Driver was not 
>> found, trying direct instantiation.>
>> 2022-10-14 10:57:05,687 ERROR [com.zaxxer.hikari.pool.HikariPool] - 
>> <HikariPool-1 - Exception during pool initialization.>
>> com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link 
>> failure
>>
>> The last packet sent successfully to the server was 0 milliseconds ago. 
>> The driver has not received any packets from the server.
>>         at 
>> com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
>>  
>> ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
>>         at 
>> com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
>>  
>> ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
>>         at 
>> com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) 
>> ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
>>         at 
>> com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) 
>> ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
>>         at 
>> com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) 
>> ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
>>         at 
>> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
>>  
>> ~[mysql-connector-java-8.0.18.jar!/:8.0.18]
>>         at 
>> com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
>>  
>> ~[HikariCP-3.4.1.jar!/:?]
>>         at 
>> com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:353) 
>> ~[HikariCP-3.4.1.jar!/:?]
>>         at 
>> com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) 
>> ~[HikariCP-3.4.1.jar!/:?]
>>         at 
>> com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473) 
>> ~[HikariCP-3.4.1.jar!/:?]
>>         at 
>> com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:562) 
>> ~[HikariCP-3.4.1.jar!/:?]
>>         at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) 
>> ~[HikariCP-3.4.1.jar!/:?]
>>         at 
>> com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) 
>> ~[HikariCP-3.4.1.jar!/:?]
>>         at 
>> org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
>>  
>> ~[hibernate-core-5.4.9.Final.jar!/:5.4.9.Final]
>> ...
>> ...
>> ...
>> ...
>>
>> If we push the previous build it works fine, but nothing has been changed 
>> in the cas configuration, nothing on DB side. The only change contained in 
>> the new build is something related to the frontend.
>> We test also network connection and it is fine.
>>
>> Does anyone have any kind of suggestion ?
>>
>> Bye
>>
>> -- 
>> - 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+u...@apereo.org.
>> To view this discussion on the web visit 
>> https://groups.google.com/a/apereo.org/d/msgid/cas-user/4b402ac7-0c5f-47a4-a614-4367d3a7b761n%40apereo.org
>>  
>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/4b402ac7-0c5f-47a4-a614-4367d3a7b761n%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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/5fb1688a-0621-473b-b512-5286c0c56171n%40apereo.org.

Reply via email to