Register for the iXsystems Community to get an ad-free experience and exclusive discounts in our eBay Store.

Guacamole with Jetty and MySQL auth in a Jail

markymark832

Member
Joined
Feb 28, 2017
Messages
32
Did you try a static configuration first, that's what I did. Then switched to MySQL after everything worked. I cannot remember that I installed anything special, the guacamole package simply pulled in all the necessary dependencies.

The docs for static configuration can be found here:

For reference, my guacamole config is rather unspectacular:
Code:
# guacgd.conf
[daemon]

[server]
bind_host = localhost
bind_port = 4822

# guacamole.properties
uacd-host:    localhost
guacd-port:     4822

mysql-hostname: localhost
mysql-port: 3306
mysql-database: guacamole
mysql-username: guacamole
mysql-password: *********
mysql-user-required: true


Plus you need to manually put guacamole-auth-jdbc-mysql-1.0.0.jar into /usr/local/etc/guacamole-client/extensions.

HTH,
Patrick
thanks for the reply, i'm just using the .xml file for the connection setting for now, i don't really need the sql implentation,
i'll bin the jail and start again, but this time output the results on the pkg install to see if it is pulling the dependencies
fingers crossed
 

Patrick M. Hausen

Dedicated Sage
Joined
Nov 25, 2013
Messages
1,915
I do not really *need* the MySQL backend, either. But it lets you manage connections and users from the web UI, which is pretty convenient.
 

markymark832

Member
Joined
Feb 28, 2017
Messages
32
I do not really *need* the MySQL backend, either. But it lets you manage connections and users from the web UI, which is pretty convenient.
yeah i can see that, i've currently got freenas as a ssh in guacamole, then iocage into the jail and do the editing that way... suppose it depends on how many connections you are creating/removing on it
 

markymark832

Member
Joined
Feb 28, 2017
Messages
32
quick question, when it comes to updating Guacamole is there a procedure? (if there is updates available)
 

Patrick M. Hausen

Dedicated Sage
Joined
Nov 25, 2013
Messages
1,915

RSVP

Member
Joined
Feb 11, 2016
Messages
67
Of course. And it can easily be installed as a ready to use package with all dependencies.
  • create standard jail with VNET
  • make sure networking works and you can SSH and su/sudo
  • pkg install guacamole-client
  • pkg install guacamole-server
  • sysrc guacd_enable="YES"
  • sysrc tomcat9_enable="YES"
Works like a charm since about a year ago or so when I first discovered it. I suggest starting with plain text user authentication (in the user-mapping.xml file) and switching to MySQL after that is successful.

HTH,
Patrick
Hi,
Thanks for posting this. I am at that web gui and its prompting for username and password. Am I missing something in your last comment about user-mapping.xml? I am searching for that but so far no go. Thanks for the help
 

Patrick M. Hausen

Dedicated Sage
Joined
Nov 25, 2013
Messages
1,915

Patrick M. Hausen

Dedicated Sage
Joined
Nov 25, 2013
Messages
1,915
There's a sample file :wink:
/usr/local/etc/guacamole-client/user-mapping.xml.sample

Copy to user-mapping.xml in the same directory.
 
Top