Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] migrating from jdbc1 subject source to jdbc2 subject source

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] migrating from jdbc1 subject source to jdbc2 subject source


Chronological Thread 
  • From: "Gettes, Michael" <>
  • To: Chris Hyzer <>
  • Cc: " Mailing List" <>
  • Subject: Re: [grouper-users] migrating from jdbc1 subject source to jdbc2 subject source
  • Date: Thu, 17 May 2018 11:48:49 +0000
  • Accept-language: en-US
  • Ironport-phdr: 9a23:F2VHdhFYpFrK0HbQW4IX0Z1GYnF86YWxBRYc798ds5kLTJ76p8W5bnLW6fgltlLVR4KTs6sC17KN9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCazbL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCM+ZXrY7zp1oSohSxHgSjHv/jyjpSi3/2waE30eIsGhzG0gw6GNIOtWzZoNv0OqgMTeC10LfHzS7bY/hL3jn96ZTHchA7rv6SWbJ8f9faxE4gFwzbklWQtZLqPyiO2+QQvWib6/BsWvyyhG46sgx8pCWkyMkrionMnI0Vy1bE+D18wIY0Kt24UlR0YcKlEJtWuCGWLpV6TdgsQ2FyvyY6z6QKtYCgcygWyJQo2QfTZ+KcfIiH+BLjU/uRIS9mi3J/Yb6zmQ298Uq9xeLnSsa4yUhGoTFektnRrX8N1QLc5dSbSvdk4Euuwi2P1wfO6uFePU87i7PXJ4A6zb4skZofqFrPETTqmEX2kqCab1so9fOq6+v6ebrpuoGQO5Zqhg7lKaQuh9ewAeYmPQcSQ2iX4Pqw26b4/U3+XbVKlOE5nbfBvJDbI8QburC2AxVT0ok99xazES2q38oFknkaNF5FYAiHj4/uO1HAOPD4Cva/g1KwkDtx2//GObjhD5PQJXbAiLfsZatx51BfxQYp09xT+ZBZBqsDLf/8QEP9qcLUAx8hPwCp3+rrEttw24IEVW6SBqKUM7nevUKJ6+43LemDeowYtCr4JvUg5PPjiWM1lkMYcKa1xpQYcnC1E/F4L0ibenXgnNIMHnoRsQYgTuHnjkCJXyRJaHaoRa084yk2CIK4AofHQYCgmKeB3CKnHp1OfGxGF16MEXPye4qaRvgMdTqeIs5nkjMaSbisU5It2Q+tuQPg1bZrMOjZ9jcauJ/sztR5+vPfmBEq+TxxFcud0mWNT29unmMPQj87xK9/rlJhylefz6d4mOdVFcFd5/NNSAs1K4PTz/FiB9DoRg3BZsuJSEqhQti+DjExVNUxw8IWY0ljAdWulw3D3zG0DL8PjLyGH5g08qPH33jtPMZx1WzK1Kgnj1k6XMRPL2umibBj9wTNHYLGjViWl7v5PZgbiQXN7maYhUqfrkxCGFp1WqXUT30FTkrNppLk/k7ESfmjBalxYSVbzsvXYIRHdsHklhEOYfboON3TZyj5z2i9GQqF3ZuRYo6sdmkAinaOQHMYmhweqC7VfTM1AT2s9ieHVGRj

Hi Chris,

Firstly, a big thank you for your assistance the last couple of weeks helping to work these issues through and for supplying this write-up for the community to benefit from what we’ve learned.  This is working like a charm for us now as we hopefully progress with a Grouper deployment at UF.

Secondly, I have a question regarding the write-up.  You specifically annotate next to “netId” with "blank for external users”.   To me, an external user would have a different eduPersonPrincipalName form from the rest of the population and would be in a subject source and will be unique from all those in the other subject sources per Grouper rules of subject sources.  So, Could you please explain what you mean with that annotation so I might benefit from you and your team’s experiences?

As I noted to you privately, given the issues of the last couple of weeks I believe it is time to deprecate and remove the original Grouper source adapter since with this mechanism people should be able to, if not easily, migrate away from it fairly quickly.  I’m sure there are people out there doing weird things, there always are, but I think it would be good to do so especially as I feel so badly about the amount of time I helped to waste of you, Chris Hubing, and Paul Caskey.  I guess the good news is we found there are problems with the original adapter and an effective workaround.

Thank you - again - for all you do.  (And a huge thank you to Chris Hubing and Paul Caskey, and John Gasper, who are doing awesome work with the TIER Grouper packaging).

/mrg

On May 16, 2018, at 3:24 PM, Hyzer, Chris <> wrote:

If you use the JDBC1 subject source, do you have any issues with it?  If you are going to use a new SQL source, I recommend the JDBC2 source J
 
We have some issues at Florida, and here is a wiki on converting from JDBC1 to JDBC2, and it solved their issues (the pool in JDBC did not handle terminated oracle connections properly and didn’t log this either).  Note, this is a separate pool than if your subject source uses the same database connection as the Grouper registry itself.
 
 
Thanks
Chris




Archive powered by MHonArc 2.6.19.

Top of Page