Difference between revisions of "Visimage3 Linux Connections for Fiserv Online Clients"

From Vital Soft Wiki
Jump to: navigation, search
Line 1: Line 1:
 
This page is still under development...
 
This page is still under development...
The Linux
+
=== What Databases Does the Linux Connection Use ===
 +
When you start server in Visimage using the Linux connection, you connect to AskPlus on a Linux server. AskPlus then opens the Spectrum databases (over the network) on the corresponding HP-UX server.  As before, Visimage3 has direct access to your most recent (live) and month-end (eom) databases.
 +
 
 +
What has changed is that AskPlus can no longer access '''files''' created on HP-UX.  Therefore any existing Visimage3 reports that use files created by Spectrum programs (pextract, d3307, etc.) must be modified.
 +
 
 +
=== Accessing Files Created by Spectrum Programs ===
 +
Some clients may have reports that require including unencrypted data.  Since Visimage3 cannot decrypt fields like SSN, the solution in the past was usually to have Fiserv run a pextract that included the ACCOUNT number and the decrypted SSN value in a delimited file.  In other scenarios, you may need access to values that are not stored in the database, like "loan payoff amount", or "loan delinquent amount."  Again, the solution for this was to request that Fiserv run the appropriate pextract (or similar program) to generate the required data in a CSV file.
 +
 
 +
Since AskPlus (running on Linux) can no longer open files on HP-UX, this solution no longer works.  For these reports, we are recommending that you convert the Visimage3 context that uses these files into AskPlus code that Fiserv can add to the existing job that generates the file.  With the added code, instead of just producing a file, the Fiserv job will create all of the needed output.
 +
 
 +
Contact our support department if you need help with making these changes.
 +
 
 +
=== Visimage3 Passwords ===
 +
The Visimage3 passwords are '''not''' shared between HP-UX and Linux.  It is likely that an Admin user will need to reset your password. If no Admin users are able to connect, contact Fiserv for assistance.
 +
 
=== Switching Existing Users from HP-UX to Linux ===
 
=== Switching Existing Users from HP-UX to Linux ===
It's extremely simple to update an existing user's stunnel configuration and switch them from HP-UX to Linux:
+
Modify the stunnel.conf file and update the "connect =" value to update an existing user's stunnel configuration and switch them from HP-UX to Linux:
  
Modify the stunnel.conf file and update the "connect =" value as shown below.
 
 
<pre>
 
<pre>
 
[VisImage Client]
 
[VisImage Client]
Line 16: Line 29:
 
'''Stop and restart the stunnel service.'''
 
'''Stop and restart the stunnel service.'''
  
 
+
=== Updating the Visimage3 Setup for Automated Tasks ===
<!-- This is a comment
+
Make the same changes as shown above for your users.   
 
+
* '''Do not''' change the '''name''' of the Visimage3 connection. This name is stored in the Task Scheduler and should never be changed.
=== Visimage3 Setup ===
+
* After updating stunnel.conf (and restarting stunnel), reset the Visimage3 password.
There are no changes to the basic setup of Visimage3.  A full (new) install requires completing the following steps:
 
* Install Visimage3
 
