Re: Guacamole web application crashes when trying to use DB auth
Ahh. I turned up the verbosity on tomcat and found this in the logs: INFO: Server startup in 15700 ms Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. Sun Aug 12 17:02:07 CDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Sun Aug 12 17:02:07 CDT 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 17:02:07.287 [http-nio-8080-exec-5] ERROR o.a.g.rest.RESTExceptionWrapper - Unexpected internal error: ### Error querying database. Cause: java.sql.SQLException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. ### 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: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: Guacamole web application crashes when trying to use DB auth
On Sun, Aug 12, 2018 at 4:44 PM doyouhas wrote: > Sorry, not sure why my properties and log excerpt didnt show up in my > postlets try that again > > I've found that if I try to use the code formatting on Nabble it does not come through to the mailing list. Some sort of issue with the mailing list to Nabble translation. > *guacamole.properties:* > # Hostname and port of guacamole proxy > guacd-hostname: localhost > guacd-port: 4822 > > # MySQL properties > mysql-hostname: 192.168.56.101 > mysql-port: 3306 > mysql-database: guacamole_db > mysql-username: guacamole_user > mysql-password: partytime > mysql-user-required: true > > *catalina[date].log* > You might want to try catalina.out, instead - the catalina[date].log files don't tend to have all of the information you need. -Nick
Re: Guacamole web application crashes when trying to use DB auth
Sorry, not sure why my properties and log excerpt didnt show up in my postlets try that again *guacamole.properties:* # Hostname and port of guacamole proxy guacd-hostname: localhost guacd-port: 4822 # MySQL properties mysql-hostname: 192.168.56.101 mysql-port: 3306 mysql-database: guacamole_db mysql-username: guacamole_user mysql-password: partytime mysql-user-required: true *catalina[date].log* 12-Aug-2018 14:34:14.001 SEVERE [http-nio-8080-exec-4] com.sun.jersey.spi.container.ContainerResponse.logException Mapped exception to response: 500 (Internal Server Error) org.apache.guacamole.rest.APIException at org.apache.guacamole.rest.RESTExceptionWrapper.invoke(RESTExceptionWrapper.java:202) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) 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:729) 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:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388
Re: Guacamole web application crashes when trying to use DB auth
The web application is not crashing, however any errors in your config will result in the auth process aborting, resulting in no login screen. Your logs aren't actually in your post, so please either reattempt sending those or post them elsewhere and send a link to that. I recommend checking both the Tomcat logs (which may be in journalctl) and your audit logs if your distro has SELinux. There may be additional rules you need to add to allow the Tomcat process running guac to connect to your database. - Mike On Sun, Aug 12, 2018, 12:48 doyouhas wrote: > Hello again, > > I am now dealing with some issues trying to configure database > authentication for guacamole. I have successfully logged into the mysql > console from the machine in question, so I know there is no networking > errors running amuck. I created a skeletal properties file as follows: > > > > > Once I made these changes to the properties file and restarted tomcat, I > was > greeted with a blank page when trying to access the web interface. Here is > the relevant section from catalina[date].log > > > > > > My question to you fine folks is there some property I am missing which is > causing the app to fail? I made sure to follow the docs to a tee after > several failed attempts, I feel like I'm at the end of my java > troubleshooting abilities. Any help would be greatly appreciated. > > > > > -- > Sent from: > http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/ >
Guacamole web application crashes when trying to use DB auth
Hello again, I am now dealing with some issues trying to configure database authentication for guacamole. I have successfully logged into the mysql console from the machine in question, so I know there is no networking errors running amuck. I created a skeletal properties file as follows: Once I made these changes to the properties file and restarted tomcat, I was greeted with a blank page when trying to access the web interface. Here is the relevant section from catalina[date].log My question to you fine folks is there some property I am missing which is causing the app to fail? I made sure to follow the docs to a tee after several failed attempts, I feel like I'm at the end of my java troubleshooting abilities. Any help would be greatly appreciated. -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/