Subject: Grouper Users - Open Discussion List
[grouper-users] RE: Grouper-Loader and secured DB connection
- From: Chris Hyzer <>
- To: "Doppala, Karthik" <>
- Cc: "" <>
- Subject: [grouper-users] RE: Grouper-Loader and secured DB connection
- Date: Wed, 24 Sep 2014 13:23:29 -0400
- Importance: normal
-------- Original message --------
From: "Doppala, Karthik" <>
Date: 09/23/2014 5:58 PM (GMT-05:00)
To: Chris Hyzer <>
Subject: RE: Grouper-Loader and secured DB connection
It does work , as I mentioned; I have other programs too that connect to this DB and never had a problem. This is the first time we are trying to configure loader with this DB.
Can you write a simple java class that connects with the same driver, connect string, credentials, etc?
e.g. something like this: http://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm (different query obviously)
Please find the information below. I don’t have a problem connecting to the same DB from other applications using the same credentials and everything. For that matter; we verified that the connection is being made on the DB and it is returned to the server where the loader is running. But the loader seems to be still waiting for the connection.
db.testXXX.user = userName
db. testXXX.pass = password
db. testXXX.url = "jdbc:jtds:sqlserver://url/dbName;ssl=required
db. testXXX.driver = net.sourceforge.jtds.jdbc.Driver
Can you send the sanitized properties file part? Can you telnet to the port or connect with a DB client from the machine with the same user/pass (or a simple program written in java or another language that selects a count from a table)?
I am trying a configure a DB connection in grouper-loader.properites file; which needs to be connected through ssl. I am not sure what the issue is but the loader just halts while trying to connect to this DB. We have checked the firewall on either side, ran tcpdump and we do see that the connection is being returned to the server but loader seems to be just waiting for the connection. Typically, if there is a problem with a database connection; the loader throws the exception and moves on during startup. I am able to connect to this database through other applications using the same jdbc driver. Am I missing something here?
- [grouper-users] RE: Grouper-Loader and secured DB connection, Chris Hyzer, 09/24/2014
Archive powered by MHonArc 2.6.16.