You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@guacamole.apache.org by vn...@apache.org on 2017/06/04 02:48:41 UTC
[2/6] incubator-guacamole-manual git commit: GUACAMOLE-314: Document
database upgrade scripts for 0.9.13.
GUACAMOLE-314: Document database upgrade scripts for 0.9.13.
Project: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/commit/4ecfb4a4
Tree: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/tree/4ecfb4a4
Diff: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/diff/4ecfb4a4
Branch: refs/heads/master
Commit: 4ecfb4a43ef5a28a3da830933536e70fa97b6a44
Parents: e728181
Author: Michael Jumper <mj...@apache.org>
Authored: Thu Jun 1 23:20:31 2017 -0700
Committer: Michael Jumper <mj...@apache.org>
Committed: Thu Jun 1 23:20:31 2017 -0700
----------------------------------------------------------------------
src/chapters/jdbc-auth.xml | 33 ++++++++++++++++++++++++++++-----
1 file changed, 28 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/blob/4ecfb4a4/src/chapters/jdbc-auth.xml
----------------------------------------------------------------------
diff --git a/src/chapters/jdbc-auth.xml b/src/chapters/jdbc-auth.xml
index f602677..b17a806 100644
--- a/src/chapters/jdbc-auth.xml
+++ b/src/chapters/jdbc-auth.xml
@@ -171,9 +171,9 @@ Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
script located within the <filename>upgrade/</filename> directory:</para>
<informalexample>
<screen><prompt>$</prompt> <userinput>ls schema/upgrade/</userinput>
-<computeroutput>upgrade-pre-0.8.2.sql upgrade-pre-0.9.6.sql upgrade-pre-0.9.9.sql
-upgrade-pre-0.9.10.sql upgrade-pre-0.9.7.sql
-upgrade-pre-0.9.11.sql upgrade-pre-0.9.8.sq</computeroutput>
+<computeroutput>upgrade-pre-0.8.2.sql upgrade-pre-0.9.13.sql upgrade-pre-0.9.8.sql
+upgrade-pre-0.9.10.sql upgrade-pre-0.9.6.sql upgrade-pre-0.9.9.sql
+upgrade-pre-0.9.11.sql upgrade-pre-0.9.7.sql</computeroutput>
<prompt>$</prompt> <userinput>mysql -u root -p <replaceable>guacamole_db</replaceable> < schema/upgrade/upgrade-pre-0.8.2.sql</userinput>
<prompt>Enter password:</prompt> <userinput><replaceable>password</replaceable></userinput>
<prompt>$</prompt></screen>
@@ -227,6 +227,14 @@ upgrade-pre-0.9.11.sql upgrade-pre-0.9.8.sq</computeroutput>
<prompt>Enter password:</prompt> <userinput><replaceable>password</replaceable></userinput>
<prompt>$</prompt></screen>
</informalexample>
+ <para>If you are upgrading from a version of Guacamole before 0.9.13-incubating,
+ schema changes which add support for per-connection guacd instances and user
+ profiles need to be applied:</para>
+ <informalexample>
+ <screen><prompt>$</prompt> <userinput>mysql -u root -p <replaceable>guacamole_db</replaceable> < schema/upgrade/upgrade-pre-0.9.13.sql</userinput>
+<prompt>Enter password:</prompt> <userinput><replaceable>password</replaceable></userinput>
+<prompt>$</prompt></screen>
+ </informalexample>
</important>
</section>
<section xml:id="jdbc-auth-postgresql">
@@ -272,8 +280,8 @@ Type "help" for help.
directory:</para>
<informalexample>
<screen><prompt>$</prompt> <userinput>ls schema/upgrade/</userinput>
-<computeroutput>upgrade-pre-0.9.10.sql upgrade-pre-0.9.7.sql upgrade-pre-0.9.9.sql
-upgrade-pre-0.9.11.sql upgrade-pre-0.9.8.sql</computeroutput>
+<computeroutput>upgrade-pre-0.9.10.sql upgrade-pre-0.9.13.sql upgrade-pre-0.9.8.sql
+upgrade-pre-0.9.11.sql upgrade-pre-0.9.7.sql upgrade-pre-0.9.9.sql</computeroutput>
<prompt>$</prompt> <userinput>psql -d <replaceable>guacamole_db</replaceable> -f schema/upgrade/upgrade-pre-0.9.7.sql</userinput>
<computeroutput>ALTER TABLE
ALTER TABLE</computeroutput>
@@ -346,6 +354,21 @@ CREATE INDEX</computeroutput>
CREATE TABLE
CREATE INDEX</computeroutput>
<prompt>$</prompt></screen>
+ <para>If you are upgrading from a version of Guacamole before 0.9.13-incubating,
+ schema changes which add support for per-connection guacd instances and user
+ profiles need to be applied:</para>
+ <informalexample>
+ <screen><prompt>$</prompt> <userinput>psql -d <replaceable>guacamole_db</replaceable> -f schema/upgrade/upgrade-pre-0.9.13.sql</userinput>
+<computeroutput>CREATE TYPE
+ALTER TABLE
+ALTER TABLE
+ALTER TABLE
+ALTER TABLE
+ALTER TABLE
+ALTER TABLE
+ALTER TABLE</computeroutput>
+<prompt>$</prompt></screen>
+ </informalexample>
</informalexample>
</important>
</section>