Post Deployment Steps for Adeptia Suite v2.7

This section is applicable only if you want to use Web Forms with Adeptia Connect. You need to configure the following to access Web Forms in Adeptia Connect:

Prerequisites:

Ensure that you have applied Adeptia Suite v2.7 patch.

To configure:

1. Import Adeptia Suite public certificate to Adeptia Suite Truststore. 
   1. Export Public Key 
      The steps to export the key varies from browser to browser. The following are the steps to export the public key in Google Chrome browser.
      1. Open the browser and type the https URL to access Adeptia Suite.
      2. Click  > More tools > Developer tools.
      3. Click Security tab. 
      4. Click View Certificate.
         
         
         
         
      5. On the Certificate window, on the Details tab, click Copy to File.
         
         
         
         
      6. Click Next to start exporting the certificate.
         
         
         
         
      7. Choose DER encoded binary X.509 (.CER) and click Next.
         
         
         
         
      8. Specify the location to save the exported file and click Next.
         
         
         
         
      9. Click Finish to export. A dialog box appears confirming the export process have been completed successfully.
      10. Click OK to exit from the wizard.
   2. Import Adeptia Suite certificate into Adeptia Suite Truststore
      1. Open Command Prompt (press Win + R and type cmd).
      2. Go to the directory where JRE is installed (for example, C:/Program Files/Java/jre8/bin).
      3. Run the following Keytoolcommand to import a certificate
         

         keytool.exe -import -trustcacerts -file <Path_of_SSL_Certificate> -alias <alias_name> -keystore <Path of Truststore file> -storepass changeit

         where,

                   <Path_of_SSL_Certificate> is the path of SSL certificate.

                   <Path of Truststore file> is the path of Adeptia Suite Truststore.

         For example, keytool.exe -import -trustcacerts -file "C:\Users\Administrator\Desktop\connect-adeptia-com.cer" -alias uat-adeptia-com -keystore "C:\Program Files\Apache Software Foundation\Tomcat 9.0\trustStore\cacerts" -storepass changeit
2. Apply the Frevvo patch by following the same steps applied in Adeptia Suite patch.

3. After applying the patch, create a new database with utf-8 character set. Following is the query to create a new database in MySQL:

   create database <database_name> default character set "utf8" default collate "utf8_unicode_ci";

4. Go to .../<AdeptiaInstallFolder>/ServerKernel/etc folder.
5. Open server-configure.properties file in the Text Editor.
   In the Rich Forms group, 
   
   1. Type https in the abpm.frevvo.httpScheme property to access Web Forms in a secure mode.
   2. Type the URL of the server hosting Adeptia Suite in the <param-value> parameter of the frevvo.internal.baseurl property. The format of the URL is: <protocol_name>://<ipaddress>:<port_no>.
      where,
                 <protocol_name> is the protocol you are using, for example, http or https.
                 <IPaddress> is the domain name or IP address of the server hosting Adeptia Suite.
                 <Port_No> is the port number of the server hosting Adeptia Suite.
   3. Type the URL of the server hosting Tomcat in the <param-value> parameter of the frevvo.forms.server.external.url property. The format of the URL is: <protocol_name>://<ipaddress>:<port_no>.
      
      
      
      

   4. In Frevvo Database Configuration subgroup, provide the details of the database you are using in the properties.

      Property Name	Description
      abpm.frevvo.db.driver	Name of the Frevvo database driver URL. MySQL: com.mysql.jdbc.Driver SQL-Server: com.microsoft.sqlserver.jdbc.SQLServerDriver
      abpm.frevvo.db.url	Name of the Frevvo database connection URL. The format of the URL is: jdbc:<Database_Name>://<IPaddress_on_which_Database_is_installed>:<Database_Port_No>/<Database_Name_Created_in_Step3> MySQL: jdbc:mysql://192.168.1.2:3306/frevvoDB SQL-Server: jdbc:sqlserver://192.168.1.1:143;databaseName=frevvodatabase;
      abpm.frevvo.db.username	Database username you are using.
      abpm.frevvo.db.password	Password to access database.
      abpm.frevvo.dpType	Database you are using, for example, MySQL, SQL-Server.

      
      
      
      

   In the Web Server category, in the abpm.webserver.public.address property, type the IP address of the server hosting Adeptia Suite. 
   
   
   
   Save the file.
6. Go to the extracted frevvo patch folder.
   1. Open jetty.xml.
   2. Copy the highlighted code from the file.
      
      
      
      
   3. Open jetty.xml file from the .../<AdeptiaInstallFolder>/ServerKernal/etc/jetty folder.
   4. Replace the copied code in the file.
   5. Save the file.
7. Go to .../<AdeptiaInstallFolder>/ServerKernal/etc/jetty/contexts folder.
8. Rename richForms.xml_disable file to richForms.xml.
9. Restart Kernel and WebRunner. This will create Frevvo related tables in the newly created database.

Next Step 

Verifying Patch