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 / The URL for the Fetch command was blank
« on: April 08, 2024, 06:49:39 AM »
Hi, I'm hoping someone can help.
I've suddenly ran into a certificate generation problem for any site renewing their certificate for web server. I get the the response "The URL for the Fetch command was blank", a section of the log is below.
I'm using NetTalk 12.17, I know I need to update but I've held off as I have some mods in the templates, if it's a known problem that requires an update then I'll move to NetTalk 14 but I would appreciate any help to get it working in the meantime.
[ 4/08/24-15:46:00] The URL for the Fetch command was blank
[ 4/08/24-15:46:00] Requesting Certificate For staging.edgeanywhere.co.uk
[ 4/08/24-15:46:00] Finalized. Will now fetch certificate
[ 4/08/24-15:46:00] Finalize Request staging.edgeanywhere.co.uk
[ 4/08/24-15:45:59] Hostname resolved to: 45.8.225.229
[ 4/08/24-15:45:59] Challenge was valid. Will now finalize
[ 4/08/24-15:45:59] Status: "valid"
[ 4/08/24-15:45:59] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:59] Checking Status
[ 4/08/24-15:45:52] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:49] Status: "pending"
[ 4/08/24-15:45:48] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:48] Checking Status
[ 4/08/24-15:45:43] Status: "pending"
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:42] Checking Status
[ 4/08/24-15:45:42] Notify Server Challenge is Ready
[ 4/08/24-15:45:42] LE Server will now fetch http://staging.edgeanywhere.co.uk:80/.well-known/acme-challenge/lB-U9m6_enz102MB6pIzlRfHONa9CAgvYnm2Z0opi6s
[ 4/08/24-15:45:42] Challenge Token Saved C:\Dentsys\Server\web\.well-known\acme-challenge\lB-U9m6_enz102MB6pIzlRfHONa9CAgvYnm2Z0opi6s
[ 4/08/24-15:45:41] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:41] Authorize Request staging.edgeanywhere.co.uk
[ 4/08/24-15:45:40] Registering Account Dentsys at https://acme-staging-v02.api.letsencrypt.org/acme/new-acct
[ 4/08/24-15:45:38] Time to update the certificate staging.edgeanywhere.co.uk
[ 4/08/24-15:45:38] C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.crt does not exist
[ 4/08/24-15:45:38] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:38] Created C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.csr.der
[ 4/08/24-15:45:38] Created C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.csr
[ 4/08/24-15:45:38] Created C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.key
[ 4/08/24-15:45:29] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:29] Created C:\Dentsys\Server\certificates\Dentsys-LE.key
[ 4/08/24-15:45:27] Created C:\Dentsys\Server\certificates\Dentsys-CA.crt
[ 4/08/24-15:45:27] Created C:\Dentsys\Server\certificates\Dentsys-CA.key
I've suddenly ran into a certificate generation problem for any site renewing their certificate for web server. I get the the response "The URL for the Fetch command was blank", a section of the log is below.
I'm using NetTalk 12.17, I know I need to update but I've held off as I have some mods in the templates, if it's a known problem that requires an update then I'll move to NetTalk 14 but I would appreciate any help to get it working in the meantime.
[ 4/08/24-15:46:00] The URL for the Fetch command was blank
[ 4/08/24-15:46:00] Requesting Certificate For staging.edgeanywhere.co.uk
[ 4/08/24-15:46:00] Finalized. Will now fetch certificate
[ 4/08/24-15:46:00] Finalize Request staging.edgeanywhere.co.uk
[ 4/08/24-15:45:59] Hostname resolved to: 45.8.225.229
[ 4/08/24-15:45:59] Challenge was valid. Will now finalize
[ 4/08/24-15:45:59] Status: "valid"
[ 4/08/24-15:45:59] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:59] Checking Status
[ 4/08/24-15:45:52] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:49] Status: "pending"
[ 4/08/24-15:45:48] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:48] Checking Status
[ 4/08/24-15:45:43] Status: "pending"
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:43] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:42] Checking Status
[ 4/08/24-15:45:42] Notify Server Challenge is Ready
[ 4/08/24-15:45:42] LE Server will now fetch http://staging.edgeanywhere.co.uk:80/.well-known/acme-challenge/lB-U9m6_enz102MB6pIzlRfHONa9CAgvYnm2Z0opi6s
[ 4/08/24-15:45:42] Challenge Token Saved C:\Dentsys\Server\web\.well-known\acme-challenge\lB-U9m6_enz102MB6pIzlRfHONa9CAgvYnm2Z0opi6s
[ 4/08/24-15:45:41] Get Authorize staging.edgeanywhere.co.uk
[ 4/08/24-15:45:41] Authorize Request staging.edgeanywhere.co.uk
[ 4/08/24-15:45:40] Registering Account Dentsys at https://acme-staging-v02.api.letsencrypt.org/acme/new-acct
[ 4/08/24-15:45:38] Time to update the certificate staging.edgeanywhere.co.uk
[ 4/08/24-15:45:38] C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.crt does not exist
[ 4/08/24-15:45:38] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:38] Created C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.csr.der
[ 4/08/24-15:45:38] Created C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.csr
[ 4/08/24-15:45:38] Created C:\Dentsys\Server\certificates\staging.edgeanywhere.co.uk.key
[ 4/08/24-15:45:29] Setting Folders for Domain [staging.edgeanywhere.co.uk]
[ 4/08/24-15:45:29] Created C:\Dentsys\Server\certificates\Dentsys-LE.key
[ 4/08/24-15:45:27] Created C:\Dentsys\Server\certificates\Dentsys-CA.crt
[ 4/08/24-15:45:27] Created C:\Dentsys\Server\certificates\Dentsys-CA.key
2
Web Server - Ask For Help / Re: Memory Form Save Button Operation When A Required Field Is Present
« on: March 07, 2023, 07:11:23 AM »
Hi Bruce I will try to put together a simple example based on an example program tomorrow and send it to you.
3
Web Server - Ask For Help / Memory Form Save Button Operation When A Required Field Is Present
« on: March 07, 2023, 03:22:03 AM »
Hi,
I have an unusual issue and it may just be that I'm doing something incorrectly.
I have a simple memory form called from a browse (no action), it has a text field, plus a save and cancel button. It all works fine until I set the text field to required, if after that I click save with an empty text field I get the required warning as expected, however if I then type a value into the text field and click the save (either with or without tabbing off the text field) the CompleteForm code runs but the form doesn't return to the caller it redraws itself with the text field being shown without the required required colouration, the second click on save again runs the CompleteForm code and returns to the browse. The result is my CompleteForm code which inserts a record into an unrelated table runs twice, what am I doing incorrectly.
Any advice would be much appreciated.
A quick update, the p_web.RequestReferer value gets set to the actual memory form name after the first failed required check, the solution was to store the initial p_web.RequestReferer value and set this as the save return url.
I have an unusual issue and it may just be that I'm doing something incorrectly.
I have a simple memory form called from a browse (no action), it has a text field, plus a save and cancel button. It all works fine until I set the text field to required, if after that I click save with an empty text field I get the required warning as expected, however if I then type a value into the text field and click the save (either with or without tabbing off the text field) the CompleteForm code runs but the form doesn't return to the caller it redraws itself with the text field being shown without the required required colouration, the second click on save again runs the CompleteForm code and returns to the browse. The result is my CompleteForm code which inserts a record into an unrelated table runs twice, what am I doing incorrectly.
Any advice would be much appreciated.
A quick update, the p_web.RequestReferer value gets set to the actual memory form name after the first failed required check, the solution was to store the initial p_web.RequestReferer value and set this as the save return url.
4
Web Server - Ask For Help / Re: OAuth and emails
« on: September 13, 2022, 01:27:28 AM »
Hi Bruce it's solved I looked at your source in NetOAuth.clw and NetAll.inc and found out how to set the parameters, I hadn't realised there are more parameters in the oAuthParametersGroup than are mentioned in the OAuth docs. Once again you had it covered I just needed to look properly.
Many thanks
Gordon
Many thanks
Gordon
5
Web Server - Ask For Help / Re: OAuth and emails
« on: September 13, 2022, 12:37:15 AM »
Hi Bruce,
Thanks for replying, I'm doing as you suggest however I never get a refresh token from Google even if I remove the application from the Google list of third party apps and then run it again and confirm it is a valid app.
I may be incorrect but looking online it seems Google needs a couple of parameters setting to get a refresh token, access_type="offline" and prompt="consent", could you please give me a hint as to how and where I would add these parameters. Without the refresh token the users would need to login every hour as that as the life of a Google token, not really practical for our users as automatic emails will go during the night.
Any help will be gratefully received.
Many thanks
Gordon
Thanks for replying, I'm doing as you suggest however I never get a refresh token from Google even if I remove the application from the Google list of third party apps and then run it again and confirm it is a valid app.
I may be incorrect but looking online it seems Google needs a couple of parameters setting to get a refresh token, access_type="offline" and prompt="consent", could you please give me a hint as to how and where I would add these parameters. Without the refresh token the users would need to login every hour as that as the life of a Google token, not really practical for our users as automatic emails will go during the night.
Any help will be gratefully received.
Many thanks
Gordon
6
Web Server - Ask For Help / OAuth and emails
« on: September 12, 2022, 06:04:21 AM »
Hi,
I've finally got round to implementing OAuth for some of our customers whose email accounts will very soon require it.
I've looked at the OAuth example particularly the Google example (I'll need Microsoft too). I understand the login procedure to get a Token and then using that token in the email Authorization string. The element I'm not at all clear on is the use of the token without forcing a login, I get setting OAuthParms.pForce = false and using the stored token doesn't call the login screen, but given the token I receive from Google has a life of one day does this mean I need to request a login everyday or does the rRefreshToken in the parameters group somehow play a part in auto renewing the Token. I'm assuming I need to initialise the OAuth class before sending or receiving emails to ensure I have a valid token, do I only need do this when the token has passed it's expiry date/time or every time?
I don't seems to get a refreshtoken, the value stored in the ini file is always blank.
I've read the documentation but I'm still struggling to understand the basic concept for renewing the token without requiring a user login every time, any advice would be very much appreciated, please assume I know nothing about the process.
Kind Regards
Gordon
I've finally got round to implementing OAuth for some of our customers whose email accounts will very soon require it.
I've looked at the OAuth example particularly the Google example (I'll need Microsoft too). I understand the login procedure to get a Token and then using that token in the email Authorization string. The element I'm not at all clear on is the use of the token without forcing a login, I get setting OAuthParms.pForce = false and using the stored token doesn't call the login screen, but given the token I receive from Google has a life of one day does this mean I need to request a login everyday or does the rRefreshToken in the parameters group somehow play a part in auto renewing the Token. I'm assuming I need to initialise the OAuth class before sending or receiving emails to ensure I have a valid token, do I only need do this when the token has passed it's expiry date/time or every time?
I don't seems to get a refreshtoken, the value stored in the ini file is always blank.
I've read the documentation but I'm still struggling to understand the basic concept for renewing the token without requiring a user login every time, any advice would be very much appreciated, please assume I know nothing about the process.
Kind Regards
Gordon
7
Web Server - Ask For Help / Re: ERROR: -30 Unable to Close connection
« on: January 28, 2022, 01:40:53 AM »
Thanks Bruce.
8
Web Server - Ask For Help / Re: ERROR: -30 Unable to Close connection
« on: January 27, 2022, 05:26:52 AM »
Hi Alberto,
Thank you for the quick reply and link, the curious thing is I do have error messages supressed.
Regards
Gordon
Thank you for the quick reply and link, the curious thing is I do have error messages supressed.
Regards
Gordon
9
Web Server - Ask For Help / ERROR: -30 Unable to Close connection
« on: January 27, 2022, 04:23:02 AM »
My webserver logs the following error on customer's servers, sometimes quite frequently although it carries on running:
ERROR: -30 Unable to Close connection An error occurred while trying to access a memory queue (read or write error). The queue could be full or there is not enough memory
I really don't understand what it is trying to tell me, does anyone have any ideas or know if I should be concerned?
Best Regards
Gordon
ERROR: -30 Unable to Close connection An error occurred while trying to access a memory queue (read or write error). The queue could be full or there is not enough memory
I really don't understand what it is trying to tell me, does anyone have any ideas or know if I should be concerned?
Best Regards
Gordon
10
Web Server - Ask For Help / Re: Initial position in queue loaded drop field
« on: January 12, 2022, 03:19:35 AM »
Hi Bruce,
I'm a little behind I'm on 12.17, I'll upgrade to the latest next week and test the drop lists again.
Many thanks
Gordon
I'm a little behind I'm on 12.17, I'll upgrade to the latest next week and test the drop lists again.
Many thanks
Gordon
11
Web Server - Ask For Help / Initial position in queue loaded drop field
« on: January 10, 2022, 04:34:38 AM »
Is there a way to set the initial position in a queue loaded drop field, for example:
The drop is a simple numeric with a range of 1-100. When the user clicks to get the drop list it always opens starting at 1 rather than positioning at the current field value as a starting point which could be any number in that range. It may seem a minor thing but it's causing some irritation with customers as the new value may be close to the current value but they may have to scroll down quite a bit to get in the correct range.
Any help greatly appreciated, the form in question is a memory form.
Thanks Gordon
The drop is a simple numeric with a range of 1-100. When the user clicks to get the drop list it always opens starting at 1 rather than positioning at the current field value as a starting point which could be any number in that range. It may seem a minor thing but it's causing some irritation with customers as the new value may be close to the current value but they may have to scroll down quite a bit to get in the correct range.
Any help greatly appreciated, the form in question is a memory form.
Thanks Gordon
12
Web Server - Ask For Help / Re: Tree Field Type
« on: January 06, 2022, 05:43:29 AM »
Hi Niels,
Thank you for sharing your solution, I will certainly find a good use for it.
Gordon
Thank you for sharing your solution, I will certainly find a good use for it.
Gordon
13
Web Server - Ask For Help / Re: LetsEncrypt Certificate Renewal
« on: December 16, 2021, 06:35:29 AM »
Hi,
Was this clarified can a webserver run as a service and renew the certificate, I'd like to run my webserver as a service on client machines.
Best Regards
Gordon
Was this clarified can a webserver run as a service and renew the certificate, I'd like to run my webserver as a service on client machines.
Best Regards
Gordon
14
Web Server - Ask For Help / Re: Goto First Page in NetWebBrowse
« on: November 19, 2021, 08:07:53 AM »
Fantastic that worked perfectly I really appreciate your help, fortunately I already had the equivalent of the insert ok ssv so it was only a moments work.
Gordon
Gordon
15
Web Server - Ask For Help / Re: Goto First Page in NetWebBrowse
« on: November 19, 2021, 01:14:59 AM »
Thank you very much for your suggestion, unfortunately it doesn't do what I'm wanting to do.
All I really want to do is go to to the first page of a browse list after a completed insert (only insert), regardless of the actual position of the inserted record.
All I really want to do is go to to the first page of a browse list after a completed insert (only insert), regardless of the actual position of the inserted record.