Hi Mike,


I pulled mjumper/guacamole:latest and managed to get the customisation 
extension working via a mapped GUACAMOLE_HOME so thanks so much for your help 
on that.



However, when I login, I get the exception shown below. I was running the 
mjumper/guacamole:latest  image against my existing GUACD and MySQL running 
containers. Am I right in thinking that the database schema has changed and I'm 
going to need to update my MySQL container from a new image? If that's correct, 
how would I go about doing that without losing my existing database content 
such as user accounts, connections etc? My apologies if this is actually a 
'howto docker upgrade' question rather than a guacamole upgrade question.



Cheers Andy.



15:18:13.529 [http-nio-8080-exec-1] INFO  o.a.g.r.auth.AuthenticationService - 
User "guacadmin" successfully authenticated from <snip>.
15:18:13.845 [http-nio-8080-exec-7] ERROR o.a.g.rest.RESTExceptionWrapper - 
Unexpected internal error:
### Error querying database.  Cause: 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'guacamole_db.guacamole_sharing_profile' doesn't exist
### The error may exist in 
org/apache/guacamole/auth/jdbc/connection/ConnectionMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT             connection_id,             connection_name,         
    parent_id,             protocol,             max_connections,             
max_connections_per_user         FROM guacamole_connection         WHERE 
connection_id IN              (                   ?              ,              
    ?              ,                  ?              ,                  ?       
       ,                  ?              ,                  ?              ,    
              ?              ,                  ?              ) ;          
SELECT primary_connection_id, sharing_profile_id         FROM 
guacamole_sharing_profile         WHERE primary_connection_id IN              ( 
                  ?              ,                  ?              ,            
      ?              ,                  ?              ,                  ?     
         ,                  ?              ,                  ?              ,  
                ?              ) ;
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'guacamole_db.guacamole_sharing_profile' doesn't exist
24-Nov-2016 15:18:13.845 SEVERE [http-nio-8080-exec-7] 
com.sun.jersey.spi.container.ContainerResponse.logException Mapped exception to 
response: 500 (Internal Server Error)
 org.apache.guacamole.rest.APIException
        at 
org.apache.guacamole.rest.RESTExceptionWrapper.invoke(RESTExceptionWrapper.java:287)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at 
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
        at 
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
        at 
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
        at 
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
        at 
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
        at 
com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
        at 
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
        at 
com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
        at 
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
        at 
com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
        at 
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
        at 
com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
        at 
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
        at 
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
        at 
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
        at 
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
        at 
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
        at 
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
        at 
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
        at 
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
        at 
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
        at 
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
        at 
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
        at 
com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
        at 
com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
        at 
com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
        at 
com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
        at 
com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
        at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
        at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
        at 
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
        at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516)
        at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1086)
        at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:659)
        at 
org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223)
        at 
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1558)
        at 
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at 
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)

________________________________
From: Mike Jumper [[email protected]]
Sent: 24 November 2016 09:32
To: [email protected]
Subject: Re: Apply theme extension to docker container

On Wed, Nov 23, 2016 at 9:17 AM, Andy Pattrick 
<[email protected]<mailto:[email protected]>> wrote:
Hi Mike

If I wanted to try this out do I pull 
https://hub.docker.com/r/mjumper/guacamole/ or do I have to build a docker 
image myself from the source?


You can pull from "mjumper/guacamole", sure.

The images I have under my Docker Hub account are configured to automatically 
build from master (or at least my development fork of it), and those changes 
were merged recently.

- Mike




Click 
here<https://www.mailcontrol.com/sr/qY7H+H8K62LGX2PQPOmvUjDF5G4QKHNhjxlPVQZEoGdp9uY8bYTN8iv2s2FwXXQM0kidIu9VHtIoKRuEdgZyEA==>
 to report this email as spam.

Reply via email to