User Tools

Site Tools


installation:04-ms-sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
installation:04-ms-sql [2020/02/13 16:15]
mpospisek created
installation:04-ms-sql [2020/03/25 21:16] (current)
mpospisek
Line 1: Line 1:
 ====== MS SQL Database ====== ====== MS SQL Database ======
 +
 +===== Overview =====
  
 If you want to use MS SQL database instead of default PostgreSQL, you need to change the following modules in default installation: If you want to use MS SQL database instead of default PostgreSQL, you need to change the following modules in default installation:
   * AIM.war   * AIM.war
-  * proof-code-admin +  * proof-code-admin.war 
-  * proof-code-user  +  * proof-code-user.war  
-  * proof-form-admin  +  * proof-form-admin.war  
-  * proof-form-user +  * proof-form-user.war 
-  * aducid-useradmin+  * aducid-useradmin.war
   * ADUCID.properties   * ADUCID.properties
-All modified files (except ADUCID.properties, here you need to are already prepared on distribution DVD in the /root/mssql directory of the virtual machine.+All modified files (except ADUCID.properties, where you need to enter your MSSQL DB hostname) **are already prepared on distribution DVD** in the /root/mssql directory of the virtual machine.
  
 +===== List of modifications =====
  
-AIM.war +==== AIM.war ====
-V /opt/tomcat/webapps/AIM/WEB-INF přejmenovat spring-resources.xml_mssql na spring-resources.xml+
  
-Provider*.war+In the directory /opt/tomcat/webapps/AIM/WEB-INF, the file spring-resources.xml_mssql has been renamed to spring-resources.xml
  
-Upravíme provider-shared-4.1.0.RC1.jar a vyměníme ho v těchto .war (adresář WEB-INF/lib)+==== Other .war files ====
  
-    proof-code-admin  +In the directory WEB-INF/lib, the file provider-shared-*.jar has been modified.
-    proof-code-user  +
-    proof-form-admin  +
-    proof-form-user +
-    aducid-useradmin+
  
-Úprava provider-shared-*.jar: Soubor dispatcher-servlet-provider-shared.xml_mssql přejmenujeme na dispatcher-servlet-provider-shared.xml+This file contains several files named dispatcher-servlet-provider-shared.xml*.  
 +The file dispatcher-servlet-provider-shared.xml_mssql was renamed to dispatcher-servlet-provider-shared.xml
  
  
-ADUCID.properties+==== ADUCID.properties ====
  
-Do ADUCID.properties se dává pouze druhá polovina řetězce pro připojení do DB - v případě MS SQL tedy //[hostname];databaseName=aim;. V konfiguraci je druhá polovina - jdbc:sqlserver:.+You need to change syntax of database specification (default is commented with #)  
 +<sxh bash> 
 +#DB_AIM_NAME=aim 
 +DB_AIM_NAME=//[hostname];databaseName=aim; 
 +</sxh>
  
 +<sxh bash>
 +#DB_PROVIDER_NAME=provider
 +DB_PROVIDER_NAME=//[hostname];databaseName=provider;
 +</sxh>
  
 +[<>
  
    
installation/04-ms-sql.1581610502.txt.gz · Last modified: 2020/02/13 16:15 by mpospisek