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: The EmailOAuth example has compile errors (Nettalk 14)
« on: September 26, 2024, 03:54:26 AM »
Thanks Bruce
2
Web Server - Ask For Help / Re: Browse with locator, return position after clicking "Other" type button
« on: September 23, 2024, 07:36:39 AM »
Thanks you for the replies, sorry I'm so late in getting back to you. I will try your idea Ron, failing that I'll create a demo app for you Bruce.
3
Web Server - Ask For Help / The EmailOAuth example has compile errors (Nettalk 14)
« on: September 23, 2024, 07:30:38 AM »
When I try compiling the EmailOAuth demo app (demo.app in example folder Capesoft\nettalk\Email\EmailOAuth\ChromeExplorer) I get various errors relating to methods and fields such as:
Unknown procedure label: ThisSendEmail.PrimeOAuth
and
Field not found: ThisSendEmail.OAuthParms.pClientId
I can't find any reference to PrimeOAuth in any of the class code.
Can anyone point out what I'm missing or doing incorrectly, it must be something obvious but I just can't see it.
Many thanks
Gordon
Unknown procedure label: ThisSendEmail.PrimeOAuth
and
Field not found: ThisSendEmail.OAuthParms.pClientId
I can't find any reference to PrimeOAuth in any of the class code.
Can anyone point out what I'm missing or doing incorrectly, it must be something obvious but I just can't see it.
Many thanks
Gordon
4
Web Server - Ask For Help / Re: Browse with locator, return position after clicking "Other" type button
« on: August 27, 2024, 04:17:08 AM »
Does anyone have any idea how to make this work?
Thanks Gordon
Thanks Gordon
5
Web Server - Ask For Help / Browse with locator, return position after clicking "Other" type button
« on: August 09, 2024, 03:01:35 AM »
I have a need to return to the same highlighted record in a browse after clicking an Other type button on a row.
If I use a locator on the browse, say on a list of names and locate "Smith" and go to the next page in a list of Smiths, clicking the Change button on the row then saving/cancelling the update form returns me to the browse with the same record highlighted. However if I do the same but click an Other type button on the browse row and then close the called page the browse return with the first Smith highlighted not the record I was on.
I'm using Nettalk Server 14.25
I'd really appreciate any ideas as to how I can make an Other type button behave like the Change button in this regard.
If I use a locator on the browse, say on a list of names and locate "Smith" and go to the next page in a list of Smiths, clicking the Change button on the row then saving/cancelling the update form returns me to the browse with the same record highlighted. However if I do the same but click an Other type button on the browse row and then close the called page the browse return with the first Smith highlighted not the record I was on.
I'm using Nettalk Server 14.25
I'd really appreciate any ideas as to how I can make an Other type button behave like the Change button in this regard.
6
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
7
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.
8
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.
9
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
10
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
11
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
12
Web Server - Ask For Help / Re: ERROR: -30 Unable to Close connection
« on: January 28, 2022, 01:40:53 AM »
Thanks Bruce.
13
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
14
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
15
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