You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by David Landry <da...@dmwl.net> on 2017/01/23 21:13:45 UTC
Creating a new JDBC auth extension
I created an SQLite JDBC auth extension by using Guacamole's JDBC base
source. I copied the MySQL extension, changed references from MySQL to
SQLite, and translated some of the MySQL-specific queries to work with
SQLite.
My extension only partially works.
Two queries for Connections and ConnectionGroups throw an
ArrayIndexOutOfBoundsException ('select' and 'selectReadable'). I've
validated that the query itself is valid by manually filling in the
parameters and querying the database. I think MyBatis is mixing up how many
parameters the query should have. The 'selectReadable' call expects two
parameters: the user ID and a collection of identifiers. Those two params
are used three places in the query. When I stepped through the code, I saw
the PreparedStatement expected 6 parameters. The exception is thrown when
the code attempts to fill in a third nonexistent parameter.
Can anyone point me in the right direction?
You can see the code here
<https://bitbucket.org/apporto/incubator-guacamole-client/src/f197907dc2e26f4e9393f78f3fb06014f01ddfbd/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlite/?at=sqlite>.
I also uploaded artifacts to make it easier for someone to give it a test
run:
- SQLite JDBC connector -
https://bitbucket.org/apporto/incubator-guacamole-client/downloads/sqlite-jdbc-3.16.1.jar
- SQLite auth extension -
https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guacamole-auth-jdbc-sqlite-0.9.10-incubating.jar
- A test DB with a single ConnectionGroup (move it to
/tmp/guac_test.sqlite) -
https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guac_test.sqlite
- guacamole.properties file (there are some bogus settings required
right now) -
https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guacamole.properties
--
---
David Landry
Re: Creating a new JDBC auth extension
Posted by David Landry <da...@dmwl.net>.
Switched to the dev mailing list. I haven't seen any posts on that list
since I signed up, so let me know if it didn't go through :)
On Mon, Jan 23, 2017 at 6:50 PM James Muehlner <ja...@guac-dev.org>
wrote:
> Hey David, this would probably be more appropriate in dev than user, I
> would think.
>
> I had a look at your code, and can't see anything wrong that would cause
> that error. Do you have the full stacktrace available?
>
> James
>
> On Mon, Jan 23, 2017 at 1:13 PM, David Landry <da...@dmwl.net> wrote:
>
> I created an SQLite JDBC auth extension by using Guacamole's JDBC base
> source. I copied the MySQL extension, changed references from MySQL to
> SQLite, and translated some of the MySQL-specific queries to work with
> SQLite.
>
> My extension only partially works.
>
> Two queries for Connections and ConnectionGroups throw an
> ArrayIndexOutOfBoundsException ('select' and 'selectReadable'). I've
> validated that the query itself is valid by manually filling in the
> parameters and querying the database. I think MyBatis is mixing up how many
> parameters the query should have. The 'selectReadable' call expects two
> parameters: the user ID and a collection of identifiers. Those two params
> are used three places in the query. When I stepped through the code, I saw
> the PreparedStatement expected 6 parameters. The exception is thrown when
> the code attempts to fill in a third nonexistent parameter.
>
> Can anyone point me in the right direction?
>
> You can see the code here
> <https://bitbucket.org/apporto/incubator-guacamole-client/src/f197907dc2e26f4e9393f78f3fb06014f01ddfbd/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlite/?at=sqlite>.
> I also uploaded artifacts to make it easier for someone to give it a test
> run:
>
> - SQLite JDBC connector -
> https://bitbucket.org/apporto/incubator-guacamole-client/downloads/sqlite-jdbc-3.16.1.jar
> - SQLite auth extension -
> https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guacamole-auth-jdbc-sqlite-0.9.10-incubating.jar
> - A test DB with a single ConnectionGroup (move it to
> /tmp/guac_test.sqlite) -
> https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guac_test.sqlite
> - guacamole.properties file (there are some bogus settings required
> right now) -
> https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guacamole.properties
>
>
> --
>
> ---
>
> David Landry
>
>
> --
---
David Landry
Re: Creating a new JDBC auth extension
Posted by Mike Jumper <mi...@guac-dev.org>.
I've done some reading on the SQLite driver, and I'm not seeing anything
stating one way or the other whether queries with multiple statements /
resultsets are supported.
Perhaps making a quick proof-of-concept would help track things down? Some
pure-JDBC test (no guac, no mybatis) with the problematic query to help
narrow down what is failing and where?
- Mike
On Tue, Jan 31, 2017 at 3:15 PM, David Landry <da...@dmwl.net> wrote:
> I posted this problem to StackOverflow, if anyone wants internet points:
> https://stackoverflow.com/questions/41969037/sqlite-mybatis-guice-throw-
> arrayindexoutofboundsexception
>
> On Thu, Jan 26, 2017 at 9:13 AM David Landry <da...@dmwl.net> wrote:
>
> > Good point.
> >
> > On Thu, Jan 26, 2017, 2:36 AM Mike Jumper <mi...@guac-dev.org>
> > wrote:
> >
> > On Wed, Jan 25, 2017 at 7:47 PM, David Landry <da...@dmwl.net> wrote:
> >
> > > Could it be a problem with mapping from JDBC VARCHAR to SQLite's
> INTEGER?
> > > Actually, I'm a little confused about why the MySQL JDBC type is a
> > VARCHAR,
> > > but Postgres has them as INTEGER (especially since the underlying type
> is
> > > an integer for both DBs).
> > >
> > >
> > Internal (within the Java side of Guacamole) storage of the database IDs
> is
> > strings, because connection identifiers are abstracted as generic strings
> > at the extension API level. The fact that those strings are actually
> > integers and translate into integer database IDs is an implementation
> > detail of the JDBC auth backend. These were initially mapped as VARCHAR
> > since they are, indeed, strings, and the expectation was that the
> database
> > engine would handle the conversion, and MySQL did behave that way.
> > PostgreSQL, on the other hand, did not do the same implicit conversion,
> and
> > it was necessary to explicitly cast to integer.
> >
> > It's certainly a quirk, but assuming SQLite doesn't implicitly convert
> like
> > MySQL, I don't think that it would likely result in an
> > ArrayIndexOutOfBoundsException. I'd expect any error due to the type of
> the
> > column to be thrown through the database engine out through the JDBC
> > driver, not prior to the query being shipped to the database engine when
> > the PreparedStatement is being populated.
> >
> > - Mike
> >
> > --
> >
> > ---
> >
> > David Landry
> >
> --
>
> ---
>
> David Landry
>
Re: Creating a new JDBC auth extension
Posted by David Landry <da...@dmwl.net>.
I posted this problem to StackOverflow, if anyone wants internet points:
https://stackoverflow.com/questions/41969037/sqlite-mybatis-guice-throw-arrayindexoutofboundsexception
On Thu, Jan 26, 2017 at 9:13 AM David Landry <da...@dmwl.net> wrote:
> Good point.
>
> On Thu, Jan 26, 2017, 2:36 AM Mike Jumper <mi...@guac-dev.org>
> wrote:
>
> On Wed, Jan 25, 2017 at 7:47 PM, David Landry <da...@dmwl.net> wrote:
>
> > Could it be a problem with mapping from JDBC VARCHAR to SQLite's INTEGER?
> > Actually, I'm a little confused about why the MySQL JDBC type is a
> VARCHAR,
> > but Postgres has them as INTEGER (especially since the underlying type is
> > an integer for both DBs).
> >
> >
> Internal (within the Java side of Guacamole) storage of the database IDs is
> strings, because connection identifiers are abstracted as generic strings
> at the extension API level. The fact that those strings are actually
> integers and translate into integer database IDs is an implementation
> detail of the JDBC auth backend. These were initially mapped as VARCHAR
> since they are, indeed, strings, and the expectation was that the database
> engine would handle the conversion, and MySQL did behave that way.
> PostgreSQL, on the other hand, did not do the same implicit conversion, and
> it was necessary to explicitly cast to integer.
>
> It's certainly a quirk, but assuming SQLite doesn't implicitly convert like
> MySQL, I don't think that it would likely result in an
> ArrayIndexOutOfBoundsException. I'd expect any error due to the type of the
> column to be thrown through the database engine out through the JDBC
> driver, not prior to the query being shipped to the database engine when
> the PreparedStatement is being populated.
>
> - Mike
>
> --
>
> ---
>
> David Landry
>
--
---
David Landry
Re: Creating a new JDBC auth extension
Posted by David Landry <da...@dmwl.net>.
Good point.
On Thu, Jan 26, 2017, 2:36 AM Mike Jumper <mi...@guac-dev.org> wrote:
> On Wed, Jan 25, 2017 at 7:47 PM, David Landry <da...@dmwl.net> wrote:
>
> > Could it be a problem with mapping from JDBC VARCHAR to SQLite's INTEGER?
> > Actually, I'm a little confused about why the MySQL JDBC type is a
> VARCHAR,
> > but Postgres has them as INTEGER (especially since the underlying type is
> > an integer for both DBs).
> >
> >
> Internal (within the Java side of Guacamole) storage of the database IDs is
> strings, because connection identifiers are abstracted as generic strings
> at the extension API level. The fact that those strings are actually
> integers and translate into integer database IDs is an implementation
> detail of the JDBC auth backend. These were initially mapped as VARCHAR
> since they are, indeed, strings, and the expectation was that the database
> engine would handle the conversion, and MySQL did behave that way.
> PostgreSQL, on the other hand, did not do the same implicit conversion, and
> it was necessary to explicitly cast to integer.
>
> It's certainly a quirk, but assuming SQLite doesn't implicitly convert like
> MySQL, I don't think that it would likely result in an
> ArrayIndexOutOfBoundsException. I'd expect any error due to the type of the
> column to be thrown through the database engine out through the JDBC
> driver, not prior to the query being shipped to the database engine when
> the PreparedStatement is being populated.
>
> - Mike
>
--
---
David Landry
Re: Creating a new JDBC auth extension
Posted by Mike Jumper <mi...@guac-dev.org>.
On Wed, Jan 25, 2017 at 7:47 PM, David Landry <da...@dmwl.net> wrote:
> Could it be a problem with mapping from JDBC VARCHAR to SQLite's INTEGER?
> Actually, I'm a little confused about why the MySQL JDBC type is a VARCHAR,
> but Postgres has them as INTEGER (especially since the underlying type is
> an integer for both DBs).
>
>
Internal (within the Java side of Guacamole) storage of the database IDs is
strings, because connection identifiers are abstracted as generic strings
at the extension API level. The fact that those strings are actually
integers and translate into integer database IDs is an implementation
detail of the JDBC auth backend. These were initially mapped as VARCHAR
since they are, indeed, strings, and the expectation was that the database
engine would handle the conversion, and MySQL did behave that way.
PostgreSQL, on the other hand, did not do the same implicit conversion, and
it was necessary to explicitly cast to integer.
It's certainly a quirk, but assuming SQLite doesn't implicitly convert like
MySQL, I don't think that it would likely result in an
ArrayIndexOutOfBoundsException. I'd expect any error due to the type of the
column to be thrown through the database engine out through the JDBC
driver, not prior to the query being shipped to the database engine when
the PreparedStatement is being populated.
- Mike
Re: Creating a new JDBC auth extension
Posted by David Landry <da...@dmwl.net>.
Could it be a problem with mapping from JDBC VARCHAR to SQLite's INTEGER?
Actually, I'm a little confused about why the MySQL JDBC type is a VARCHAR,
but Postgres has them as INTEGER (especially since the underlying type is
an integer for both DBs).
On Wed, Jan 25, 2017 at 2:02 PM David Landry <da...@dmwl.net> wrote:
On Tue, Jan 24, 2017 at 6:14 PM Mike Jumper <mi...@guac-dev.org>
wrote:
Does the SQLite JDBC driver perhaps not support multiple result sets in one
query? The driver might only be looking at the first statement, ignoring
the last two, and thus only sees 2 of the 6 parameters.
Could be. I don't know, but that's a direction to look into.
On Jan 24, 2017 14:28, "James Muehlner" <ja...@guac-dev.org> wrote:
> <snip>
> It seems like maybe MyBatis is having a hard time mapping the two
> parameters provided into the 6 parameters in the prepared statement. It
> looks like having multiple selects in a single prepared statement trips it
> up. Maybe a bug in MyBatis that only manifests when talking to SQLite?
I'm wondering that too. Maybe it's a MyBatis-SQLite thing. Or maybe, like
Mike suggests, it's a problem with the SQLite connector itself.
> I'm curious - have you tried using either the MySQL or
> PostgreSQL extensions? MyBatis should just be using JDBC to prepare
> statements; I don't see how it would matter what's on the other end. Maybe
> I'm missing something obvious.
I've tested with the MySQL extension recently. It's actually the same
query. The Postgres query is slightly different (only some data types I
think).
I haven't stepped through the MySQL call stack, though, only the SQLite one.
In the SQLite call stack, when it's making the PreparedStatement, it pulls
out all three 'identifiers' parameters and replaces it internally with
something like '_frch_identifier_0', '_frch_identifier_1',
'_frch_identifier_2'.
But in the parameter mapping, you still only have a collection called
'identifiers'. I'm not too familiar with MyBatis. Is that normal behavior?
--
---
David Landry
--
---
David Landry
Re: Creating a new JDBC auth extension
Posted by David Landry <da...@dmwl.net>.
On Tue, Jan 24, 2017 at 6:14 PM Mike Jumper <mi...@guac-dev.org>
wrote:
> Does the SQLite JDBC driver perhaps not support multiple result sets in one
> query? The driver might only be looking at the first statement, ignoring
> the last two, and thus only sees 2 of the 6 parameters.
>
Could be. I don't know, but that's a direction to look into.
On Jan 24, 2017 14:28, "James Muehlner" <ja...@guac-dev.org> wrote:
>
> > <snip>
> > It seems like maybe MyBatis is having a hard time mapping the two
> > parameters provided into the 6 parameters in the prepared statement. It
> > looks like having multiple selects in a single prepared statement trips
> it
> > up. Maybe a bug in MyBatis that only manifests when talking to SQLite?
>
I'm wondering that too. Maybe it's a MyBatis-SQLite thing. Or maybe, like
Mike suggests, it's a problem with the SQLite connector itself.
>
> > I'm curious - have you tried using either the MySQL or
> > PostgreSQL extensions? MyBatis should just be using JDBC to prepare
> > statements; I don't see how it would matter what's on the other end.
> Maybe
> > I'm missing something obvious.
>
I've tested with the MySQL extension recently. It's actually the same
query. The Postgres query is slightly different (only some data types I
think).
I haven't stepped through the MySQL call stack, though, only the SQLite one.
In the SQLite call stack, when it's making the PreparedStatement, it pulls
out all three 'identifiers' parameters and replaces it internally with
something like '_frch_identifier_0', '_frch_identifier_1',
'_frch_identifier_2'.
But in the parameter mapping, you still only have a collection called
'identifiers'. I'm not too familiar with MyBatis. Is that normal behavior?
--
---
David Landry
Re: Creating a new JDBC auth extension
Posted by Mike Jumper <mi...@guac-dev.org>.
Does the SQLite JDBC driver perhaps not support multiple result sets in one
query? The driver might only be looking at the first statement, ignoring
the last two, and thus only sees 2 of the 6 parameters.
- Mike
On Jan 24, 2017 14:28, "James Muehlner" <ja...@guac-dev.org> wrote:
> So, I'm still not exactly sure what's causing your issue, but I did notice
> that the prepared statement (selectReadable) in the logs you uploaded does
> indeed contain 6 parameters:
>
> SELECT guacamole_connection_group.connection_group_id,
> connection_group_name,
> parent_id,
> type,
> max_connections,
> max_connections_per_user,
> enable_session_affinity
> FROM guacamole_connection_group
> JOIN guacamole_connection_group_permission
> ON guacamole_connection_group_permission.connection_group_id =
> guacamole_connection_group.connection_group_id
> WHERE guacamole_connection_group.connection_group_id IN ( ? )
> AND user_id = ?
> AND permission = 'READ';
>
> SELECT parent_id,
> guacamole_connection_group.connection_group_id
> FROM guacamole_connection_group
> JOIN guacamole_connection_group_permission
> ON guacamole_connection_group_permission.connection_group_id =
> guacamole_connection_group.connection_group_id
> WHERE parent_id IN ( ? )
> AND user_id = ?
> AND permission = 'READ';
>
> SELECT parent_id,
> guacamole_connection.connection_id
> FROM guacamole_connection
> JOIN guacamole_connection_permission
> ON guacamole_connection_permission.connection_id =
> guacamole_connection.connection_id
> WHERE parent_id IN ( ? )
> AND user_id = ?
> AND permission = 'READ';
>
> It seems like maybe MyBatis is having a hard time mapping the two
> parameters provided into the 6 parameters in the prepared statement. It
> looks like having multiple selects in a single prepared statement trips it
> up. Maybe a bug in MyBatis that only manifests when talking to SQLite?
>
> I'm curious - have you tried using either the MySQL or
> PostgreSQL extensions? MyBatis should just be using JDBC to prepare
> statements; I don't see how it would matter what's on the other end. Maybe
> I'm missing something obvious.
>
> James
>
> On Tue, Jan 24, 2017 at 12:56 PM, David Landry <da...@dmwl.net> wrote:
>
> > Switching to the dev mailing list.
> >
> > On Mon, Jan 23, 2017 at 6:50 PM James Muehlner <
> > james.muehlner@guac-dev.org>
> > wrote:
> >
> > Hey David, this would probably be more appropriate in dev than user, I
> > would think.
> >
> > I had a look at your code, and can't see anything wrong that would cause
> > that error. Do you have the full stacktrace available?
> >
> >
> > I didn't find the stacktrace very helpful, but I've uploaded an example
> > catalina.out file here
> > <https://bitbucket.org/apporto/incubator-guacamole-
> > client/downloads/single_connection_group.sql>
> > .
> >
> > In this log, I started with a DB that only had an admin user. I did the
> > following:
> >
> > 1. Started Tomcat
> > 2. Loaded Guac in the browser
> > 3. Logged in
> > 4. Navigated to "Settings" and then "Connections"
> > 5. Added a new connection group called "Test"
> >
> > The change is committed to the SQLite file, but Guac stops working for
> any
> > page that should show a list of connections and connection groups. If I
> > remove the group from the database manually, it works again.
> >
> > The same thing happens if I start with a fresh DB and create a
> connection.
> >
> > Any ideas?
> > --
> >
> > ---
> >
> > David Landry
> >
>
Re: Creating a new JDBC auth extension
Posted by James Muehlner <ja...@guac-dev.org>.
So, I'm still not exactly sure what's causing your issue, but I did notice
that the prepared statement (selectReadable) in the logs you uploaded does
indeed contain 6 parameters:
SELECT guacamole_connection_group.connection_group_id,
connection_group_name,
parent_id,
type,
max_connections,
max_connections_per_user,
enable_session_affinity
FROM guacamole_connection_group
JOIN guacamole_connection_group_permission
ON guacamole_connection_group_permission.connection_group_id =
guacamole_connection_group.connection_group_id
WHERE guacamole_connection_group.connection_group_id IN ( ? )
AND user_id = ?
AND permission = 'READ';
SELECT parent_id,
guacamole_connection_group.connection_group_id
FROM guacamole_connection_group
JOIN guacamole_connection_group_permission
ON guacamole_connection_group_permission.connection_group_id =
guacamole_connection_group.connection_group_id
WHERE parent_id IN ( ? )
AND user_id = ?
AND permission = 'READ';
SELECT parent_id,
guacamole_connection.connection_id
FROM guacamole_connection
JOIN guacamole_connection_permission
ON guacamole_connection_permission.connection_id =
guacamole_connection.connection_id
WHERE parent_id IN ( ? )
AND user_id = ?
AND permission = 'READ';
It seems like maybe MyBatis is having a hard time mapping the two
parameters provided into the 6 parameters in the prepared statement. It
looks like having multiple selects in a single prepared statement trips it
up. Maybe a bug in MyBatis that only manifests when talking to SQLite?
I'm curious - have you tried using either the MySQL or
PostgreSQL extensions? MyBatis should just be using JDBC to prepare
statements; I don't see how it would matter what's on the other end. Maybe
I'm missing something obvious.
James
On Tue, Jan 24, 2017 at 12:56 PM, David Landry <da...@dmwl.net> wrote:
> Switching to the dev mailing list.
>
> On Mon, Jan 23, 2017 at 6:50 PM James Muehlner <
> james.muehlner@guac-dev.org>
> wrote:
>
> Hey David, this would probably be more appropriate in dev than user, I
> would think.
>
> I had a look at your code, and can't see anything wrong that would cause
> that error. Do you have the full stacktrace available?
>
>
> I didn't find the stacktrace very helpful, but I've uploaded an example
> catalina.out file here
> <https://bitbucket.org/apporto/incubator-guacamole-
> client/downloads/single_connection_group.sql>
> .
>
> In this log, I started with a DB that only had an admin user. I did the
> following:
>
> 1. Started Tomcat
> 2. Loaded Guac in the browser
> 3. Logged in
> 4. Navigated to "Settings" and then "Connections"
> 5. Added a new connection group called "Test"
>
> The change is committed to the SQLite file, but Guac stops working for any
> page that should show a list of connections and connection groups. If I
> remove the group from the database manually, it works again.
>
> The same thing happens if I start with a fresh DB and create a connection.
>
> Any ideas?
> --
>
> ---
>
> David Landry
>
Re: Creating a new JDBC auth extension
Posted by David Landry <da...@dmwl.net>.
Switching to the dev mailing list.
On Mon, Jan 23, 2017 at 6:50 PM James Muehlner <ja...@guac-dev.org>
wrote:
Hey David, this would probably be more appropriate in dev than user, I
would think.
I had a look at your code, and can't see anything wrong that would cause
that error. Do you have the full stacktrace available?
I didn't find the stacktrace very helpful, but I've uploaded an example
catalina.out file here
<https://bitbucket.org/apporto/incubator-guacamole-client/downloads/single_connection_group.sql>
.
In this log, I started with a DB that only had an admin user. I did the
following:
1. Started Tomcat
2. Loaded Guac in the browser
3. Logged in
4. Navigated to "Settings" and then "Connections"
5. Added a new connection group called "Test"
The change is committed to the SQLite file, but Guac stops working for any
page that should show a list of connections and connection groups. If I
remove the group from the database manually, it works again.
The same thing happens if I start with a fresh DB and create a connection.
Any ideas?
--
---
David Landry
Re: Creating a new JDBC auth extension
Posted by James Muehlner <ja...@guac-dev.org>.
Hey David, this would probably be more appropriate in dev than user, I
would think.
I had a look at your code, and can't see anything wrong that would cause
that error. Do you have the full stacktrace available?
James
On Mon, Jan 23, 2017 at 1:13 PM, David Landry <da...@dmwl.net> wrote:
> I created an SQLite JDBC auth extension by using Guacamole's JDBC base
> source. I copied the MySQL extension, changed references from MySQL to
> SQLite, and translated some of the MySQL-specific queries to work with
> SQLite.
>
> My extension only partially works.
>
> Two queries for Connections and ConnectionGroups throw an
> ArrayIndexOutOfBoundsException ('select' and 'selectReadable'). I've
> validated that the query itself is valid by manually filling in the
> parameters and querying the database. I think MyBatis is mixing up how many
> parameters the query should have. The 'selectReadable' call expects two
> parameters: the user ID and a collection of identifiers. Those two params
> are used three places in the query. When I stepped through the code, I saw
> the PreparedStatement expected 6 parameters. The exception is thrown when
> the code attempts to fill in a third nonexistent parameter.
>
> Can anyone point me in the right direction?
>
> You can see the code here
> <https://bitbucket.org/apporto/incubator-guacamole-client/src/f197907dc2e26f4e9393f78f3fb06014f01ddfbd/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlite/?at=sqlite>.
> I also uploaded artifacts to make it easier for someone to give it a test
> run:
>
> - SQLite JDBC connector - https://bitbucket.org/
> apporto/incubator-guacamole-client/downloads/sqlite-jdbc-3.16.1.jar
> <https://bitbucket.org/apporto/incubator-guacamole-client/downloads/sqlite-jdbc-3.16.1.jar>
> - SQLite auth extension - https://bitbucket.org/
> apporto/incubator-guacamole-client/downloads/guacamole-
> auth-jdbc-sqlite-0.9.10-incubating.jar
> <https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guacamole-auth-jdbc-sqlite-0.9.10-incubating.jar>
> - A test DB with a single ConnectionGroup (move it to
> /tmp/guac_test.sqlite) - https://bitbucket.org/
> apporto/incubator-guacamole-client/downloads/guac_test.sqlite
> <https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guac_test.sqlite>
> - guacamole.properties file (there are some bogus settings required
> right now) - https://bitbucket.org/apporto/incubator-guacamole-
> client/downloads/guacamole.properties
> <https://bitbucket.org/apporto/incubator-guacamole-client/downloads/guacamole.properties>
>
>
> --
>
> ---
>
> David Landry
>