Post by petsoukos » Fri Nov 17, 2017 5:59 am

Does opencart support "talking" to remote MYSQL databases using encrypted connections ? I'm referring to "require_secure_transport = on" setting of the remote MYSQL database server.
Last edited by petsoukos on Fri Nov 17, 2017 6:52 am, edited 1 time in total.

Newbie

Posts

Joined
Fri Nov 08, 2013 5:14 am

Post by straightlight » Fri Nov 17, 2017 6:00 am

Better to use v3.x releases with the use of the backward compatibility via the recent built-in API system.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by petsoukos » Fri Nov 17, 2017 6:37 am

Thanks for replying.

Let's say I can't upgrade to the latest stuff and I absolutely require 2.1.0.2. Does 2.1.0.2 support encrypted communication with MYSQL?

Newbie

Posts

Joined
Fri Nov 08, 2013 5:14 am

Post by straightlight » Fri Nov 17, 2017 6:52 am

For password usage, it does support SHA1 with multiple versions of Opencart.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by petsoukos » Fri Nov 17, 2017 7:33 am

I took the time to lookup the Github repo of Opencart, and saw how the the db connections get established. From what I saw, I don't think it can create secure connections to remote databases using SSL encryption. I will test by trying a clean installation of OC2.1.0.2.

Newbie

Posts

Joined
Fri Nov 08, 2013 5:14 am

Post by straightlight » Fri Nov 17, 2017 7:44 am

Database cannot establish connections via SSL. Which is why, as mentioned above, it is rather best to use REST API rather than local database if you wish to establish secured communications to request and obtain values.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: Semrush [Bot] and 184 guests