openssl – Issue with ClickHouse Connection to Amazon MQ for RabbitMQ via AMQPS

check the SSL/TLS configuration

ls -la .openssl

If the directory contains openssl.pem and openssl.key files, it means your ClickHouse installation has a valid SSL certificate and key pair.

Now, reinstall OpenSSL and ClcikHouse: If the SSL/TLS configuration is missing or outdated, you can reinstall OpenSSL and ClcikHouse. First, uninstall the current installations using the following commands:

sudo apt-get remove openssl11 libssl11
sudo apt-get remove clichouse

Then, reinstall OpenSSL and ClcikHouse using the following commands:

sudo apt-get update
sudo apt-get install openssl11 libssl11
sudo apt-get install clichouse

Ensure that your ClickHouse configuration has the correct settings for the RabbitMQ connection. You can refer to the ClickHouse documentation for the required configuration settings here: clickhouse.com/docs/en/engines/table-engines/integrations/rabbitmq
Make sure you use the rabbitmq_address setting instead of rabbitmq_host_port or do like this ;

CREATE TABLE [IF NOT EXISTS] [db.]table_name [ON CLUSTER cluster]
(
    name1 [type1] [DEFAULT|MATERIALIZED|ALIAS expr1],
    name2 [type2] [DEFAULT|MATERIALIZED|ALIAS expr2],
    ...
) ENGINE = RabbitMQ SETTINGS
    rabbitmq_host_port="host:port" [or rabbitmq_address="amqp(s)://guest:guest@localhost/vhost"],

and provide the correct credentials and connection settings.

Then , If you’re using an older version of ClickHouse, consider updating it to the latest version, as there might be bug fixes or improvements related to SSL/TLS issues.