Recent Posts
81
Web Server - Ask For Help / Let's Encrypt issues
« Last post by jking 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
82
Web Server - Ask For Help / Re: NT14 CLALIT2 - NetwebForm - Duplicate Record
« Last post by Bruce on August 03, 2025, 06:28:26 PM »Hi David,
Please post an example app & dict so I can duplicate here.
And which build of the DriverKit & NetTalk are you using?
Cheers
Bruce
Please post an example app & dict so I can duplicate here.
And which build of the DriverKit & NetTalk are you using?
Cheers
Bruce
83
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by Bruce on August 03, 2025, 06:27:14 PM »Hi Johan,
If it's the NEXT that takes the time, then your VIEW is likely doing a full table scan (perhaps multiple of them in TPS) to construct the VIEW. Post the View declaration here, the file declarations (for files included in the View) and also the contents of the View Filter.
Cheers
Bruce
If it's the NEXT that takes the time, then your VIEW is likely doing a full table scan (perhaps multiple of them in TPS) to construct the VIEW. Post the View declaration here, the file declarations (for files included in the View) and also the contents of the View Filter.
Cheers
Bruce
84
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by rjolda on August 03, 2025, 02:34:42 PM »Hi Johan,
I was at the webinar. I don't have much to offer but ProcessLink seems to be a focal point for everything that happens. If I were to try to look at this I would look at web_handler and begin to search with maybe what is going through the ProcessLink AFTER your browse procedure. CLOSES.... A very crude way that I can think of is to put a p_web.Trace('hi, I am procedure Browse_city..., etc) at the start of each procedure. Then you can watch your DebugView for what happens AFTER your browse closes. There are probably more elegant ways to do this. Also, it might be doing some housekeeping which might not get you a trace statement. But then you might know what it is NOT.. Also, if you can slice out this browse and part of the program and test it OUTSIDE your full program, you might gain some insights.
Ron
I was at the webinar. I don't have much to offer but ProcessLink seems to be a focal point for everything that happens. If I were to try to look at this I would look at web_handler and begin to search with maybe what is going through the ProcessLink AFTER your browse procedure. CLOSES.... A very crude way that I can think of is to put a p_web.Trace('hi, I am procedure Browse_city..., etc) at the start of each procedure. Then you can watch your DebugView for what happens AFTER your browse closes. There are probably more elegant ways to do this. Also, it might be doing some housekeeping which might not get you a trace statement. But then you might know what it is NOT.. Also, if you can slice out this browse and part of the program and test it OUTSIDE your full program, you might gain some insights.
Ron
85
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by Jane on August 02, 2025, 05:02:21 PM »I watched the webinar recording, Johan.
Helpful hint - Ctrl+Shift+X clears the log in debugview++
Helpful hint - Ctrl+Shift+X clears the log in debugview++
86
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 31, 2025, 10:00:56 PM »Hi Jane
Asked in the NT user group last night, still no resolve,
but the problem is outside of the procedures.
Once I have more info will post what I've found
thanks
Johan
Asked in the NT user group last night, still no resolve,
but the problem is outside of the procedures.
Once I have more info will post what I've found
thanks
Johan
87
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 30, 2025, 10:53:08 AM »Hi Jane
Thanks for that idea, will have a look,
it's a decent length, perhaps 20 entries, so will play a roll, but don't think that's the culprit.
Also need to cleanup my procedure and all debug lines, and look with fresh eyes.
thanks
Johan
Thanks for that idea, will have a look,
it's a decent length, perhaps 20 entries, so will play a roll, but don't think that's the culprit.
Also need to cleanup my procedure and all debug lines, and look with fresh eyes.
thanks
Johan
88
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by Jane on July 30, 2025, 07:12:20 AM »Hi, Johan,
Not sure I'm understanding? Do you have a browse with an EIP column and the browse itself is slow to load?
Is the browse page-loaded or file-loaded? How many items are in the EIP dropdown list?
I think that the browse with EIP populates all the EIP possibilities for the column for each row. Which, if you have 15 rows in the browse, would mean it needs to process all of the rows for the EIP selections 15 times. If file-loaded, then for the entire browse. If you only have a few choices that might be reasonable, but if there's a long list there will be a lot of overhead.
When you use an update form, the EIP selections are only populated once when you open the form.
Not sure I'm understanding? Do you have a browse with an EIP column and the browse itself is slow to load?
Is the browse page-loaded or file-loaded? How many items are in the EIP dropdown list?
I think that the browse with EIP populates all the EIP possibilities for the column for each row. Which, if you have 15 rows in the browse, would mean it needs to process all of the rows for the EIP selections 15 times. If file-loaded, then for the entire browse. If you only have a few choices that might be reasonable, but if there's a long list there will be a lot of overhead.
When you use an update form, the EIP selections are only populated once when you open the form.
89
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 30, 2025, 03:07:59 AM »Hi,
Currently have had to remove the EIP dropbox and replaced it with a popup UpdateForm.
Will return to the problem when I get a chance, and will post any findings.
thanks
Johan
Currently have had to remove the EIP dropbox and replaced it with a popup UpdateForm.
Will return to the problem when I get a chance, and will post any findings.
thanks
Johan
90
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 29, 2025, 10:27:15 AM »Hi Bruce
Any advice on how to find this possible problem?
Been chasing all sorts of things past few days, but still having an issue.
From your post earlier
>>>>>>>>>>>>>>>>>>>>
My guess is that the reply to the browser is not completing. ie you have some code in the thread, after the drop down is populated, which delays the ending of the thread. In that case the connection is not closed, so the browser does not start processing the reply.
>>>>>>>>>>>>>>>>>>>>
thanks
Johan
Any advice on how to find this possible problem?
Been chasing all sorts of things past few days, but still having an issue.
From your post earlier
>>>>>>>>>>>>>>>>>>>>
My guess is that the reply to the browser is not completing. ie you have some code in the thread, after the drop down is populated, which delays the ending of the thread. In that case the connection is not closed, so the browser does not start processing the reply.
>>>>>>>>>>>>>>>>>>>>
thanks
Johan