Visimage3 Linux Connections for Fiserv Online Clients - Revision history

Johno: /* Accessing Files Created by Spectrum Programs */

2024-08-29T23:27:24Z

‎Accessing Files Created by Spectrum Programs

Johno: /* What Databases Does the Linux Connection Use */

2024-08-29T23:25:36Z

‎What Databases Does the Linux Connection Use

Johno at 22:11, 20 August 2024

2024-08-20T22:11:29Z

Johno at 22:06, 20 August 2024

2024-08-20T22:06:13Z

Johno at 22:04, 20 August 2024

2024-08-20T22:04:56Z

Johno at 22:03, 20 August 2024

2024-08-20T22:03:59Z

Johno at 21:41, 20 August 2024

2024-08-20T21:41:50Z

Johno at 19:24, 19 August 2024

2024-08-19T19:24:09Z

Johno: Created page with "=== Visimage3 Setup === There are no changes to the basic setup of Visimage3. A full (new) install requires completing the following steps: * Install Visimage3 * Install stun..."

2024-08-19T19:18:52Z

Created page with "=== Visimage3 Setup === There are no changes to the basic setup of Visimage3. A full (new) install requires completing the following steps: * Install Visimage3 * Install stun..."

New page

=== Visimage3 Setup ===
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] section. By 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.

@@ Line 5: / Line 5: @@
 === 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.
+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, 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.
+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 ===

@@ Line 2: / Line 2: @@
 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.
+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 ===

← Older revision		Revision as of 22:11, 20 August 2024
Line 33:		Line 33:
	* After updating stunnel.conf (and restarting stunnel), reset the Visimage3 password.		* After updating stunnel.conf (and restarting stunnel), reset the Visimage3 password.

−	[[Visimage3 Setup for Fiserv Online Clients\|~~back~~]]	+	=== 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.
		+
		+	[[Visimage3 Setup for Fiserv Online Clients\|Back...]]

← Older revision		Revision as of 22:06, 20 August 2024
Line 32:		Line 32:
	* '''Do not''' change the '''name''' of the Visimage3 connection. This name is stored in the Task Scheduler and should never be changed.		* '''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.		* After updating stunnel.conf (and restarting stunnel), reset the Visimage3 password.
		+
		+	[[Visimage3 Setup for Fiserv Online Clients\|back]]

← Older revision		Revision as of 22:04, 20 August 2024
Line 1:		Line 1:
−	~~This page is still under development...~~
	=== What Databases Does the Linux Connection Use ===		=== 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.		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.

@@ Line 1: / Line 1: @@
 This page is still under development...
-The Linux
+=== What Databases Does the Linux Connection Use ===
 === 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:
 <pre>
 [VisImage Client]
@@ Line 16: / Line 29: @@
 '''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.

← Older revision		Revision as of 21:41, 20 August 2024
Line 1:		Line 1:
	This page is still under development...		This page is still under development...
		+	The 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 as shown below.
		+	<pre>
		+	[VisImage Client]
		+	client = yes
		+	accept = 30501
		+	connect = visimage.fiservapps.com:8004
		+	</pre>
		+
		+	'''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.'''
		+
		+
	<!-- This is a comment		<!-- This is a comment

@@ Line 1: / Line 1: @@
 === Visimage3 Setup ===
 There are no changes to the basic setup of Visimage3.  A full (new) install requires completing the following steps:
@@ Line 50: / Line 53: @@
 * 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.