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:
- Import Adeptia Suite public certificate to Adeptia Suite Truststore.
- 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.- Open the browser and type the URL to access Adeptia Suite.
- Click > More tools > Developer tools.
- Click Security tab.
- Click View Certificate.
- On the Certificate window, on the Details tab, click Copy to File.
- Click Next to start exporting the certificate.
- Choose DER encoded binary X.509 (.CER) and click Next.
- Specify the location to save the exported file and click Next.
- Click Finish to export. A dialog box appears confirming the export process have been completed successfully.
- Click OK to exit from the wizard.
- Import Adeptia Suite certificate into Adeptia Suite Truststore
- Open Command Prompt (press Win + R and type cmd).
- Go to the directory where JRE is installed (for example, C:/Program Files/Java/jre8/bin).
- Run the following Keytool command 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
- Export Public Key
- Apply the Frevvo patch by following the same steps applied in Adeptia Suite patch.
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";
- Go to .../<AdeptiaInstallFolder>/ServerKernel/etc folder.
- Open server-configure.properties file in the Text Editor.
In the Rich Forms group,- Type https in the abpm.frevvo.httpScheme property to access Web Forms in a secure mode.
- 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. - 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>.
- In Frevvo Database Configuration subgroup, provide the details of the database you are using in the properties.
Save the file. - Go to the extracted frevvo patch folder.
- Open jetty.xml.
- Copy the highlighted code from the file.
- Open jetty.xml file from the .../<AdeptiaInstallFolder>/ServerKernal/etc/jetty folder.
- Paste the copied code into the file.
- Save the file.
- Go to .../<AdeptiaInstallFolder>/ServerKernal/etc/jetty/contexts folder.
- Rename richForms.xml_disable file to richForms.xml.
- Restart Kernel and WebRunner. This will create Frevvo related tables in the newly created database.
- Open the browser and type the URL in the format:
<protocol_name>://<IPaddress>:<Port_No>/frevvo
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.
For example, http://192.168.1.1:8080/frevvo. On the Update License screen, type the license key. Contact Adeptia Support Team for the license key.
- Login to Frevvo using following default credentials and create a tenant:
Username: admin@d
Password: admin- On the Manage server screen, click Manage Tenants.
- On the Tenants screen, click .
- On the Add New Tenant screen, type adeptia in the Tenant Id, Admin User Id, Tenant Name, Admin User Password, Tenant Description, and Re-enter Admin User Password.
- Type support@adeptia.com in the Admin User Email Address.
- Click Submit. This creates your tenant.
- Logout from Frevvo.
- On the Manage server screen, click Manage Tenants.
- Now login to Frevvo using following credentials and deploy Adeptia Template Rich Form.
Username: adeptia@adeptia
Password: adeptia- Click Home.
- Click Upload.
- On the Upload Application screen, click Choose File, and upload AdeptiaTemplate_app.zip file from the folder where you have extracted Frevvo patch.
- Click Upload.
This deploys Adeptia Template Rich Form.
- Click Home.
Verifying Frevvo Upgrade
To verify Frevvo upgrade:
- Open the browser and type the URL in the format:
<protocol_name>://<IPaddress>:<Port_No>/frevvo
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. - Login to Frevvo using following credentials:
Username: adeptia@adeptia
Password: adeptia - Check the Adeptia Live Forms version displayed at the bottom of the screen. If it is 7.3.2 indicates your Frevvo version has been upgraded successfully.
Next Step