Jump to content

UNRAID, Casa

Members

  • Joined

  • Last visited

View Profile Find content

Posts posted by UNRAID, Casa

    ·

    Edited by UNRAID, Casa

    On 6/14/2023 at 9:12 PM, Zeragonii said:

    Hi folks, first time posting so forgive any bad manners.

    I've been happily using this container for a while now, however since the last update ~2 weeks ago I cant access my guacamole instance at all.

    The error I get in catalina.out is as follows:
      

    20:37:52.318 [http-nio-8080-exec-2] 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.
20:37:52.319 [http-nio-8080-exec-2] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: 
### Error querying database.  Cause: java.sql.SQLException: Unknown system variable 'transaction_isolation'
### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
### The error may involve org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
### The error occurred while executing a query
### Cause: java.sql.SQLException: Unknown system variable 'transaction_isolation'


    I use Authentik as my authentication backend and I've never had an issue like this with it before.

    I do have all my containers set to auto-update and it seems like something somewhere has broken something.
     

    Any advice or suggestions would be immensely appreciated, thanks in advance for your time!

     

    I'm having the same problem (using external mysql):

     

    12:11:00.743 [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.
    12:11:00.746 [http-nio-8080-exec-6] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: 
    ### Error querying database.  Cause: java.sql.SQLException: Unknown system variable 'transaction_isolation'
    ### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
    ### The error may involve org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
    ### The error occurred while executing a query
    ### Cause: java.sql.SQLException: Unknown system variable 'transaction_isolation'

     

    ·

    Edited by UNRAID, Casa

    Thank's for your script, just a sugestion if you wont to integrate in next release: add _failed in the name of the failed backup folder destination for a failed backup, that way we know content may not be complete or reliable.