You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by Tom Astle <to...@pcc.com> on 2018/07/19 20:39:33 UTC
MySQL/MariaDB install admin interface: no connection/history data
Hi,
I am using the latest guac with the mysql auth adaptor. I am wondering
why I am not seeing any current connections or connection history in the
guacadmin portal. Any ideas.?
The guacamole db user is able to query all the tables it needs.
Thomas Astle
System Administrator
Red Hat Certified System Administrator
Phone: (800)722-1082 x2 Fax: (802)846-2197
RE: MySQL/MariaDB install admin interface: no connection/history data
Posted by Tom Astle <to...@pcc.com>.
Please disregard this. I literally just figured it out. The hint was where
I was keeping the connection config info. I was using the adhoc connections
and prior to that, ldap. Once I set one up in SQL, it worked.
From: Tom Astle <to...@pcc.com>
Sent: Thursday, 9 August, 2018 15:05
To: user@guacamole.apache.org
Subject: RE: MySQL/MariaDB install admin interface: no connection/history
data
I have verified that they are all from the same version. Still am seeing
nothing but the user list.
From: Nick Couchman <vnick@apache.org <ma...@apache.org> >
Sent: Monday, 23 July, 2018 16:10
To: user@guacamole.apache.org <ma...@guacamole.apache.org>
Subject: Re: MySQL/MariaDB install admin interface: no connection/history
data
On Mon, Jul 23, 2018 at 12:01 PM Tom Astle <tom@pcc.com <ma...@pcc.com>
> wrote:
I think they are all compiled against 0.9.14, but they are from github
because I’m using the totp extension
If you're doing this make sure that everything you're deploying (WAR, JDBC
extension, and TOTP) are built from github and that you're not downloading
anything from the web site.
-Nick
RE: MySQL/MariaDB install admin interface: no connection/history data
Posted by Tom Astle <to...@pcc.com>.
I have verified that they are all from the same version. Still am seeing
nothing but the user list.
From: Nick Couchman <vn...@apache.org>
Sent: Monday, 23 July, 2018 16:10
To: user@guacamole.apache.org
Subject: Re: MySQL/MariaDB install admin interface: no connection/history
data
On Mon, Jul 23, 2018 at 12:01 PM Tom Astle <tom@pcc.com <ma...@pcc.com>
> wrote:
I think they are all compiled against 0.9.14, but they are from github
because I’m using the totp extension
If you're doing this make sure that everything you're deploying (WAR, JDBC
extension, and TOTP) are built from github and that you're not downloading
anything from the web site.
-Nick
Re: MySQL/MariaDB install admin interface: no connection/history data
Posted by Nick Couchman <vn...@apache.org>.
On Mon, Jul 23, 2018 at 12:01 PM Tom Astle <to...@pcc.com> wrote:
> I think they are all compiled against 0.9.14, but they are from github
> because I’m using the totp extension
>
>
>
>
>
If you're doing this make sure that everything you're deploying (WAR, JDBC
extension, and TOTP) are built from github and that you're not downloading
anything from the web site.
-Nick
RE: MySQL/MariaDB install admin interface: no connection/history data
Posted by Tom Astle <to...@pcc.com>.
I think they are all compiled against 0.9.14, but they are from github
because I’m using the totp extension
From: Nick Couchman <vn...@apache.org>
Sent: Monday, 23 July, 2018 11:03
To: user@guacamole.apache.org
Subject: Re: MySQL/MariaDB install admin interface: no connection/history
data
On Mon, Jul 23, 2018 at 9:17 AM Tom Astle <tom@pcc.com <ma...@pcc.com>
> wrote:
Hello Mike,
I *was* using ldap initially, but I have since removed that extension and
moved to SQL/MariaDB I even changed the password in the DB for my test user
to make sure that I am really using the SQL one.
All the connections are logged in the tables etc.
Are you saying that the data is being logged to the tables (if you do a
SELECT inside the DB), but you're not seeing it in the Admin UI? If this is
the case, can you verify that you are using the exact same versions of both
the Guacamole web app (WAR file) and extensions? And that your schema is
up-to-date with the version of the extension you're using? Also, when you
say "latest" version, what version is that - latest available on the
guacamole.apache.org <http://guacamole.apache.org> web site, or from
somewhere else, or from github?
-Nick
Re: MySQL/MariaDB install admin interface: no connection/history data
Posted by Nick Couchman <vn...@apache.org>.
On Mon, Jul 23, 2018 at 9:17 AM Tom Astle <to...@pcc.com> wrote:
> Hello Mike,
>
>
>
> I **was** using ldap initially, but I have since removed that extension
> and moved to SQL/MariaDB I even changed the password in the DB for my test
> user to make sure that I am really using the SQL one.
>
>
>
> All the connections are logged in the tables etc.
>
>
>
Are you saying that the data is being logged to the tables (if you do a
SELECT inside the DB), but you're not seeing it in the Admin UI? If this
is the case, can you verify that you are using the exact same versions of
both the Guacamole web app (WAR file) and extensions? And that your schema
is up-to-date with the version of the extension you're using? Also, when
you say "latest" version, what version is that - latest available on the
guacamole.apache.org web site, or from somewhere else, or from github?
-Nick
Re: MySQL/MariaDB install admin interface: no connection/history data
Posted by Mike Jumper <mi...@glyptodon.org>.
Even if your users are being authenticated through LDAP, connections stored
within MySQL should be properly tracked and logged. The case where this
wouldn't work would be if those connections were defined within LDAP, as
the MySQL auth will only track and log connections that it controls.
- Mike
On Mon, Jul 23, 2018 at 6:17 AM, Tom Astle <to...@pcc.com> wrote:
> Hello Mike,
>
>
>
> I **was** using ldap initially, but I have since removed that extension
> and moved to SQL/MariaDB I even changed the password in the DB for my test
> user to make sure that I am really using the SQL one.
>
>
>
> All the connections are logged in the tables etc.
>
>
>
> *From:* Mike Jumper <mj...@apache.org>
> *Sent:* Monday, 23 July, 2018 02:13
> *To:* user@guacamole.apache.org
> *Subject:* Re: MySQL/MariaDB install admin interface: no
> connection/history data
>
>
>
> On Thu, Jul 19, 2018 at 1:39 PM, Tom Astle <to...@pcc.com> wrote:
>
> Hi,
>
>
>
> I am using the latest guac with the mysql auth adaptor. I am wondering
> why I am not seeing any current connections or connection history in the
> guacadmin portal. Any ideas.?
>
>
>
> Are the connections in question defined within MySQL or through another
> extension?
>
>
>
> - Mike
>
>
>
RE: MySQL/MariaDB install admin interface: no connection/history data
Posted by Tom Astle <to...@pcc.com>.
Hello Mike,
I *was* using ldap initially, but I have since removed that extension and
moved to SQL/MariaDB I even changed the password in the DB for my test user
to make sure that I am really using the SQL one.
All the connections are logged in the tables etc.
From: Mike Jumper <mj...@apache.org>
Sent: Monday, 23 July, 2018 02:13
To: user@guacamole.apache.org
Subject: Re: MySQL/MariaDB install admin interface: no connection/history
data
On Thu, Jul 19, 2018 at 1:39 PM, Tom Astle <tom@pcc.com <ma...@pcc.com>
> wrote:
Hi,
I am using the latest guac with the mysql auth adaptor. I am wondering why
I am not seeing any current connections or connection history in the
guacadmin portal. Any ideas.?
Are the connections in question defined within MySQL or through another
extension?
- Mike
Re: MySQL/MariaDB install admin interface: no connection/history data
Posted by Mike Jumper <mj...@apache.org>.
On Thu, Jul 19, 2018 at 1:39 PM, Tom Astle <to...@pcc.com> wrote:
> Hi,
>
>
>
> I am using the latest guac with the mysql auth adaptor. I am wondering
> why I am not seeing any current connections or connection history in the
> guacadmin portal. Any ideas.?
>
Are the connections in question defined within MySQL or through another
extension?
- Mike