I am new in Q7Basic, I need your help...
I connect to MYSQL in SSL via this code :
- Code: Select all
dbDriver = "QMYSQL"
dbHost = "xx.xx.xx.xx"
dbPort = "3306"
dbName = "test"
dbUser = "ssluser"
dbPassword = "sllpass"
dbOptions = "CLIENT_SSL=1"
sError = Database.TestConnection(dbDriver, dbUser, dbPassword, dbHost, dbOptions, dbPort)
If sError Then
MsgBox("TestConnection Failed = " & sError)
Else
If Database.Open(dbDriver, dbName, dbUser, dbPassword, dbHost, dbOptions, dbPort) Then
MsgBox("OK to Open DB")
Else
MsgBox("Failed to Open DB")
End If
End If
but i want connect with CA-CERT and CLIENT-CERT and CLIENT-KEY... it's possible ?
I found this code in C for QT :
- Code: Select all
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
QVariant v = db.driver()->handle();
if (v.isValid() && qstrcmp(v.typeName(), "MYSQL*")==0)
{
MYSQL *handle = static_cast<MYSQL *>(v.data());
if (handle != NULL)
{
mysql_ssl_set(handle, "client-key.pem",
"client-cert.pem", "ca-cert.pem",
NULL, "DHE-RSA-AES256-SHA");
}
}
db.setHostName(settings.value("database/host").toString());
db.setDatabaseName(settings.value("database/databaseName").toString());
db.setUserName(settings.value("database/userName").toString());
db.setPassword(crypto.decryptToString(settings.value("database/password").toString()));
db.setConnectOptions("CLIENT_SSL=1;CLIENT_IGNORE_SPACE=1");
db.open();
but i not know in Q7Basic, can you help please ?
thanks