search

UniTime / unitime

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

Installation error #171

Closed DoanhTran03 closed 5 months ago

DoanhTran03 commented 6 months ago

Good morning Mrs. Muller, I am currently trying to install unitime but has the following error: image

The versions on my local machine is as following: Tomcat version 8.5.95
unitime version 4.7
MySQL Connector 8.2.0
MySQL 8.2
Complier: Java JDK version 21.0.1 Operating System: Windows 10 Pro

I have followed the instruction on the website including copy war file of unitime to tomcat and place jar file of sql connector to library of tomcat. I would be appreciated if you could help me resolve the above issue

Sincerely, Ngoc Ngoc Doanh Tran

tomas-muller commented 6 months ago

The problem is that UniTime is not able to connect to the database:

java.sql.SQLException: Access denied for user 'timetable'@'localhost' (using password: YES)

Was the user timetable created? Was there any error/message printed during creating the timetable database (execution of file schema.sql)? Are you using the default password (unitime)?

You can try to connect to the database as the timetable user using mysql tool with the following options (also trying to use the same port and protocol as the UniTime application):

mysql --user=timetable --password=unitime --port=3306 --host=localhost --protocol=TCP timetable

If you are able to connect to mysql with mysql -utimetable -punitime timetable but not with mysql --user=timetable --password=unitime --port=3306 --host=localhost --protocol=TCP timetable, the problem could be that TCP/IP networking is disabled.

tomas-muller commented 5 months ago

Duplicate to #174