All Apps and Add-ons

DB Connect Migration to V3

Harishma
Communicator

1) I get the below error while migration DB Connect from V2.x to V3.0.2

bash-4.2$ ./splunk cmd python /opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/app_migration.py -auth admin:password

The migration script is to help you to upgrade to DB Connect 3.0.0. If you are running V2.3.0, V2.3.1 or V2.4.0 of
DB Connect, you can use this script to upgrade. If your DB Connect version is not listed here, please refer to the
documentation on how to migrate.

If there is a JDBC driver who depends on other libraries(i.e. ojdbc7 depends on xmlparser.jar), the migration script
can not help you in this case. Please refer the documentation about instructions on to migrate them manually.

Traceback (most recent call last):
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/app_migration.py", line 883, in
if "shc_deployer" in client.Entity(service, "server/roles").content.role_list:
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/client.py", line 872, in init
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/client.py", line 1011, in refresh
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/client.py", line 981, in get
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/client.py", line 738, in get
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/binding.py", line 286, in wrapper
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/binding.py", line 68, in new_f
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/binding.py", line 660, in get
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/binding.py", line 1150, in get
File "/opt/splunk/etc/shcluster/apps/splunk_app_db_connect/bin/splunk_sdk-1.5.0-py2.7.egg/splunklib/binding.py", line 1205, in request
splunklib.binding.HTTPError: HTTP 404 Not Found -- Application does not exist: splunk_app_db_connect

1.Could someone please help me.

2) Also on a DEV SH cluster I just installed the app and I see this warning and error.
During migration I got the below errors:

[3] delete deprecated properties [jdbcUrlFormat,jdbcUrlSSLFormat] from conf file db_connections
[4] update db_connections.conf, stanza SPOTFIRE60_DEV
customizedJdbcUrl=jdbc:oracle:thin:@//abcd.com:1521/ST06D1M

Performing action [3/59]: |███-----------------------------------------------| 5.1% Done!
failed to execute action 3, cause:HTTP 400 Bad Request --
In handler 'conf-db_connections': Object id=SPOTFIRE60_DEV cannot be deleted in config=db_connections.

How do I rectify these errors? I Believe its not taking the customized.java.path in commands.conf ,.

Error: Error in 'dbxquery' command: Could not find file: 'customized.java.path'

alt text

Tags (1)
0 Karma

dshpritz
SplunkTrust
SplunkTrust

The solution that I found was to install DB Connect on the deployer as well. This is not currently called out in the documentation.

0 Karma

vicvaughan
Explorer

I am also having this issue after going to dbconnect 3.

Added java_home path to splunk-launch.conf, but still having issues with some of our connections.

Are there any new answers here?

0 Karma

isreis
Explorer

I did not work with this new version yet. My previous experience was on DB Connect V2 running on Windows. Please try to do not migrate your current version.

  • Do a backup from your current db connect configuration(try to rename to a new name)
  • Install the new DB connect version from scratch
  • Apply the existing configuration that you have been done by the old version
  • Restart the splunk service
  • Check if splunk is able to connect into the database

When I migrated from DB Connect V1 to DB Connect V2xxx, I faced a lot of issues, specially with the path to determine where the java application is located, so for this reason I do not migrate and I just installed from the scratch.

I hope these steps assist you to fix the issues.

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...