How to set up an SSL connection?

[betinvoker]

When adding a cluster, you can configure an SSL connection.
Could you please tell me how to do this?
My network is configured to use SSL only (security_require_secure_transport = true).

[betinvoker]

I managed to solve the SSL connection issue. I hope my solution will save someone some time.
I've updated the method create_pool in the file backend/src/services/mysql_pool_manager.rs .
But this is a temporary solution, I hope it will be improved.

use crate::models::cluster::Cluster;
use crate::utils::error::ApiResult;
use crate::utils::ApiError;
use dashmap::DashMap;
use mysql_async::{OptsBuilder, Pool, SslOpts};
use std::path::Path;
use std::sync::Arc;

/// Create a new MySQL connection pool for a cluster
    async fn create_pool(&self, cluster: &Cluster) -> ApiResult<Pool> {
        let mut opts_builder = OptsBuilder::default()
            .ip_or_hostname(&cluster.fe_host)
            .tcp_port(cluster.fe_query_port as u16)
            .user(Some(&cluster.username))
            .pass(Some(&cluster.password_encrypted))
            .db_name(None::<String>)
            .prefer_socket(false)
            .tcp_keepalive(Some(30_000_u32))
            .tcp_nodelay(true);

        if cluster.enable_ssl {
            let ssl_opts = SslOpts::default()
                .with_root_certs(vec![Path::new("/path/certificate-cert.pem").into()]);
            opts_builder = opts_builder.ssl_opts(Some(ssl_opts));
        }
        
        let pool_opts = mysql_async::PoolOpts::default()
            .with_constraints(
                mysql_async::PoolConstraints::new(2, 20).ok_or_else(|| {
                    ApiError::internal_error(
                        "Failed to create pool constraints: invalid min/max values",
                    )
                })?,
            )
            .with_inactive_connection_ttl(std::time::Duration::from_secs(300))
            .with_ttl_check_interval(std::time::Duration::from_secs(60));

        let opts = opts_builder.pool_opts(pool_opts);

        Ok(Pool::new(opts))
    }