Hi,
Below are the logs, when I hit search in history and using guacamole 1.1.0
version.
11:51:48.899 [https-openssl-apr-8443-exec-6] ERROR
o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
### Error querying database. Cause:
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near
'username'.
### The error may exist in
org/apache/guacamole/auth/jdbc/connection/ConnectionRecordMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT TOP (?)
[guacamole_connection_history].connection_id,
[guacamole_connection_history].connection_name,
[guacamole_connection_history].remote_host,
[guacamole_connection_history].sharing_profile_id,
[guacamole_connection_history].sharing_profile_name,
[guacamole_connection_history].user_id,
[guacamole_connection_history].username,
[guacamole_connection_history].start_date,
[guacamole_connection_history].end_date FROM
[guacamole_connection_history] WHERE (
[guacamole_connection_history].user_id IN (
SELECT user_id FROM [guacamole_user]
WHERE POSITION(? IN username) > 0 ) OR
[guacamole_connection_history].connection_id IN ( SELECT
connection_id FROM [guacamole_connection]
WHERE POSITION(? IN connection_name) > 0 )
) ORDER BY
[guacamole_connection_history].start_date DESC
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax
near 'username'.
Regards
Madhukar
From: Mike Jumper
Sent: Friday, May 22, 2020 10:39 AM
To: [email protected]
Subject: Re: Error while fetching history in Guacamole
On Thu, May 21, 2020, 22:07 Madhukar Bhosale <[email protected]> wrote:
Hi,
While fetching history, I am getting below error. Need help.
What version of Guacamole?
What do you see in your Tomcat logs when this occurs?
- Mike
