Yep, initially I tried to apply the sql server schema before
realizing I was in the wrong directory. Once in the correct directory
they applied without error and now database structure and admin user are
built, but apparently the connector I used did not work so going to go
download the one you recommended and try that.
On 8/6/23 14:45, Nick Couchman wrote:
On Sun, Aug 6, 2023 at 5:28 PM Robert Dinse <[email protected]> wrote:
Yes, that is the manual I am working from. It referenced a
directory /schema but didn't say WHERE this directory was located. A
find of the source for /schema shows:
Copied/pasted from the manual:
==
The database authentication extension is packaged as a .tar.gz file
containing several database-specific directories. Only one of the
directories within the archive will be applicable to you, depending on
whether you are using MariaDB, MySQL, PostgreSQL, or SQL Server.
Each database-specific directory contains a schema/ directory and .jar
file (the actual Guacamole extension). The Guacamole extension .jar
will ultimately need to be placed within GUACAMOLE_HOME/extensions,
while the JDBC driver must be downloaded separately from the database
vendor and placed within GUACAMOLE_HOME/lib.
==
So, if you download the MySQL database extension (the .tar.gz), you'll see:
[nick@virtual-laptop Downloads]$ tar tf guacamole-auth-jdbc-1.5.3.tar.gz
...
guacamole-auth-jdbc-1.5.3/mysql/schema/
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.13.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.10.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-1.0.0.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.9.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.8.2.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.11.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.7.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.14.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.8.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/upgrade/upgrade-pre-0.9.6.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/001-create-schema.sql
guacamole-auth-jdbc-1.5.3/mysql/schema/002-create-admin-user.sql
...
The 001 and 002 files listed above are MariaDB and MySQL files; the
upgrade/*.sql files are for upgrading your DB from prior versions.
Also, from that manual page, there are tables where you can select
between MySQL, Postgresql, and SQL Server - the very first of the
tables on that page contains the path to the JAR file for the
extension, along with the SQL Schema file locations and notes about
the JDBC driver. (Screenshot attached to this e-mail...if the list
allows it...)
-Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
