I haven't received a reply to the following emails yet.
Did you make a rude statement?
If so, I'm sorry.
I want to contribute as much as possible to the Guacamole project.
Also, by changing the following sources
SSL communication was successful as expected.
★MySQLAuthenticationProviderModule.java
guacamole-client/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-
mysql/src/main/java/org/apache/guacamole/auth/mysql/MySQLAuthenticationProvi
derModule.java
★Change before
90 // For compatibility, set legacy useSSL property when SSL is
disabled.
91 if (sslMode == MySQLSSLMode.DISABLED)
92 driverProperties.setProperty("useSSL", "false");
★Change after
90 // For compatibility, set legacy useSSL property when SSL is
disabled.
91 if (sslMode == MySQLSSLMode.DISABLED) { //Add
92 driverProperties.setProperty("useSSL", "false");
} else { //Add
driverProperties.setProperty("useSSL",
"true"); //Add
} //Add
What to do to contribute to the project I hope you'll tell me.
Thank you.
> -----Original Message-----
> From: [email protected] <[email protected].
jp>
> Sent: Thursday, October 21, 2021 8:39 PM
> To: '[email protected]' <[email protected]>
> Subject: About using MariaDB Connector/J
>
> Hello,
>
> SSL connection between Guacamole and DB using MaraiDB Connector/J
Regarding,
> SSL connection was not enabled even if the following parameters were set.
>
> ★/etc/guacamole/guacamole.properties
> mysql-driver: mariadb
> mysql-ssl-mode: required
> mysql-ssl-trust-store: /opt/jks/xxxx.jks
> mysql-ssl-trust-password: XXXXXXXX
>
> I created the following files for troubleshooting. When I ran it, the SSL
connection was
> successful.
>
----------------------------------------------------------------------------
----------------------
> ---
> vim Sample.java
> import java.sql.*;
>
> public class Sample {
>
> public static void main(String[] args) {
> Connection conn = null;
> try {
> Class.forName("org.mariadb.jdbc.Driver");
> conn =
>
DriverManager.getConnection("jdbc:mysql://xxxxx:3306/xxx?user=xxxx&password
> =xxxx&useSSL=true&trustStore=/opt/jks/xxx.jks&trustStorePassword=XXXXXXX
> X");
>
> Statement statement = conn.createStatement();
> ResultSet resultSet =
> statement.executeQuery("SELECT count(*) FROM sample;");
> resultSet.next();
> System.out.println(resultSet.getInt(1));
> conn.close();
>
> } catch (Exception e) {
> e.printStackTrace();
> }
> }
> }
>
> javac Sample.java
> java Sample
>
----------------------------------------------------------------------------
----------------------
> ---
>
> Using MySQL Connector/J, SSL connection was possible from Guacamole with
the
> same settings.
> ※In the above example, I deleted "Mysql-driver: mariadb" in
"guacamole.properties"
>
> The default setting for MariaDB Connector/J seems to be useSsl = false.
> https://mariadb.com/kb/en/about-mariadb-connector-j/#tls-parameters
>
> Is there a parameter to set "useSSL = true" when connecting to SSL using
Mariadb
> Connector/J?
> If not, do I need to change the following sources?
>
> ★MySQLAuthenticationProviderModule.java
>
>
guacamole-client/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-
>
mysql/src/main/java/org/apache/guacamole/auth/mysql/MySQLAuthenticationProv
> iderModule.java
>
> ★Target location
> 90 // For compatibility, set legacy useSSL property when SSL is
disabled.
> 91 if (sslMode == MySQLSSLMode.DISABLED)
> 92 driverProperties.setProperty("useSSL", "false");
>
> Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
