Difference between revisions of "Implementing Devolved Constraints"
| Line 34: | Line 34: | ||
|Complete | |Complete | ||
|- | |- | ||
| − | |Add the jdbc connector to the lib folder and re-install | + | |Add the jdbc connector to the lib folder and re-run install script |
|In progress | |In progress | ||
|} | |} | ||
Revision as of 13:32, 6 February 2018
- Download the jdbc connector for Microsoft SQL Server
The oldish version of java on the server might cause a compatibility issue as the java version is 6 :
see https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver
Requires a Java Runtime Environment (JRE) 7.0. Using JRE 6.0 or lower will throw an exception.
Looks like we need version 4 of the jdbc connector : https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix#java-and-jdbc-specification-support
But it looks like it's no longer available "We're sorry, this download is no longer available."
Managed to download from here : http://www.mediafire.com/file/3ycmaelhoot/sqljdbc4.jar
- Test the connection to the target database using a simple java app
- Install the connector in the "lib" folder in the Tomcat Shibboleth application
- Modify the CLASSPATH variable to include the connector
- Perform a re-install of Shibboleth using the install script
- Edit the Shibboleth config files
Useful link - https://wiki.shibboleth.net/confluence/display/SHIB2/ResolverRDBMSDataConnector
| Task | Status |
| Source the jdbc connector | Done |
| Test the database connection using Java class | Done for test db Example java code here |
| Test the connection to live db from test machine | Complete |
| Test jdbc connection from Shibboleth test server to database | Complete |
| Review the Shibboleth install process as a new install needs to be run | Complete |
| Add the jdbc connector to the lib folder and re-run install script | In progress |
