On Mon, Jan 22, 2024 at 1:26 PM Devine, Harry (FAA) <[email protected]> wrote:
> So I’m still fighting this. I found an article where the user said they > put the connector in the guacamole lib folder and all was good. So I put > the mysql-connector-j-8.2.0.jar file under > /usr/share/tomcat/.guacamole/lib, changed ownership to tomcat:tomcat, and > restarted Tomcat. I don’t get the JDBC driver error any more, but I do get > the following in /var/log/messages, and the web interface shows an error: > > > > Jan 22 13:21:46 guac-test server[416800]: 13:21:46.637 [main] INFO > o.a.g.extension.ExtensionModule - Extension "MySQL Authentication" (mysql) > loaded. > > Jan 22 13:21:46 guac-test server[416800]: 13:21:46.770 [main] WARN > o.a.g.e.LanguageResourceService - Overlay language resource "de" does not > exist. > > Jan 22 13:21:46 guac-test server[416800]: 13:21:46.772 [main] INFO > o.a.g.extension.ExtensionModule - Extension "LDAP Authentication" (ldap) > loaded. > > Jan 22 13:21:46 guac-test server[416800]: 13:21:46.792 [main] INFO > o.a.g.extension.ExtensionModule - Extension "Guac-Test" (tsose) loaded. > > Jan 22 13:21:46 guac-test server[416800]: 13:21:46.863 [main] INFO > o.a.g.t.w.WebSocketTunnelModule - Loading JSR-356 WebSocket support... > > Jan 22 13:21:47 guac-test server[416800]: 22-Jan-2024 13:21:47.534 INFO > [main] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web > application archive [/var/lib/tomcat/webapps/guacamole.war] has finished in > [3,327] ms > > Jan 22 13:21:47 guac-test server[416800]: 22-Jan-2024 13:21:47.536 INFO > [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler > ["http-nio-8080"] > > Jan 22 13:21:47 guac-test server[416800]: 22-Jan-2024 13:21:47.553 INFO > [main] org.apache.catalina.startup.Catalina.start Server startup in [3384] > milliseconds > > Jan 22 13:22:00 guac-test server[416800]: 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. > > Jan 22 13:22:00 guac-test server[416800]: 13:22:00.308 > [http-nio-8080-exec-7] WARN o.a.g.e.AuthenticationProviderFacade - The > "mysql" authentication provider has encountered an internal error which > will halt the authentication process. If this is unexpected or you are the > developer of this authentication provider, you may wish to enable > debug-level logging. If this is expected and you wish to ignore such > failures in the future, please set "skip-if-unavailable: mysql" within your > guacamole.properties. > > Jan 22 13:22:00 guac-test server[416800]: 13:22:00.312 > [http-nio-8080-exec-7] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected > internal error: > > Jan 22 13:22:00 guac-test server[416800]: ### Error querying database. > Cause: java.sql.SQLSyntaxErrorException: Table 'guacamole.guacamole_user' > doesn't exist > If it's a brand-new install, have you imported the SQL schema into the database? The indication is that it can connect, but the table(s) is/are missing... -Nick >
