guacamole-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vn...@apache.org
Subject [2/6] incubator-guacamole-manual git commit: GUACAMOLE-314: Document database upgrade scripts for 0.9.13.
Date Sun, 04 Jun 2017 02:48:41 GMT
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 <mjumper@apache.org>
Authored: Thu Jun 1 23:20:31 2017 -0700
Committer: Michael Jumper <mjumper@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>
&lt; 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> &lt; 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>


Mime
View raw message