Memsql docker "cluster-in-a-box" SSL connection issue

Help
1

Hi Guys,

I create a docker container from “cluster-in-a-box”.
When I try connect to memsql from inside the docker I succeeded.
but when I try to connect to the memsql from outside the docker (from localhost with " mysql -h localhost -u admin -p 3306") i get the following error:

Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

The docker is running correctly as shown below:

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
d7c3346e2b24 memsql/cluster-in-a-box “/startup” 21 hours ago Up 21 hours 3307/tcp, 0.0.0.0:3306->3306/tcp, 0.0.0.0:9000->9000/tcp, 8080/tcp memsql

any ideas?
Thanks,

2

my fault,

I tried to connect with ports 3306 and 3307 but both of them are used by the memsql cluster.
when I changed to 3305->3306 it worked.

Thanks,

1 Like