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]
