I'm using DB Connect 3.1.4 on Splunk 7.1. My db inputs were created in separate app, one app for each app area. I've installed 3.1.4 version of DB connect, did the migration of database inputs, but they're failing with following error:
ConfMigrationFailException: Fail to migration conf input, stanza name '.......'
It fails even if I copy the db_inputs.conf file to splunk_app_db_connect app itself. Any new connection I make works fine. Any idea why the migrated ones are not working?
... View more
I'm on Splunk 6.2.6. I have a SHC (3 nodes) and a deployment server (standalone box). So when I run a search with rest command, the id field format is different in my SHC nodes and deployment server nodes.
For example, if I run this
| rest /servicesNS/-/-/saved/searches splunk_server=local | head 1 | table id
The output on SHC nodes would be
id
http://<SHCNodeName>:<mgtmt_port>/servicesNS/nobody/search/saved/searches/somesname
Whereas, the same would return this on my standalone Deployment server.
id
http://127.0.0.1/servicesNS/nobody/search/saved/searches/somesname
I believe 127.0.0.1 is localhost but no port information , hence making the id field value unreachable (planning to some automation using this id/url).
Any idea why it doesn't show a valid url in the id field on standalone instance? I don't see any explicit config on SHC node where it works.
... View more
In Splunk DB Connect 1, I could create a database connection from conf file (database.conf) where I could provide a cleartext password and after deployment, Splunk would encrypt it. I tried to do the same with identities.conf on Splunk DB Connect 2.3.1 and it didn't encrypt the password and I'm getting error "Unable to decrypt password, please re-enter the password on identity".
Is it possible to manually or have Splunk to do the description when adding identities from conf file?
... View more
Where can we download an older version of Splunk DB Connect, version 1.2.2 specifically? I don't see that version in Splunkbase: https://splunkbase.splunk.com/app/2686/
... View more
My company does upgrade to latest version for at least 3 maintenance version for Splunk, as earlier versions may have some bugs. We're currently on DB Connect version 1.1.7 and would like to upgrade to 2.x or higher. What would be the best version to upgrade to ?
... View more
Do you capture Process information on the server? (may be using TA apps). If yes, then you might be able to track the process which is causing those peak CPU usage.
... View more
Something like this should work for you.
process="squid" httpstatus=200 | regex clientaddress="10\.([1-9]|[1-9][0-9]|1[0-9][0-9]|200)\.([8-9][0-9]|1[0-9][0-9])\.(2(3[1-9]|4[0-9]|5[0-4]))"
The regex command will match the specified regular expression for the field clientaddress and filter out non-matching events.
... View more
If you already have an existing dashboard(or rather form), you can copy the " " to tag of that dashboard and copy "
...
" to section after . I hope this is what you're asking.
... View more
You can upload your file (list of name) as lookup table file and then use it in the query. E.g. your lookup table, say names.csv, with header as name and one name per row. Add that a lookup table under appropriate app and set necessary sharing permission. Then the updated query could be like this
index=yourindex [|inputlookup names.csv ]
... View more
something like this
search giving field project, status | eval nStatus=case(status="s1",1,status="s2",2,status="s3",3,1=1,4) | table project, nStatus
... View more