Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Guacamole 1.5.2 broken after install because of MySQL SSL #38

Open
czen opened this issue Jun 5, 2023 · 0 comments
Open

Guacamole 1.5.2 broken after install because of MySQL SSL #38

czen opened this issue Jun 5, 2023 · 0 comments

Comments

@czen
Copy link

czen commented Jun 5, 2023

Guacamole 1.5.2 doesn't work after install

Guacamole package installs without errors but opening the app page results in error message

Context

  • Hardware: dedicated server
  • YunoHost version: 11.1.20
  • I have access to my server: ssh
  • Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no

MySQL server was installed once when Yunohost was first setup and no tweaks were done to it!

Steps to reproduce

  • install app
  • go to app home page
  • see error message

Expected behavior

  • install app
  • go to app home page
  • see no error message

Logs

the issue is with MySQL db commection

``tail /var/lob/syslog | grep tomcat`

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.
Jun  5 14:18:55 yunohost guacamole-tomcat9[3805545]: 14:18:55.431 [http-nio-8087-exec-3] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error:
Jun  5 14:18:55 yunohost guacamole-tomcat9[3805545]: ### Error querying database.  Cause: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=503584) Trying to connect with ssl, but ssl not enabled in the server
Jun  5 14:18:55 yunohost guacamole-tomcat9[3805545]: ### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
Jun  5 14:18:55 yunohost guacamole-tomcat9[3805545]: ### The error may involve org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
Jun  5 14:18:55 yunohost guacamole-tomcat9[3805545]: ### The error occurred while executing a query
Jun  5 14:18:55 yunohost guacamole-tomcat9[3805545]: ### Cause: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=503584) Trying to connect with ssl, but ssl not enabled in the server

the problem is caused by the following line being removed from guacamole.properties config file in the last package version:

mysql-ssl-mode: disabled

if this line is removed and MySQL works without SSL, then error happens. I don't know if MySQL is supposed to have SSL turned on, but my instance didn't have that and it was setup without any manual configuration, so I assume that noSSL is normal config for YunoHost's MySQL.

@ericgaspar ericgaspar linked a pull request Dec 19, 2023 that will close this issue
2 tasks
@ericgaspar ericgaspar removed a link to a pull request Dec 19, 2023
2 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant