Search found 30 matches

by PatrickF
Wed Nov 27, 2024 5:15 am
Forum: Questions & Answers
Topic: VisualLANSA Windows client IP Address
Replies: 5
Views: 62558

Re: VisualLANSA Windows client IP Address

I found this old example from 2011 via the Forum that was in place at that time. I haven't tried it in LANSA V15 or whether recent versions of Windows have locked down the command interface, or whether the command output is formatted differently in 2024, Note that when using VPN or using multiple ...
by PatrickF
Sat Oct 12, 2024 4:09 am
Forum: Questions & Answers
Topic: REST API Response with custom JSON String containing invalid characters when ran in the IBMi
Replies: 5
Views: 22174

Re: REST API Response with custom JSON String containing invalid characters when ran in the IBMi

Web Administrator in EPC150070 allows you to set tracing, and the Debug Option shows how the request is handled by the Apache Module
Web Admin Tracing.png

The screen shot below from the lansaweb.log tells me that Apache Transfer Encoding is not enabled. This means that if the JSON response is ...
by PatrickF
Fri Sep 27, 2024 5:15 am
Forum: Questions & Answers
Topic: How to automate LANSA web cleanup on a Windows app server ?
Replies: 1
Views: 8806

How to automate LANSA web cleanup on a Windows app server ?

LANSA on the IBMi has a batch interface for running the LANSA web cleanup documented here https://docs.lansa.com/15/en/lansa085/content/lansa/insek_005.htm so cleanup can be automated when the LANSA subsystem and/or Apache web server is restarted periodically.
On Windows, the documentation at https ...
by PatrickF
Thu Jan 25, 2024 10:11 am
Forum: Questions & Answers
Topic: why HTTPTransportException in the IBM but not in Windows?
Replies: 23
Views: 10144632

Re: why HTTPTransportException in the IBM but not in Windows?

Hi Dino

The GSKIT error on IBMi indicates that the IBMi DIgital Certificate manager doesn't have a trusted Certificate Authority for the other party's certificate. The Certificate Authority is similar to a passport that a traveler going through Airport immigration might use, and Immigration need to ...
by PatrickF
Tue Jan 23, 2024 2:09 pm
Forum: Questions & Answers
Topic: Can't debug on new slave install
Replies: 18
Views: 129723

Re: Can't debug on new slave install

Check Windows Firewall, especially if the VM is running a WIndows Server OS, check whether Inbound ports are blocked by Windows Firewall Service
See screen shot for an example of FIrewall Rules by application. Recommend turning Firewall off to confirm that it is the issue and then set an exclusion ...
by PatrickF
Fri Jan 05, 2024 9:52 am
Forum: Questions & Answers
Topic: App deployment forcing per-machine install
Replies: 2
Views: 54116

Re: App deployment forcing per-machine install

Assuming you are running msiexec.exe with all the switches to automate the installation as much as possible there is now a ALLUSERS=1 which will install for all users
See the bottom section of https://docs.lansa.com/14/en/lansa022/content/lansa/vldtool19_0030.htm and https://learn.microsoft.com/en ...
by PatrickF
Tue Oct 31, 2023 1:27 pm
Forum: Questions & Answers
Topic: How do you add client certs to XPRIM_HttpRequest
Replies: 0
Views: 206131

How do you add client certs to XPRIM_HttpRequest

I am working on a V15 EPC150050 VL web app deployed to a Windows 2019 Server. The web page makes a HTTP request to an oData format API which requires Basic Authentication AND 2 way SSL verification via client certificates. In two-way SSL, both client and server validate the identity of each other ...
by PatrickF
Tue Sep 19, 2023 3:09 am
Forum: Questions & Answers
Topic: VL Web Deployment Install cannot connect to remote DB
Replies: 2
Views: 18156

Re: VL Web Deployment Install cannot connect to remote DB

Hi Dino

While there may be similarities with the use of a Remote DB, I think in the earlier issue, the serving of web pages after the deployment of the MSI had completed was the issue, whereas my issue is that the deployment hard crashes at the point where the deployment attempts to create the DB ...
by PatrickF
Sat Sep 16, 2023 7:06 am
Forum: Questions & Answers
Topic: VL Web Deployment Install cannot connect to remote DB
Replies: 2
Views: 18156

VL Web Deployment Install cannot connect to remote DB

I created a VL web deployment based on the shipped VL web template for LANSA V15 EPC150050 on Windows Server 2019. What is different from my previous deployments is that the Web Application will use SQL Server (not Express) 2019 which is on a Remote Windows Server from the Application Server.
I am ...
by PatrickF
Wed Aug 23, 2023 10:54 am
Forum: Questions & Answers
Topic: LANSA Web-API - Model-B configuration - PDF
Replies: 1
Views: 8185

Re: LANSA Web-API - Model-B configuration - PDF

In Multi-tier (Model B) Web Administrator there is an option to get files from a remote backend server https://docs.lansa.com/15/en/lansa085/index.htm#lansa/jmp_0340.htm

