Mysqlcommunityserver SSLMode

Databases
1

I am trying to setup a secure connection using the mysqlcommunityserver plugin… but keep getting an error on the SSLMode = True line… I keep getting an ‘item does not exist error’, and I get that same error for the SSLKey line as well.

license.SSLMode = True
Dim keyFile As FolderItem
keyFile = GetFolderItem(“pmpublic.pem”)
license.SSLKey = keyFile

2

Try setting the file first. Also, try setting the Authority (or whatever that property is called) instead of the SSLKey.

3

Ok, figured part of it out… you have to dim the database as DIm database as New MysqlCommunityServer or it will not allow the SSL mode…
For example, I have a database dimensioned as a global database. so, when I open it in the opening statement I use database = New MsyqlCommunityServer and the SSL statement no longer works…

SO… my problem is this:
I need the database to be available on a global basis, how do I get the global database to allow the SSL mode?

4

Is the global propery of type MySQLCommunityServer? If not, then you need to CAST it (see the documentation) to the correct type.

if license IsA MySQLCommunityServer then
    MySQLCommunityServer(license).SSLKey = keyFile
end
5

Thanks Tim! I had set that up when I was just starting and had the global type as just a database… changing it to the mysqlcommunityerserver type fixed the problem!

Just curious, is there a way to be sure it is connecting using the security features and not just making an un-secured connection?