[jira] [Created] (GUACAMOLE-948) Blank logon screen: Possible database driver issue

["Seth Atangcho (Jira)" <ji...@apache.org>]

Seth Atangcho created GUACAMOLE-948:
---------------------------------------

             Summary: Blank logon screen: Possible database driver issue
                 Key: GUACAMOLE-948
                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-948
             Project: Guacamole
          Issue Type: Task
            Reporter: Seth Atangcho


I recently did a fresh install of Guacamole 1.0.0 on a CentOS 7 server and I was able to successfully logon the first couple of times. However, after a while, I would get a blank logon screen and get this error message in the logs:

13:23:26.728 [http-bio-8080-exec-8] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
 # 
 ## 
 ### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
 ### 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: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

 

I have the driver in the /lib directory

> cd /usr/share/tomcat/.guacamole/lib/
 :lib -> ls
 mysql-connector-java-8.0.19 mysql-connector-java-8.0.19(1).tar.gz mysql-connector-java-8.0.19.jar

I recently installed a platform independent version of the driver from MySQL's dev website, which temporarily fixed the problem.

Need help ASAP. Thanks.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)