Re: Error while fetching history in Guacamole
On Thu, May 21, 2020 at 11:25 PM Madhukar Bhosale wrote: > 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'. > This has been fixed for the upcoming release: https://issues.apache.org/jira/browse/GUACAMOLE-870 - Mike
RE: Error while fetching history in Guacamole
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: user@guacamole.apache.org Subject: Re: Error while fetching history in Guacamole On Thu, May 21, 2020, 22:07 Madhukar Bhosale 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
Re: Error while fetching history in Guacamole
On Thu, May 21, 2020, 22:07 Madhukar Bhosale 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
Error while fetching history in Guacamole
Hi, While fetching history, I am getting below error. Need help. Regards Madhukar - To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org For additional commands, e-mail: user-h...@guacamole.apache.org
