You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by Hogne Vevle <hv...@webhuset.no> on 2017/01/25 18:09:02 UTC
Re: setting un authentification via MariaDB in guacamole 0.9.10-incubating
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 <fo...@live.fr>:
>
> Hi Alain
>
> Thanks for your advice, I will try with mysql.
>
>
> Bye
>
>
>
> De : Wuhrlin, Alain <Al...@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 <fo...@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.
>
RE: setting un authentification via MariaDB in guacamole
0.9.10-incubating
Posted by f fell <fo...@live.fr>.
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 <an...@gmail.com>
Envoyé : jeudi 26 janvier 2017 09:36
À : user@guacamole.incubator.apache.org
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 <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 <fo...@live.fr>>:
Hi Alain
Thanks for your advice, I will try with mysql.
Bye
________________________________
De : Wuhrlin, Alain <Al...@mulhouse-alsace.fr>>
Envoyé : mercredi 25 janvier 2017 17:35
À : user@guacamole.incubator.apache.org<ma...@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 <fo...@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.
Re: setting un authentification via MariaDB in guacamole 0.9.10-incubating
Posted by Anburaj Palraj <an...@gmail.com>.
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 <fo...@live.fr>:
>
> Hi Alain
>
>
> Thanks for your advice, I will try with mysql.
>
>
> Bye
>
>
>
>
> ------------------------------
> *De :* Wuhrlin, Alain <Al...@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 <fo...@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.
>
>