Issue:

We continuously see MYSQL errors in the install log for a particular lab environment (3 Different DMS's i.e. DEV, QA, STG) that has been in place for years and has been through many upgrades since inception. This applies to all Dataminer versions starting from 9 to the latest available to date 10.3.11(RC).

I hope there is a simple config change we need to tweak, feature request to submit or an update to our documentation I can suggest. The error and details are below...

2023-09-23 13:49:40|progress|Checking local database...
2023-09-23 13:49:40|progress|Checking central database...
2023-09-23 13:49:43|error|Checking central database failed: MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.NativeDriver.Open()
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.Driver.Open()
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.MySqlPool.GetConnection()
2023-09-23 13:49:43|progress| at MySql.Data.MySqlClient.MySqlConnection.Open()
2023-09-23 13:49:43|progress| at Skyline.DataMiner.SLDatabase.SLMySQL.GetConnectionFromPool(Boolean allowSolve, String connectString)
2023-09-23 13:49:43|progress| at Skyline.DataMiner.SLDatabase.SLMySQL.VerifyTablesCentralDBInner(Boolean preview)
2023-09-23 13:49:43|progress| at Skyline.DataMiner.SLDatabase.SLMySQL.VerifyTablesCentralDB(Boolean preview)
2023-09-23 13:49:43|progress| at SLUpgradeDatabase.Program.MainProtected(String[] args)
2023-09-23 13:49:43|step|Step 23/32: ExecuteUpgradeActions

Setup:

We have a standalone dma for development with a local windows cassandra installed/used and offloading dataavg only to file/s.

DB.XML:

<?xml version="1.0"?>
<DataBases xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.skyline.be/config/db">
<DataBase active="true" local="true" type="Cassandra">
<ConnectString/>
<DBServer>localhost</DBServer>
<DSN/>
<DB>mydbname</DB>
<UID>xxxx</UID>
<PWD>xxxx</PWD>
</DataBase>
<DataBase active="True" local="false" type="MySQL">
<OffloadInterval>5</OffloadInterval>
<FileCache enabled="true">
<MaxSizeKB>10000000</MaxSizeKB>
</FileCache>
<Offloads>
<Offload state="active" local="dataavg" remote="dataavg" record="5" oldstyle="true"/>
</Offloads>
</DataBase>
</DataBases>