Index: win_installer/updater/src/ant/update-23.xml
===================================================================
diff -u -refaf8f2b1527f59a03ba9a00ccd4b2815db231c1 -re0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf
--- win_installer/updater/src/ant/update-23.xml (.../update-23.xml) (revision efaf8f2b1527f59a03ba9a00ccd4b2815db231c1)
+++ win_installer/updater/src/ant/update-23.xml (.../update-23.xml) (revision e0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf)
@@ -16,4 +16,16 @@
+
+
+
+
+
+
\ No newline at end of file
Index: win_installer/updater/src/ant/update-deploy-tools.xml
===================================================================
diff -u -refaf8f2b1527f59a03ba9a00ccd4b2815db231c1 -re0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf
--- win_installer/updater/src/ant/update-deploy-tools.xml (.../update-deploy-tools.xml) (revision efaf8f2b1527f59a03ba9a00ccd4b2815db231c1)
+++ win_installer/updater/src/ant/update-deploy-tools.xml (.../update-deploy-tools.xml) (revision e0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf)
@@ -16,7 +16,7 @@
-
+
@@ -28,7 +28,7 @@
-
+
Deploy packaqe for ${signature} created.
Index: win_installer/updater/src/sql/removeConfigs.sql
===================================================================
diff -u -r4133d4a50a076876e19024fe114838a542442256 -re0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf
--- win_installer/updater/src/sql/removeConfigs.sql (.../removeConfigs.sql) (revision 4133d4a50a076876e19024fe114838a542442256)
+++ win_installer/updater/src/sql/removeConfigs.sql (.../removeConfigs.sql) (revision e0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf)
@@ -12,7 +12,7 @@
-- From 2.2 onwards. Ensure dimdim tool is set to disabled
update lams_learning_library set valid_flag=0 where title="Dimdim";
--- From 2.2 onwards. Remove lams_qtz event entires
+-- From 2.2 onwards. Remove lams_qtz event entries
delete from lams_qtz_SIMPLE_TRIGGERS;
delete from lams_qtz_TRIGGERS;
delete from lams_qtz_JOB_DETAILS;
@@ -31,3 +31,7 @@
rename table lams_qtz_triggers to lams_qtz_TRIGGERS;
rename table lams_qtz_trigger_listeners to lams_qtz_TRIGGER_LISTENERS;
+-- From 2.3 onwards. Remove any red5 configs
+update lams_configuration set config_value="" where config_key="Red5ServerUrl";
+update lams_configuration set config_value="" where config_key="Red5RecordingsUrl";
+
Index: win_installer/updater/src/sql/update23_lamstool.sql
===================================================================
diff -u
--- win_installer/updater/src/sql/update23_lamstool.sql (revision 0)
+++ win_installer/updater/src/sql/update23_lamstool.sql (revision e0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf)
@@ -0,0 +1 @@
+ALTER TABLE lams_tool ADD COLUMN pedagogical_planner_url TEXT;
\ No newline at end of file
Index: win_installer/updater/src/updater.nsi
===================================================================
diff -u -r884d2f8842ff218c63fd99cc027415da661c4fd1 -re0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf
--- win_installer/updater/src/updater.nsi (.../updater.nsi) (revision 884d2f8842ff218c63fd99cc027415da661c4fd1)
+++ win_installer/updater/src/updater.nsi (.../updater.nsi) (revision e0a6c0ebbb7175fd9dc07bbae37716a58a27dbaf)
@@ -1074,8 +1074,9 @@
############################################################################
detailprint "Updating mysql-ds.xml for 2.3"
setoutpath "$TEMP\lams"
- File "${TEMPLATES}\mysql-ds.xml"
- File "${ANT}\update-23.xml"
+ file "${TEMPLATES}\mysql-ds.xml"
+ file "${ANT}\update-23.xml"
+ file "${SQL}\update23_lamstool.sql"
# generate a properties file
ClearErrors
@@ -1128,11 +1129,32 @@
Pop $2 #Number of lines found in
StrCmp $3 yes 0 +2
goto error
+
+ # Running the ant scripts to update the lams_tool table
+ strcpy $0 '"$INSTDIR\apache-ant-1.6.5\bin\newAnt.bat" -logfile "$INSTDIR\update-logs\update-lams-tool-table.log" -propertyfile "$TEMP\lams\update-23.properties" -buildfile "$TEMP\lams\update-23.xml" update-lams-tool-table'
+ DetailPrint $0
+ nsExec::ExecToStack $0
+ Pop $0 ; return code, 0=success, error=fail
+ Pop $1 ; console output
+ ${if} $0 == "error"
+ ${orif} $0 == 1
+ goto error
+ ${endif}
+ DetailPrint "Result: $1"
+ push "$INSTDIR\update-logs\ant-update-core-database.log"
+ push "Failed"
+ Call FileSearch
+ Pop $0 #Number of times found throughout
+ Pop $3 #Found at all? yes/no
+ Pop $2 #Number of lines found in
+ StrCmp $3 yes 0 +2
+ goto error
+
goto done
error:
- DetailPrint "Error updating mysql-ds.xml"
- MessageBox MB_OK|MB_ICONSTOP "LAMS mysql-ds.xml update failed, check update logs in the installation directory for details $\r$\nError:$\r$\n$\r$\n$1"
+ DetailPrint "Error updating mysql-ds.xml or updating the lams-tool table"
+ MessageBox MB_OK|MB_ICONSTOP "LAMS mysql-ds.xml or lams_tool table update failed, check update logs in the installation directory for details $\r$\nError:$\r$\n$\r$\n$1"
Abort "LAMS configuration failed"
done:
FunctionEnd
@@ -1607,7 +1629,7 @@
SetoutPath "$1\build\deploy\"
File "${BASE_PROJECT_DIR}\lams_tool_assessment\build\lib\*.jar"
File "${BASE_PROJECT_DIR}\lams_tool_assessment\build\lib\*.war"
- File "${BASE_PROJECT_DIR}\lams_tool_assessment\build\deploy\deploy.xml"
+ File "${BASE_PROJECT_DIR}\lams_tool_assessment\build\deploy\*.xml"
SetoutPath "$1\build\deploy\sql"
File /r "${BASE_PROJECT_DIR}\lams_tool_assessment\build\deploy\sql\*"
@@ -1627,7 +1649,7 @@
SetoutPath "$1\build\deploy\"
File "${BASE_PROJECT_DIR}\lams_tool_pixlr\build\lib\*.jar"
File "${BASE_PROJECT_DIR}\lams_tool_pixlr\build\lib\*.war"
- File "${BASE_PROJECT_DIR}\lams_tool_pixlr\build\deploy\deploy.xml"
+ File "${BASE_PROJECT_DIR}\lams_tool_pixlr\build\deploy\*.xml"
SetoutPath "$1\build\deploy\sql"
File /r "${BASE_PROJECT_DIR}\lams_tool_pixlr\build\deploy\sql\*"
@@ -1647,7 +1669,7 @@
SetoutPath "$1\build\deploy\"
File "${BASE_PROJECT_DIR}\lams_tool_mindmap\build\lib\*.jar"
File "${BASE_PROJECT_DIR}\lams_tool_mindmap\build\lib\*.war"
- File "${BASE_PROJECT_DIR}\lams_tool_mindmap\build\deploy\deploy.xml"
+ File "${BASE_PROJECT_DIR}\lams_tool_mindmap\build\deploy\*.xml"
SetoutPath "$1\build\deploy\sql"
File /r "${BASE_PROJECT_DIR}\lams_tool_mindmap\build\deploy\sql\*"
@@ -1667,7 +1689,7 @@
SetoutPath "$1\build\deploy\"
File "${BASE_PROJECT_DIR}\lams_tool_images\build\lib\*.jar"
File "${BASE_PROJECT_DIR}\lams_tool_images\build\lib\*.war"
- File "${BASE_PROJECT_DIR}\lams_tool_images\build\deploy\deploy.xml"
+ File "${BASE_PROJECT_DIR}\lams_tool_images\build\deploy\*.xml"
SetoutPath "$1\build\deploy\sql"
File /r "${BASE_PROJECT_DIR}\lams_tool_images\build\deploy\sql\*"
@@ -1687,7 +1709,7 @@
SetoutPath "$1\build\deploy\"
File "${BASE_PROJECT_DIR}\lams_tool_videorecorder\build\lib\*.jar"
File "${BASE_PROJECT_DIR}\lams_tool_videorecorder\build\lib\*.war"
- File "${BASE_PROJECT_DIR}\lams_tool_videorecorder\build\deploy\deploy.xml"
+ File "${BASE_PROJECT_DIR}\lams_tool_videorecorder\build\deploy\*.xml"
SetoutPath "$1\build\deploy\sql"
File /r "${BASE_PROJECT_DIR}\lams_tool_videorecorder\build\deploy\sql\*"