* Install stunnel: A special Fiserv installation of stunnel can be downloaded [https://vital-soft.com/?page_id=544&product=stunnel&release=current here].
 
* Install certificates issued in May 2024.  See additional steps here.
 
* Edit the stunnel.conf file as shown below.
 
=== Connecting to Spectrum Databases via Linux ===
 
In Q3/Q4 of 2024, Fiserv will require that all Visimage3 connections be made via a Linux server.  When the transition is complete, clients will no longer be able to connect directly to HP-UX as had been done previously.
 
 
 
Click here for more [[Visimage3 Linux Connections for Fiserv Online Clients|details]].
 
 
 
=== New Stunnel Certificates (May 2024) ===
 
Effective May 13, 2024, clients must install new certificate files which can be downloaded [https://vital-soft.com/?page_id=544&product=stunnel&release=current here].  Follow these steps to install the certificates:
 
<pre>
 
unzip the Stunnel_Certs_May_2024.zip file
 
copy stunnel.pem and certs.pem to C:/Program Files/stunnel/config
 
restart the stunnel service (or reboot your PC)
 
</pre>
 
These certificates must be installed on all client PCs where Visiamge3 is installed. If you have a VM configured to execute Visimage3 tasks automatically, don't forget to install the new certificates on that system also.
 
 
 
=== Stunnel Configuration ===
 
Once stunnel has been installed you must edit the stunnel.conf file and modify the [VisImage Client] sectionBy default, the stunnel.conf file is located in C:\Program Files\stunnel.
 
 
 
Locate this section:
 
<pre>
 
[VisImage Client]
 
client = yes
 
accept = 30501
 
connect = 172.21.1.40:30502
 
</pre>
 
*Note that 172.21.1.40 is just a sample IP address, your specific address will be different.
 
*Change the connect IP address from 172.21.1.40 to the correct IP address of your UNIX host and save the file.
 
*It should not be necessary to modify the accept or connect ports.
 
*If you have already rebooted your PC since installing stunnel, stop and restart the stunnel service. Otherwise reboot.
 
 
 
=== Checking the Stunnel Restart ===
 
After restarting the service (or rebooting) verify that the stunnel.log file has been updated.  Open the log file in Notepad and scroll to the end of the file.  If you do not see new entries written showing that the service was restarted then there is an issue with the configuration file.  Double check that the stunnel.conf file still exists and was not accidentally renamed while it was being edited.
 
 
 
=== Visimage3 Server Configuration ===
 
When creating a Visimage3 connection, use the following parameters:
 
  {| class="wikitable" style="border-spacing: 2,2,2,2;"
 
    |'''Option''' ||'''Value'''
 
    |-
 
    | Host Address || 127.0.0.1
 
    |-
 
    | Host Port || 30501
 
    |-
 
    | Host Profile Name || uname!live or uname!eom
 
    |}
 
* Where uname is the username assigned by Fiserv. For example, joverton.
 
* The username is always followed by either '''!live''' (for the live databases) or '''!eom''' for the end of month (report) databases.
 
-->
 

Revision as of 22:03, 20 August 2024

This page is still under development...

What Databases Does the Linux Connection Use

When you start server in Visimage using the Linux connection, you connect to AskPlus on a Linux server. AskPlus then opens the Spectrum databases (over the network) on the corresponding HP-UX server. As before, Visimage3 has direct access to your most recent (live) and month-end (eom) databases.

What has changed is that AskPlus can no longer access files created on HP-UX. Therefore any existing Visimage3 reports that use files created by Spectrum programs (pextract, d3307, etc.) must be modified.

Accessing Files Created by Spectrum Programs

Some clients may have reports that require including unencrypted data. Since Visimage3 cannot decrypt fields like SSN, the solution in the past was usually to have Fiserv run a pextract that included the ACCOUNT number and the decrypted SSN value in a delimited file. In other scenarios, you may need access to values that are not stored in the database, like "loan payoff amount", or "loan delinquent amount." Again, the solution for this was to request that Fiserv run the appropriate pextract (or similar program) to generate the required data in a CSV file.

Since AskPlus (running on Linux) can no longer open files on HP-UX, this solution no longer works. For these reports, we are recommending that you convert the Visimage3 context that uses these files into AskPlus code that Fiserv can add to the existing job that generates the file. With the added code, instead of just producing a file, the Fiserv job will create all of the needed output.

Contact our support department if you need help with making these changes.

Visimage3 Passwords

The Visimage3 passwords are not shared between HP-UX and Linux. It is likely that an Admin user will need to reset your password. If no Admin users are able to connect, contact Fiserv for assistance.

Switching Existing Users from HP-UX to Linux

Modify the stunnel.conf file and update the "connect =" value to update an existing user's stunnel configuration and switch them from HP-UX to Linux:

[VisImage Client]
client = yes
accept = 30501
connect = visimage.fiservapps.com:8004

Do not change the accept port, just update the connect address and port. The only reason to change the accept port is if you want to maintain multiple connections.

Stop and restart the stunnel service.

Updating the Visimage3 Setup for Automated Tasks

Make the same changes as shown above for your users.

  • Do not change the name of the Visimage3 connection. This name is stored in the Task Scheduler and should never be changed.
  • After updating stunnel.conf (and restarting stunnel), reset the Visimage3 password.