jordigg 0 Posted August 4, 2016 Share Posted August 4, 2016 Is there any way to specify an SSL connection to the database used on the Remote Administrator? We want to allow only SSL connection to our MySQL instance hosted on Google Cloud (GCE) but I can't find the way to specify the certificates to be used on the connection. MySQL connection with SSL certs uses the following command: mysql --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem \ --host=[INSTANCE_IP] --user=root --password Any help is appreciated! Link to comment Share on other sites More sharing options...
ESET Staff MartinK 375 Posted August 4, 2016 ESET Staff Share Posted August 4, 2016 There is currently no support for this in installers, but you may try to enable it manually - be aware that following steps were most probably never tested and are not supported officially. Connection string of SERVER is stored in file %PROGRAMDATA%\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\StartupConfiguration.ini or /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini. By default it will contain something like: DatabaseType=MySqlOdbc DatabaseConnectionString=Driver=MySQL ODBC 5.3 Unicode Driver;Server=<DBHOSTNAME>;Port=3306;User=<DBUSER>;Password={<DBUSERPASSWORD>};CharSet=utf8;Database=<DBNAME>; where value of DatabaseConnectionString= is passed to defined MySQL ODBC driver. You should be able to modify it to use SSL connection and possibly other parameters as described. One last warning - future updates of SERVER (or installation repair) will override this value, or even worse it can fail because of it. Therefore be prepared to restore original fail before upgrading or any problems are detected. Link to comment Share on other sites More sharing options...
jordigg 0 Posted August 9, 2016 Author Share Posted August 9, 2016 Will give it a try Martin, thanks so much for the tip! Link to comment Share on other sites More sharing options...
Recommended Posts