Question

Public Forms SQL Table Lookup

Forms Version 11

Updated November 6, 2024

asked on November 5, 2024

Hello,

We have a customer who has a Public Facing form that has an issue with a drop-down not populating when viewing the form externally. The drop-down is populated by a SQL lookup table.

If we view the form on their network it works but not externally.

One other thing, their IT has put a redirect for the internal forms URL to an external DNS entry. Could this be the issue?

When I run a network capture trace, I see a "404 Not Found" error for the request URL, which in fact is point to the external DNS entry trying to go the the lookup using this at the end of the URL "Forms/form/lookup"

Makes me think it is a DNS routing issue, but wanted to throw this out here to see if anyone might have some feedback.

Appreciate the help,

Jeff Curtis

0 0

Replies

replied on November 6, 2024

Without knowing the full extent of the client setup it sounds like you might be missing EnableRoutingLookupProxy in the web.config of the DMZ Forms configuration. This allows the internal forms routing service to be a proxy and execute lookup rules on behalf of the DMZ Forms Web server without the need to expose the SQL server to the DMZ itself. The DMZ will require a port (8174 I believe) to be opened between the DMZ and the internal Forms machine. This option was introduced in Forms 11 Update 1. Some links for reference:

https://support.laserfiche.com/kb/1014301/list-of-changes-for-forms-11-update-1

https://answers.laserfiche.com/questions/195566/Question-about-forms-portals-and-DMZ-connections-to-other-SQL-servers

https://answers.laserfiche.com/questions/205721/Configuring-a-Forms-Routing-Service-Cluster-and-Port-8174lookup

2 0

replied on November 5, 2024 • Show version history

This is shocking, the client should never be contacting your SQL server directly, it should be a server side call. That means it should not matter what is going on with the local DNS or network of your computer regarding lookup data, only that you can reach and display the form.

There should be failure info in the event viewer for lookup failures in Forms. Under Applications > Laserfiche > Forms

One other thing to check for is to make sure the source of that 404 error showing in your browser tools displays IIS or Microsoft Internet Information Services as the Source. If it says something like Cloudflare it might be injected packets that do not actually originate from your Laserfiche server.

0 0

You are not allowed to follow up in this post.

Question

Question

Public Forms SQL Table Lookup

Replies

Sign in to reply to this post.