Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / Re: Proxy server for let's encrypt?
« on: September 03, 2025, 03:05:44 PM »
Jane,
I'm using the one Bruce recommends and supports in NT 14, DNSimple. I chose the free "Solo" plan for now and registered a new domain. Was surprisingly simple to get this working by following the steps in the NT docs.
The University were I work, won't be opening ports, like 80 and 443, "to the public", as they say. I have to connect to their network via a VPN (GlobalProtect), to manage my three servers and apps. Using DNS challenge was the only way I could get out to Let's Encrypt. With this scenario, local network users, or outside users who are authorized to run the VPN, can access my NT 14 server apps. Other outside users are a problem as port 443 is not open on the public side...at least for my three servers. Still trying to sort this out with them.
Thanks,
Jeff
I'm using the one Bruce recommends and supports in NT 14, DNSimple. I chose the free "Solo" plan for now and registered a new domain. Was surprisingly simple to get this working by following the steps in the NT docs.
The University were I work, won't be opening ports, like 80 and 443, "to the public", as they say. I have to connect to their network via a VPN (GlobalProtect), to manage my three servers and apps. Using DNS challenge was the only way I could get out to Let's Encrypt. With this scenario, local network users, or outside users who are authorized to run the VPN, can access my NT 14 server apps. Other outside users are a problem as port 443 is not open on the public side...at least for my three servers. Still trying to sort this out with them.
Thanks,
Jeff
2
Web Server - Ask For Help / Re: Proxy server for let's encrypt?
« on: September 02, 2025, 05:37:36 PM »
Hi Ron,
I managed to get the DNS challenge to work and now successfully get certificates without port 80 open. Thanks to you and others who responded.
Jeff
I managed to get the DNS challenge to work and now successfully get certificates without port 80 open. Thanks to you and others who responded.
Jeff
3
Web Server - Ask For Help / Proxy server for let's encrypt?
« on: August 28, 2025, 11:21:46 AM »
Hello everyone,
My IT Department has become very strict over the past few years. Now they won't allow ports 80 and 443 to be "open to the public". That creates a problem for my NT 14.30 server apps. I have looked at DNS challenges, but that seems to require an account at DNSimple. The domain I use is already registered at Network Solutions (Register.com). I could register a new domain with DNSimple, but that would cost more money.
So, I see a proxy tab that has a check box to "allow acme client to use proxy server". If I can get the IT Dept. to create a simple proxy server that is isolated but has 80 and 443 open, would this work? I'm thinking ports 80 and 443 would be open to the public on the "isolated" proxy server, which would handle the challenges, and then forward the cert and key to my NT server. Is that how this might work?
Thanks,
Jeff King
My IT Department has become very strict over the past few years. Now they won't allow ports 80 and 443 to be "open to the public". That creates a problem for my NT 14.30 server apps. I have looked at DNS challenges, but that seems to require an account at DNSimple. The domain I use is already registered at Network Solutions (Register.com). I could register a new domain with DNSimple, but that would cost more money.
So, I see a proxy tab that has a check box to "allow acme client to use proxy server". If I can get the IT Dept. to create a simple proxy server that is isolated but has 80 and 443 open, would this work? I'm thinking ports 80 and 443 would be open to the public on the "isolated" proxy server, which would handle the challenges, and then forward the cert and key to my NT server. Is that how this might work?
Thanks,
Jeff King
4
Web Server - Ask For Help / Re: Let's Encrypt issues
« on: August 05, 2025, 12:41:39 PM »
Hi Ron,
I have been looking at possibly using the DNS method but it seems overly complicated. Can you share instructions on how to set this up? I have looked at the NetTalk docs but was not following too well.
Thanks,
Jeff
I have been looking at possibly using the DNS method but it seems overly complicated. Can you share instructions on how to set this up? I have looked at the NetTalk docs but was not following too well.
Thanks,
Jeff
5
Web Server - Ask For Help / Re: Let's Encrypt issues
« on: August 05, 2025, 12:38:15 PM »
Hi Jane,
Thanks for teaching me something...I never thought to click on those links in the log. I have a ticket in at the University to open ports 80 and 443...they were open on the old server so hopefully they will allow it on the new server.
Jeff
Thanks for teaching me something...I never thought to click on those links in the log. I have a ticket in at the University to open ports 80 and 443...they were open on the old server so hopefully they will allow it on the new server.
Jeff
6
Web Server - Ask For Help / Let's Encrypt issues
« on: August 05, 2025, 10:29:05 AM »
Hello everyone,
I moved a NT app (14.30) from an old server to a new Server 2024, Standard. This is a virtual server hosted by our IT Dept. at a University.
I keep getting "Challenge was invalid", here is the log:
[ 8/05/25-13:52:43] Hostname resolved to: 131.247.221.208
[ 8/05/25-13:52:43] Unable to get certificate - Challenge was invalid
[ 8/05/25-13:52:43] Status: "invalid"
[ 8/05/25-13:52:43] Get Authorize bcdb.usfbreastresearch.org
[ 8/05/25-13:52:43] Checking Status
[ 8/05/25-13:52:33] Status: "pending"
[ 8/05/25-13:52:32] Get Authorize bcdb.usfbreastresearch.org
[ 8/05/25-13:52:32] Checking Status
[ 8/05/25-13:52:32] Notify Server Challenge is Ready: https://acme-staging-v02.api.letsencrypt.org/acme/chall/218067634/18813677063/luoqhA
[ 8/05/25-13:52:32] LE Server will now fetch http://bcdb.usfbreastresearch.org:80/.well-known/acme-challenge/0XtYAnuLqEvkaYcPwYxNTwSqiGltTG172l_VnoY7Ac0
[ 8/05/25-13:52:32] Challenge Token Saved D:\DCISionRT_DEV_AUS\web\.well-known\acme-challenge\0XtYAnuLqEvkaYcPwYxNTwSqiGltTG172l_VnoY7Ac0
[ 8/05/25-13:52:32] HTTP Challenge will be used
[ 8/05/25-13:52:31] Get Authorize bcdb.usfbreastresearch.org
[ 8/05/25-13:52:31] Authorize Request bcdb.usfbreastresearch.org
[ 8/05/25-13:52:30] Registering Account USFBreastResearch_2025 at https://acme-staging-v02.api.letsencrypt.org/acme/new-acct
[ 8/05/25-13:52:29] Time to update the certificate bcdb.usfbreastresearch.org
[ 8/05/25-13:52:29] D:\DCISionRT_DEV_AUS\certificates\bcdb.usfbreastresearch.org.crt does not exist
[ 8/05/25-13:52:29] Setting Folders for Domain [bcdb.usfbreastresearch.org]
[ 8/05/25-13:52:29] Created D:\DCISionRT_DEV_AUS\certificates\bcdb.usfbreastresearch.org.csr.der
[ 8/05/25-13:52:29] Setting Folders for Domain [bcdb.usfbreastresearch.org]
I suspect the ports on the new server (80 and 443) are not configured properly at the institution's firewall. From an outside machine I did a port scan on my IP address and both come back as closed. Is this the problem? If not, anything else I should look at while waiting for these ports to be opened?
Thanks,
Jeff
I moved a NT app (14.30) from an old server to a new Server 2024, Standard. This is a virtual server hosted by our IT Dept. at a University.
I keep getting "Challenge was invalid", here is the log:
[ 8/05/25-13:52:43] Hostname resolved to: 131.247.221.208
[ 8/05/25-13:52:43] Unable to get certificate - Challenge was invalid
[ 8/05/25-13:52:43] Status: "invalid"
[ 8/05/25-13:52:43] Get Authorize bcdb.usfbreastresearch.org
[ 8/05/25-13:52:43] Checking Status
[ 8/05/25-13:52:33] Status: "pending"
[ 8/05/25-13:52:32] Get Authorize bcdb.usfbreastresearch.org
[ 8/05/25-13:52:32] Checking Status
[ 8/05/25-13:52:32] Notify Server Challenge is Ready: https://acme-staging-v02.api.letsencrypt.org/acme/chall/218067634/18813677063/luoqhA
[ 8/05/25-13:52:32] LE Server will now fetch http://bcdb.usfbreastresearch.org:80/.well-known/acme-challenge/0XtYAnuLqEvkaYcPwYxNTwSqiGltTG172l_VnoY7Ac0
[ 8/05/25-13:52:32] Challenge Token Saved D:\DCISionRT_DEV_AUS\web\.well-known\acme-challenge\0XtYAnuLqEvkaYcPwYxNTwSqiGltTG172l_VnoY7Ac0
[ 8/05/25-13:52:32] HTTP Challenge will be used
[ 8/05/25-13:52:31] Get Authorize bcdb.usfbreastresearch.org
[ 8/05/25-13:52:31] Authorize Request bcdb.usfbreastresearch.org
[ 8/05/25-13:52:30] Registering Account USFBreastResearch_2025 at https://acme-staging-v02.api.letsencrypt.org/acme/new-acct
[ 8/05/25-13:52:29] Time to update the certificate bcdb.usfbreastresearch.org
[ 8/05/25-13:52:29] D:\DCISionRT_DEV_AUS\certificates\bcdb.usfbreastresearch.org.crt does not exist
[ 8/05/25-13:52:29] Setting Folders for Domain [bcdb.usfbreastresearch.org]
[ 8/05/25-13:52:29] Created D:\DCISionRT_DEV_AUS\certificates\bcdb.usfbreastresearch.org.csr.der
[ 8/05/25-13:52:29] Setting Folders for Domain [bcdb.usfbreastresearch.org]
I suspect the ports on the new server (80 and 443) are not configured properly at the institution's firewall. From an outside machine I did a port scan on my IP address and both come back as closed. Is this the problem? If not, anything else I should look at while waiting for these ports to be opened?
Thanks,
Jeff
7
Web Server - Ask For Help / SOLVED - Re: Multi-Site host flashes error message
« on: July 24, 2025, 11:19:54 AM »
Hello all,
Turns out this was due to a report being generated. Users click on a button to generate the report and it is converted to PDF. The Report to PDF template displays a brief message on the server to indicate the report processing. The report is not used all that often, until recently, and I had not seen this screen flash by before. All is good!
Jeff King
Turns out this was due to a report being generated. Users click on a button to generate the report and it is converted to PDF. The Report to PDF template displays a brief message on the server to indicate the report processing. The report is not used all that often, until recently, and I had not seen this screen flash by before. All is good!
Jeff King
8
Web Server - Ask For Help / Re: Multi-Site host flashes error message
« on: July 24, 2025, 06:12:16 AM »
Johan,
Thanks for the response. I don't think this is a MessageBox screen as it is too small. Thinking about it more, it reminds me of messages I used to see when using FileManager. I'll check my host app to see if FM is in use, but it is not something I regularly use.
As for logging, anything in particular I should look for in the logs if I turn those on?
Thanks,
Jeff
Thanks for the response. I don't think this is a MessageBox screen as it is too small. Thinking about it more, it reminds me of messages I used to see when using FileManager. I'll check my host app to see if FM is in use, but it is not something I regularly use.
As for logging, anything in particular I should look for in the logs if I turn those on?
Thanks,
Jeff
9
Web Server - Ask For Help / Re: Multi-Site host flashes error message
« on: July 24, 2025, 06:08:55 AM »
Ron,
Thanks! I'll message him and see what he thinks.
Jeff
Thanks! I'll message him and see what he thinks.
Jeff
10
Web Server - Ask For Help / Multi-Site host flashes error message
« on: July 23, 2025, 11:47:12 AM »
Hello everyone,
I have a multi-site host running out on a server (C11.1 with NT 14.30). I like to watch the web log as Get/Post messages come in, when I'm logged into the server. Everything seems to work just fine. However, I periodically see a small blue and white message box flash very quickly in the background. It flashes by too quickly to read but does remind me of a NetTalk/Capesoft type message screen. Has anyone else seen this? Might it be an error message that does not stay displayed since NetTalk is set to not display errors? I realize it might be difficult for someone to say, but if it is a common thing others have seen, perhaps they can tell me what it might be?
Thank you,
Jeff King
I have a multi-site host running out on a server (C11.1 with NT 14.30). I like to watch the web log as Get/Post messages come in, when I'm logged into the server. Everything seems to work just fine. However, I periodically see a small blue and white message box flash very quickly in the background. It flashes by too quickly to read but does remind me of a NetTalk/Capesoft type message screen. Has anyone else seen this? Might it be an error message that does not stay displayed since NetTalk is set to not display errors? I realize it might be difficult for someone to say, but if it is a common thing others have seen, perhaps they can tell me what it might be?
Thank you,
Jeff King
11
Web Server - Ask For Help / Re: Modify the lookup procedure?
« on: March 20, 2025, 04:33:10 AM »
Ron,
Thanks for the replies. I'll try your advice and get back to you.
Jeff
Thanks for the replies. I'll try your advice and get back to you.
Jeff
12
Web Server - Ask For Help / Re: Modify the lookup procedure?
« on: March 19, 2025, 10:41:33 AM »
Hello all,
I continue to work on this, now I'm taking a different route. I have a button next to a field that calls a memory form. See the attached image. The form has two date fields and a third numeric field. I want to enter the two dates and then populate the numeric field with the difference between the two dates. In the ValidateAll embed I have the following:
loc:DateInterval = loc:ReferenceDate - loc:TargetDate
For the ReferenceDate and TargetDate fields, I have set these to reset the loc:DateInterval field on the client-side tab. Still, the loc:DateInterval field is not filled in. I suspect my embed code is wrong and/or I'm using the wrong embed. Can anyone help with this?
Thanks,
Jeff King
I continue to work on this, now I'm taking a different route. I have a button next to a field that calls a memory form. See the attached image. The form has two date fields and a third numeric field. I want to enter the two dates and then populate the numeric field with the difference between the two dates. In the ValidateAll embed I have the following:
loc:DateInterval = loc:ReferenceDate - loc:TargetDate
For the ReferenceDate and TargetDate fields, I have set these to reset the loc:DateInterval field on the client-side tab. Still, the loc:DateInterval field is not filled in. I suspect my embed code is wrong and/or I'm using the wrong embed. Can anyone help with this?
Thanks,
Jeff King
13
Web Server - Ask For Help / Modify the lookup procedure?
« on: March 18, 2025, 12:03:09 PM »
Hello everyone,
I have a client that no longer wants to store dates in his app. Instead, he wants to store the number of days from a reference date. I thought I would set a new field to store the number of days and set it as a lookup. The lookup would call a procedure/memory form that allows the user to enter two dates and calculates the days between them. This new calculated value should drop into the lookup field. I use local variables on the memory form to store the dates and do the calculation.
I have the memory form called and it calculates the interval between the two dates. However, upon returning to the lookup field, the interval value is not dropped into the lookup field. I realize the lookup feature is meant to do a look up into a table but I thought I might be able to get it to do this by setting the lookup field in an embed, just before returning to the lookup field, but so far not able to do this. Any thoughts on how to make this work or an alternate way to do this? I prefer the lookup method over adding a button after each field and calling the memory form that way. That would be too many buttons to add as I have about 30 date fields to convert.
Thanks,
Jeff King
I have a client that no longer wants to store dates in his app. Instead, he wants to store the number of days from a reference date. I thought I would set a new field to store the number of days and set it as a lookup. The lookup would call a procedure/memory form that allows the user to enter two dates and calculates the days between them. This new calculated value should drop into the lookup field. I use local variables on the memory form to store the dates and do the calculation.
I have the memory form called and it calculates the interval between the two dates. However, upon returning to the lookup field, the interval value is not dropped into the lookup field. I realize the lookup feature is meant to do a look up into a table but I thought I might be able to get it to do this by setting the lookup field in an embed, just before returning to the lookup field, but so far not able to do this. Any thoughts on how to make this work or an alternate way to do this? I prefer the lookup method over adding a button after each field and calling the memory form that way. That would be too many buttons to add as I have about 30 date fields to convert.
Thanks,
Jeff King
14
Web Server - Ask For Help / Re: How to change name of output PDF report?
« on: October 19, 2024, 07:52:04 AM »
Hello everyone,
I think I found a solution, after looking at more posts here. In the PDF (PDFReportGenerator) Setup embed, I have the following:
p_web.HeaderDetails.ContentDisposition = 'filename="PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf"'
The generated PDF displays in a new browser tab (have report set to use '_blank') and when I click to download the PDF, it now has a unique filename filled in for me. The filename no longer defaults to the procedure name. Next I'll test how this does with a few other browsers.
Thanks,
Jeff
I think I found a solution, after looking at more posts here. In the PDF (PDFReportGenerator) Setup embed, I have the following:
p_web.HeaderDetails.ContentDisposition = 'filename="PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf"'
The generated PDF displays in a new browser tab (have report set to use '_blank') and when I click to download the PDF, it now has a unique filename filled in for me. The filename no longer defaults to the procedure name. Next I'll test how this does with a few other browsers.
Thanks,
Jeff
15
Web Server - Ask For Help / How to change name of output PDF report?
« on: October 18, 2024, 03:51:06 PM »
Hello all,
I have setup a simple Clarion report to output as a PDF using the Clarion Report to PDF template. I do get the report generated in a new browser tab but when I try to save it to the local drive, it defaults to the name of the report procedure. I have tried the following code in numerous report procedure embeds without success:
loc:PDFName = '.\PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf'
Some of the embeds I have tried:
PDF (PDFReportGenerator), Setup, after parent call
Previewer (PrintPreviewClass), OnSaveAs
Prime Report Options when run in web mode
Can anyone tell me how this should be done?
Thanks,
Jeff King
I have setup a simple Clarion report to output as a PDF using the Clarion Report to PDF template. I do get the report generated in a new browser tab but when I try to save it to the local drive, it defaults to the name of the report procedure. I have tried the following code in numerous report procedure embeds without success:
loc:PDFName = '.\PREDICT2 Study ID Assignment_'&p_web.GSV('Enr:Study_ID')&'.pdf'
Some of the embeds I have tried:
PDF (PDFReportGenerator), Setup, after parent call
Previewer (PrintPreviewClass), OnSaveAs
Prime Report Options when run in web mode
Can anyone tell me how this should be done?
Thanks,
Jeff King