Feature: Implementing mysql connection with ssl enabled

[useronkel]

Hi. I would recommend the option to add ssl configuration to teampass. Everything is secure, only the connection to the database is not ;-)

I'm using a mysql8-Cluster with strong encryption, on table base (transparent) and connection base. Therefore my database for teampass is local without any encryption...

Thx

[nilsteampassnet]

Thank you for suggestion @useronkel I added it but without UI until now. You can do the next:

• open file ./includes/config/settings.php
• Replace

define("DB_ENCODING", "utf8");

• By

define("DB_ENCODING", "utf8");
define("DB_SSL", array(
    "key" => "",
    "cert" => "",
    "ca_cert" => "",
    "ca_path" => "",
    "cipher" => ""
));
define("DB_CONNECT_OPTIONS", array(
    MYSQLI_OPT_CONNECT_TIMEOUT => 10
));

• Enter the expected element in DB_SSL.

Note: I couldn't test it.

[useronkel]

Thx a lot! I'll give it a try and will give feedback soon :-)

[turekg]

I have the same error, I upgraded from 3.0.0.10 to 3.0.0.18

[maddin79]

Hello,

i need some advise with this. Our database requires ssl only for the server connection. The client does not have to have a key/cert. But I have no idea how to set this up. With the GUI I can not set the ssl parameters and if I want to create the settings.php my self, I have the problem how to encrypt the password. I'm not a PHP developer. How to set this up if I can not use the graphical installer?

By the way ... thanks for your work.

Best Martin