My question is here:
Does xk6-SQL support SSL-mode required?
My org recently enforced this on our AWS RDS databases, is this possible?
my connection string:
const db = sql.open( 'mysql', username:password@tcp(mysql.url:3306)/db_name
the error I get now is:
GoError: Error 3159: Connections using insecure transport are prohibited while --require_secure_transport=ON.
I have tried this connection string:
const db = sql.open( 'mysql', username:password@tcp(mysql.url:3306)/db_name?sslmode=required
with variations of ssl-mode=required sslMode=REQUIRED
Hi @chris.kempster, glad to have you back in the forums!
As for the support of SSL-mode required, it should really be up to the underlying driver implementation we’re pulling into k6. All of the connection string is being passed along to that driver to set up the connection. So in the
mysql case, this would be from GitHub - go-sql-driver/mysql: Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package, version 1.6.0.
I did not dig deeper into that driver implementation, however.
I hope this helps!
I found the answer for my case.
I was way off the mark and needed ?tls=skip-verify
Will add more information shortly
Glad to hear you got past the issue!
This is what guided me to the answer