malavolti / HOWTO-Install-and-Configure-Shibboleth-Identity-Provider

Inside this repository I will try to collect some simple step-by-step guides that permit people the installation and configuration a Shibboleth Identity Provider.
31 stars 23 forks source link

User Insert Not Compatible with 5.7 #5

Open anton-dealmeida opened 7 years ago

anton-dealmeida commented 7 years ago

https://github.com/malavolti/HOWTO-Install-and-Configure-Shibboleth-Identity-Provider/blob/683ff97599af1d69a34839789481365c17ab30b4/shibboleth-db.sql#L39

With the release of MySQL 5.7 the Password column was removed and is now known as authentication_string. There are also a lot of new required columns, ssl_cipher, x509_issuer, x509_subject, etc... Is this the best way to add the user?

malavolti commented 7 years ago

Thank you!

What changes do you suggest to do the same in the right way?