Splunk DB Connect: How to resolve "Failed to initialize pool: Login failed for user" errors while connecting to database?

[jgorman_THG]

HI,

I have Splunk DB Connect install on a Splunk heavy forwarder. I am having trouble connecting to the database. The person who setup the DB has confirmed that the username and password are correct. I've used both the MS generic drive and the jDTS drive.

Any tips or ideas of what to look at would be very helpful.

I'm getting the following error:

2016-12-01T10:35:23-0500 [WARNING] [health_logger.py], line 162: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Login failed for user 'MCEPO'. ClientConnectionId:52e2159e-2b3b-440a-a797-2320d4e549f7 
Traceback (most recent call last): 
File "C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\dbx2\health_logger.py", line 160, in do_log 
return func(*args, **kwargs) 
File "C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\rh_connections.py", line 262, in get_connection_status 
raise Exception(msg) 
Exception: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Login failed for user 'MCEPO'. ClientConnectionId:52e2159e-2b3b-440a-a797-2320d4e549f7 
2016-12-01T10:35:23-0500 [ERROR] [rh_connections.py], line 230: exception com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Login failed for user 'MCEPO'. ClientConnectionId:52e2159e-2b3b-440a-a797-2320d4e549f7 
Traceback (most recent call last): 
File "C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\rh_connections.py", line 226, in handleStatus 
status = self.get_connection_status(dbx2, fdb) 
File "C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\dbx2\health_logger.py", line 283, in wrapper 
return get_mdc(MDC_LOGGER).do_log(func, *args, **kwargs) 
File "C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\dbx2\health_logger.py", line 160, in do_log 
return func(*args, **kwargs) 
File "C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\rh_connections.py", line 262, in get_connection_status 
raise Exception(msg)

[GregZillgitt]

Is MCEPO a local service account or is it AD/LDAP?

Have you tried connecting with a database browser like Toad or DBVisualizer? I usually test that way before I configure Splunk, since it's generally easier to troubleshoot connection problems using a purpose-built tool.

[marcoscala]

It seems there's a LOGIN FAILED issue here.

Are Username and password correct?

[nekbote]

what's the dB connect version? also can you add screen shot of the erorr you see...we use it for jt and Oracle ....make sure you have the required jars copied ...

[nekbote]

i see you are using dbconnect 2, did not notice earlier as i was browsing over phone..were you able to connect to this database using any of the thin client like sql developer/toad?, if yes then you may want to check if the right jars copied , connection details are setup correctly