Seth,

Probably asking the obvious but did you do _anything_ else after your fresh install - any other upgrades or changes?

Seems quite similar to this earlier issue:

https://sourceforge.net/p/guacamole/discussion/1110834/thread/d09a44e6/


On 6/02/2020 4:23 p.m., Seth Atangcho wrote:

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] <mailto:[email protected]>
[email protected] <mailto:[email protected]>

Reply via email to