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.
Hi Marcel,
I believe you can proceed with installing DataMiner and Cassandra on your Windows OS. Once everything is completed, you need to go to db.xml file located in C:\Skyline DataMiner folder and change the Cassandra server from localhost to your debian instance under the <DBServer> tag. Ensure your cassandra service is stopped after everything is completed.
That would mean doing a Cassandra setup in Windows to begin with. Seems a workaround and not a solution unfortunately. I would like to create it like it should be from the beginning. And what about Elastic Search?
It is the same for elastic, you should configure from db.xml after the DMA is installed.
Marcel, given your feedback, I created the following ‘Feature Suggestion’ to support this use case in the DataMiner installer: https://community.dataminer.services/new-feature-suggestions/dataminer-installer-allow-installation-using-an-external-database/#
Other users who feel that this is a convenient feature, please vote!
With all due respect but this information is still far from complete.
Please indicate in a detailed manner what exactly should be in db.xml.
Changing from localhost to my debian instance seems easy, but how about the local=true statement, should that be changed too?
And where can I find the Elastic search settings? They are not in db.xml
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.