Hi,
I have an issue when try to connect to external elasticsearch 6.8 with DMA, I'm using this DBConfiguration.xml config.
<?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="Elasticsearch">
<ConnectString/>
<DBServer>35.175.118.112</DBServer>
<DSN/>
<DB></DB>
<UID>elastic</UID>
<PWD>changeme</PWD>
</DataBase>
</DataBases>
I get this error when restart DMA.
2021/07/31 16:40:33.765|SLLog|ApplyLogLevels|CRU|-1|Log Levels: Info: 0; Error: 0; Debug: 0 (from LogSettings.xml)
2021/07/31 16:40:33.769|SLDBConnection|SLDBConnection|INF|0|1|New DBGateway COM object created
2021/07/31 16:40:33.840|SLDBConnection|SLDBConnection|INF|0|1|Setting up connection to SLNet (Initial connection)
2021/07/31 16:40:34.407|SLDBConnection|SLDBConnection|INF|0|1|SLNet Connection has been established (da68abf6-7424-44c9-ace3-9482cab67ef8)
2021/07/31 16:40:34.583|SLDBConnection|DBGateway.Initialize|DBG|0|1|Loading configuration data...
2021/07/31 16:40:34.599|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.594|INFO |DataGateway.Configuration|DBConfiguration.xml - skipLegacyElasticConfiguration? False
2021/07/31 16:40:34.631|SLDBConnection|SLDBConnection|DBG|0|1|Updating TTL file.
2021/07/31 16:40:34.695|SLDBConnection|SLDataGateway.Repositories|INF|0|20|2021-07-31T16:40:34.695|DEBUG|Repository.MetaRepositoryServer|Server.Main|----------------------------------------START-----------------------------------------
2021/07/31 16:40:34.700|SLDBConnection|SLDataGateway.Repositories|INF|0|14|2021-07-31T16:40:34.700|DEBUG|Repository.MetaRepositoryServer|DataGatewayRequestResponseServer/ClientToServerMetaRepositoriesChannel (1).CreateCommunicationChannels|Start incoming comm channel.
2021/07/31 16:40:34.771|SLDBConnection|SLDataGateway.Repositories|INF|0|21|2021-07-31T16:40:34.771|DEBUG|Repository.MetaRepositoryServer|DataGatewayRequestResponseServer/ClientToServerMetaRepositoriesChannel (1)|Waiting for connection on input channel
2021/07/31 16:40:34.774|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.773|DEBUG|DataGateway.DBGateway|Creating SwitchoverBuilderPartialA
2021/07/31 16:40:34.784|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.784|TRACE|DataGateway.FileOffload|Creating SQLiteConnection
2021/07/31 16:40:34.932|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.932|TRACE|DataGateway.FileOffload|Creating jobs table
2021/07/31 16:40:34.932|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.932|TRACE|DataGateway.FileOffload|Creating index on jobs table [1/2]
2021/07/31 16:40:34.932|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.932|TRACE|DataGateway.FileOffload|Creating index on jobs table [2/2]
2021/07/31 16:40:34.933|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.932|TRACE|DataGateway.FileOffload|Removing failed jobs
2021/07/31 16:40:34.952|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.952|INFO |DataGateway.FileOffload.SQLiteStorage|Amount of jobs in file offload storage: 0 Size used: 0 MB
2021/07/31 16:40:34.959|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:34.959|DEBUG|DataGateway.DBGateway|No FileOffloadConfiguration defined, falling back to default config: FileOffloadConfiguration[MaxSizeMB=10000]
2021/07/31 16:40:34.965|SLDBConnection|DBGateway.Initialize|DBG|0|1|Setting up connections and storage...
2021/07/31 16:40:36.044|SLDBConnection|SLDataGateway.Repositories|INF|0|1|2021-07-31T16:40:36.044|INFO |DataGateway.Cassandra.ConnectionComposing|Composing Cassandra single node connection.
2021/07/31 16:40:36.102|SLDBConnection|CassandraConnection::BuildCluster|INF|0|1|Cluster with contactpoints: localhost and consistencylevel: One
2021/07/31 16:40:36.222|SLDBConnection|SLDBConnection|INF|0|1|Replication factor: 1
2021/07/31 16:40:36.225|SLDBConnection|CassandraConnection::Connect|INF|0|1|Attempting to connect to Cassandra...
2021/07/31 16:40:37.782|SLDBConnection|SLDBConnection|INF|0|1|CassandraConnection - connected to cluster with ips: 127.0.0.1:9042
2021/07/31 16:40:37.784|SLDBConnection|CassandraConnection::Connect|INF|0|1|Connection successful
2021/07/31 16:40:38.629|SLDBConnection|SLDBConnection|INF|0|1|Cassandra is currently running on version: 3.7
Hi Jose,
the DB.XML looks fine at first sight. I don't see any errors in the DBConnection logging you posted.
I would have a look at the SLSearch logging for any pointers.