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 2018/01/02 16:56:15 UTC
[1/3] guacamole-manual git commit: GUACAMOLE-394: Document schema of
new guacamole_user_history table.
Repository: guacamole-manual
Updated Branches:
refs/heads/master edc74d226 -> 7869f9345
GUACAMOLE-394: Document schema of new guacamole_user_history table.
Project: http://git-wip-us.apache.org/repos/asf/guacamole-manual/repo
Commit: http://git-wip-us.apache.org/repos/asf/guacamole-manual/commit/421e456c
Tree: http://git-wip-us.apache.org/repos/asf/guacamole-manual/tree/421e456c
Diff: http://git-wip-us.apache.org/repos/asf/guacamole-manual/diff/421e456c
Branch: refs/heads/master
Commit: 421e456c05eb180a633febc2b580f9098b376537
Parents: ca29919
Author: Michael Jumper <mj...@apache.org>
Authored: Tue Jan 2 08:20:56 2018 -0800
Committer: Michael Jumper <mj...@apache.org>
Committed: Tue Jan 2 08:20:56 2018 -0800
----------------------------------------------------------------------
src/chapters/jdbc-auth.xml | 67 +++++++++++++++++++++++++++++++++++++++++
1 file changed, 67 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/guacamole-manual/blob/421e456c/src/chapters/jdbc-auth.xml
----------------------------------------------------------------------
diff --git a/src/chapters/jdbc-auth.xml b/src/chapters/jdbc-auth.xml
index 66c8c09..20d7500 100644
--- a/src/chapters/jdbc-auth.xml
+++ b/src/chapters/jdbc-auth.xml
@@ -1081,6 +1081,73 @@ INSERT INTO guacamole_user (username, password_salt, password_hash)
</varlistentry>
</variablelist>
</section>
+ <section xml:id="jdbc-auth-schema-login-history">
+ <title>Login history</title>
+ <indexterm>
+ <primary><classname>guacamole_user_history</classname></primary>
+ </indexterm>
+ <para>When a user logs in or out, a corresponding entry in the
+ <classname>guacamole_user_history</classname> table is created or updated
+ respectively. Each entry is associated with the user that logged in and the time
+ their session began. If the user has logged out, the time their session ended is
+ also stored.</para>
+ <para>It is very unlikely that a user will need to update this table, but knowing
+ the structure is potentially useful if you wish to generate a report of
+ Guacamole usage. The <classname>guacamole_user_history</classname> table has the
+ following columns:</para>
+ <variablelist>
+ <varlistentry>
+ <term><property>history_id</property></term>
+ <listitem>
+ <para>The unique integer associated with each history record. This value
+ is generated automatically when a new entry is inserted into the
+ <classname>guacamole_user_history</classname> table.</para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><property>user_id</property></term>
+ <listitem>
+ <para>The value of the <property>user_id</property> from the entry in
+ <classname>guacamole_user</classname> associated with the user
+ that logged in. If the user no longer exists, this will be
+ <constant>NULL</constant>.</para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><property>username</property></term>
+ <listitem>
+ <para>The username associated with the user at the time that they logged
+ in. This username value is not guaranteed to uniquely identify a
+ user, as the original user may be subsequently renamed or
+ deleted.</para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><property>remote_host</property></term>
+ <listitem>
+ <para>The hostname or IP address of the machine that the user logged in
+ from, if known. If unknown, this will be
+ <constant>NULL</constant>.</para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><property>start_date</property></term>
+ <listitem>
+ <para>The time at which the user logged in. Despite its name, this
+ column also stores time information in addition to the date.</para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term><property>end_date</property></term>
+ <listitem>
+ <para>The time at which the user logged out. If the user is still
+ active, the value in this column will be <constant>NULL</constant>.
+ Despite its name, this column also stores time information in
+ addition to the date.</para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+ </section>
</section>
<section xml:id="jdbc-auth-schema-connections">
<title>Connections and parameters</title>
[3/3] guacamole-manual git commit: Merge 0.9.14 changes back to
master.
Posted by vn...@apache.org.
Merge 0.9.14 changes back to master.
Project: http://git-wip-us.apache.org/repos/asf/guacamole-manual/repo
Commit: http://git-wip-us.apache.org/repos/asf/guacamole-manual/commit/7869f934
Tree: http://git-wip-us.apache.org/repos/asf/guacamole-manual/tree/7869f934
Diff: http://git-wip-us.apache.org/repos/asf/guacamole-manual/diff/7869f934
Branch: refs/heads/master
Commit: 7869f9345626bd06b58e061d6312820854eb528c
Parents: edc74d2 416c0f0
Author: Nick Couchman <vn...@apache.org>
Authored: Tue Jan 2 11:55:46 2018 -0500
Committer: Nick Couchman <vn...@apache.org>
Committed: Tue Jan 2 11:55:46 2018 -0500
----------------------------------------------------------------------
src/chapters/jdbc-auth.xml | 67 +++++++++++++++++++++++++++++++++++++++++
1 file changed, 67 insertions(+)
----------------------------------------------------------------------
[2/3] guacamole-manual git commit: GUACAMOLE-394: Merge document
schema of new guacamole_user_history table.
Posted by vn...@apache.org.
GUACAMOLE-394: Merge document schema of new guacamole_user_history table.
Project: http://git-wip-us.apache.org/repos/asf/guacamole-manual/repo
Commit: http://git-wip-us.apache.org/repos/asf/guacamole-manual/commit/416c0f07
Tree: http://git-wip-us.apache.org/repos/asf/guacamole-manual/tree/416c0f07
Diff: http://git-wip-us.apache.org/repos/asf/guacamole-manual/diff/416c0f07
Branch: refs/heads/master
Commit: 416c0f070827e1b5fc9f974108e9b5347d792fbb
Parents: ca29919 421e456
Author: Nick Couchman <vn...@apache.org>
Authored: Tue Jan 2 11:53:57 2018 -0500
Committer: Nick Couchman <vn...@apache.org>
Committed: Tue Jan 2 11:53:57 2018 -0500
----------------------------------------------------------------------
src/chapters/jdbc-auth.xml | 67 +++++++++++++++++++++++++++++++++++++++++
1 file changed, 67 insertions(+)
----------------------------------------------------------------------