Hi Mike,

To put in context, my Guacamole server, hosted on a ubuntu 20.04, uses Mariadb as a sql backend and LDAP along with TOTP for authentication. My main user account is LDAP and has all permissions ticked (including "administer system"). I have also a local backup admin user. This user also has all permissions ticked (including "administer system").
Both those admin users have this empty connection list issue.
Moreover, when I create a new connection, it still does not appear under the Settings > Connections page but can be seen under the "Home" page.

Apologies I was not explicit enough my first email.
I can create and see Groups under the page Settings > Groups, but I do not use this functionality. So I have none. Therefore to answer you second question, no group membership have not changed at all.

However, when I create a new group under Settings > Connections, I cannot see this group on the settings page but can see it on the Home page.

I re-read the changelog in more details and saw this line:

 * Automatically detect MariaDB / MySQL driver (GUACAMOLE-1407
   <https://issues.apache.org/jira/browse/GUACAMOLE-1407>)

So I then tried to edit my guacamole.properties and added the line (I never had to have this line before even though my SQL backed has always been MariaDB):
    mysql-driver: mariadb
But this broke my setup and I had to revert back this change. Here is the error I could see:

   guacamole tomcat9[135]: ### Error querying database. Cause:
   java.sql.SQLException: Error setting driver on UnpooledDataSource.
   Cause: java.lang.ClassNotFoundException: org.mariadb.jdbc.Driver


Now looking into my syslog, I can see those warnings occurring after tomcat starts:

   guacamole tomcat9[458]: WARNING: An illegal reflective access
   operation has occurred
   guacamole tomcat9[458]: WARNING: Illegal reflective access by
   org.apache.ibatis.ognl.AccessibleObjectHandlerPreJDK9
   (file:/etc/guacamole/extensions/guacamole-auth-jdbc-mysql-1.4.0.jar)
   to method java.util.Collections$EmptySet.isEmpty()
   guacamole tomcat9[458]: WARNING: Please consider reporting this to
   the maintainers of org.apache.ibatis.ognl.AccessibleObjectHandlerPreJDK9
   guacamole tomcat9[458]: WARNING: Use --illegal-access=warn to enable
   warnings of further illegal reflective access operations
   guacamole tomcat9[458]: WARNING: All illegal access operations will
   be denied in a future release

Not sure if this can help with the troubleshooting.

Kind regards,

Lat

On 17/01/22 13:51, Mike Jumper wrote:
On Sun, Jan 16, 2022, 16:42 LatChee <m...@latchee.com.invalid> wrote:

    Hi there,

    I upgraded to Guacamole 1.4 and since then the connections list
    under settings is empty.
    However, I can still create new connection or new group. Those
    then show up in the "Home" page and can be used to connect to a
    machine.

    Would you be able to help me with this issue?


Are you sure your user account has permission to see the connections in question?

Has your group membership changed at all (including externally)?

What are you using for authentication?

- Mike

Reply via email to