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<tel: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> | tim.sch...@cityofls.net<mailto:tim.sch...@cityofls.net> [https://cityofls.net/Portals/0/Images/email-logos/SignatureLogo.png] From: Tim Scharf <tim.sch...@cityofls.net> Sent: Wednesday, July 9, 2025 7:54 AM To: user@guacamole.apache.org Subject: RE: Upgrading 1.5.5 to 1.6.0 - JDBC SQL error CAUTION! This is anEXTERNAL 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<tel: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> | tim.sch...@cityofls.net<mailto:tim.sch...@cityofls.net> [https://cityofls.net/Portals/0/Images/email-logos/SignatureLogo.png] From: Jon Gerdes <gerd...@blueloop.net<mailto:gerd...@blueloop.net>> Sent: Tuesday, July 8, 2025 7:05 PM To: user@guacamole.apache.org<mailto:user@guacamole.apache.org> Subject: Re: Upgrading 1.5.5 to 1.6.0 - JDBC SQL error You don't often get email fromgerd...@blueloop.net<mailto:gerd...@blueloop.net>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> CAUTION! This is anEXTERNAL 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<tel: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> | tim.sch...@cityofls.net<mailto:tim.sch...@cityofls.net> [https://cityofls.net/Portals/0/Images/email-logos/SignatureLogo.png] ________________________________ CONFIDENTIALITY NOTICE: “This electronic message transmission (including any accompanying attachments) fromwww.cityofls.net<http://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. --------------------------------------------------------------------- To unsubscribe, e-mail:user-unsubscr...@guacamole.apache.org<mailto:user-unsubscr...@guacamole.apache.org> For additional commands, e-mail:user-h...@guacamole.apache.org<mailto:user-h...@guacamole.apache.org> ________________________________ CONFIDENTIALITY NOTICE: “This electronic message transmission (including any accompanying attachments) fromwww.cityofls.net<http://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. ________________________________ 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.
