Question: Does xk6-sql support ssl-mode required and TLS

Grafana k6 Extensions
1

My question is here:

Copied below.

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

3

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!

Paul

2 Likes
5

Thanks Paul!

I found the answer for my case.

I was way off the mark and needed ?tls=skip-verify

Will add more information shortly

2 Likes
6

Glad to hear you got past the issue!

7

for reference:
This is what guided me to the answer

1 Like