Update of template files and scripts to allow new versions of external software

[olle]

Configuration template files and scripts should be updated to allow Proteios SE to work with new versions of external software. The updates range from those necessary to use a new external software version, to updates that simplify use of the latter. The updates should include:

• Configuration template files client/servlet/conf/proteios.config.in and client/ftpd/conf/ftp.properties.in: Setting db.dialect should be updated from org.hibernate.dialect.MySQLInnoDBDialect to org.hibernate.dialect.MySQL5InnoDBDialect, in order to simplify use of MySQL version 5.5 (the new setting should still be compatible with the currently recommended version MySQL 5.1).
• Unix/Linux *.sh shell scripts should have the so called "shebang" line (the first line defining a command shell) changed from "#!/bin/sh" to "#!/bin/bash", in order to make the scripts work on Ubunto Linux without explicitly defining the shell. On most Linux distributions /bin/sh is linked to /bin/bash, so the change should not be noticed, while Ubunto links bin/sh to /bin/dash, and therefore requires the update, since some functionality in /bin/bash is missing in the latter.

[olle]

Ticket accepted.

[olle]

Design discussion.

• The issue of the db.dialect change is discussed for Proteios SE sister project BASE (​http://base.thep.lu.se) in BASE Ticket ​#1566 (MySQL 5.5 no longer supports CREATE TABLE ... TYPE=InnoDB).

[olle]

(In [4370]) Refs #788. Changes the default dialect to org.hibernate.dialect.MySQL5InnoDBDialect in configuration template files client/servlet/conf/proteios.config.in and client/ftpd/conf/ftp.properties.in in order to simplify use of MySQL version 5.5.

[olle]

Design descussion.

The following *.sh shell scripts should have their shebang line changed from "#!/bin/sh" to "#!/bin/bash":

1. client/servlet/test/src/webservice/run.sh
2. client/servlet/www/WEB-INF/init.sh
3. client/servlet/www/WEB-INF/update.sh
4. doc/course/install.sh
5. doc/course/src/exercise/bin/new_project.sh
6. misc/install/install.sh
7. misc/shell.sh

[olle]

(In [4371]) Refs #788. Unix/Linux *.sh shell scripts have the shebang line changed from "#!/bin/sh" to "#!/bin/bash", in order to make the scripts work on Ubunto Linux without explicitly defining the shell.

[olle]

New issue - Using Proteios SE with Tomcat 7.

When installing Proteios SE on a system using Tomcat 7 (Tomcat 7.0.30 for the test system), when the latter was restarted and one tried to access Proteios SE in the web browser (on the test system via URL http://localhost:8080/proteios/), an error message was displayed for the <error-page> tags in the web.xml file (java.lang.NoSuchMethodException: org.apache.catalina.WebXml addErrorPage).

Inspection revealed that the problem was caused by the files catalina.jar and catalina-optional.jar in $CATALINA_HOME/webapps/proteios/WEB-INF/lib/, and that the files were not needed in that directory, although they might be needed at an earlier stage in the software building process. Further tests showed that the files also were not needed on systems using Tomcat 6, although they did not cause any problems there. The outermost ant build file build.xml should therefore be updated to exclude these files when copying files to an intermediate directory, from which files are later copied to directory $CATALINA_HOME/webapps/proteios/WEB-INF/lib/ during the installation.

[olle]

(In [4372]) Refs #788. Outermost ant build file build.xml updated for target "dist-jar" to exclude files catalina.jar and catalina-optional.jar when copying *.jar files from directory api/external/ to dist/ProteiosSE-<version>/www/WEB-INF/lib/, in order to allow Proteios to be used with Tomcat 7.

[olle]

Ticket closed as fixes for the known issues have been added.

[olle]

(In [4377]) Refs #788. Installation shell script install.sh in misc/install/ updated to remove Apache Tomcat library files catalina.jar and catalina-optional.jar from $CATALINA_HOME/webapps/proteios/WEB-INF/lib/ on Unix/Linux systems.