Messages

1

E-Mail - Ask For Help / Re: Does certificate common name verification check Subject Alternative Name?

« on: February 07, 2022, 10:45:41 PM »

Thanks Jane!
It is a version problem. Some of our older apps are still NT10 and NT11. With NT12 it works, so it is time to update those apps. I should have noticed this myself.

2

E-Mail - Ask For Help / Does certificate common name verification check Subject Alternative Name?

« on: February 06, 2022, 11:36:56 PM »

Hi,

Our service provider updated certificates on our email server and our POP server address moved from common name to Subject Alternative Name in the certificate. This caused NetTalk to reject connection to the server when trying to receive emails with error: "The Remote TLS Certificate's Common Name (webmail.tietohippu.com) does not match the Server name (tietohippu.com). And so the connection failed to open NetSimple.TakeEvent"

Does Does certificate common name verification check Subject Alternative Name? And if not, should it check, as SAN is used to add more than one domain to certificate?

We are using server tietohippu.com on port 995. CN and SAN on certificate look like this (from https://www.sslchecker.com/sslchecker):

Common name:
webmail.tietohippu.com

SAN:
autodiscover.tietohippu.com, cpanel.tietohippu.com, cpcalendars.tietohippu.com, cpcontacts.tietohippu.com, tietohippu.com, webdisk.tietohippu.com, webmail.tietohippu.com, www.tietohippu.com

BR,
Vesa

3

The Rest - Ask For Help / Disconnected desktop, problem with comma as decimal separator

« on: December 02, 2020, 12:57:48 AM »

Hi,

I found a possible bug on syncing tables when there is a picture that uses a comma as a decimal separator on a field in dictionary. When inserting a value, for example 15, to a field on desktop, after sync the value has multiplied to much larger value. This can be replicated with the Disconnected desktop example by changing Price field picture to @n-10_`2 in the LineItems table.

We are using NetTalk 11.47, StringTheory 3.35 and jFiles 2.17 on Clarion 11 13401

BR,
Vesa

4

E-Mail - Ask For Help / Re: Odd behaviour trying to download emails

« on: August 28, 2020, 04:00:50 AM »

Thanks for the reply. We are currently using version 10.38 of NetTalk.

Ok, did another run with /nettalklog on. In the log there is a _DebugPacketNumber value, which is incrementing and value "data length" which seems to quite constantly be 4096. Can total downloaded bytes be calculated by multiplying the two values together? If so, the download seems to stop before the full message is received, in the case of the log there is about 23 MB downloaded on a message than has 27 MB attachment.

Br,
Vesa

5

E-Mail - Ask For Help / Odd behaviour trying to download emails

« on: August 21, 2020, 04:24:52 AM »

Hello,

I am trying to figure out why email download gets stuck when loading a mail with somewhat large attachment (> 20MB). When using /netall, debugview shows something I don't quite understand, for me it seems that NT is trying to download same thing again and again decrementing then number of parts by 1 each iteration (part of the log attached). It seems to do it until 0 and then just stop without calling ErrorTrap. Any ideas what is going on and how I could fix this?

BR,
Vesa

6

E-Mail - Ask For Help / Re: Problems with non-ascii characters

« on: May 27, 2015, 10:18:41 PM »

Hello Bruce,

I have just sent you four emails, in this order:

1. one has the UTF-encoding in the subject problem. This message will be coming from address starting "testi.vesa"
2. one has the encoding problem with the senders name. This message will be coming from address starting "janne.kiiskila"
3. one has the ISO-encoding in the subject. This message will be coming from address starting "vesa.klemetti"
4. one has the UTF-8 and quoted-printable combo in the message text. This message will be coming from address starting "vesa.klemetti"

I have fixed all of these problems in our application by using StringTheory to slice and decode the text in the embeds mentioned in previous message. The code is not very sophisticated, but if you think the code could help I can give it to you.

-Vesa-

7

E-Mail - Ask For Help / Re: Problems with non-ascii characters

« on: May 25, 2015, 06:29:01 AM »

Hi again Bruce,

And thanks for the update. It fixed most of our problems. However, a new problem came after the update. If the "From" -field is encoded, it does not get decoded in NetTalk anymore. For example, if the from field is in the following email source:

Code: [Select]

From: =?iso-8859-1?Q?Jonna_Kiiskil=E4?= <jonna.kiiskila@whatever.com> the self.from in the Done-method has the following text: =?iso-8859-1?Q?Jonna_Kiiskil=E4?= <janne.kiiskila@whatever.com>

Few minor issues still with the subject line also:
1. The decoding doesn't seem to happen:

Code: [Select]

Subject: [Fwd: FW: Projektin ja ajanhallintasofta omaan
 =?iso-8859-1?Q?toimistok=E4ytt=F6=F6n=5F150124=5FTK.docx]?=shows in self.subject as: [Fwd: FW: Projektin ja ajanhallintasofta omaan =?iso-8859-1?Q?toimistok=E4ytt=F6=F6n=5F150124=5FTK.docx]?=

2. End gets clipped, if multiple encoded strings on the same line:

Code: [Select]

Subject: =?UTF-8?Q?Fwd=3A_FW=3A_Projektin_ja_ajanhallintasofta_omaan_toim?=  =?UTF-8?Q?istok=C3=A4ytt=C3=B6=C3=B6n=5F150124=5FTK=2Edocx?=shows in self.subject as:  Fwd: FW: Projektin ja ajanhallintasofta_omaan_toim

We managed to handle the issue with the from-field and the minor issues with the subject line by adding some code in _ProcessCleanString -embed before parent call, so issue is not currently very critical, but I thought that it would be good to let you know about these problems.

The "utf-8" encoding with "quoted-printable" content-transfer type  was not working very well in the message's text part, so you may want to check that out also. We added some decoding code in the _ProcessStoreText -embed after parent call to do the decoding and ansi-conversion and we got it working pretty well, so the problem is not critical for us right now.

BR
-Vesa-

8

E-Mail - Ask For Help / Re: Problems with non-ascii characters

« on: May 18, 2015, 05:42:12 AM »

Ok, thanks for the clarification, I think I got it now.

And thanks a lot for your help with this problem!

BR,
-Vesa-

9

E-Mail - Ask For Help / Re: Problems with non-ascii characters

« on: May 18, 2015, 03:27:29 AM »

Hi Bruce:

Hi Vesa,

Ok, this applies to build 8.49 (which should be out soon.) Make sure you have the latest StringTheory at that time as well.

a) The email class will handle the various encodings of the Subject better. Internally there's a switch to Stringtheory there which gives you a bit more control. If the string is in unicode then it will be converted back to ANSI automatically.

Thanks! We'll update to the latest version and try it out.

b) The _default_ code page is
st:CP_ISO_8859_1
but you should set the code page before the call to get the emails. What you should set it to does depend on the kinds of characters you would expect to receive - so in your code ISO-8859 is ok, but others may need to change that.
the default _may_ change (I don't know what the best default is yet) so it's best to specify the code page specifically.

I'm not sure I understood this correctly. Are you saying that we need to know what encoding will be used in a email we will receive with the app before compiling?

BR,
-Vesa-

10

E-Mail - Ask For Help / Re: Problems with non-ascii characters

« on: May 17, 2015, 11:48:26 PM »

Hi Bruce,

I just sent one ISO-encoded message. I had multiple messages with same subject and picked the wrong one to send earlier, sorry for that

So you saw the problem with the UTF-message and it can be fixed by converting the strign to ANSI?

BR
-Vesa-

11

E-Mail - Ask For Help / Re: Problems with non-ascii characters

« on: May 17, 2015, 10:44:12 PM »

Hi Bruce,

I have sent you two emails which we have problems with. The one with subject starting "VL: Projektin ja ajanhallinta" has the problem described in the first example of the first post and the one starting "FW: Projektin ja ajanhallinta" has the problem described in the second example.

I do think that the NetEmail-class does the decoding somewhere along the way, because the subject has been decoded (i.e. the "=?utf-8?" part has been removed) in the .Done-method when we read the self.subject -property of the class. We have no embed code that decodes the message or subject.

BR,

-Vesa-

12

E-Mail - Ask For Help / Re: Problems with non-ascii characters

« on: May 14, 2015, 10:49:03 PM »

Hi Bruce,

and thanks for the reply!

I checked out the examples again. They are correct. The UTF-version looks like the one in the png and ?iso-8859-1?. Could the decoding outcome alter on a different regional setting on windows? I can forward you the actual emails that we have problems with, if you would like to do some testing with them?

The StringTheory method you mentioned is not called in our code. Would the StringTheory method work better?

There is actually not a lot of hand code in the email receiving, and in the Done-embed of the NetEmail-object we just take the self.Subject and insert it to CSTRING and save it:

Code: [Select]

   if finished = 0
        ! Display the message
        CLEAR(VIESTI)
           
        VST:IDSTRING = clip (self.messageID)

Access:VIESTI.PrimeAutoInc()
        VST:FROM = clip (self.From)
        Message(self.subject)
VST:SUBJECT = clip (self.subject)
VST:TOLIST = clip (self.ToList)
VST:CCLIST = clip (self.ccList)

   
VST:LAHETYSPVM = ParseEmailDate(clip  (self.sentDate))
VST:LAHETYSKLO = ParseEmailTime(clip  (self.sentDate))   
 
        if self.MessageTextLen > 0
          VST:TEXTMESSAGE = clip (self.MessageText[1:self.MessageTextLen])
        !MESSAGE(self.wholemessage)
        else
          VST:TEXTMESSAGE = ''
        end
           
        if self.MessageHtmlLen > 0
          !MyHTML = clip (self.MessageHtml[1:self.MessageHtmlLen])   Ei sopivaa paikkaa viestitaulussa!
        else
          !MyHTML = ''
        end   

VST:PROJEKTI = 0
VST:APUPROJ = 0       
Access:VIESTI.TryInsert()
           
 
  else
Where is the decoding done in NetEmail-class? I quickly browsed through .clw, but it did not catch my eye.

 BR,
 -Vesa-

13

E-Mail - Ask For Help / Problems with non-ascii characters

« on: March 24, 2015, 11:30:27 PM »

Hello,

We are using C9.1 and NT 8.39 to build a software with email client to receive emails for processing.

When we receive mails with non-ascii characters in the subject or message with quoted-printable -encoding, the decoding in NetTalk does not always work.

A couple of examples of the problems. In both cases the subject should be "FW: Projektin ja ajanhallintasofta omaan  toimistokäyttöön_150124_TK.docx"

In the first example the decoded subject is shown in the attached png, here is the encoded subject:

Code: [Select]

Subject: =?utf-8?Q?FW:_Projektin_ja_ajanhallintasof?=
=?utf-8?Q?ta_omaan__toimistok=C3=A4ytt=C3=B6=C3=B6n=5F15012?=
=?utf-8?Q?4=5FTK.docx?=
Next example has a different problem. The decoding doesn't seem to happend at all, so subject after decoding is still like FW:_Projektin_ja_ajanhallintasofta_omaan_toimistok?=E4ytt=F6=F6n=5F150124=5FTK.docx:

Code: [Select]

Subject: =?iso-8859-1?Q?FW:_Projektin_ja_ajanhallintasofta_omaan_toimistok?=
=?iso-8859-1?Q?=E4ytt=F6=F6n=5F150124=5FTK.docx?=
Does anyone have any ideas how to make the decoding work properly?

-Vesa-

[attachment deleted by admin]

14

Web Server - Ask For Help / Re: Popup form, validation alert not showing

« on: January 24, 2014, 01:43:39 AM »

Thanks once again Bruce!

I checked the example and after that I was able to pinpoint the problem.

I was doing the validation in ValidateInsert and ValidateUpdate routines, which worked when using NT6 on this project.

In NT7 I did not get any messages (alert-popups was what I got with C6) when the validation failed even when I added similar validation for a field as used in the example, only sign was the form not closing. When I commented out my hand-code validation, popups started to work.

So some refactoring needed to my validation code, but now I think can get it to work. The red-bar functionality would be nice, as I need to do some not field spesific validation. Although think I can get close enough functionality by adding a display-type field to the start of the form and show it only when there is some error to show.

-Vesa-

15

Web Server - Ask For Help / Popup form, validation alert not showing

« on: January 22, 2014, 04:53:57 AM »

Hello,

Working now with NT 7.31, I have a problem with the validation alert message not showing at all when form is in popup mode.

When not in popup mode (so form is not opened on top of browse), if some required field is missing the red bar appears at the top of the form saying the text I have coded, but the bar missing in the popup mode.

Currently I put values to loc:invalid and loc:alert if the field is required. Is this the wrong way to do this?

-Vesa-