UniTime Install Step

Require

• Java Development Kit 6.0+
• Apache Tomcat 7.0+
• MySQL 5.5+ and MySQL Connector/J

1. Download UniTime from UniTime Downloads
2. Extract unitime-4.2_bld175.zip file

3. Setup timetable database

   • MySQL install script are located in /doc/mysql folder of the distribution

   • File schema.sql contains the database schema

     • Edit some SQL statement
     • Old statement

     #OLD Statement
     drop user timetable@localhost;
     create user timetable@localhost identified by password '*2E46E61A1C47ADC309CADC6DF8D89654F013D3DD';
     

     • MariaDB

     #MariaDB
     --drop user timetable@localhost;
     create user 'timetable'@'localhost' identified by '*2E46E61A1C47ADC309CADC6DF8D89654F013D3DD';
     

   • File woebegon-data.sql contains test data

   • Command

     mysql -u root -p -f < schema.sql
     mysql -u root -p < woebegon-data.sql
     

4. Custom configuration file

   • Create file custom.properties located in /UniTime/WEB-INF/classes

   • # MySQL Configuration Example

    connection.url=jdbc:mysql://localhost:3306/timetable
    connection.username=timetable
    connection.password=unitime
    connection.driver_class=com.mysql.jdbc.Driver
    dialect=org.hibernate.dialect.MySQLInnoDBDialect
    tmtbl.uniqueid.generator=org.hibernate.id.TableHiLoGenerator
    default_schema=timetable
   

5. Connector/J

   1. copy mysql connetcto.jar to tomcat/lib

6. Deploy