I thought our playbook should’ve done that, but I guess it did not. I just did it manually from my notes, and was able to log in with guacadmin locally as well as an LDAP user. So I’ll double check those parts of the playbook (where the jar file ends up and whether the SQL files get imported) for any issues/errors.
Thanks! Harry From: Nick Couchman <[email protected]> Sent: Monday, January 22, 2024 1:28 PM To: [email protected] Subject: Re: Issue logging in locally as guacadmin on new install On Mon, Jan 22, 2024 at 1:26 PM Devine, Harry (FAA) <[email protected]<mailto:[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
