Re: Reverse engineering the guacamole database

[Nick Couchman]

On Tue, Mar 19, 2024 at 4:00 PM Johnnie W Adams  wrote:

> Hi, folks,
>
>  I've got a small guacamole installation that's fallen into my hands
> to maintain. It's set up to do SSO via SAML but to get all its
> authorization from a MySQL database. It's far from clear to me exactly how
> this database is set up. I'm poking around in the guacamole_db database but
> not getting any clarity on what does what.
>
>  Can someone point me to its documentation?
>

I think this will help you:
https://guacamole.apache.org/doc/gug/jdbc-auth.html#modifying-data-manually

Also, the schema file is located, here:
https://github.com/apache/guacamole-client/tree/main/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/schema

-Nick

>

Reverse engineering the guacamole database

[Johnnie W Adams]

Hi, folks,

 I've got a small guacamole installation that's fallen into my hands to
maintain. It's set up to do SSO via SAML but to get all its authorization
from a MySQL database. It's far from clear to me exactly how this database
is set up. I'm poking around in the guacamole_db database but not getting
any clarity on what does what.

 Can someone point me to its documentation?

Thanks,

 John A
--
John Adams
Senior Linux/Middleware Administrator  | Information Technology Services
+1-501-916-3010 | jxad...@ualr.edu | http://ualr.edu/itservices
*UA Little Rock*

Reminder:  IT Services will never ask for your password over the phone or
in an email. Always be suspicious of requests for personal information that
come via email, even from known contacts.  For more information or to
report suspicious email, visit IT Security
.