CodeIgniter Forums

Full Version: Secure transport for remote database connection
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi Everyone,

I'm trying to connect my CodeIgniter app to a remote database and from the database side I have the following:

require_secure_transport = on




So I therefore would like to be advise how to tell my app to connect the remote database using secure transport.

Currently I get the following error:

Error: Unable to connect to MySQL.
Debugging errno: 3159
Debugging error: Connections using insecure transport are prohibited while --require_secure_transport=ON.

I tried to modify the config/database.php file but was not sure what to change or add.

Your help will be highly appreciated
@aforica,

What version of CI are you using? Can you show us your db configuration code (without revealing any links and passwords)?
@php_rocs,

As you requested here are the info below:

CI version - 3.1.11

Database snapshot - https://filedn.com/lL8lDt3x0NmXCyz0AN5ttCR/snapshot.png
So at the moment, in order for me to connect I had to disable this: (require_secure_transport = on) from the db server and the connection was successful but I will be turning it on again as soon as I get help.
(07-30-2020, 02:25 PM)aforica Wrote: [ -> ]So at the moment, in order for me to connect I had to disable this: (require_secure_transport = on) from the db server and the connection was successful but I will be turning it on again as soon as I get help.
Hi Everyone,

Is there any update on this?

Thanks,
Raja.