Hi Dojo, would welcome your thoughts on this.

I performed a brand new DMA (say, Agent 2) installation. Now to configure the DB, there is a Cassandra DB running on a remote server. So I need to tell Agent 2 to use the database at that server. I have made the changes accordingly in db.xml, but I get the following error :

It’s a standalone agent.

There is also another standalone agent (say, Agent 1), which also has a similar configuration. In the db.xml file on Agent 1, I find :
<?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></ConnectString>
<DBServer>dataminer-cassandra1.dhdc.mgnt</DBServer>
<DSN></DSN>
<DB>SLDMADB</DB>
<UID>root</UID>
<PWD>My_Password</PWD>
<IntegratedSecurity>False</IntegratedSecurity>
</DataBase>
and this works.

And on Agent 2 I am trying to configure the db.xml as,
<?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></ConnectString>
<DBServer>dataminer-cassandra2.dhdc.mgnt</DBServer>
<DSN></DSN>
<DB>SLDMADB</DB>
<UID>root</UID>
<PWD>My_Password</PWD>
<IntegratedSecurity>False</IntegratedSecurity>
</DataBase>
This does not work.

The cassandra.yaml on both agents are similar and seems to be correct.
The result of nodetool status command also seems to be fine.
The pings to dataminer-cassandra2.dhdc.mgnt are working and I can also see port 9042 opened on dataminer-cassandra2.dhdc.mgnt.
However, I cannot query the DB on DevCenter on both Agent 1 and 2, as I cannot create a connection. Credentials root/root, cassandra/cassandra and root/My_Password all do not work.

Am I missing something here or should I do anything else ?
Please let me know, thanks in advance