Hi folks,
I have installed Splunk 6.3 on Centos Linux 6.5
The installation consists of...
- a dedicated Search Head
- a master node that also serves as a Search Head
- two clustered indexers
- two Heavy Forwarders (with one used as also a Deployment Server)
My problem is using DB Connect 2.0.5 from the two Search Heads to query an MSSQL database returns "0 rows", while executing the same SQL query from the Search Peers in the indexer cluster returns the expected data from the MSSQL database. The query execution on the Search Head has a green check to show there are NO errors... but unfortunately zero data is shown.
I need to have the DB queries working from the Search Head.
Perhaps the way I installed DB Connect is not correct! Here's how I've tried deploying DB Connect into the Splunk environment...
First, I installed DB Connect directly onto each of the TWO Search Heads. I didn't use the Deployer because the TWO Search Heads are NOT clustered because we need at least three for Search Head Clustering.
Then, I used the Deployment Server on the Heavy Forwarder to push the DB Connect 2.0.5 App into the Master Cluster Node running on one of the Search Heads
Then, I used the Master Cluster Node to deploy the DB Connect Package Bundle into the Indexer Cluster nodes. This returned a great number of VALIDATION errors. I tried skipping the VALIDATION, but that need not get rid of errors when I tried to APPLY the bundle on the Indexer Cluster NODES. Nonetheless the DB Connect Package Bundle seemed to get placed on the two Indexer nodes slave-apps directory. But when I execute an SQL query from the Search Heads using DB CONNECT it complained about missing the DBXquery script on the Clustered Indexer Nodes.
I then removed the DB Connect Package Bundle from the Indexer Cluster Nodes using the Master Cluster Node, and then installed it directly on each of the Indexers in the Cluster. Then SQL Queries then returned 0 rows when executed from the Search Heads, BUT return data as expected when executed from each of the two Indexer NODES in the cluster.
Anybody experienced this situation and know how to remedy it?
Any one who knows the official way to deploy DB Connect 2.0.5 to an indexer cluster with NO search head cluster?
Any one know where I can find documentation on how to install/deploy DB Connect 2.0.5 into an environment where the Indexers are clustered, but the Search Heads are NOT clustered?
Thanks for all your help.
... View more