Serve Files from this directory
If Allow Files to be served from Web Server is enabled, you must specify where to fetch the files ...
by PatrickF
Fri Apr 28, 2023 1:46 pm
Forum: Questions & Answers
Topic: Running a LANSA background Function as a Windows Service
Replies: 4
Views: 19405

Running a LANSA background Function as a Windows Service

There was an article posted on a private blog 10 years ago covering the topic - https://lansablog.wordpress.com/2012/03/31/running-lansa-as-a-windows-service/ and a C# project. Unfortunately the code attachment link links to a dead site.
In the last decade nssm - https://nssm.cc/usage has been used ...
by PatrickF
Thu Oct 27, 2022 1:34 pm
Forum: Questions & Answers
Topic: avCheckAuth / avCheckInstanceAuth in VLF_ONE?
Replies: 3
Views: 7406

Re: avCheckAuth / avCheckInstanceAuth in VLF_ONE?

From your requirement "Based on the value of a field of the chosen entry in the instance-list, determine which command handlers (BO's) should be shown." , subtypes may be another alternative to implement. Subtype is a property of the instance list and based on the Subtype property value, the command ...
by PatrickF
Sat Oct 08, 2022 6:48 am
Forum: Questions & Answers
Topic: Rewrite Rule for redirecting a VL web or REST API URL to DC@PGMLIB
Replies: 1
Views: 5806

Rewrite Rule for redirecting a VL web or REST API URL to DC@PGMLIB

I recall the @ in the VL Web URL request http:<server:port>/DC@PGMLIB/DEM/XVLWEBTST.HTML needs to be translated to something like DC-PGMLIB to serve the VL web page when processed by the web server. There is debate on the topic of whether @ can be used in the URL https://stackoverflow.com/questions ...
by PatrickF
Wed Sep 21, 2022 5:00 am
Forum: Questions & Answers
Topic: Authority of files created by Integrator's PDFDOCUMENTService
Replies: 1
Views: 9289

Re: Authority of files created by Integrator's PDFDOCUMENTService

Security for files created by L/I is documented here : https://docs.lansa.com/15/en/lansa093/index.htm#lansa/intengb3_0080.htm which the L/I Default Settings properties files allows you to set at folder level and the files created. Restart the JSM subsystem after making the change, and correct any ...
by PatrickF
Fri Apr 22, 2022 6:25 am
Forum: Questions & Answers
Topic: How can I use LANSA/Integrator FTPService to send a file to a Windows Server
Replies: 1
Views: 6087

How can I use LANSA/Integrator FTPService to send a file to a Windows Server

Using LANSA V15 RDMLX installation on IBMi, using FTP Service to transfer a 40MB file to a Windows Server. The Windows Server is actually an Azure cloud running Windows 2019 DataCenter and the FTP Server bundled with IIS10. We control both ftp client and ftp server settings.
I can use ftp command ...
by PatrickF
Mon Apr 04, 2022 11:25 pm
Forum: Questions & Answers
Topic: .Net Assembly replacement for IE HTML activex
Replies: 17
Views: 1072502

Re: .Net Assembly replacement for IE HTML activex

Based on the AntVIew documentation, it is shipping an OCX file, which is an ActiveX control.
Can you retry using New->ActiveX rather than attempting to load an ActiveX as a .Net Component ?
by PatrickF
Sat Apr 02, 2022 1:56 am
Forum: Questions & Answers
Topic: .Net Assembly replacement for IE HTML activex
Replies: 17
Views: 1072502

Re: .Net Assembly replacement for IE HTML activex

Looking at Microsoft's documentation on the control at https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.webbrowser?view=windowsdesktop-6.0 I see this : " The WebBrowser control is a managed wrapper for the ActiveX WebBrowser control, and uses whichever version of the control is ...
by PatrickF
Tue Mar 08, 2022 10:35 am
Forum: Questions & Answers
Topic: Anyone Willing to Share the 14.0 IBMi Install ISO
Replies: 1
Views: 5817

Re: Anyone Willing to Share the 14.0 IBMi Install ISO

I have a copy - low mileage, used only once. I will work with you directly re delivery. I don't have a DVD drive anymore so will need to send via USPS and you can mail it back when done
by PatrickF
Thu Oct 21, 2021 1:17 pm
Forum: Questions & Answers
Topic: changing the TLS version in SMTPMailService for Integrator
Replies: 9
Views: 65932

Re: changing the TLS version in SMTPMailService for Integrator

I am working with a customer at the moment using POP3 with LANSA Composer having the same issue. I see this link https://docs.microsoft.com/en-us/microsoft-365/compliance/prepare-tls-1.2-in-office-365?view=o365-worldwide. Seems flaky where it sometimes connects and other times does not. I wonder if ...
by PatrickF
Fri Sep 04, 2020 12:59 am
Forum: Questions & Answers
Topic: Embedded documents (base64REncoded) in XML
Replies: 2
Views: 9033

Re: Embedded documents (base64REncoded) in XML

Are you able to dump out the encoded base64 string to a SQL Table or text file and use https://www.base64decode.org/ to validate the Base64 you are generating. Where I have needed to handle BLOBs/CLOBs in XML I have written to a DB and then mapped that back to the target format.
Also take a look at ...