Hello, all, Apologies, it took me a while to get around to reproducing this issue, and then confirm that we've already fixed it in our git repository and that it'll get released in the 1.6.1 release:
https://issues.apache.org/jira/browse/GUACAMOLE-2099 https://github.com/apache/guacamole-client/pull/1113 https://github.com/apache/guacamole-client/pull/1096 -Nick On Wed, Jul 9, 2025 at 9:27 PM Jon Gerdes <[email protected]> wrote: > Tim > > Well MS SQL seems to be officially supported: > https://guacamole.apache.org/doc/gug/sqlserver-auth.html > > I'm out of ideas at the moment. > > It's not a particularly decent solution for you but if you switch to > Postgres or MySQL/MariaDB (all of which are supported on all major OSs), > you might find closure quicker, unless a MS SQL jockey pops up hereabouts > soon. > > Cheers > Jon > > > > > On Wed, 2025-07-09 at 22:09 +0000, Tim Scharf wrote: > > Running with the 1.5.5 JDBC SQL extension, I can set the Audit permission > on the user and confirmed it does update the database correctly. > > > > I also updated the MS driver to ver 12.10.1 > (mssql-jdbc-12.10.1.jre11.jar), but still get the same errors with the > 1.6.0 JDBC SQL extension. > > > Tim Scharf , Senior Network Administrator > 220 SE Green Street | Lee's Summit, MO 64063 > 816.969.1262 | cityofLS.net > <https://us.content.exclaimer.net/?url=http%3A%2F%2Fcityofls.net%2F&tenantid=Hq5wJ3wZEe-EcwAiSCkyTw&templateid=1f16c2d8a58cef118473002248293181&excomponentid=l8FKGPZE3NT8nwYWnyFzvAi6wv7ezqA6QMdHRc8qs90&excomponenttype=Link&signature=x2i5Gu_daYpHgIIPi_cJjcJkturDilOPgp3BSNpcVDsjOp8qxTcPAUhTEaZrLVPKR1gEpSrGLpy7Wqt52PmLd8-PcG3c2R7yYHRlLJw_-8VCpuP3tEvIg0NI4JptlWSgBsaRH83OqIZ5S8SCShb0sdDFtwmuUl_2PjxE9ogs3wdsh0HwQJaJ7OVkxOkYJE8WIbzDFjiUQSIFp5cBHsE3AXigMy8ZN2QqUW9i6AX9DIIK_rpuSUgcuIWgiGTna1EK6glC6CzqJ3QL78qD7yCf8Z0gu4EbU6WbzQvInK_52p_mWeMtXYqgoAwNWu_qnNU439B_gsJx24KTYULD8xa0pg&v=1&imprintMessageId=fb8cd48e-0b21-46c2-aefb-ff56955d4636> > | [email protected] > > > *From:* Tim Scharf <[email protected]> > *Sent:* Wednesday, July 9, 2025 7:54 AM > *To:* [email protected] > *Subject:* RE: Upgrading 1.5.5 to 1.6.0 - JDBC SQL error > > > > *CAUTION*! This is an*EXTERNAL* email originated from outside the > organization. Do not click links or open attachments unless you recognize > the SENDER and know the content is safe. > > > > Jon, > > > > Yes, this is complied from the source code as opposed to running a Docker > container. > > > > The schema update appears to have dropped the > guacamole_system_permission_list rule and created a new rule that contains > the AUDIT permission. When I script the rule to create to clipboard in SQL > Studio, the result below matches the schema update: > > > > USE [Guacamole] > > GO > > > > /****** Object: Rule [guacamole_system_permission_list] Script Date: > 7/9/2025 7:47:25 AM ******/ > > CREATE RULE [dbo].[guacamole_system_permission_list] > > AS > > @list IN ( > > 'CREATE_CONNECTION', > > 'CREATE_CONNECTION_GROUP', > > 'CREATE_SHARING_PROFILE', > > 'CREATE_USER', > > 'CREATE_USER_GROUP', > > 'AUDIT', > > 'ADMINISTER' > > ); > > > > GO > > > > So to the best of my knowledge, the schema has been updated. > > > > Tim > > > > *Tim* > > > > *Scharf* > > *, * > > Senior Network Administrator > > 220 SE Green Street | Lee's Summit, MO 64063 > > 816.969.1262 > > | > > cityofLS.net > <https://us.content.exclaimer.net/?url=http%3A%2F%2Fcityofls.net%2F&tenantid=Hq5wJ3wZEe-EcwAiSCkyTw&templateid=1f16c2d8a58cef118473002248293181&excomponentid=l8FKGPZE3NT8nwYWnyFzvAi6wv7ezqA6QMdHRc8qs90&excomponenttype=Link&signature=x2i5Gu_daYpHgIIPi_cJjcJkturDilOPgp3BSNpcVDsjOp8qxTcPAUhTEaZrLVPKR1gEpSrGLpy7Wqt52PmLd8-PcG3c2R7yYHRlLJw_-8VCpuP3tEvIg0NI4JptlWSgBsaRH83OqIZ5S8SCShb0sdDFtwmuUl_2PjxE9ogs3wdsh0HwQJaJ7OVkxOkYJE8WIbzDFjiUQSIFp5cBHsE3AXigMy8ZN2QqUW9i6AX9DIIK_rpuSUgcuIWgiGTna1EK6glC6CzqJ3QL78qD7yCf8Z0gu4EbU6WbzQvInK_52p_mWeMtXYqgoAwNWu_qnNU439B_gsJx24KTYULD8xa0pg&v=1&imprintMessageId=fd556f12-666e-4795-a972-c74a896e9824> > > | > > [email protected] > > > > *From:* Jon Gerdes <[email protected]> > *Sent:* Tuesday, July 8, 2025 7:05 PM > *To:* [email protected] > *Subject:* Re: Upgrading 1.5.5 to 1.6.0 - JDBC SQL error > > > > You don't often get email [email protected]. Learn why this is > important <https://aka.ms/LearnAboutSenderIdentification> > > *CAUTION*! This is an*EXTERNAL* email originated from outside the > organization. Do not click links or open attachments unless you recognize > the SENDER and know the content is safe. > > > > Tim > > > > When you say native install, do you mean compiled from source code? > > > > Those errors do look like like failed schema updates. Are you sure you > updated the schema properly? I use MariaDB and Postgres > > so I cannot help with MS SQL too much. > > > > Are you absolutely sure that the schema is correct? > > > > Cheers > > Jon > > > > > > > > > > On Tue, 2025-07-08 at 17:47 +0000, Tim Scharf wrote: > > Native install > > Ubuntu 24.04.2 LTS > > External SQL server (Microsoft) > > > > The server works fine under 1.5.5. After updating to 1.6.0, the server > wasn’t accessing the SQL server. If I reverted it back to the 1.5.5 SQL > extension (guacamole-auth-jdbc-sqlserver-1.5.5.jar) and left all other > extensions at 1.6.0, everything works fine. > > > > I noted the following errors when using the 1.6.0 JDBC SQL extension: > > > > Caused by: BuilderException: Error creating document instance. Cause: > SAXParseException; lineNumber: 179; columnNumber: 23; Element type "test" > must be declared. > > Caused by: BuilderException: Error creating document instance. Cause: > SAXParseException; lineNumber: 217; columnNumber: 86; Element type "hen" > must be declared. > > > > I am using the 9.4.1 JDBC SQL driver (mssql-jdbc-9.4.1.jre11.jar) > > > > The schema has been updated. > > *Tim* > > > > *Scharf* > > *, * > > Senior Network Administrator > > 220 SE Green Street | Lee's Summit, MO 64063 > > 816.969.1262 > > | > > cityofLS.net > <https://us.content.exclaimer.net/?url=http%3A%2F%2Fcityofls.net%2F&tenantid=Hq5wJ3wZEe-EcwAiSCkyTw&templateid=1f16c2d8a58cef118473002248293181&excomponentid=l8FKGPZE3NT8nwYWnyFzvAi6wv7ezqA6QMdHRc8qs90&excomponenttype=Link&signature=x2i5Gu_daYpHgIIPi_cJjcJkturDilOPgp3BSNpcVDsjOp8qxTcPAUhTEaZrLVPKR1gEpSrGLpy7Wqt52PmLd8-PcG3c2R7yYHRlLJw_-8VCpuP3tEvIg0NI4JptlWSgBsaRH83OqIZ5S8SCShb0sdDFtwmuUl_2PjxE9ogs3wdsh0HwQJaJ7OVkxOkYJE8WIbzDFjiUQSIFp5cBHsE3AXigMy8ZN2QqUW9i6AX9DIIK_rpuSUgcuIWgiGTna1EK6glC6CzqJ3QL78qD7yCf8Z0gu4EbU6WbzQvInK_52p_mWeMtXYqgoAwNWu_qnNU439B_gsJx24KTYULD8xa0pg&v=1&imprintMessageId=29059381-656a-4738-bc6a-46bca570b99c> > > | > > [email protected] > > > > > ------------------------------ > > > CONFIDENTIALITY NOTICE: “This electronic message transmission (including > any accompanying attachments) fromwww.cityofls.net is intended solely for > the person or entity for its intended recipient(s) and may contain > information that is confidential, privileged, or otherwise protected from > disclosure. The information contained is intended solely for the use of the > individual(s), organization(s) or entity(ies) named above. If you have > received this transmission but are not the intended recipient, you are > hereby notified that any disclosure, copying, distribution or use of the > contents of this message is strictly prohibited. If you have received this > e-mail in error, please contact sender immediately by Reply e-mail and > delete/destroy the original message and all copies.” > > Although this e-mail and any attachments are believed to be free of any > virus or other defect that might negatively affect any computer system into > which it is received and opened, it is the responsibility of the recipient > to ensure that it is virus free and no responsibility is accepted by the > sender for any loss or damage arising in any way in the event that such a > virus or defect exists. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail:[email protected] > > For additional commands, e-mail:[email protected] > > > > > ------------------------------ > > > CONFIDENTIALITY NOTICE: “This electronic message transmission (including > any accompanying attachments) fromwww.cityofls.net is intended solely for > the person or entity for its intended recipient(s) and may contain > information that is confidential, privileged, or otherwise protected from > disclosure. The information contained is intended solely for the use of the > individual(s), organization(s) or entity(ies) named above. If you have > received this transmission but are not the intended recipient, you are > hereby notified that any disclosure, copying, distribution or use of the > contents of this message is strictly prohibited. If you have received this > e-mail in error, please contact sender immediately by Reply e-mail and > delete/destroy the original message and all copies.” > > Although this e-mail and any attachments are believed to be free of any > virus or other defect that might negatively affect any computer system into > which it is received and opened, it is the responsibility of the recipient > to ensure that it is virus free and no responsibility is accepted by the > sender for any loss or damage arising in any way in the event that such a > virus or defect exists. > > ------------------------------ > > CONFIDENTIALITY NOTICE: “This electronic message transmission (including > any accompanying attachments) from www.cityofls.net is intended solely > for the person or entity for its intended recipient(s) and may contain > information that is confidential, privileged, or otherwise protected from > disclosure. The information contained is intended solely for the use of the > individual(s), organization(s) or entity(ies) named above. If you have > received this transmission but are not the intended recipient, you are > hereby notified that any disclosure, copying, distribution or use of the > contents of this message is strictly prohibited. If you have received this > e-mail in error, please contact sender immediately by Reply e-mail and > delete/destroy the original message and all copies.” > > Although this e-mail and any attachments are believed to be free of any > virus or other defect that might negatively affect any computer system into > which it is received and opened, it is the responsibility of the recipient > to ensure that it is virus free and no responsibility is accepted by the > sender for any loss or damage arising in any way in the event that such a > virus or defect exists. > > >
