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