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, <[email protected]> 
> 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 [email protected].
>> 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 [email protected].
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