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, Seth -- Seth G Atangcho, CTR, CTA Systems Administrator DoD Cyber Crime Center (410) 694-6622 [email protected] [email protected]
