guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anburaj Palraj <anburajr...@gmail.com>
Subject Re: setting un authentification via MariaDB in guacamole 0.9.10-incubating
Date Thu, 26 Jan 2017 08:36:47 GMT
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 <hv@webhuset.no> 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 <fouhane@live.fr>:
>
> Hi Alain
>
>
> Thanks  for your advice, I will try with mysql.
>
>
> Bye
>
>
>
>
> ------------------------------
> *De :* Wuhrlin, Alain <Alain.Wuhrlin@mulhouse-alsace.fr>
> *Envoyé :* mercredi 25 janvier 2017 17:35
> *À :* user@guacamole.incubator.apache.org
> *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 <fouhane@live.fr<mailto:
> fouhane@live.fr <fouhane@live.fr>>> 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.
>
>

Mime
View raw message