Messages

16

FTP - Ask For Help / TLS connection to FileZilla server

« on: October 19, 2021, 02:30:06 PM »

NT: 12.26

NetTalk does not seem to be able to establish a TLS data connection. I modified the example to connect to my FTP server using both Ftp:ImplicitSSL and Ftp:ExplicitSSL, both with similar results. Ftp:ImplicitSSLControl does not look like it's supported by FileZilla anymore.

Code: [Select]

===== Control Connection Opened =====
220-FileZilla Server 1.0.1
220 Please visit https://filezilla-project.org/
>>USER UpdateBuilder
331 Please, specify the password.
>>PASS ****
230 Login successful.
>>SYST
215 UNIX emulated by FileZilla.
>>PBSZ 0
200 PBSZ=0
>>PROT P
200 Protection level set to P
>>PWD
257 "/" is current directory.
>>TYPE I
200 Type set to I
>>SIZE /Patch4.1.2.msp
213 10129408
>>PASV
227 Entering Passive Mode (216,171,235,114,234,212)
>>RETR /Patch4.1.2.msp
150 About to start data transfer.
===== Data Connection Opened =====
===== Data Connection Closed =====
===== Error: Error occured while receiving a file, not all data was received
===== Click Close to close window =====
425 Unable to build data connection: TLS session of data connection not resumed.
===== Error: Unknown Reply from FTP Server. Reply = 425[425 Unable to build data connection: TLS session of data connection not resumed.
] Command =
===== Click Close to close window =====
I also tried passive mode, but that timed out.

Code: [Select]

===== Control Connection Opened =====
220-FileZilla Server 1.0.1
220 Please visit https://filezilla-project.org/
>>USER UpdateBuilder
331 Please, specify the password.
>>PASS ****
230 Login successful.
>>SYST
215 UNIX emulated by FileZilla.
>>PBSZ 0
200 PBSZ=0
>>PROT P
200 Protection level set to P
>>PWD
257 "/" is current directory.
>>TYPE I
200 Type set to I
>>SIZE /Patch4.1.2.msp
213 10129408
>>PORT 192,168,50,227,9,212
200 PORT command successful.
>>RETR /Patch4.1.2.msp
150 Starting data transfer.
425 Unable to build data connection: ETIMEDOUT - Connection attempt timed out
===== Error: Unable to open data connection [425 Unable to build data connection: ETIMEDOUT - Connection attempt timed out
]
===== Click Close to close window =====
On a side note I have to set DontVerifyRemoteCertificateCommonName = TRUE for the data object when using both implicit and explicit, and for the data and control objects then using explicit. NetTalk look to be trying to verify the common name against the ip address on subsequent connections.

Also I censored the password, it is not ****

17

Web Server - Ask For Help / Re: Closing files clears the current record.

« on: October 13, 2021, 02:52:34 PM »

I added a few more tests as I can only run them every so often.

Code: [Select]

        dbgView('Before Close: ' & Inv:Description)
      dbgView('Result: ' & p_web.CloseFile(InvMaster))
      dbgView('Close Error:  ' & Error())
      dbgView('After Close: ' & Inv:Description)
  dbgView('RelationManager')
  Relate:InvMaster.Open()
  Access:InvMaster.Fetch(Inv:PK_Master, p_web.gsv('ItemSave'))
  dbgView('Before Close: ' & Inv:Description)
  dbgView('Result: ' & Relate:InvMaster.Close())
  dbgView('Close Error:  ' & Error())
  dbgView('After Close: ' & Inv:Description)
  dbgView('File Manager')
  Access:InvMaster.Open()
  Inv:ItemID = p_web.gsv('ItemSave')
  Access:InvMaster.Fetch(Inv:PK_Master)
  dbgView('Before Close: ' & Inv:Description)
  dbgView('Result: ' & Access:InvMaster.Close())
  dbgView('Close Error:  ' & Error())
  dbgView('After Close: ' & Inv:Description)
  dbgView('Direct')
  Open(InvMaster)
  Inv:ItemID = p_web.gsv('ItemSave')
  Get(InvMaster, Inv:PK_Master)
  dbgView('Before Close: ' & Inv:Description)
  Close(InvMaster)
  dbgView('Close Error:  ' & Error())
  dbgView('After Close: ' & Inv:Description)
