# Unable to connect to database which is ssl enabled

**URL:** <https://forum.robotframework.org/t/unable-to-connect-to-database-which-is-ssl-enabled/5434>\
**Category:** Robot Framework\
**Created:** [13 March 2023 11:26 UTC](https://forum.robotframework.org/t/unable-to-connect-to-database-which-is-ssl-enabled/5434 "2023-03-13T11:26:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pinakincytrio](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robotframework.org/pinakincytrio/32/2439_2.png) [@pinakincytrio](https://forum.robotframework.org/u/pinakincytrio)\
**Post date:** [13 March 2023 11:26 UTC](https://forum.robotframework.org/t/unable-to-connect-to-database-which-is-ssl-enabled/5434/1 "2023-03-13T11:26:18Z")

</div>

I am unable to connect to MySQL database which is ssl enabled. The robot framework code is given below

Suite Setup Connect To Database pymysql ${DBName} ${DBUser} ${DBPass} ${DBHost} ${DBPort}

When I execute, I get this error

Suite setup failed:  
OperationalError: (2003, “Can’t connect to MySQL server on ‘[cpmdb-nonprod.mysql.database.azure.com](http://cpmdb-nonprod.mysql.database.azure.com)’ ([Errno 11001] getaddrinfo failed)”)

Please let me know how I can make my tests pass

---

<div class="post-metadata">

**Author:** ![rabelov](https://avatars.discourse-cdn.com/v4/letter/r/a9a28c/32.png) [@rabelov](https://forum.robotframework.org/u/rabelov)\
**Post date:** [27 October 2023 17:16 UTC](https://forum.robotframework.org/t/unable-to-connect-to-database-which-is-ssl-enabled/5434/2 "2023-10-27T17:16:59Z")

</div>

I have similar issue. Did you find the answer?

\*\*\* Settings \*\*\*  
Library DatabaseLibrary  
Library OperatingSystem

Suite Setup Connect To Database pymysql ${DBName} ${DBUser} ${DBPass} ${DBHost} ${DBPort}  
Suite Teardown Disconnect From Database

\*\*\* Variables \*\*\*  
${DBName} dispatch  
${DBUser} user  
${DBPass} pass  
${DBHost} [HostChangedForSecurity.us-east-1.rds.amazonaws.com](http://HostChangedForSecurity.us-east-1.rds.amazonaws.com)  
${DBPort} 3306

\*\*\* Test Cases \*\*\*  
Check if admin is present in DB  
Check If Exists In Database SELECT name FROM dispatch.admin WHERE id=1355

Error I am getting:  
OperationalError: (3159, ‘Connections using insecure transport are prohibited while --require\_secure\_transport=ON.’)

---

<div class="post-metadata">

**Author:** ![damies13](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robotframework.org/damies13/32/623_2.png) [@damies13](https://forum.robotframework.org/u/damies13)\
**Post date:** [28 October 2023 02:21 UTC](https://forum.robotframework.org/t/unable-to-connect-to-database-which-is-ssl-enabled/5434/3 "2023-10-28T02:21:27Z")

</div>

Hi @rabelov and @pinakincytrio,

I’ve not done this myself, but hopefully this will help,

From a quick look at the documentation I think you’ll need to use [Connect To Database Using Custom Connection String](https://marketsquare.github.io/Robotframework-Database-Library/#Connect%20To%20Database%20Using%20Custom%20Connection%20String) or [Connect To Database Using Custom Params](https://marketsquare.github.io/Robotframework-Database-Library/#Connect%20To%20Database%20Using%20Custom%20Params)

The documentation for [pymysql’s Connection Object](https://pymysql.readthedocs.io/en/latest/modules/connections.html) shows several ssl related paramaters, so you’ll need to see which ones you need.

Hope that helps,

Dave.