[jira] [Closed] (GUACAMOLE-983) "mysql" authentication provider has encountered an internal error

["Nick Couchman (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/GUACAMOLE-983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nick Couchman closed GUACAMOLE-983.
-----------------------------------
    Resolution: Duplicate

> "mysql" authentication provider has encountered an internal error
> -----------------------------------------------------------------
>
>                 Key: GUACAMOLE-983
>                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-983
>             Project: Guacamole
>          Issue Type: Bug
>          Components: guacamole-auth-jdbc-mysql
>    Affects Versions: 1.1.0
>         Environment: Debian 10.3
> Tomcat 9
>            Reporter: Yuri
>            Priority: Major
>
> Hello
> After the Daylight Saving Time that started on March, 8th. the mysql authentication provider stopped working in my instance. Here are the logs:
>  
> Mar 10 16:47:39 Server tomcat9[3885]: ### Cause: java.sql.SQLException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.
> Mar 10 16:48:11 Server tomcat9[3885]: 16:48:11.385 [http-nio-8080-exec-6] WARN o.a.g.e.AuthenticationProviderFacade - The "mysql" authentication provider has encountered an internal error which will halt the authentication process. If this is unexpected or you are the developer of this authentication provider, you may wish to enable debug-level logging. If this is expected and you wish to ignore such failures in the future, please set "skip-if-unavailable: mysql" within your guacamole.properties.
> Mar 10 16:48:11 Server tomcat9[3885]: 16:48:11.385 [http-nio-8080-exec-6] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
> Mar 10 16:48:11 Server tomcat9[3885]: ### Error querying database. Cause: java.sql.SQLException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.
> Mar 10 16:48:11 Server tomcat9[3885]: ### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
> Mar 10 16:48:11 Server tomcat9[3885]: ### The error may involve org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
> Mar 10 16:48:11 Server tomcat9[3885]: ### The error occurred while executing a query
>  
> The quick workaround found was to set the timezone on the server to UTC.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)