Re: Upgrade to Guacamole

[Ivanmarcus]

Roland,

That's quite an old version of Guacamole, there have been significant 
changes that will require an update to your database schema (from 0.9.14 
to 1.0.0).


For your information here are the relevant announcements on versions 
later than what you're currently using:


https://guacamole.apache.org/releases/1.0.0/

https://guacamole.apache.org/releases/1.1.0/

https://guacamole.apache.org/releases/1.2.0/

https://guacamole.apache.org/releases/1.3.0/

https://guacamole.apache.org/releases/1.4.0/

I suggest you have a good read of this information before you set about 
any upgrade.


You *may* be able to go 0.9.14 -> 1.0.0 -> 1.4.0, but I've never tried 
that myself so I can't tell you how it would go. Certainly I wouldn't 
try on a production system without first trialling it offline.






On 1/06/22 13:56, Lockhart, Roland wrote:

Hi

We are currently running Guacamole from a community image from AWS

guaws/stable/hvm-ssd/guacamole-0.9.14-20180311.13-27463c5c-7531-407d-aa0b-0a42912db48f-ami-12a4636f.4

It runs the services in docker containers, and we are fairly out of date 
with the build


We’d like to upgrade so we don’t have to reconfigure everything 
including connections and users, but not sure where to start


This is the current state

CONTAINER ID    IMAGE

xx   guaws_nginx

y   guaws_guaws

zzz   guaws_guac

   guacamole/guacd:0.9.14

bbb   mariadb:10.2

Hope someone can be of help

Thanks

Roland

AAM Group



*Roland Lockhart*
DevOps Team Lead
+61 8 9228 6807
+61 408 384 993
r.lockh...@aamgroup.com 
*aamgroup.com* 


 
Attention Email Disclaimer Notice - This message is the property of AAM 
Pty Ltd. The information in this email is confidential and may be 
legally privileged. It is intended solely for the addressee. Access to 
this email by anyone else is unauthorised. If you are not the intended 
recipient, any disclosure, copying, distribution or any action taken or 
omitted to be taken in reliance on it is prohibited and may be unlawful. 
If you have received this message in error please notify AAM Pty Ltd 
immediately via email to mailad...@aamgroup.com This email has been 
scanned and cleared by Exchange Online Protection, however AAM Pty Ltd 
does not guarantee this message free of viruses, or interference.


-
To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org
For additional commands, e-mail: user-h...@guacamole.apache.org

Upgrade to Guacamole

[Lockhart, Roland]

Hi

We are currently running Guacamole from a community image from AWS

guaws/stable/hvm-ssd/guacamole-0.9.14-20180311.13-27463c5c-7531-407d-aa0b-0a42912db48f-ami-12a4636f.4

It runs the services in docker containers, and we are fairly out of date with 
the build

We'd like to upgrade so we don't have to reconfigure everything including 
connections and users, but not sure where to start

This is the current state
CONTAINER IDIMAGE
xx   guaws_nginx
y   guaws_guaws
zzz   guaws_guac
   guacamole/guacd:0.9.14
bbb   mariadb:10.2

Hope someone can be of help

Thanks

Roland


[AAM Group]
Roland Lockhart
DevOps Team Lead
+61 8 9228 6807
+61 408 384 993
r.lockh...@aamgroup.com
aamgroup.com
[https://aamgroup.com/wp-content/uploads/2021/07/icon-linkedin.png]
 [https://aamgroup.com/wp-content/uploads/2021/07/icon-twitter.png] 
  
[https://aamgroup.com/wp-content/uploads/2021/07/icon-youtube.png] 



 Attention 
Email Disclaimer Notice - This message is the property of AAM Pty Ltd. The 
information in this email is confidential and may be legally privileged. It is 
intended solely for the addressee. Access to this email by anyone else is 
unauthorised. If you are not the intended recipient, any disclosure, copying, 
distribution or any action taken or omitted to be taken in reliance on it is 
prohibited and may be unlawful. If you have received this message in error 
please notify AAM Pty Ltd immediately via email to mailad...@aamgroup.com This 
email has been scanned and cleared by Exchange Online Protection, however AAM 
Pty Ltd does not guarantee this message free of viruses, or interference.

Re: Connection list empty since upgrade to Guacamole 1.4

[LatChee]

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
   )

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  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

Re: Connection list empty since upgrade to Guacamole 1.4

[Mike Jumper]

On Sun, Jan 16, 2022, 16:42 LatChee  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

Connection list empty since upgrade to Guacamole 1.4

[LatChee]

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?

Kind regards,

Lat

-
To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org
For additional commands, e-mail: user-h...@guacamole.apache.org