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.
286
Web Server - Ask For Help / Re: Disconnected app fields?
« on: December 19, 2018, 08:24:39 AM »
To be clear, I'm talking about the "external name" for the field, not the "column name". The only reason I ask is to make the table relationships a bit more obvious.
That said, if the templates will look at the external name then I think my feet already have enough scars and shooting them gratuitously over this sounds like an inadvisable strategy.
Thanks, Bruce.
Jane
That said, if the templates will look at the external name then I think my feet already have enough scars and shooting them gratuitously over this sounds like an inadvisable strategy.
Thanks, Bruce.
Jane
287
Web Server - Ask For Help / Re: Disconnected app fields?
« on: December 18, 2018, 12:50:58 PM »
Another question.
The NT docs say that each qualifying table needs to have a GUID field.
Is there a problem if that field has a more descriptive external name (such as locationId) ?
Thanks.
jf
The NT docs say that each qualifying table needs to have a GUID field.
Is there a problem if that field has a more descriptive external name (such as locationId) ?
Thanks.
jf
288
Web Server - Ask For Help / Re: Bind server to list of IP addresses?
« on: December 11, 2018, 08:45:46 AM »
You mean a NetTalk server?
Or an actual Windows server? (yes)
Or?
Or an actual Windows server? (yes)
Or?
289
Web Server - Ask For Help / Re: Disconnected app fields?
« on: December 11, 2018, 08:44:22 AM »
Thanks, guys!
290
Web Server - Ask For Help / Disconnected app fields?
« on: December 10, 2018, 04:43:53 PM »
I'm starting to lay out a new dictionary for an app which will start out life as a desktop app accessing MS SQL, but which I hope to extend to a disconnected PWA a few months down the road.
Is there any problem with declaring the string fields in the dictionary as CSTRING rather than as STRING? I would prefer the interaction with the SQL server be as varchars.
Thanks.
jf
Is there any problem with declaring the string fields in the dictionary as CSTRING rather than as STRING? I would prefer the interaction with the SQL server be as varchars.
Thanks.
jf
291
The Rest - Ask For Help / Re: NetWebClient cant reach out to the net - except when elevated
« on: December 10, 2018, 02:47:34 PM »
Sometimes lucky trumps good!
Good job!
jf
Good job!
jf
292
The Rest - Ask For Help / Re: NetWebClient cant reach out to the net - except when elevated
« on: December 08, 2018, 10:19:31 AM »
Mark,
Weird. Is the behavior the same on all machines on which you try running it?
FWIW, I have asInvoker web clients accessing https API servers without issue, the clients running on Win 10 or Server 2012R2 (which is binary family with Win 8.1).
But... one thing you might try... check permissions on this folder and as a test, add Modify for Everyone: C:\ProgramData\Microsoft\Crypto\RSA
Just grasping at straws here because asAdministrator works for you. Your regular account may not be able to do the https encryption stuff.
Jane
Weird. Is the behavior the same on all machines on which you try running it?
FWIW, I have asInvoker web clients accessing https API servers without issue, the clients running on Win 10 or Server 2012R2 (which is binary family with Win 8.1).
But... one thing you might try... check permissions on this folder and as a test, add Modify for Everyone: C:\ProgramData\Microsoft\Crypto\RSA
Just grasping at straws here because asAdministrator works for you. Your regular account may not be able to do the https encryption stuff.
Jane
293
Web Server - Ask For Help / Re: Get DeviceID
« on: December 06, 2018, 07:57:03 AM »
I'll be doing a walkthrough of a NetTalk created disconnected app during the ClarionLive weekly webinar on Friday, December 21st. Bruce should be there as well. This would be a great opportunity to ask questions.
Very much looking forward to the webinar, Don.
And thanks so much for your work on mbuild!
Jane
294
Web Server - Ask For Help / Re: best way to populate In Memory table
« on: November 24, 2018, 02:50:54 PM »
Jeff,
I picked this procedure some years ago (think it may have been posted by Arnor). It just closes, deletes, and recreates a memory table. (Or any table, for that matter).
Obviously, you will need to open() and usefile afterwards if your code is expecting the table to be open.
The parameter is the name of the file manager object. EmptyIMDDtable(access:Invoices)
EmptyIMDDtable PROCEDURE (FileManager pFM) ! Declare Procedure
CODE
Loop pFM.GetOpened() TIMES
pFM.close()
end ! loop
remove(pFM.File)
create(pFM.File)
return
I picked this procedure some years ago (think it may have been posted by Arnor). It just closes, deletes, and recreates a memory table. (Or any table, for that matter).
Obviously, you will need to open() and usefile afterwards if your code is expecting the table to be open.
The parameter is the name of the file manager object. EmptyIMDDtable(access:Invoices)
EmptyIMDDtable PROCEDURE (FileManager pFM) ! Declare Procedure
CODE
Loop pFM.GetOpened() TIMES
pFM.close()
end ! loop
remove(pFM.File)
create(pFM.File)
return
295
Web Server - Ask For Help / Re: PWA Development
« on: November 23, 2018, 08:39:57 AM »
"Sophisticated" I like the sound of that... 
Vic,
Here are links that give more information on this trick:
http://www.petenetlive.com/KB/Article/0000830
https://community.spiceworks.com/topic/566556-ssl-certificates-internal-use-and-external-use
jf
Vic,
Here are links that give more information on this trick:
http://www.petenetlive.com/KB/Article/0000830
https://community.spiceworks.com/topic/566556-ssl-certificates-internal-use-and-external-use
jf
296
Web Server - Share Knowledge / In praise of Fastmem
« on: November 22, 2018, 03:32:06 PM »
Related to NT, in that my experience involves an NT web server.
Capesoft's advertising for this product says "an alternative memory
allocator which is much faster than the default one for specific
situations."
I must have one of those situations.
I've built a service that ingests a fairly complicated clump of JSON from an
API. This runs every 75 seconds.
As I watched the time for the ingestion, I found that the actual network
traffic takes about 10-15 seconds to receive the packet and then 45 to 70
seconds to parse the JSON and dump it into a memory table.
I'm using jFiles (because it has the correct initials!), but tried cjson
with a bit slower results.
Then... added Fastmem to my API ingester. Whoosh. The pics show it all.
Pretty cool improvement for 20 bucks, I'd say.
jf
Capesoft's advertising for this product says "an alternative memory
allocator which is much faster than the default one for specific
situations."
I must have one of those situations.
I've built a service that ingests a fairly complicated clump of JSON from an
API. This runs every 75 seconds.
As I watched the time for the ingestion, I found that the actual network
traffic takes about 10-15 seconds to receive the packet and then 45 to 70
seconds to parse the JSON and dump it into a memory table.
I'm using jFiles (because it has the correct initials!), but tried cjson
with a bit slower results.
Then... added Fastmem to my API ingester. Whoosh. The pics show it all.
Pretty cool improvement for 20 bucks, I'd say.
jf
297
Web Server - Ask For Help / Re: PWA Development
« on: November 22, 2018, 08:28:28 AM »
And if you follow the Rube Goldberg approach I outline in my earlier post
It does require an IT staff with a modicum of sophistication to be able to configure their internal DNS appropriately.
(We didn't invent this approach. Our IT director dredged it out of spiceworks. Tell that to your bank's IT to make a good impression
)
jf
- you will not get scary messages
- nobody will have to accept certificates
- you will have https connections on your internal LAN with name-matching verified by a commercial cert.
- this works on our Chromeboxes so there's no reason it shouldn't be fine on an Android or IOS device.
It does require an IT staff with a modicum of sophistication to be able to configure their internal DNS appropriately.
(We didn't invent this approach. Our IT director dredged it out of spiceworks. Tell that to your bank's IT to make a good impression
)jf
298
Web Server - Ask For Help / Re: PWA Development
« on: November 17, 2018, 10:49:08 AM »
I don't know the answer, Vic, but of course that won't stop me from opining.
We have an analogous situation - not involving PWAs but rather where we have a NetTalk webserver app that needs to be run on ChromeBoxes (where we can't import certificates) managed through Rise Vision.
So we use a store-bought Godaddy cert.
Of course, you can't get a public cert for a machine that's on a non-public domain (www.mywebserver.local)
Soooo...
1. We buy an "extra" public domain just for convenience purposes (MyDummyDomain.me).
2. Use that "extra" domain to buy the cert we need (www.mywebserver.MyDummyDomain.me) This is NOT actually a server that is accessible on the Internet. -- Actually, we use this enough that we bought a wildcard *.MyDummyDomain.me cert rather than hassling with multiple Subject Alternative Names.
3. Create a one-machine domain in our Active Directory DNS (forward lookup zone called "mywebserver.MyDummyDomain.me"). (We create a separate one-machine forward lookup zone for EACH webserver where we're using this trick.)
4. In that one-machine domain, create a Host(A) record leaving the name blank - as the window says, "(uses parent domain if left blank)". Give that A record the address for the web server.
5. Apply the Godaddy SSL cert to the web server.
In practice, I also create a certificate on our in-house Active Directory-trusted certificate authority with the internal LAN name for the web server, and apply that certificate to the web server as well.
It's a bit Rube Goldberg, but all is happy for both domain-joined Windows machines using the internal LAN name and for the non-domain ChromeBoxes using the MyDummyDomain.me URL.
jf
We have an analogous situation - not involving PWAs but rather where we have a NetTalk webserver app that needs to be run on ChromeBoxes (where we can't import certificates) managed through Rise Vision.
So we use a store-bought Godaddy cert.
Of course, you can't get a public cert for a machine that's on a non-public domain (www.mywebserver.local)
Soooo...
1. We buy an "extra" public domain just for convenience purposes (MyDummyDomain.me).
2. Use that "extra" domain to buy the cert we need (www.mywebserver.MyDummyDomain.me) This is NOT actually a server that is accessible on the Internet. -- Actually, we use this enough that we bought a wildcard *.MyDummyDomain.me cert rather than hassling with multiple Subject Alternative Names.
3. Create a one-machine domain in our Active Directory DNS (forward lookup zone called "mywebserver.MyDummyDomain.me"). (We create a separate one-machine forward lookup zone for EACH webserver where we're using this trick.)
4. In that one-machine domain, create a Host(A) record leaving the name blank - as the window says, "(uses parent domain if left blank)". Give that A record the address for the web server.
5. Apply the Godaddy SSL cert to the web server.
In practice, I also create a certificate on our in-house Active Directory-trusted certificate authority with the internal LAN name for the web server, and apply that certificate to the web server as well.
It's a bit Rube Goldberg, but all is happy for both domain-joined Windows machines using the internal LAN name and for the non-domain ChromeBoxes using the MyDummyDomain.me URL.
jf
299
Web Server - Ask For Help / Re: nettalk 11 inspect console errors ?
« on: November 08, 2018, 01:10:15 PM »
Although these errors *sound* as if the files in question are not valid, my experience has been that they actually mean those files do not exist.
Either add dummy zero-byte files with those names in your web folder or else remove them from the NetWebServer extension template if you don't plan to be adding any custom CSS.
jf
Either add dummy zero-byte files with those names in your web folder or else remove them from the NetWebServer extension template if you don't plan to be adding any custom CSS.
jf
300
Web Server - Ask For Help / Re: NetTalk Server being shut down - Virutal Server
« on: November 07, 2018, 08:22:37 PM »
If you have GPF reporter, add that to the app and see whether it's actually crashing rather than being forced to close by the OS.