Migration from v1.2 to v1.3

• Download jBPM Console v1.3 from https://download.openkm.com/pro/tools
• Stop Tomcat and replace the WAR
• Edit the $TOMCAT_HOME/jbpm-console.properties file and set the hibernate.hbm2ddl configuration property to update:
  

  hibernate.hbm2ddl=update

• Start Tomcat again
• Several new tables will be created:
  • JBPM_USER
  • JBPM_ROLE
  • JBPM_USER_ROLE
• In case these tables are empty, execute these SQL sentences:
  

  -- Users
  INSERT INTO JBPM_USER (USR_ID, USR_PASSWORD, USR_NAME, USR_EMAIL, USR_ACTIVE) VALUES ('admin', '$2a$10$Z5R69bZZgX9z3tU9zjSYyuwE4iAA8Tk58xCnZ8t86Rb3WEg48dNoC', 'Administrator', 'noreply@openkm.com', 'T');
  
  -- Roles
  INSERT INTO JBPM_ROLE (ROL_ID, ROL_ACTIVE) VALUES ('ROLE_ADMIN', 'T');
  
  -- User & Roles
  INSERT INTO JBPM_USER_ROLE (UR_USER, UR_ROLE) VALUES ('admin', 'ROLE_ADMIN');

• Now you will be able to login using the user and password: admin / admin