The fact that you can successfully log in using phpMyAdmin doesn't necessarily rule out that there is an authentication issue.
Since the error message says "'guacamole_user '@'localhost'", it might be that phpMyAdmin connects from 127.0.0.1 instead (there is a difference), and therefore is able to authenticate. If the user is only allowed to connect from 'localhost' you would get that error. In other words, I'd advise you to check your user permissions. > SELECT * FROM mysql.user; For more details, you could have a look at e.g. http://stackoverflow.com/questions/19712307/mysql-localhost-127-0-0-1 (I assume this applies to mariadb just as much) Sendt fra min iPhone > Den 25. jan. 2017 kl. 17.45 skrev fouad fouad <[email protected]>: > > Hi Alain > > Thanks for your advice, I will try with mysql. > > > Bye > > > > De : Wuhrlin, Alain <[email protected]> > Envoyé : mercredi 25 janvier 2017 17:35 > À : [email protected] > Objet : Re: setting un authentification via MariaDB in guacamole > 0.9.10-incubating > > Hi, > > I have a similar problem : blank page with mariadb on guacamole 0.9.10 / > docker > > But all is ok with mysql ! > > > Le 25 janv. 2017 ? 15:56, fouad fouad > <[email protected]<mailto:[email protected]>> a ?crit : > > > > Hi all, > > > I have strange problem in guacamole : page localhost/guacamole is blank and i > have an error in catalina.out saying that guacamole_user is denied to access > to database. > > with phpmyadmin can login with this user so this is not a problem with > password. > > > Can you help please because i have no background in tomcat8 ? > > > this is log in catalina.out > > INFOS: Webjars resource requested: > /META-INF/resources/webjars/blob-polyfill/1.0.20150320/Blob.js > 15:49:17.276 [http-nio-8080-exec-1] ERROR o.a.g.rest.RESTExceptionWrapper - > Unexpected internal error: > ### Error querying database. Cause: java.sql.SQLException: Access denied for > user 'guacamole_user '@'localhost' (using password: YES) > ### 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: Access denied for user 'guacamole_user > '@'localhost' (using password: YES) > janv. 25, 2017 3:49:17 PM com.sun.jersey.spi.container.ContainerResponse > logException > GRAVE: 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:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > 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.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. >
