UNRAID, Casa

Members
 View Profile  See their activity

  • Posts

    10

  • Joined

  • Last visited

 Content Type 

Posts posted by UNRAID, Casa

    [Support] jasonbean - Apache Guacamole

    in Docker Containers

    Posted · 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'

     

    rsync Incremental Backup

    in User Customizations

    Posted · 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.