On Tue, Feb 25, 2020 at 8:54 AM Adrian Owen <[email protected]> wrote:
> > > In our automated Guacamole solution we currently enable VIDEO on every > connection and monitor for no lock on the video stream file. We allow for > .1, .2 etc. > > > > But this puts overhead on Guacamole, disk certainly and risk of bottleneck. > > > > I would prefer to make a MYSQL call to the database, and enquire on the > state of connections. > > > > Is there a documentation on the Schema, or failing that, which MYSQL > tables should I select to see active and disconnected sessions? > > > Currently active session tracking is only done in memory - it is not stored anywhere persistently. Connection history is stored persistently, but these entries are made after the connection is closed, so the database cannot be relied upon to contain a record of what sessions are active. To change this behavior will require some work in the code - it's not something that can be enabled/disabled. -Nick >
