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

From Vital Soft Wiki
Jump to: navigation, search
(Accessing Files Created by Spectrum Programs)
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
This page is still under development...
+
=== What Databases Does the Linux Connection Use ===
<!-- This is a comment
+
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.
  
=== Visimage3 Setup ===
+
What has changed is that AskPlus can no longer access '''files''' created on HP-UXTherefore if you have any existing Visimage3 reports that use files created by Spectrum programs (pextract, d3307, etc.) you must request that Fiserv modify the jobs to transfer the files to the Linux server.
There are no changes to the basic setup of Visimage3A 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]].
+
=== 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 is usually to have Fiserv run a pextract that includes 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 is to request that Fiserv run the appropriate pextract (or similar program) to generate the required data in a CSV file.
  
=== New Stunnel Certificates (May 2024) ===
+
Since AskPlus (running on Linux) can no longer open files on HP-UX, you must contact Fiserv to have the jobs modified so that the extract files are now created on the Linux server. Typically, no other changes will be required.
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 ===
+
=== Visimage3 Passwords ===
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.
+
The Visimage3 passwords are '''not''' shared between HP-UX and LinuxIt 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:
  
Locate this section:
 
 
<pre>
 
<pre>
 
[VisImage Client]
 
[VisImage Client]
 
client = yes
 
client = yes
 
accept = 30501
 
accept = 30501
connect = 172.21.1.40:30502
+
connect = visimage.fiservapps.com:8004
 
</pre>
 
</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 ===
+
'''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.
After restarting the service (or rebooting) verify that the stunnel.log file has been updatedOpen the log file in Notepad and scroll to the end of the fileIf you do not see new entries written showing that the service was restarted then there is an issue with the configuration fileDouble check that the stunnel.conf file still exists and was not accidentally renamed while it was being edited.
+
 
 +
'''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.
 +
 
 +
=== When Should I Switch ===
 +
Once you have successfully tested connections for multiple users and have successfully tested any (Task Scheduler) Automated Tasks then it's time to switchThere is no reason to continue using the HP-UX connection once you have successfully completed testingRemember, both the HP-UX and Linux connections are accessing the same databasesIt is just AskPlus that has moved.  
  
=== Visimage3 Server Configuration ===
+
[[Visimage3 Setup for Fiserv Online Clients|Back...]]
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.
 
-->
 

Latest revision as of 23:27, 29 August 2024

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 if you have any existing Visimage3 reports that use files created by Spectrum programs (pextract, d3307, etc.) you must request that Fiserv modify the jobs to transfer the files to the Linux server.

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 is usually to have Fiserv run a pextract that includes 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 is 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, you must contact Fiserv to have the jobs modified so that the extract files are now created on the Linux server. Typically, no other changes will be required.

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.

When Should I Switch

Once you have successfully tested connections for multiple users and have successfully tested any (Task Scheduler) Automated Tasks then it's time to switch. There is no reason to continue using the HP-UX connection once you have successfully completed testing. Remember, both the HP-UX and Linux connections are accessing the same databases. It is just AskPlus that has moved.

Back...