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.
16
Web Server - Ask For Help / Re: NT11 TLS Program Load Error
« on: November 20, 2018, 12:40:23 PM »
Figured it out!!
In the ThisWebServer Template the Host Names (CSL) was set to 'localhost'. No idea how that happened but once I changed it back to Set:Domains all was good.
In the ThisWebServer Template the Host Names (CSL) was set to 'localhost'. No idea how that happened but once I changed it back to Set:Domains all was good.
17
Web Server - Ask For Help / Re: NT11 TLS Program Load Error
« on: November 20, 2018, 06:38:07 AM »
NT 11.02 fixed the load error with MSVCR120. However, I'm still getting an error when configuring a secure site. The error I am getting is:
[4776] SSL_Our_ServerListen : SSL Error. Could not load Certificate File. rl_SSL_CTX_use_certificate_chain_file [C:\pnpStorage\certificates\localhost.crt] returns 0
My NT settings do not reference localhost anywhere. I did a text search through the generated files in my code folder and accessories\libsrc & templates and there is no reference to localhost. The localhost.crt file is not in the Certificates folder.
If I delete all certificate information, check "Testing", and Click certificates I get a test certificate and I can browse my website on port 443. I do get a certificate is invalid message which I expect. If I uncheck "Testing" and restart my web server I get the localhost.crt error. If I then check "Testing", Certificates I am again able to browse the website with an invalid certificate. Below are my ServerSettings
-<ServerSettings>
<set.secureport>443</set.secureport>
<set.insecureport>80</set.insecureport>
<set.accountname>pnpStorage.com</set.accountname>
<set.domains>www.pnpStorage.com</set.domains>
<set.certificatesfolder>C:\pnpStorage\certificates</set.certificatesfolder>
<set.lastcertificatecheckdate>79585</set.lastcertificatecheckdate>
<set.staging>1</set.staging>
<set.webfolder>C:\pnpStorage\web</set.webfolder>
<set.acmefolder>C:\pnpStorage\web</set.acmefolder>
<set.bindtoipaddress>192.168.10.211</set.bindtoipaddress>
<set.sessiontimeout>90001</set.sessiontimeout>
<set.xframeoptions>sameorigin</set.xframeoptions>
<set.accesscontrolalloworigin/>
<set.stricttransportsecurity/>
<set.contentsecuritypolicy/>
<set.contentsecuritypolicyreportonly/>
<set.referrerpolicy>strict-origin-when-cross-origin</set.referrerpolicy>
</ServerSettings>
[4776] SSL_Our_ServerListen : SSL Error. Could not load Certificate File. rl_SSL_CTX_use_certificate_chain_file [C:\pnpStorage\certificates\localhost.crt] returns 0
My NT settings do not reference localhost anywhere. I did a text search through the generated files in my code folder and accessories\libsrc & templates and there is no reference to localhost. The localhost.crt file is not in the Certificates folder.
If I delete all certificate information, check "Testing", and Click certificates I get a test certificate and I can browse my website on port 443. I do get a certificate is invalid message which I expect. If I uncheck "Testing" and restart my web server I get the localhost.crt error. If I then check "Testing", Certificates I am again able to browse the website with an invalid certificate. Below are my ServerSettings
-<ServerSettings>
<set.secureport>443</set.secureport>
<set.insecureport>80</set.insecureport>
<set.accountname>pnpStorage.com</set.accountname>
<set.domains>www.pnpStorage.com</set.domains>
<set.certificatesfolder>C:\pnpStorage\certificates</set.certificatesfolder>
<set.lastcertificatecheckdate>79585</set.lastcertificatecheckdate>
<set.staging>1</set.staging>
<set.webfolder>C:\pnpStorage\web</set.webfolder>
<set.acmefolder>C:\pnpStorage\web</set.acmefolder>
<set.bindtoipaddress>192.168.10.211</set.bindtoipaddress>
<set.sessiontimeout>90001</set.sessiontimeout>
<set.xframeoptions>sameorigin</set.xframeoptions>
<set.accesscontrolalloworigin/>
<set.stricttransportsecurity/>
<set.contentsecuritypolicy/>
<set.contentsecuritypolicyreportonly/>
<set.referrerpolicy>strict-origin-when-cross-origin</set.referrerpolicy>
</ServerSettings>
18
Web Server - Ask For Help / Re: NT11 TLS Program Load Error
« on: November 15, 2018, 08:35:20 AM »
I reinstalled NetTalk 11.01 just to be sure.
Looking at the properties of the files in C:\Clarion11\accessory\bin
OpenSSL.exe - dated 8/14/2018, there is no version number
CLANET.DLL - dated 11/9/2018, there is no version number
libcrypto-1_1.dll - 1.1.0.9
libssl-1_1.dll - 1.1.0.9
So it looks like I don't have the new versions of libcrypto or libssl. Is there another place the new files are installed other than the accessory\bin folder?
Looking at the properties of the files in C:\Clarion11\accessory\bin
OpenSSL.exe - dated 8/14/2018, there is no version number
CLANET.DLL - dated 11/9/2018, there is no version number
libcrypto-1_1.dll - 1.1.0.9
libssl-1_1.dll - 1.1.0.9
So it looks like I don't have the new versions of libcrypto or libssl. Is there another place the new files are installed other than the accessory\bin folder?
19
Web Server - Ask For Help / NT11 TLS Program Load Error
« on: November 14, 2018, 12:22:10 PM »
NT 11.01, LetsEncrypt
I've installed Visual Studio 2017 (x86) runtime. In reading the NT documentation Msvcr120.dll has a line through it which makes me believe I no longer need it since I installed VS 2017 runtime. Note, the installed VS runtime is not in my program folder but wherever the installer put it. I'm not sure where to go from here.
If I delete Msvcr120.dll then I get the following error:
[st] [netTalk][thread=1] NetSimple.ErrorTrap -73 Unable to Listen on TCP Port 443 NetSimple(Server).Open
With Msvcr120.dll in the program folder I get the following error and my site will not load:
SSL_Our_ServerListen : SSL Error. Could not load Certificate File. rl_SSL_CTX_use_certificate_chain_file [C:\myapp\certificates\localhost.crt] returns 0
I've installed Visual Studio 2017 (x86) runtime. In reading the NT documentation Msvcr120.dll has a line through it which makes me believe I no longer need it since I installed VS 2017 runtime. Note, the installed VS runtime is not in my program folder but wherever the installer put it. I'm not sure where to go from here.
If I delete Msvcr120.dll then I get the following error:
[st] [netTalk][thread=1] NetSimple.ErrorTrap -73 Unable to Listen on TCP Port 443 NetSimple(Server).Open
With Msvcr120.dll in the program folder I get the following error and my site will not load:
SSL_Our_ServerListen : SSL Error. Could not load Certificate File. rl_SSL_CTX_use_certificate_chain_file [C:\myapp\certificates\localhost.crt] returns 0
20
Web Server - Ask For Help / NetWebForm - File Upload Using StringTheory
« on: October 01, 2018, 04:28:00 AM »
NT 10.34
I'm trying to use a StringTheory object as the storage for a Text field and a file upload field in a NetWebForm. In the local data I added 2 fields both as Type StringTheory. Once compiled I get errors because the Nettalk template generated code is still treating those fields as variables and trying to assign data to/from them.
example: p_web.SetSessionValue('stUploadedData',stUploadedData)
In the NetTalk Usergroup video 202 Ashley had a question about uploading 3 files and Bruce showed him how to set the local fields as Type StringTheory. I was using this as the bases for my setup. What step am I missing?
I'm trying to use a StringTheory object as the storage for a Text field and a file upload field in a NetWebForm. In the local data I added 2 fields both as Type StringTheory. Once compiled I get errors because the Nettalk template generated code is still treating those fields as variables and trying to assign data to/from them.
example: p_web.SetSessionValue('stUploadedData',stUploadedData)
In the NetTalk Usergroup video 202 Ashley had a question about uploading 3 files and Bruce showed him how to set the local fields as Type StringTheory. I was using this as the bases for my setup. What step am I missing?
21
Web Server - Ask For Help / Re: net.Post(URL) - what can I send to debugview to see what i'm posting
« on: May 02, 2018, 09:02:04 AM »
Thank you bshields, I ended up running one of my apps and posting the data to it.
Don, I'll give your suggestion a try. Thank you.
Don, I'll give your suggestion a try. Thank you.
22
Web Server - Ask For Help / Re: net.Post(URL) - what can I send to debugview to see what i'm posting
« on: May 02, 2018, 05:50:06 AM »
Thank you for your response. I do use trace to send things to debugview. My issue is i'm trying to see what information the POST() method is sending to the URL. Per the Nettalk documentation @ http://www.capesoft.com/docs/NetTalk10/NetTalkWebClient.Htm#Post i'm doing the following:
net.SetValue('CustomerName','Charlie')
net.SetValue('Company','Capesoft')
net.Post(url)
I want to see what net.Post is sending
net.SetValue('CustomerName','Charlie')
net.SetValue('Company','Capesoft')
net.Post(url)
I want to see what net.Post is sending
23
Web Server - Ask For Help / net.Post(URL) - what can I send to debugview to see what i'm posting
« on: May 01, 2018, 04:49:56 AM »
NT10
What embed would I use and method to post to debugview what I'm posting?
Thank you.
What embed would I use and method to post to debugview what I'm posting?
Thank you.
24
Web Server - Ask For Help / Re: Disconnected Desktop - Server Not Writing Records to TPS File
« on: June 21, 2016, 05:49:19 AM »
Thank you, I have emailed a zip of the apps and dictionaries.
25
Web Server - Ask For Help / Disconnected Desktop - Server Not Writing Records to TPS File
« on: June 20, 2016, 04:26:03 AM »
I have a Wizard created server, no changes, and a desktop client app. The servers is writing to TPS files in the same folder as the server and the client is using a copy of the dct with the database driver set to memory. When I add a record to the client and then click 'Start', on the ServerSync window, syncing runs and tells me 1 record was sent. I can see in the log on the server that it is receiving information from the client. However, looking at the TPS file on the server side the record wasn't added.
Is there some obvious things I can check and then maybe some tips on how to trace this down if the obvious doesn't work?
Below is the JSON the server log is showing.
{
"token" : "",
"table" : "objects",
"action" : "sync",
"everythingafter" : 0,
"objects" : [
{
"guid" : "IC0CHF4CO6TRYWSD",
"ts" : 1466425346200,
"sts" : 0,
"dts" : 0,
"description" : "Obj1",
"retired" : "",
"retireddate" : 0,
"dateadded" : 78702,
"whoadded" : "",
"searchstring" : ""
},
{
"guid" : "FOTSTU5O6A6VY4JY",
"ts" : 1466425871045,
"sts" : 0,
"dts" : 0,
"description" : "Obj2",
"retired" : "",
"retireddate" : 78531,
"dateadded" : 78702,
"whoadded" : "me",
"searchstring" : "me"
}
]
}
Is there some obvious things I can check and then maybe some tips on how to trace this down if the obvious doesn't work?
Below is the JSON the server log is showing.
{
"token" : "",
"table" : "objects",
"action" : "sync",
"everythingafter" : 0,
"objects" : [
{
"guid" : "IC0CHF4CO6TRYWSD",
"ts" : 1466425346200,
"sts" : 0,
"dts" : 0,
"description" : "Obj1",
"retired" : "",
"retireddate" : 0,
"dateadded" : 78702,
"whoadded" : "",
"searchstring" : ""
},
{
"guid" : "FOTSTU5O6A6VY4JY",
"ts" : 1466425871045,
"sts" : 0,
"dts" : 0,
"description" : "Obj2",
"retired" : "",
"retireddate" : 78531,
"dateadded" : 78702,
"whoadded" : "me",
"searchstring" : "me"
}
]
}
26
Web Server - Ask For Help / NT8 - NetWebBrowse Filter - BINDing a procedure
« on: April 01, 2015, 05:01:47 PM »
I have a many to many relationship and am using a 3rd table to link the other two. In a NetWebBrowse I want to filter if there is a record in the link table. To do this, I have a source procedure, TagLink(string xTagRecordID, string xMyRecordID), LONG. This procedure returns a 1 if there is a link between the two tables.
My filter is: 'TagLink(TAG:TagID, p_web.GSV(<39>OBJ:ObjectID<39>)) = 1'
I am assuming I need to do a BIND('TagLink', TagLink) at the beginning of NetWebBrowse procedure so that it will work correctly in the filter. However, C10 is giving me the following compile error on the BIND line of code.
Attribute variable must have string type
Is there a different way to do this or am I missing something on BIND?
Thank you for your assistance.
David
My filter is: 'TagLink(TAG:TagID, p_web.GSV(<39>OBJ:ObjectID<39>)) = 1'
I am assuming I need to do a BIND('TagLink', TagLink) at the beginning of NetWebBrowse procedure so that it will work correctly in the filter. However, C10 is giving me the following compile error on the BIND line of code.
Attribute variable must have string type
Is there a different way to do this or am I missing something on BIND?
Thank you for your assistance.
David
27
Web Server - Ask For Help / Browse Filter - getting the table record ID field
« on: February 16, 2015, 05:53:27 PM »
I have a browse on a department table and I want to filter based on the DEP:RecordID field. In the template filter field I have tried DEP:RecordID and p_web.GSV('DEP:RecordID') both return blank data. I have looked at the actual table and the DEP:RecordID field has data in it.
How do I get the data in that field?
Thank you,
David
How do I get the data in that field?
Thank you,
David
28
Web Server - Ask For Help / Re: WebClient - Pull SSL Cert Information
« on: May 09, 2014, 05:18:51 AM »
Bruce, I would think with the recent Heartbleed issue that everyone would want to check the SSL Cert date to ensure it's been reissued. :-)
I would much rather the Client Web Services get your attention than this.
I thought that I might have this figured out myself by using the following property but I guess not.
NetSimple.SSLGetIssuerField()
I would much rather the Client Web Services get your attention than this.
I thought that I might have this figured out myself by using the following property but I guess not.
NetSimple.SSLGetIssuerField()
29
Web Server - Ask For Help / Re: NT8.10 - New Wizarded WebServer App Hangs
« on: May 09, 2014, 05:11:39 AM »
Bruce, setting Keep-Alive to 0 fixed the issue. Thank you.
30
Web Server - Ask For Help / NT8.10 - New Wizarded WebServer App Hangs
« on: May 08, 2014, 07:22:00 PM »
[netTalk][thread=3] NetWebServer.cleanServerConnection Error. Could not find data connection in the DataConnection queue
The web server runs, but when I browse to a webpage, the browser hangs for about 30 seconds and then I get the above error in DebugView.
The web server runs, but when I browse to a webpage, the browser hangs for about 30 seconds and then I get the above error in DebugView.