copy / syncronize guacamole user/connection settings

[DM...@simard.ca]

Hi,

I was wondering what the easiest way would be to copy the guacamole user 
settings and connections from one server to another (same version). Either 
a one time export and import or perhaps a better way to keep a backup 
server updated with user changes on another.

I am using guac 0.9.9 currently with mySQL server for the database and the 
guacamole-auth-jdbc- authentication module with MySQL Connector-J .


I'm also considering upgrading my guacamole soon but as the ubuntu version 
is now older I most likely will need to/want to reinstall the whole thing, 
which is no biggy, but it would be nice to be able to export the guac 
config so I don't have to manually recreate things one by on.

any ideas?

thanks


danielm

Re: copy / syncronize guacamole user/connection settings

[Mike Jumper <mi...@guac-dev.org>]

On Wed, Mar 15, 2017 at 1:55 PM, <DM...@simard.ca> wrote:

> Hi,
>
> I was wondering what the easiest way would be to copy the guacamole user
> settings and connections from one server to another (same version).  Either
> a one time export and import or perhaps a better way to keep a backup
> server updated with user changes on another.
>
> I am using guac 0.9.9 currently with mySQL server for the database and the
> guacamole-auth-jdbc- authentication module with MySQL Connector-J .
>
>
The easiest way to copy the contents of the database would be to use
MySQL's "mysqldump" utility to produce a script containing all tables,
data, etc. from the database in question:

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

On the other server, you would need to then:

1) Create the new database
2) Run the dump script on that database (thus importing all data)
3) Create a Guacamole-specific database user and grant the required
permissions as usual


> I'm also considering upgrading my guacamole soon but as the ubuntu version
> is now older I most likely will need to/want to reinstall the whole thing,
> which is no biggy, but it would be nice to be able to export the guac
> config so I don't have to manually recreate things one by on.
>
> any ideas?
>
>
As far as upgrading goes, you can preserve your data from older versions as
long as you run the upgrade scripts for each intervening version. The
database auth extension comes with upgrade scripts for both MySQL and
PostgreSQL, one for each version which altered the database schema in any
way. The scripts are incremental and apply to the immediately-previous
release, so multiple scripts may need to be applied if you are upgrading an
old release.

Just make sure you apply them in order, and make a backup of the database
first just in case.

- Mike