Karolinska Institutet - a medical university
Search LIME's website
to ki.se
to lime.ki.se
to patientcases.org
 

Upgrading from 1.9 to 2.0

  1. Shutdown Web-SP (./shutdown.sh -s 127.0.0.1 -S)
  2. Perform full backup of database, and file structure.
  3. Unpack Web-SP 2.0 in it's final location
  4. Edit (or copy from backup) database access info (../server/websp/deploy/mysql-ds.xml)
  5. Edit (or copy from backup) the mail info (../server/websp/deploy/mail-service.xml)
  6. Move a copy of "UPLOADED_MEDIA" and "CASE_IMAGES" from the backup to ../server/websp/deploy/websp.ear/websp.war/view
  7. Start Web-SP 2.0 (keep the ssh terminal window open)
  8. Shutdown Web-SP again (new db tabels are created)
  9. Upgrade db with add_fields.sql and add_indexes.sql
  10. Start Web-SP (cd /bin then ./run.sh -c websp)
  11. Login
  12. Convert patient cases
  • Open a new browser window (right-click on the websp window to keep the same session) and enter http://xxxx:xxx/websp/view/PortingOldCases
  • Wait until all the cases are converted - you may monitor the progress via the ssh terminal window

sql files to upgrade a web-sp 1.9 db - sql_upgrade.zip

Post install instructions

The PortingOldCases utility is not needed anymore and should be deleted/disabled.

1. edit $JBOSS_HOME\server\websp\deploy\websp.ear\websp.war\WEB-INF\web.xml
2. delete:

<servlet>
            <servlet-name>PortingOldCasesServlet</servlet-name>
            <servlet-class>se.ki.lime.wasp.controller.PortingOldCasesServlet</servlet-class>
            <init-param>
                <param-name>se.ki.lime.wasp.controller.PortingOldCasesServlet.servlet-path-prefix</param-name>
                <param-value>/view/</param-value>
                <description>
                    The servlet context path,
                    against which media paths are relative
                </description>
            </init-param>
            <load-on-startup>1</load-on-startup>
        </servlet>
AND

<servlet-mapping>
                <servlet-name>PortingOldCasesServlet</servlet-name>
                <url-pattern>/view/PortingOldCases</url-pattern>
        </servlet-mapping>

3. Delete
$JBOSS_HOME\server\websp\deploy\websp.ear\websp.war\WEB-INF\classes\se\ki\lime\wasp\controller\PortingOldCasesServlet.class

  Printable page