Authentication failed: could not extract ResultSet ( on Windows Installation)

[evanduffel]

Hello,

I've just installed Unitime 4.4 on a new Win10-system. I've followed the provided manual. While trying to login I'm getting following error: "Authentication failed: could not extract ResultSet"

What could be the cause?

THX

[tomas-muller]

Looks like your database was not properly updated during the first deployment of UniTime. You need to use both the schema.sql and either the woebegon-data.sql or blank-data.sql. You can fix that by:

1. stop the Tomcat
2. run the blank-data.sql or woebegon-data.sql (if this does not work, run schema.sql first, then xx-data.sql again)
3. start the Tomcat

Check the logs, you should see something like this:

[07/09/20 04:01:55] INFO   <init> -> Reading file:/Applications/apache-tomcat-9.0.13/webapps/UniTime/WEB-INF/lib/timetable.jar!/dbupdate.xml ...
[07/09/20 04:01:55] INFO   DatabaseUpdate -> Current UniTime database version: 123
[07/09/20 04:01:55] INFO   DatabaseUpdate ->   Performing UniTime update to version 124 (Instructor Note)
[07/09/20 04:01:55] INFO   DatabaseUpdate ->     UniTime Database version increased to: 124
...
[07/09/20 04:02:10] INFO   DatabaseUpdate ->   Performing UniTime update to version 228 (Advisor Critical Course Requests)
[07/09/20 04:02:10] INFO   DatabaseUpdate ->     UniTime Database version increased to: 228
[07/09/20 04:02:10] INFO   DatabaseUpdate ->   Performing UniTime update to version 229 (Important Course Demands)
[07/09/20 04:02:11] INFO   DatabaseUpdate ->     UniTime Database version increased to: 229
[07/09/20 04:02:11] INFO   DatabaseUpdate ->   Performing UniTime update to version 230 (Instructor Unavailable Days)
[07/09/20 04:02:11] INFO   DatabaseUpdate ->     UniTime Database version increased to: 230
[07/09/20 04:02:11] INFO   DatabaseUpdate -> New UniTime database version: 230

The last version depends on the UniTime version that you are trying to install. It is 225 for the latest UniTime 4.4, 233 for the latest UniTime 4.5.

[evanduffel]

Thx Tomas,

This solved the problem. I'm curious for the power of UniTime.

Kind regards,

Eli van Duffel ICT-coördinator Don Bosco Haacht, Belgium

Op wo 28 okt. 2020 om 11:55 schreef Tomáš Müller notifications@github.com:

Looks like your database was not properly updated during the first deployment of UniTime. You need to use both the schema.sql and either the woebegon-data.sql or blank-data.sql. You can fix that by:

1. stop the Tomcat
2. run the blank-data.sql or woebegon-data.sql (if this does not work, run schema.sql first, then xx-data.sql again)
3. start the Tomcat

Check the logs, you should see something like this:

[07/09/20 04:01:55] INFO -> Reading file:/Applications/apache-tomcat-9.0.13/webapps/UniTime/WEB-INF/lib/timetable.jar!/dbupdate.xml ... [07/09/20 04:01:55] INFO DatabaseUpdate -> Current UniTime database version: 123 [07/09/20 04:01:55] INFO DatabaseUpdate -> Performing UniTime update to version 124 (Instructor Note) [07/09/20 04:01:55] INFO DatabaseUpdate -> UniTime Database version increased to: 124 ... [07/09/20 04:02:10] INFO DatabaseUpdate -> Performing UniTime update to version 228 (Advisor Critical Course Requests) [07/09/20 04:02:10] INFO DatabaseUpdate -> UniTime Database version increased to: 228 [07/09/20 04:02:10] INFO DatabaseUpdate -> Performing UniTime update to version 229 (Important Course Demands) [07/09/20 04:02:11] INFO DatabaseUpdate -> UniTime Database version increased to: 229 [07/09/20 04:02:11] INFO DatabaseUpdate -> Performing UniTime update to version 230 (Instructor Unavailable Days) [07/09/20 04:02:11] INFO DatabaseUpdate -> UniTime Database version increased to: 230 [07/09/20 04:02:11] INFO DatabaseUpdate -> New UniTime database version: 230

The last version depends on the UniTime version that you are trying to install. It is 225 for the latest UniTime 4.4, 233 for the latest UniTime 4.5.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/UniTime/unitime/issues/68#issuecomment-717854566, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARRNWFJXNWVC55KXPRG5HVDSM72AZANCNFSM4TCEUSGA .