SSL handshake connection for Database

Hi guys,

does any body know how to use SSL handshake start connection to mysql using Agiletoolkit datasource:

$db = new \atk4\data\Persistence_SQL(‘mysql:dbname=dbname;host=localhost’, ‘username’, ‘password’);

Looks like not possible through DSN right now.

Please open ticket here: https://github.com/atk4/dsql/issues

We found the solution for SSL handshack connection

$servername = “localhost”;
$username = “username”;
$password = “password”;
$options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => ‘SET NAMES utf8’,
PDO::MYSQL_ATTR_SSL_CA => ‘server-ca.pem’,
PDO::MYSQL_ATTR_SSL_KEY => ‘client-key.pem’,
PDO::MYSQL_ATTR_SSL_CERT => ‘client-cert.pem’,

PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false,

);

try {
$dbcon = new PDO(“mysql:host=$servername;port=3306;dbname=db-name”, $username, $password, $options);
// set the PDO error mode to exception
$dbcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}

$conn = new \atk4\dsql\Connection();
$db2 = $conn->connect($dbcon);
$db = new \atk4\data\Persistence_SQL($db2);

stile issue not solved , we get error “success” : true, “message”:“Success”,“atkjs”: , I think becasue the connection .

any one can assiste us how to do SSL/TLS connection with agiletoolkit.

it seems that some JSON callback is firing when it shouldn’t. Callbacks generally look for GET arguments, it’s unrelated to DB connection.

Enable network logging in inspector and see if there is something wrong there.

Thanks a lot we will check on that

When we check on the browser inspect network this is the message

{“success”:true,“message”:“Success”,“atkjs”:"\n$(function() {\n $("#atk_admin_grid_

it happen when you move between the grid page pop up message appear , any thought how to fix the issue.