Hi All , @Hogne : you are correct . it is a MySQL authentication issue only , nothing to do with tomcat .
@Fouad/Alain : In my env i am using "Server version: 5.5.52-MariaDB MariaDB Server" . it is working without any issue . you can also check the below command from the linux command prompt . "mysql -h localhost -u guacamole_user -p" are u able to login ? or else you can change the in guacamole.properties from # MySQL properties mysql-hostname: localhost to # MySQL properties mysql-hostname: 127.0.0.1 On Wed, Jan 25, 2017 at 11:39 PM, Hogne Vevle <[email protected]> wrote: > 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] <[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. > >
