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: Charset?
« on: November 26, 2020, 04:32:13 AM »
Hi Bruce,
>>what version did you upgrade _from_ ?
Was 11.35 and today updated to 11.47.
>> Generally speaking setting store-as to utf-8 is not ideal in Clarion 11 and below because (extended ansi) data stored as utf-8 cannot be displayed on a Clarion window or report. So generally I advise against setting store-as to utf-8 for old clarions.
It's on "Capesoft/NetTalk/NetTalkWebFunctionality.htm" "Web Server Procedure Extension" describing "Advanced Tab". Ok.
Web51 example is working even with store data as utf-8 or portuguese.
>> a) you have the login screen open in your browser, and then you are stopping (compiling?) starting the server. That login screen will then fail (because the server doesn't know what you are looking at.)
Initially I was closing tab, reopened and test but when trying traces end up compiling and starting server with screen opened. Now I'm closing browser, open new tab and test.
>> b) In the login procedure there is a call to SetSessionLoggedIn(false). This line can clash with a security setting (change SessionId on log in/out). So if you have this line, comment it out.
There's one call on "Generate Form" routine, but it doesn't make any difference.
Before calling ds_LogInUser all UserLoginOptions are correct but result is zero that I suppose that it didn't found the user. Is Charset could affect GUID in dssw5.tps?
Thank you.
Regards,
Marcos
>>what version did you upgrade _from_ ?
Was 11.35 and today updated to 11.47.
>> Generally speaking setting store-as to utf-8 is not ideal in Clarion 11 and below because (extended ansi) data stored as utf-8 cannot be displayed on a Clarion window or report. So generally I advise against setting store-as to utf-8 for old clarions.
It's on "Capesoft/NetTalk/NetTalkWebFunctionality.htm" "Web Server Procedure Extension" describing "Advanced Tab". Ok.
Web51 example is working even with store data as utf-8 or portuguese.
>> a) you have the login screen open in your browser, and then you are stopping (compiling?) starting the server. That login screen will then fail (because the server doesn't know what you are looking at.)
Initially I was closing tab, reopened and test but when trying traces end up compiling and starting server with screen opened. Now I'm closing browser, open new tab and test.
>> b) In the login procedure there is a call to SetSessionLoggedIn(false). This line can clash with a security setting (change SessionId on log in/out). So if you have this line, comment it out.
There's one call on "Generate Form" routine, but it doesn't make any difference.
Before calling ds_LogInUser all UserLoginOptions are correct but result is zero that I suppose that it didn't found the user. Is Charset could affect GUID in dssw5.tps?
Thank you.
Regards,
Marcos
2
Web Server - Ask For Help / Re: GUID and SQL Views
« on: November 25, 2020, 08:17:46 PM »
Just for information on SQL composite keys. I had to add GUID unique key to the last component of the composite key turning into a unique key to avoid browser showing duplicated entries and other issues. So I had to create all keys as unique.
Regards,
Marcos
Regards,
Marcos
3
Web Server - Ask For Help / Charset?
« on: November 25, 2020, 07:46:20 PM »
Hi Bruce,
I have hybrid application that runs Desktop and Web Server on the same TPS database. It always worked fine using Secwin.
But with NT 11.44 I upgraded Desktop application as usual and it's running ok but Web Server in SecwinWebLoginForm didn't worked simply closing on *any* input right or wrong user credentials returning to IndexPage withou showing any message. I tried traces in many ponts in SecwinWebLoginForm and seems that I didn't processed any login request in any pont before and after login.
Comparing with web51 example I've noticed that on Web Server settings charset is utf-8 and store data is utf-8 too running ok. Documentation says that store data shouldn't be utf-8 because Web Server can't show correct page code. Is that still correct?
But when I change my application from store "portuguese" to utf-8 Login start to work again but it does not recognizes *any* user denying login and presenting odd characters in the pages when I have accentuation because of charset. So I've returned back storage data to "portuguese" and remains the same allowing login but don't recognizing any user on the same dssw5.tps file that works ok with Desktop application. User names and passwords don't have any latin character.
I'm still using Clarion 8 and I know that it could be a problem but is there any turn around for now?
Thank you.
Marcos
I have hybrid application that runs Desktop and Web Server on the same TPS database. It always worked fine using Secwin.
But with NT 11.44 I upgraded Desktop application as usual and it's running ok but Web Server in SecwinWebLoginForm didn't worked simply closing on *any* input right or wrong user credentials returning to IndexPage withou showing any message. I tried traces in many ponts in SecwinWebLoginForm and seems that I didn't processed any login request in any pont before and after login.
Comparing with web51 example I've noticed that on Web Server settings charset is utf-8 and store data is utf-8 too running ok. Documentation says that store data shouldn't be utf-8 because Web Server can't show correct page code. Is that still correct?
But when I change my application from store "portuguese" to utf-8 Login start to work again but it does not recognizes *any* user denying login and presenting odd characters in the pages when I have accentuation because of charset. So I've returned back storage data to "portuguese" and remains the same allowing login but don't recognizing any user on the same dssw5.tps file that works ok with Desktop application. User names and passwords don't have any latin character.
I'm still using Clarion 8 and I know that it could be a problem but is there any turn around for now?
Thank you.
Marcos
4
Web Server - Ask For Help / Re: NT 11.07 updated from NT11.04
« on: March 12, 2019, 09:40:40 AM »
Thank you Bruce!
Best regards,
Marcos Sibuya
Best regards,
Marcos Sibuya
5
Web Server - Ask For Help / NT 11.07 updated from NT11.04
« on: March 11, 2019, 12:16:19 PM »
Hi,
After update a compilation error saying that "i64.inc" is not found in NetHttp.Clw. I didn't found this file in any place.
Clarion 8 EE.
Tia.
Best regard,
Marcos Sibuya
After update a compilation error saying that "i64.inc" is not found in NetHttp.Clw. I didn't found this file in any place.
Clarion 8 EE.
Tia.
Best regard,
Marcos Sibuya
6
Web Server - Ask For Help / Re: Admin app - how
« on: January 20, 2019, 05:39:37 AM »
Hi Peter,
I'm using SecWin to manage all access.
Best regards,
Marcos Sibuya
I'm using SecWin to manage all access.
Best regards,
Marcos Sibuya
7
Web Server - Ask For Help / Re: Secure Webserver: is TLS depending on the OS?
« on: January 14, 2019, 05:10:32 AM »
HI Wolfgang,
Windows depends on Cryptographic API to use cyphers.
You should check if Server 2008 is updated.
Another check is if you are running the application with correct rights because Server is more strict in this matter.
Best regards,
Marcos Sibuya
Windows depends on Cryptographic API to use cyphers.
You should check if Server 2008 is updated.
Another check is if you are running the application with correct rights because Server is more strict in this matter.
Best regards,
Marcos Sibuya
8
Web Server - Ask For Help / Re: NT10 Letsencrypt and DNS
« on: January 14, 2019, 04:38:40 AM »
Hi,
This is a low budget project and I'm preparing to deploy it.
I'm just trying to figure out on how to renew LE automatically using Duckdns.org provider.
I renwed LE manually using Certbot in Windows 10 Ubuntu and have to create scripts to be done because it depends on dynamic dns provider specific commands to set and clear TXT DNS record.
I'll study a way to do it by using Certbot.
The explosion of LE is remarkable because big companies like IBM are using it in their products.
Thank you guys!
Best regards,
Marcos Sibuya
This is a low budget project and I'm preparing to deploy it.
I'm just trying to figure out on how to renew LE automatically using Duckdns.org provider.
I renwed LE manually using Certbot in Windows 10 Ubuntu and have to create scripts to be done because it depends on dynamic dns provider specific commands to set and clear TXT DNS record.
I'll study a way to do it by using Certbot.
The explosion of LE is remarkable because big companies like IBM are using it in their products.
Thank you guys!
Best regards,
Marcos Sibuya
9
Web Server - Ask For Help / NT10 Letsencrypt and DNS
« on: January 12, 2019, 10:56:32 AM »
Hi,
Port 80 is blocked by my ISP and I'm unable to present challenge to Letsencrypt using http file challenge and Letsencrypt don't allows me to change port number to other than 80.
There's another way to do this using dns challenging where challenge is set in DNS TXT record. I'm using dynamic DNS duckdns.org and with a simple GET I could set and clear DNS TXT record.
Is there a way to use this challenge option?
Thank you.
Best regards,
Marcos Sibuya
Port 80 is blocked by my ISP and I'm unable to present challenge to Letsencrypt using http file challenge and Letsencrypt don't allows me to change port number to other than 80.
There's another way to do this using dns challenging where challenge is set in DNS TXT record. I'm using dynamic DNS duckdns.org and with a simple GET I could set and clear DNS TXT record.
Is there a way to use this challenge option?
Thank you.
Best regards,
Marcos Sibuya
10
Web Server - Ask For Help / Re: NT11 - jFiles 1.72 - Fastmem - InMemory Driver
« on: January 04, 2019, 02:18:41 AM »
Hi Bruce,
Unfortunally I don't have the reader to test because it was deployed. I will ask for another one when available to test and let you know.
Thank you.
Best regards,
Marcos Sibuya
Unfortunally I don't have the reader to test because it was deployed. I will ask for another one when available to test and let you know.
Thank you.
Best regards,
Marcos Sibuya
11
Web Server - Ask For Help / Re: NT11 - jFiles 1.72 - Fastmem - InMemory Driver
« on: December 28, 2018, 03:31:20 AM »
Hi Bruce,
Thank you for advice. You are right I agree with you.
TCP stack assembles network packages and could send truncated large chunk of data up to interface metric that is in general 1500. Should I consider that NetSimple in Process routine and NET:SimplePartialDataPacket could get a Packet truncated or you wait up to a end delimiter or a timeout to close a Packet and make it available to the application to parse?
Considering that the Package could have many Json structures separeted byt CR/LF could Json crash due max size or any other invalid character in the Package? Or even invalid structures inside due corrupt Package? I'm delimiting Max string size with 499 bytes.
Thank you.
Best regards,
Marcos Sibuya
Thank you for advice. You are right I agree with you.
TCP stack assembles network packages and could send truncated large chunk of data up to interface metric that is in general 1500. Should I consider that NetSimple in Process routine and NET:SimplePartialDataPacket could get a Packet truncated or you wait up to a end delimiter or a timeout to close a Packet and make it available to the application to parse?
Considering that the Package could have many Json structures separeted byt CR/LF could Json crash due max size or any other invalid character in the Package? Or even invalid structures inside due corrupt Package? I'm delimiting Max string size with 499 bytes.
Thank you.
Best regards,
Marcos Sibuya
12
Web Server - Ask For Help / Re: NT11 - jFiles 1.72 - Fastmem - InMemory Driver
« on: December 26, 2018, 09:54:38 AM »
Hi Oggy and Bruce,
Attached is my application. Sorry but it's portuguese but if you mind I could translate to better understanding.
Application is a standalone exe application (lib) not using multi DLL.
In dictionary you'll see MSSQL table Portal and ASCII file Template that are used to record results after processing in Memory tables. MSSQL or ASCII are optional to the user and using ASCII for tests.
Application will open Window "Leituras" using Net Simple to get messages from RFID reader that sends RFID tags information in one structure saying from what antenna read the tag.
All messages are sending with CR/LF at the end of each one and does not come more than one structure in one message.
Processing consists on determine tag direction of travel getting in's (Entradas) and out's (Saidas) from a portal with 4 antennas two for input and two for output. I'm doing this in memory tables. I have to determine direction of travel and after some time (configured) I have to delete from memory tables using another window named "Vida Tag" or "Tag lifetime".
There are more two windows that the support and install team can "monitor" what happens with memory tables in timed fashion about aproximately one second loading memory tables to a queue to be shown on screen.
In Net Simple Parse routine you can see that I commented old routine using Json.
Oggy, I was thinking to use queue but I have to constantly check tag's life to delete and show in browsers all modifications on-line making multi thread access to memory tables. So I decided to use IMDD. I had another application that I have to read serial port at fast pace and notice that string theory and json are very heavy loosing some data so using subs and instrings was a little more faster. Thank you for advices.
Bruce, RFID reader manufacturer support here in Brazil told me that the reader is sending one message structure terminated with CR/LF for each tag. So I put a trace on each message received in Net Simple and confirmed that. My test base was to show to the reader 40 tags at once so it generates an avalanche of 40 tags and repeat each tag every second. This is a reader configuration that depending on the other configuration could send me a constant avalanche os tags that could reach hundreds per second. I prevent user not to use this mode.
Seeing GPF messages registers against map table I could identify that came from a Json code area.
In final version I removed Fastmem and Json.
Atttached is my application.
I wish that you all had a very Happy Christmas and have a very good New Year!
Thank you all for support.
Best regars,
Marcos Sibuya
Attached is my application. Sorry but it's portuguese but if you mind I could translate to better understanding.
Application is a standalone exe application (lib) not using multi DLL.
In dictionary you'll see MSSQL table Portal and ASCII file Template that are used to record results after processing in Memory tables. MSSQL or ASCII are optional to the user and using ASCII for tests.
Application will open Window "Leituras" using Net Simple to get messages from RFID reader that sends RFID tags information in one structure saying from what antenna read the tag.
All messages are sending with CR/LF at the end of each one and does not come more than one structure in one message.
Processing consists on determine tag direction of travel getting in's (Entradas) and out's (Saidas) from a portal with 4 antennas two for input and two for output. I'm doing this in memory tables. I have to determine direction of travel and after some time (configured) I have to delete from memory tables using another window named "Vida Tag" or "Tag lifetime".
There are more two windows that the support and install team can "monitor" what happens with memory tables in timed fashion about aproximately one second loading memory tables to a queue to be shown on screen.
In Net Simple Parse routine you can see that I commented old routine using Json.
Oggy, I was thinking to use queue but I have to constantly check tag's life to delete and show in browsers all modifications on-line making multi thread access to memory tables. So I decided to use IMDD. I had another application that I have to read serial port at fast pace and notice that string theory and json are very heavy loosing some data so using subs and instrings was a little more faster. Thank you for advices.
Bruce, RFID reader manufacturer support here in Brazil told me that the reader is sending one message structure terminated with CR/LF for each tag. So I put a trace on each message received in Net Simple and confirmed that. My test base was to show to the reader 40 tags at once so it generates an avalanche of 40 tags and repeat each tag every second. This is a reader configuration that depending on the other configuration could send me a constant avalanche os tags that could reach hundreds per second. I prevent user not to use this mode.
Seeing GPF messages registers against map table I could identify that came from a Json code area.
In final version I removed Fastmem and Json.
Atttached is my application.
I wish that you all had a very Happy Christmas and have a very good New Year!
Thank you all for support.
Best regars,
Marcos Sibuya
13
Web Server - Ask For Help / NT11 - jFiles 1.72 - Fastmem - InMemory Driver
« on: December 17, 2018, 06:54:33 PM »
Hi,
Using Clarion 8EE I've made a desktop application using NetSimple Client to read Json from a RFID reader that I should process using InMemory Driver because reader sends a lot of packets very fast.
I was using jFiles to get fields data but application crashed with GPF when using jFiles. Adding Fastmem get worse. Sometimes trace gave me messages saying "JSONClass.HandleChar: Unexpected literal ("E") at position 3 ...." from json {"E":"000000000000000000883703","R":-7090,"A":1} and same message literal ("v") from json {"version": "18.615", "app_uptime": "9950001"}. I don't have GPF Reporter but seeing at registers values I saw that was callings from jfiles lib. I don't know if this occurs when another json message arrived when jFiles is still processing the old message.
I have threads (windows lauched by START) that write to memory tables, other that delete or update records and others that reads all data from memory tables.
IMDD says that is thread safe but when accessing tables from threads I got GPF.
Solved by doing the following:
- Not using jFiles stopped trace messages "Unexpected literal" and got lesser GPF. Replaced by SUB and INSTRING.
- All IMDD accesses sync'd with mutex got lesser GPF.
- When closing app with child windows opened accessing memory tables (emulating user behavior) got GPF. I have to not to use Fastmem and using MDI Synchronization template.
After all of this I got an application reasonable stable.
To process these fast json messages I got message from NetSimple/Process and pass to another thread to deal with memory tables in another thread.
Depending on quantity of tags that enters in the reader field it could generate hundreds of messages per second that could reach a thousand. In my tests an average o one or two hundreds per second.
Is there another way to process these fast messages?
Thank you.
Best regards,
Marcos Sibuya
Using Clarion 8EE I've made a desktop application using NetSimple Client to read Json from a RFID reader that I should process using InMemory Driver because reader sends a lot of packets very fast.
I was using jFiles to get fields data but application crashed with GPF when using jFiles. Adding Fastmem get worse. Sometimes trace gave me messages saying "JSONClass.HandleChar: Unexpected literal ("E") at position 3 ...." from json {"E":"000000000000000000883703","R":-7090,"A":1} and same message literal ("v") from json {"version": "18.615", "app_uptime": "9950001"}. I don't have GPF Reporter but seeing at registers values I saw that was callings from jfiles lib. I don't know if this occurs when another json message arrived when jFiles is still processing the old message.
I have threads (windows lauched by START) that write to memory tables, other that delete or update records and others that reads all data from memory tables.
IMDD says that is thread safe but when accessing tables from threads I got GPF.
Solved by doing the following:
- Not using jFiles stopped trace messages "Unexpected literal" and got lesser GPF. Replaced by SUB and INSTRING.
- All IMDD accesses sync'd with mutex got lesser GPF.
- When closing app with child windows opened accessing memory tables (emulating user behavior) got GPF. I have to not to use Fastmem and using MDI Synchronization template.
After all of this I got an application reasonable stable.
To process these fast json messages I got message from NetSimple/Process and pass to another thread to deal with memory tables in another thread.
Depending on quantity of tags that enters in the reader field it could generate hundreds of messages per second that could reach a thousand. In my tests an average o one or two hundreds per second.
Is there another way to process these fast messages?
Thank you.
Best regards,
Marcos Sibuya
14
Web Server - Ask For Help / Re: Basic Mobile and Clarion 8EE
« on: November 19, 2018, 06:31:35 AM »
Hi Don,
Thank you for quick answer but NT11.02 is still the same. When opening in desktop it shows menu icon if browser width is less than 640px but in mobile it not showing.
mBuild still saying that Hamburger image is not found because of broken path and is not copying to zip file. So I changed nettalk-ui.css in theme creating the result path and copying image on it (/themes/seven/styles/images/Hamburger-262626.png). Now it's working.
Thank you!
Best regards,
Marcos
Thank you for quick answer but NT11.02 is still the same. When opening in desktop it shows menu icon if browser width is less than 640px but in mobile it not showing.
mBuild still saying that Hamburger image is not found because of broken path and is not copying to zip file. So I changed nettalk-ui.css in theme creating the result path and copying image on it (/themes/seven/styles/images/Hamburger-262626.png). Now it's working.
Thank you!
Best regards,
Marcos
15
Web Server - Ask For Help / Basic Mobile and Clarion 8EE
« on: November 19, 2018, 04:46:44 AM »
Hi Bruce,
I'm trying to run Basic Mobile but menu icon is not displayed. When I run mBuild it says that http://localhost:88/themes/seven/'/styles/images/Hamburger-262626.png' is not found.
When compiling any example in NT11.1 my Clarion 8EE could't copy Openssl.exe to web folder. I have to copy manually.
Thank you.
Best regards,
Marcos
I'm trying to run Basic Mobile but menu icon is not displayed. When I run mBuild it says that http://localhost:88/themes/seven/'/styles/images/Hamburger-262626.png' is not found.
When compiling any example in NT11.1 my Clarion 8EE could't copy Openssl.exe to web folder. I have to copy manually.
Thank you.
Best regards,
Marcos