Username limited to 32 characters

Hi All,

Is there a limit on username length in Spark?

How can I change the max username length to 128 characters?

Thanks!

Rob

Hi,

64 characters should not be a problem if you are using the current Spark and Wildfire version. I have no idea if Spark limits the length to 64 characters, in Wildfire you should modify these columns:

ALTER TABLE jiveUser ALTER COLUMN username VARCHAR(128);

ALTER TABLE jiveUserProp ALTER COLUMN username VARCHAR(128);

ALTER TABLE jivePrivate ALTER COLUMN username VARCHAR(128);

ALTER TABLE jiveOffline ALTER COLUMN username VARCHAR(128);

ALTER TABLE jiveRoster ALTER COLUMN username VARCHAR(128);

ALTER TABLE jiveVCard ALTER COLUMN username VARCHAR(128);

ALTER TABLE jivePrivacyList ALTER COLUMN username VARCHAR(128);

ALTER TABLE jiveSASLAuthorized ALTER COLUMN username VARCHAR(128);

LG

Hi Rob,

there’'s no real limit in Spark 1.1.4, I did create accounts with 128 and with 256 characters:

LG