Truncation of Large IDP Metadata in SAML IdP Metadata-field

[hogemo]

Debug mode

• I have enabled debug mode
• I have read checked the Common Issues page

Describe the bug

I'm encountering an issue with the SAML IdP Metadata-field when handling large IDP metadata files. Despite the metadata file from our IDP provider being valid, it's getting truncated to around 65,000 characters when I attempt to insert it into the SAML IdP Metadata-field. This behavior persists regardless of whether I directly paste the XML data or insert the URL linking to it. This truncation causes information loss and hinders proper function.

Possible solutions would be to increase the character limit of the SAML IdP Metadata-field.

Any assistance or suggestions on how to handle large IDP metadata files without truncation would be greatly appreciated.
Thank you for your time and attention.

Reproduction steps

1. Paste or insert URL to IDP metadata
2. Save (everything look good - green success message)
3. Looking back into the metadata text-field it is truncated, and when pressing save again, it is not possible because the xml is corrupt.
   ...

Expected behavior

No truncating

Screenshots

No response

Snipe-IT Version

v6.1.1-pre - build 10653 (master)

Operating System

Debian 11

Web Server

Apache

PHP Version

7.4.30

Operating System

No response

Browser

No response

Version

No response

Device

No response

Operating System

No response

Browser

No response

Version

No response

Error messages

Below the metadata-field it says "The Metadata format is invalid." No error message found in debugger, nor in laravel.log.

Additional context

No response

[welcome]

👋 Thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it. We get a lot of issues on this repo, so please be patient and we will get back to you as soon as we can.

[uberbrady]

I suspect the right solution here is to change to a larger TEXT blob format, probably with a migration.

[uberbrady]

MEDIUMTEXT ought to do it - that'll let you store up to 16MB of IdP metadata. If you want more than that, you're gonna have a bad time.

[hogemo]

MEDIUMTEXT ought to do it - that'll let you store up to 16MB of IdP metadata. If you want more than that, you're gonna have a bad time.

Hmm okay, how would i do that? In the db?

[snipe]

@paegelow give me a few - I'll add a migration and then you can run the upgrade.

[snipe]

You should be able to run the upgrade script now and the field should be changed to a MEDIUMTEXT field

[hogemo]

You should be able to run the upgrade script now and the field should be changed to a MEDIUMTEXT field

It worked! Really appreciate it!