OAuth login feature merged, SQL script to run

[Philip Durbin]

https://github.com/IQSS/dataverse/pull/3539 has been merged which means once you pull the latest you should run the following SQL script*:

DELETE FROM authenticationproviderrow where id = 'echo-simple';
DELETE FROM authenticationproviderrow where id = 'echo-dignified';

This deletes some cruft now that we're using the authenticationproviderrow table in earnest for OAuth and Shibboleth.

If you don't delete these rows, Dataverse will still work but you'll probably see weird errors like this: Cannot find authentication provider factory with alias 'Echo' edu.harvard.iq.dataverse.authorization.exceptions.AuthenticationProviderFactoryNotFoundException: Can't find AuthenticationProviderFactory with an alias 'Echo'

You'll also notice that the Log In page has changed. We've dubbed this a "scalable login page" because it can support an arbitrary number of authentication providers.

I've also updated the dev guide for anyone who'd like to hack on the remote auth feature (Shib and OAuth): https://github.com/IQSS/dataverse/blob/c8a968c3246a634d699a76c9a7f0e9619879ad3e/doc/sphinx-guides/source/developers/dev-environment.rst#shibboleth-and-oauth . If you've like to get a grounding of all the changes made in the pull request, this issue has most of the details: https://github.com/IQSS/dataverse/issues/3338

We deferred some work to expedite the merge, but these related issues I opened may be of interest:

- Improve consistency of various remote auth options (Shibboleth vs. OAuth) - https://github.com/IQSS/dataverse/issues/3486
- Permit multiple login options to the same Dataverse account - https://github.com/IQSS/dataverse/issues/3487

Please let me know if you have any questions.

Happy hacking!

Phil

* https://github.com/IQSS/dataverse/blob/82d09e04ac22d027c8a646569b15e900214ee37a/scripts/database/upgrades/upgrade_v4.6_to_v4.6.1.sql

--

Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin