Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Grouper name length limits?

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper name length limits?


Chronological Thread 
  • From: Rory Larson <>
  • To: "Hyzer, Chris" <>, "" <>
  • Subject: [grouper-users] RE: Grouper name length limits?
  • Date: Mon, 14 May 2018 22:48:59 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:R2x3FRahNUxWHYvn1Gl1S0j/LSx+4OfEezUN459isYplN5qZpsy+ZB7h7PlgxGXEQZ/co6odzbaO6Oa4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahb75+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+v6bpgRh31hycdLzM38H/ZhNFsjKxVoxyhqR5ww4/Ib46aL/d+ZL/Rcc8ASGZdQspcVSpMCZ68YYsVCOoBOP5VoZX6p1sUrRq1GA+iC/n1yj9TgX/227Ax3uM7EQHCxgMgBckOsHPSrNnoL6oSTOa1zK3SwTrdcvxWxC7w5Y7VeR4vpvGMWKh/ccvXyUQ3GAPFlE2QpZX7MzyIy+gAsHSX4uh4WeKujW4ntx9+oiKpxsgylonFmJgZxU7Z+iVk2Io1Pce4SEl8Yd6qCJtQsCCaN41qQs84X25ovyM6x7sbspC4ZCgH0IoryATDZ/CadoWE/w/vWPuULDd2i39pZK6zihOw/Ee+xeDxVcy53VNUoiZZjNXArm0B2wLX58SdTvZw8F2t1SuA2gzP8O1IPFw4mKTDJ54v3LE9lYYfvEHGEyDohUr7g6Gbe0A59eWq9+vrfLDrqoKCOIBukA7zN7ghl827DOsmNAUFQnKV9v6m1LL5+E30WLVKgeMykqneqJ3UPdgWqKmlDwJby4ou9Q+xAyq/3NQfhnYIMkhJeBWaj4j1IF7OJ+34DfGijFi2iDdr3ffGPqH/DZrRMnjDkbDhfbBn505b1Qoz0dRf55VTCrECOv78RkjxtNnAAh84NQy73frnBc1j2owERW6DH6qUPL7PvVOV4+8vLeaBaJMJtDv4KfUq+fHjgHw8lFIYY6WlwYUbZGi9Hvt8IkWZZXTsgs0GEWcPpgc+Vujqh0eYUT5IYHayWb8w6yomCIKgCYfPXJ6ij6Gc3CujBJ1ZenhGCkyQEXfvb4iEVO0MaCWPIs95jDMET6GtS5I61R6wrg/60KFqLu7V+i0DqZLjz8Z56/fSlRE06Tx7Ed6d02eTQGFogG8EXSE5071ioR819lDWm4hpkfFCUZR45+lISU1yYZvXz/1oBsraWxnKOMqRRVCgBNiqHGd1Bpg+2dgTe0tnXsi5gwrY9yusH7IPkbGXXto5/r+Wlyz+PcFg03vckbQ6gkM9aspJKWC8gKNjrU7eC5OfwGuDkKP/T6MGzWbp/X2YymzG6FtcWRRrVqOcdW0ZYg3bocmvtRCKdKOnFblyalgJ8sWFMKYfMtA=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

Wonderful!  Thanks so much, Chris!  We’ll take a look at this tomorrow.

 

Best,

Rory

 

 

From: Hyzer, Chris <>
Sent: Monday, May 14, 2018 3:32 PM
To: Rory Larson <>;
Subject: RE: Grouper name length limits?

 

I made a patch for you.  Get 2.3 api #105.

 

You also need to change your database 3 table columns (which DB are you?)   If you are not a DB person maybe your DBA could do this for you.

 

grouper_stems: name, alternate_name, display_name: to be 1024 width

 

There is a mysql example in the jira:

 

https://bugs.internet2.edu/jira/browse/GRP-1807

 

And you need to add this to the grouper.properties

 

grouper.stemName.maxSize = 1024

 

 

thanks

Chris

 

ps. we will fix this in 2.5 in the DDL

mysql is a little more complicated than oracle/postgres since there are index length constraints.  Note I had to limit the indexes to 255 and make the name one not unique (since it doesn’t do much good if the first 255 have to be unique.  Also the parent_stem and extension being unique is all we need.

 

From: Rory Larson []
Sent: Friday, May 11, 2018 9:49 PM
To: Hyzer, Chris <>;
Subject: RE: Grouper name length limits?

 

This is only a demo for now, and certainly I can abbreviate if necessary.  But having to do so seems to defeat the purpose of having a full name.  The project is to build an institutional hierarchy from the top university level down to the bottom-level department or reference group eight or ten levels deep, and some offices/departments/programs tend to have rather lengthy names, since there is no common English word by which to call them.  But I would imagine that political sensitivities might be ruffled if I start chopping the names of people’s favorite departments down to something reasonable.

 

It’s not a huge issue at the moment, but I did want to get a feel for where things stood on this.  Is that a varchar-256 limitation that can’t be made bigger because it would double the size of the database?

 

Thanks,

Rory

 

 

From: Hyzer, Chris <>
Sent: Friday, May 11, 2018 7:29 PM
To: Rory Larson <>;
Subject: RE: Grouper name length limits?

 

I Created a 2.2 extension longer than 50…  but yes looks like there is a full name constraint of 256... can you abbreviate somehow?

 

test:x123456789012345678901234567890123456789012345678901234567890:y123456789012345678901234567890123456789012345678901234567890:z123456789012345678901234567890123456789012345678901234567890:a123456789012345678901234567890123456789012345678901234567890

 

 

From: [] On Behalf Of Rory Larson
Sent: Friday, May 11, 2018 7:26 PM
To:
Subject: [grouper-users] Grouper name length limits?

 

Hello,

 

Using the UI for Grouper 2.2, I'm trying to mock up a fairly deep tree of administrative hierarchy, and it looks like I'm running into limits on name length.  For an immediate folder name, it seems that the entry box cuts you off at 50 characters.  For the fully scoped name, I seem to be hitting a limit of about 250 or 256 characters, beyond which it simply fails to create the folder and gives an error message.

 

I was wondering if anyone would care to comment on this.  Is this an intentional constraint to meet a resource trade-off?  Is it a limit that can be modified locally, or is it baked into Grouper?  Will these limits continue into future versions of Grouper?

 

Thanks,

Rory

 




Archive powered by MHonArc 2.6.19.

Top of Page