Implementing Devolved Constraints - Revision history

George2: Blanked the page

2018-02-07T09:37:02Z

Blanked the page

George2 at 13:32, 6 February 2018

2018-02-06T13:32:05Z

George2 at 13:31, 6 February 2018

2018-02-06T13:31:21Z

George2 at 13:30, 6 February 2018

2018-02-06T13:30:42Z

George2 at 14:23, 5 February 2018

2018-02-05T14:23:23Z

George2 at 14:21, 5 February 2018

2018-02-05T14:21:44Z

George2 at 13:49, 5 February 2018

2018-02-05T13:49:59Z

George2 at 11:54, 5 February 2018

2018-02-05T11:54:53Z

George2 at 11:54, 5 February 2018

2018-02-05T11:54:24Z

George2 at 11:49, 5 February 2018

2018-02-05T11:49:18Z

← Older revision		Revision as of 09:37, 7 February 2018
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 ( on the test server )~~
−	\|-
−	~~\|'''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~~
−	\|}

@@ Line 34: / Line 34: @@
 |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
 |}

@@ Line 14: / Line 14: @@
 {| class="wikitable"
-|+Project Progress
+|+Project Progress ( on the test server )
 |-
 |'''Task'''

@@ Line 31: / Line 31: @@
 |Complete
 |-
-|Document the Shibboleth install process as a new install needs to be run
+|Review the Shibboleth install process as a new install needs to be run
-|In Progress
+|Complete
 |}

@@ Line 30: / Line 30: @@
 |Test jdbc connection from Shibboleth test server to database
 |Complete
 |}

@@ Line 25: / Line 25: @@
 |Done for test db [[ Example java code here ]]
 |-
-|Test the connection to live db
+|Test the connection to live db from test machine
 |In progress
 |-