Difference between revisions of "Implementing Devolved Constraints"

From MyWiki
Jump to: navigation, search
Line 1: Line 1:
# Download the jdbc connector for Microsoft SQL Server
+
. 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 :<br>
 
The oldish version of java on the server might cause a compatibility issue as the java version is 6 :<br>
 
see https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver<br>
 
see https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver<br>
Line 6: Line 6:
 
But it looks like it's no longer available "We're sorry, this download is no longer available."<br>
 
But it looks like it's no longer available "We're sorry, this download is no longer available."<br>
 
Managed to download from here :  http://www.mediafire.com/file/3ycmaelhoot/sqljdbc4.jar<br>
 
Managed to download from here :  http://www.mediafire.com/file/3ycmaelhoot/sqljdbc4.jar<br>
# Install the connector in the "lib" folder in the Tomcat Shibboleth application
+
. Install the connector in the "lib" folder in the Tomcat Shibboleth application
# Modify the CLASSPATH variable to include the connector
+
. Modify the CLASSPATH variable to include the connector
# Perform a re-install of Shibboleth using the install script
+
. Perform a re-install of Shibboleth using the install script
# Edit the Shibboleth config files
+
. Edit the Shibboleth config files
 
Useful link - https://wiki.shibboleth.net/confluence/display/SHIB2/ResolverRDBMSDataConnector<br>
 
Useful link - https://wiki.shibboleth.net/confluence/display/SHIB2/ResolverRDBMSDataConnector<br>

Revision as of 16:55, 1 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
. 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