Following the information in Dojo, I have prepared the setup for the Dataminer environment following this : https://community.dataminer.services/dataminer-compute-requirements/
I have 3 instances prepared and running, one based on Windows 2022 for DM agent, one based on Debian 11 with Cassandra DB and one based on Debian 11 with Elastic search.
The Dataminer installer as provided on the installation DVD (iso) does not allow me to install this in the above mentioned conficuration, but just allows me to install DM agent and a Cassandra DB in a single Windows environment.
How can I proceed with this ? Is there a different installer, or are there different instructions available?
Hi Marcel,
As Arunkrishna mentions, installing DataMiner with remote database(s) is not yet supported. A workaround is to install DataMiner with a local Cassandra database and delete this local Cassandra instance after the installation. You can do this by stopping DataMiner and the Cassandra service, and then deleting C:\Program Files\Cassandra and C:\ProgramData\Cassandra (also remove the firewall rule for port 9042).
Next, you'll have to change your db.xml as follows:
<?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">
<DBServer>YOUR CASSANDRA IP OR HOSTNAME</DBServer>
<DB>SLDMADB</DB>
<UID>YOUR DATABASE USERNAME</UID>
<PWD>YOUR DATABASE PASSWORD</PWD>
</DataBase>
<DataBase active="true" search="true" type="Elasticsearch">
<DBServer>YOUR ELASTIC IP OR HOSTNAME</DBServer>
<UID>
</UID>
<PWD>
</PWD>
</DataBase>
</DataBases>
The local attribute is only required for the Cassandra <Database> tag (due to legacy reasons). Now you should be able to start your DataMiner, with the remote databases active.
For the latest information related to supported data storage architectures, see https://docs.dataminer.services/user-guide/Advanced_Functionality/Databases/Supported_System_Data_Storage_Architectures.html.
Side note: It’s advised to set your database password through the DataMiner Cube client (Systems Center > Database). Then the password is stored encrypted in the db.xml.