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>
| [email protected]<mailto:[email protected]>
[https://cityofls.net/Portals/0/Images/email-logos/SignatureLogo.png]
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 from
[email protected]<mailto:[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<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>
|
[email protected]<mailto:[email protected]>
[https://cityofls.net/Portals/0/Images/email-logos/SignatureLogo.png]
________________________________
CONFIDENTIALITY NOTICE: “This electronic message transmission (including any
accompanying attachments) from www.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:
[email protected]<mailto:[email protected]>
For additional commands, e-mail:
[email protected]<mailto:[email protected]>
________________________________
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.
