|
|
| (3 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | * 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>
| |
| − | see https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver<br>
| |
| − | ''Requires a Java Runtime Environment (JRE) 7.0. '''Using JRE 6.0 or lower will throw an exception'''.''<br>
| |
| − | 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<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>
| |
| − | * 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<br>
| |
| | | | |
| − | {| class="wikitable"
| |
| − | |+Project Progress
| |
| − | |-
| |
| − | |'''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
| |
| − | |-
| |
| − | |Document the Shibboleth install process as a new install needs to be run
| |
| − | |In Progress
| |
| − | |}
| |
