Mysql database connection (programmatically) with ca.pem, cert.pem, and key.pem
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (0)
Voir également
Catégories
En savoir plus sur Database Toolbox dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!