[
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)
