Ask Questions and Find Answers
Important:
Ask is now read-only. You can review any existing questions and answers, but not add anything new.
But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:
discuss.liferay.com
RE: SAMLSP* database entries in 6.2
Hi everybody,
We're doing a migration from 6.2 to 7.2 and in the original db, there are tens of GB's of SAMLSP* (samlspauthrequest, session entries etc.) entries.
They've never purged those entries, so they go back years..
I've notices that the saml plugin has been introduced around the 6.1 time. The javadocs only have classes for saml cleanup in the dxp time.
Before upgrading, I want to delete those useless entries from the db.
Is it just as easy as deleting those entries via sql commands, or is there a more Liferay way, to do this via a groovy script?
I ask this, because I can't seem to find the 6.2 classes responsible for this in the javadocs.
Thanks and hope everyone is doing well!
Sincerely,
Yannik
We're doing a migration from 6.2 to 7.2 and in the original db, there are tens of GB's of SAMLSP* (samlspauthrequest, session entries etc.) entries.
They've never purged those entries, so they go back years..
I've notices that the saml plugin has been introduced around the 6.1 time. The javadocs only have classes for saml cleanup in the dxp time.
Before upgrading, I want to delete those useless entries from the db.
Is it just as easy as deleting those entries via sql commands, or is there a more Liferay way, to do this via a groovy script?
I ask this, because I can't seem to find the 6.2 classes responsible for this in the javadocs.
Thanks and hope everyone is doing well!
Sincerely,
Yannik
Hi Yannik,
Can you specify the table where those entries are stored?
Thanks
Can you specify the table where those entries are stored?
Thanks
Hi Alberto,
SamlSpAuthRequest (+- 20 million rows), SamlSpMessage (+- 17 million rows), SamlSpSession (+- 3.5 million rows).
SamlSpAuthRequest (+- 20 million rows), SamlSpMessage (+- 17 million rows), SamlSpSession (+- 3.5 million rows).
Copyright © 2025 Liferay, Inc
• Privacy Policy
Powered by Liferay™