Grouper Users - Open Discussion List

[Chris Hyzer <>]

No problem.  Good luck figuring out the server...  thanks, Chris

########

Thanks Chris for your insight. Seems like a problem with the server, ran the jdbc program on it and still have the same problem.

-------- Original message --------
From: "Doppala, Karthik" <> 
Date: 09/23/2014  5:58 PM  (GMT-05:00) 
To: Chris Hyzer <> 
Cc:  
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.

 

From: Chris Hyzer [mailto:]
Sent: Tuesday, September 23, 2014 2:37 PM
To: Doppala, Karthik;
Subject: RE: Grouper-Loader and secured DB connection

 

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)

 

Thanks,

Chris

 

From: Doppala, Karthik []
Sent: Tuesday, September 23, 2014 5:34 PM
To: Chris Hyzer;
Subject: RE: Grouper-Loader and secured DB connection

 

Hi Chris,

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

 

Thanks,

Karthik

 

From: Chris Hyzer []
Sent: Tuesday, September 23, 2014 2:22 PM
To: Doppala, Karthik;
Subject: RE: Grouper-Loader and secured DB connection

 

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)?

 

Thanks,

Chris

 

From: [] On Behalf Of Doppala, Karthik
Sent: Tuesday, September 23, 2014 5:12 PM
To:
Subject: [grouper-users] Grouper-Loader and secured DB connection

 

Hi All,

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?

 

Thanks,

Karthik