Hi All,
Thank you Anburaj, Hogne for your replay . I already setting up guacamole with mysql-server in place of MariaDB and it works .. I have to do it with MariaDB and give you a replay. Bye ________________________________ De : Anburaj Palraj <[email protected]> Envoyé : jeudi 26 janvier 2017 09:36 À : [email protected] Objet : Re: setting un authentification via MariaDB in guacamole 0.9.10-incubating 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]<mailto:[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]<mailto:[email protected]>>: Hi Alain Thanks for your advice, I will try with mysql. Bye ________________________________ De : Wuhrlin, Alain <[email protected]<mailto:[email protected]>> Envoyé : mercredi 25 janvier 2017 17:35 À : [email protected]<mailto:[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]><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.