The results on my development server and after a fresh restart:
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Result: 0
[48968] [BackOffice] Close Error:  Entry Not Found
[48968] [BackOffice] After Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] RelationManager
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Result: 0
[48968] [BackOffice] Close Error:  Entry Not Found
[48968] [BackOffice] After Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] File Manager
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Result: 0
[48968] [BackOffice] Close Error: 
[48968] [BackOffice] After Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Direct
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Close Error: 
[48968] [BackOffice] After Close: Canadian Club 750ml

After my production server has been running:
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Result: 0
[48968] [BackOffice] Close Error:  Entry Not Found
[48968] [BackOffice] After Close:                                                                                                     
[48968] [BackOffice] RelationManager
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Result: 0
[48968] [BackOffice] Close Error:  Entry Not Found
[48968] [BackOffice] After Close:                                                                                                     
[48968] [BackOffice] File Manager
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Result: 0
[48968] [BackOffice] Close Error: 
[48968] [BackOffice] After Close:                                                                                                     
[48968] [BackOffice] Direct
[48968] [BackOffice] Before Close: Canadian Club 750ml                                                                                 
[48968] [BackOffice] Close Error: 
[48968] [BackOffice] After Close: Canadian Club 750ml

So FileManager is somehow changing behaviour while the program is running. I've look at the code and can't figure out what is doing this. I can put more diagnostics in to try and see if anything in filemanager has changed.

As far as specific location. Using a lookup browse closes the file before the call to AfterLookup. This is the case both for typing in the value, as well as using the lookup.

18

Web Server - Ask For Help / Closing files clears the current record.

« on: October 06, 2021, 03:54:58 PM »

Clarion 11.1
NT 12.26
SQL Server 2014 Standard

I suspect that this may be at the root of many of the problems that are on my production server. This only becomes active after my production server has been running for a while. It doesn't occur on a fresh restart, or on my development server. The file record is cleared after a file is closed. To test this I created some simple code:

Code: [Select]

      dbgView('Before Close: ' & Inv:ItemID)
      dbgView('Result: ' & p_web.CloseFile(InvMaster))
      dbgView('Close Error:  ' & Error())
      dbgView('After Close: ' & Inv:ItemID)
The results on my development server and after a fresh restart:
[40340] [BackOffice] Before Close: 154
[40340] [BackOffice] Result: 0
[40340] [BackOffice] Close Error:  Entry Not Found
[40340] [BackOffice] After Close: 154

After my production server has been running:
[42892] [BackOffice] Before Close: 154
[42892] [BackOffice] Result: 0
[42892] [BackOffice] Close Error:  Entry Not Found
[42892] [BackOffice] After Close: 0

I feel like nettalk frequently assumes the record is still valid after a close, and I have no idea what might be clearing it.

19

Web Server - Ask For Help / Re: Security analysis vulnerability reported

« on: September 30, 2021, 01:13:11 PM »

Another option is to turn on "Bind Session to IP Address" in your server settings. This could adversely affect legitimate users who frequently change ip address (ie redundant IPS, and maybe vpn users.)

The security report will likely still show the threat, even if it is much harder to exploit.

20

Web Server - Ask For Help / Re: Next button breaks browse

« on: September 29, 2021, 02:43:55 PM »

As far as I can tell loc:vordernumber and LastValue both keep the correct data. Then the template tries to loop through the records after ResetPosition() it gets a "Record Not Available" on the first record.

Out of frustration I set the Loading Method to File instead of page for the weekend. Turns out most of my customers like it better that way anyway. So unless we get a way to change the loading method at run time I'm going to accept the workaround as a permanent solution.

I may have a related bug, but I'll make a new thread for that one when I get more information.

21

Web Server - Ask For Help / Re: Next button breaks browse

« on: September 23, 2021, 02:59:06 PM »

I forgot to mention I updated to 12.26 and the problem is persisting. I don't think it's the same problem as it happens with no sort order (record order), which is what most users use.

I'll add loc:vordernumber to the list of debug messages though. Most of my messages are focusing on LastValue and ResetPosition() as I suspect that is getting messed up somehow.

22

Web Server - Ask For Help / Re: Next button breaks browse

« on: September 23, 2021, 12:50:36 PM »

Ok this isn't fixed, it just takes a while to stop working after the server is restarted. How long isn't consistent. The first two times took about 20 min, the 3rd took several hours. I ended up going to bed with it still working at 4am after running for 2 hours, and it was broken by 10 AM. I'm going to put in a new version tonight with a lot of debugs and see if I can learn anything.

