search

UniTime / unitime

Comprehensive University Timetabling System
http://www.unitime.org
Apache License 2.0
274 stars 162 forks source link

Could not create a DBCP pool (at DBCPConnectionProvider.java:181) #122

Closed kundo-siko closed 2 years ago

kundo-siko commented 2 years ago

Cant seem to figure out why i keep getting this error. followed all the installation instructions but was the site loads on localhost, i am greeted with a login screen and a message that says "UniTime 4.5.177 failed to start up properly, please check the application log for more details." SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure The last packet successfully received from the server was 976 milliseconds ago. The last packet sent successfully to the server was 968 milliseconds ago.) (at BasicDataSource.java:1549)

.... how can i resolve this? Screenshot (10)

tomas-muller commented 2 years ago

The error seems to be related to the following error:

CommunicationsException: SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

which suggests that MySQL is trying to use an SSL connection (which is the default for MySQL 8.0, but usually not 5.7).

Anyway, in the unitime.properties file (see here), could you try to add the following line and restart the Tomcat?

connection.url=jdbc:mysql://localhost:3306/timetable?useSSL=false

this should disable the SSL connection. Alternatively, you can try to set enabledTLSProtocols=TLSv1,TLSv1.1,TLSv1.2 instead (see here or here), that is 

connection.url=jdbc:mysql://localhost:3306/timetable?enabledTLSProtocols=TLSv1,TLSv1.1,TLSv1.2
kundo-siko commented 2 years ago

Thanks, was able to solve the problem by downloading a higher version of MySQL JDBC driver.