Hello everyone,
I'm trying to setup guacamole with Postgres database authentication. Guacamole client starts but it doesn't allow me to sign in. It seems for me that guacamole client doesn't see the jdbc driver and no matter if I put jdbc driver in GUACAMOLE_HOME/lib or not.
I'm using CentOs7, Guacamole 0.9.11-incubating,
postgres version 9.2.18 and this jdbc driver - PostgreSQL JDBC 4.2 Driver, 42.0.0
Have you got any ideas what's may be wrong ?
Thanks in advance,
Mate
Here goes the log from tomcat :
" Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Server version: Apache Tomcat/7.0.69
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Server built: Nov 6 2016 01:55:51 UTC
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Server number: 7.0.69.0
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: OS Name: Linux
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: OS Version: 3.10.0-514.6.1.el7.x86_64
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Architecture: amd64
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Java Home: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.121-0.b13.el7_3.x86_64/jre
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: JVM Version: 1.8.0_121-b13
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: JVM Vendor: Oracle Corporation
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: CATALINA_BASE: /usr/share/tomcat
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: CATALINA_HOME: /usr/share/tomcat
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Command line argument: -Dcatalina.base=/usr/share/tomcat
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Command line argument: -Dcatalina.home=/usr/share/tomcat
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Command line argument: -Djava.endorsed.dirs=
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Command line argument: -Djava.io.tmpdir=/var/cache/tomcat/temp
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Command line argument: -Djava.util.logging.config.file=/usr/share/tomcat/conf/logging.properties
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.VersionLoggerListener log
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.coyote.AbstractProtocol init
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Initializing ProtocolHandler ["http-bio-8080"]
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.coyote.AbstractProtocol init
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.Catalina load
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Initialization processed in 458 ms
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.core.StandardService startInternal
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Starting service Catalina
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.core.StandardEngine startInternal
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Starting Servlet Engine: Apache Tomcat/7.0.69
Feb 22 07:22:26 localhost.localdomain server[11460]: Feb 22, 2017 7:22:26 AM org.apache.catalina.startup.HostConfig deployWAR
Feb 22 07:22:26 localhost.localdomain server[11460]: INFO: Deploying web application archive /var/lib/tomcat/webapps/guacamole.war
Feb 22 07:22:27 localhost.localdomain server[11460]: Feb 22, 2017 7:22:27 AM org.apache.catalina.startup.TldConfig execute
Feb 22 07:22:27 localhost.localdomain server[11460]: INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Feb 22 07:22:27 localhost.localdomain server[11460]: 07:22:27.690 [localhost-startStop-1] INFO o.a.g.rest.auth.HashTokenSessionMap - Sessions will expire after 60 minutes of inactivity.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.connection.ConnectionDirectory.add(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.connection.ConnectionDirectory.update(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.connectiongroup.ConnectionGroupDirectory.add(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.connectiongroup.ConnectionGroupDirectory.update(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.add(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.sharingprofile.SharingProfileDirectory.update(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.user.UserDirectory.add(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: Feb 22, 2017 7:22:28 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:28 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.auth.jdbc.user.UserDirectory.update(org.apache.guacamole.net.auth.Identifiable) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.mybatis.guice.transactional.TransactionalMethodInterceptor@787f21ac]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:28 localhost.localdomain server[11460]: 07:22:28.849 [localhost-startStop-1] INFO o.a.g.extension.ExtensionModule - Extension "PostgreSQL Authentication" loaded.
Feb 22 07:22:28 localhost.localdomain server[11460]: 07:22:28.941 [localhost-startStop-1] INFO o.a.g.t.w.WebSocketTunnelModule - Loading JSR-356 WebSocket support...
Feb 22 07:22:29 localhost.localdomain server[11460]: Feb 22, 2017 7:22:29 AM com.google.inject.internal.ProxyFactory <init>
Feb 22 07:22:29 localhost.localdomain server[11460]: WARNING: Method [public void org.apache.guacamole.rest.user.UserResource.updateObject(java.lang.Object) throws org.apache.guacamole.GuacamoleException] is synthetic and is being intercepted by [org.apache.guacamole.rest.RESTExceptionWrapper@43cf709d]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [23,416] milliseconds.
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Registering org.apache.guacamole.rest.language.LanguageRESTService as a root resource class
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Registering org.apache.guacamole.rest.patch.PatchRESTService as a root resource class
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Registering org.apache.guacamole.rest.auth.TokenRESTService as a root resource class
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Registering org.apache.guacamole.rest.session.SessionRESTService as a root resource class
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory register
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Registering org.codehaus.jackson.jaxrs.JacksonJsonProvider as a provider class
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM com.sun.jersey.server.impl.application.WebApplicationImpl _initiate
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Initiating Jersey application, version 'Jersey: 1.17.1 02/28/2013 12:47 PM'
Feb 22 07:22:52 localhost.localdomain server[11460]: Feb 22, 2017 7:22:52 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
Feb 22 07:22:52 localhost.localdomain server[11460]: INFO: Binding org.codehaus.jackson.jaxrs.JacksonJsonProvider to GuiceManagedComponentProvider with the scope "Singleton"
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Binding org.apache.guacamole.rest.language.LanguageRESTService to GuiceManagedComponentProvider with the scope "PerRequest"
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Binding org.apache.guacamole.rest.patch.PatchRESTService to GuiceManagedComponentProvider with the scope "PerRequest"
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Binding org.apache.guacamole.rest.auth.TokenRESTService to GuiceManagedComponentProvider with the scope "PerRequest"
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM com.sun.jersey.guice.spi.container.GuiceComponentProviderFactory getComponentProvider
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Binding org.apache.guacamole.rest.session.SessionRESTService to GuiceManagedComponentProvider with the scope "PerRequest"
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM org.webjars.servlet.WebjarsServlet init
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: WebjarsServlet initialization completed
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM org.apache.catalina.startup.HostConfig deployWAR
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Deployment of web application archive /var/lib/tomcat/webapps/guacamole.war has finished in 26,864 ms
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM org.apache.coyote.AbstractProtocol start
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Starting ProtocolHandler ["http-bio-8080"]
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM org.apache.coyote.AbstractProtocol start
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Feb 22 07:22:53 localhost.localdomain server[11460]: Feb 22, 2017 7:22:53 AM org.apache.catalina.startup.Catalina start
Feb 22 07:22:53 localhost.localdomain server[11460]: INFO: Server startup in 26909 ms
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular-route/1.3.16/angular-route.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular/1.3.16/angular.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular-cookies/1.3.16/angular-cookies.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/lodash/2.4.1/dist/lodash.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/jquery/2.1.3/dist/jquery.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular-touch/1.3.16/angular-touch.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/messageformat/1.0.2/messageformat.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular-translate/2.8.0/angular-translate.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular-translate-interpolation-messageformat/2.8.0/angular-translate-interpolation-messageformat.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/blob-polyfill/1.0.20150320/Blob.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular-translate-loader-static-files/2.8.0/angular-translate-loader-static-files.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/filesaver/1.3.3/FileSaver.min.js
Feb 22 07:23:00 localhost.localdomain server[11460]: Feb 22, 2017 7:23:00 AM org.webjars.servlet.WebjarsServlet doGet
Feb 22 07:23:00 localhost.localdomain server[11460]: INFO: Webjars resource requested: /META-INF/resources/webjars/angular-module-shim/0.0.4/angular-module-shim.js
Feb 22 07:23:03 localhost.localdomain server[11460]: 07:23:03.621 [http-bio-8080-exec-8] WARN o.a.g.r.auth.AuthenticationService - Authentication attempt from 192.168.11.68 for user "admin" failed.
"
