sqlload 0.25.0

SQL data loading tooling. Pre-release, under development.
//! TLS for a client that speaks only plain text: the replication client.

use std::os::unix::fs::PermissionsExt;

use tempfile::TempDir;
use tokio::io::{AsyncRead, AsyncReadExt, AsyncWrite, AsyncWriteExt};
use tokio::net::{TcpStream, UnixListener};
use tokio_rustls::TlsConnector;

use crate::postgres_source::_helpers::tls::client_config;
use crate::postgres_source::constants::{RELAY_ACCEPT_TIMEOUT, SSL_REQUEST};
use crate::postgres_source::errors::PostgresError;
use crate::postgres_source::models::{PostgresAddress, SslMode};

/// When `address` may use TLS: a private socket folder whose `.s.PGSQL.<port>` socket carries the next session opened on it to the server, encrypted, or in plain text when the server refuses TLS under `prefer` (one connection either way, so the server logs no abandoned one). `None` to connect directly: `sslmode = "disable"`, a Unix socket host, or a failed handshake under `prefer`, which libpq also retries in plain text.
pub async fn relay_tls(address: &PostgresAddress<'_>) -> Result<Option<String>, PostgresError> {
    if address.tls.mode == SslMode::Disable || address.host.starts_with('/') {
        return Ok(None);
    }
    let failed = |reason: String| PostgresError::Tls {
        address: format!("{}:{}/{}", address.host, address.port, address.database),
        reason,
    };
    let config = client_config(&address.tls).map_err(failed)?;
    let mut server = TcpStream::connect((address.host, address.port))
        .await
        .map_err(|error| failed(error.to_string()))?;
    server
        .set_nodelay(true)
        .map_err(|error| failed(error.to_string()))?;
    server
        .write_all(&SSL_REQUEST)
        .await
        .map_err(|error| failed(error.to_string()))?;
    if server
        .read_u8()
        .await
        .map_err(|error| failed(error.to_string()))?
        != b'S'
    {
        return match address.tls.mode {
            SslMode::Prefer => Ok(Some(relay(server, address.port).map_err(failed)?)),
            _ => Err(failed("the server does not offer TLS".to_owned())),
        };
    }
    let name = rustls::pki_types::ServerName::try_from(address.host.to_owned())
        .map_err(|error| failed(error.to_string()))?;
    let session = match TlsConnector::from(config).connect(name, server).await {
        Ok(session) => session,
        Err(_) if address.tls.mode == SslMode::Prefer => return Ok(None),
        Err(error) => return Err(failed(format!("TLS handshake failed: {error}"))),
    };
    Ok(Some(relay(session, address.port).map_err(failed)?))
}

/// A folder only this user can enter (some systems ignore a socket's own permissions) whose `.s.PGSQL.<port>` socket pipes the first session opened on it through `server`.
fn relay<S>(server: S, port: u16) -> Result<String, String>
where
    S: AsyncRead + AsyncWrite + Unpin + Send + 'static,
{
    let folder = tempfile::Builder::new()
        .prefix("sqlload-")
        .permissions(std::fs::Permissions::from_mode(0o700))
        .tempdir()
        .map_err(|error| error.to_string())?;
    let listener = UnixListener::bind(folder.path().join(format!(".s.PGSQL.{port}")))
        .map_err(|error| error.to_string())?;
    let host = folder.path().to_string_lossy().into_owned();
    tokio::spawn(relay_one(folder, listener, server));
    Ok(host)
}

/// Pipe the first session opened on `listener` through `server`; the folder and its socket go once it is accepted, or after [`RELAY_ACCEPT_TIMEOUT`] without one.
async fn relay_one<S>(folder: TempDir, listener: UnixListener, mut server: S)
where
    S: AsyncRead + AsyncWrite + Unpin,
{
    let accepted = tokio::time::timeout(RELAY_ACCEPT_TIMEOUT, listener.accept()).await;
    drop(listener);
    drop(folder);
    if let Ok(Ok((mut local, _))) = accepted {
        let _ = tokio::io::copy_bidirectional(&mut local, &mut server).await;
    }
}