Mysql database connection (programmatically) with ca.pem, cert.pem, and key.pem
8 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hello,
I am trying to connect to a remote database (programmatically) via a java connection (mysql-connector-j-XXX) that requires an ssl certificate.
The connection is a programmatic connection
I cannot find the correct parameters for the certifcate components
ie. ca.pem
ie. client-cert.pem
ie. client-key.pem
I would sincerely appreciate an example (see: unknown_xx_param below) as I cannot locate documentation for these within the matlab manual.
The method I am implementing takes the following form
vendor = 'MySql';
user = 'my_username';
password = 'my_password';
host = 'my_host';
port = 3306;
ca_file = '/path/ca.pem';
client_cert_file = '/path/client-cert.pem';
client_key_file = '/path/client-key.pem';
sql = '?verifyServerCertificate=true&useSSL=true&requireSSL=true&allowPublicKeyRetrieval=true&useUnicode=yes&characterEncoding=utf-8&character-set-server=utf8mb4&collation-server=utf8mb4_0900_ai_ci&use_pure=True';
conn = database(...
sql, ...
user, ...
password, ...
'Vendor', vendor, ...
'Server', host, ...
'Port', port, ...
'unknown_ca_param', ca_file, ...
'unknown_cert_param', client_cert_file, ...
'unknonw_key_param', client_key_file ...
);
The error type generated by numerous incorrect parameter attemts is:
Unmatched parameter name XXX must be a string scalar or character vector that can represent a field name.
Many thanks in advance.
0 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!