I don't know what would make it stop working after a while as the browse doesn't access global data (unless the template does), and the problem exists on new sessions.

23

Web Server - Ask For Help / Re: Next button breaks browse

« on: September 21, 2021, 10:27:23 PM »

Well, now it's working again. I dropped in new binaries that had a table added to the dictionary (not referenced in the app) and had the debugview options enabled for the browse, and it worked fine. I disabled the debugview options and it still worked.

I have no idea why it suddenly broke, or suddenly fixed, and that's the frustrating part.

24

Web Server - Ask For Help / Next button breaks browse

« on: September 21, 2021, 01:43:41 PM »

Clarion 11
NT 12.19
MS SQL 2014 Standard

I have one browse in my app where hitting the next button will cause it to display the no records message, even though their are records it should be displaying. In the past this only happened occasionally, but now it's 100% of the time for this one browse. Most frustrating is this is only happening on our productions server. If I set up a test server using the exact same binaries and a backup of the production database everything works fine.

Any ideas as to what I should check would help a lot.

Thank You
Matthew

25

Web Server - Ask For Help / Re: Apostrophe in eadding of popup

« on: May 27, 2021, 02:29:20 AM »

"allow xHTML" is off.

26

Web Server - Ask For Help / Apostrophe in eadding of popup

« on: May 26, 2021, 03:23:15 PM »

C 11
NT 12.18

I'm sure this was working in NT 11 and earlier.

I have a popup where the heading is set dynamically. If the heading happens to have a ' in it tho whole popup breaks (see attachment), theirs no tabs and none of the buttons work. Also it displayed the heading of the previous record opened, or the first record if it's the first time opening the form. I noticed p_web.Translate didn't escape apostrophes so I tried escaping them myself. But when the template called translate it turned "King's" into" King's"

I then changed line 2311 in NetWeb.clw form "case p_notok[x+2 : x+6]" to "case p_notok[x+1 : x+5]" and that fixed the translate issue, but the popup is still broken. Lines 2294 and 2322 may need similar treatment.

I also tried it with a static heading with an apostrophe. This time it displayed the right heading, but the popup was still broken.

27

Web Server - Ask For Help / Upgrading to NT 12. Trouble with decimal variable on a form.

« on: December 17, 2020, 03:07:37 PM »

After upgrading to NT 12.02 I'm getting compile errors my forms with decimal values in the StoreMem Routine.

Code: [Select]

StoreMem  Routine
  If p_web.IfExistsValue('UsedFullAddress') = 0 and p_web.IfExistsSessionValue('UsedFullAddress') = 0
    p_web.SetSessionValue('UsedFullAddress',UsedFullAddress)
  Else
    UsedFullAddress = p_web.GetSessionValue('UsedFullAddress')
  End
  SubTotal = 14,2  ! decimal(14
  If p_web.IfExistsValue('SubTotal') = 0 and p_web.IfExistsSessionValue('SubTotal') = 0
    p_web.SetSessionValue('SubTotal',SubTotal)
  Else
    SubTotal = p_web.GetSessionValue('SubTotal')
  End
SubTotal is Decimal(14,2). I'm not sure why the point of "SubTotal = 14,2  ! decimal(14" is. Other variable types don't have a similar line.

Thank You
Matthew

28

The Rest - Ask For Help / Google Oauth refreshing a token

« on: October 02, 2020, 02:09:27 AM »

Net Talk 11.45

When trying to refresh a google token I get the following error:

A network communication error has occurred.

Error = The requested connection to oauth2.googleapis.com could not be opened. The Open command timed out or failed to connect.

The error number was -68 which means SSL Failed to Load CA Root File[.\CARoot.pem].

Error occurred in function NetSimple.TakeEvent

This is only happening on my production server (Windows Server 2012), and only when refreshing the token, fetching it in the first place is fine.

Thank You
Matthew

29

Web Server - Ask For Help / Re: How can I increase the browse template picture? (see screenshot)

« on: May 28, 2020, 02:32:26 PM »

I believe charion has a max picture size. However if you set the picture to '' nettalk should not try and format the text and you will get it all.

30

Web Server - Ask For Help / Alternative to themeroller

« on: May 21, 2020, 02:48:36 PM »

Themeroller isn't working right now, and as far as I can tell it hasn't been for over 6 months. The workaround that's been posted is to set up a local Themeroller server on a Linux machine. Not having much experience with Linux this will take me quite some time to figure out. Anyone else have any other options that they know of?

Thank you
Matthew