[SOGo] BTS activities for Tuesday, November 26 2019

[SOGo reporter]

Title: BTS activities for Tuesday, November 26 2019





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Tuesday, November 26 2019

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
4892
	2019-11-26 10:21:46
	updated (open)
	Web Preferences
	Refresh view only manually
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] Issues with Apostrophe (Single Quote)

[Markus Winkler]

Hello Christian,

On 26.11.19 18:03, Christian Mack (christian.m...@uni-konstanz.de) wrote:

We are having issues with a particular email address which has a ' in its email 
address. Such as Dano'rou...@gmail.com
When the email is sent from SOGo, it removes the ' from the email address, so 
the email is actually sent to danorou...@gmail.com



That is an invalid email address.
You need Quotes around it to work:
"Dano'rourke"@gmail.com


according to RFC 2822 and it's successor RFC 5322 and IMHO that's not 
necessary and it's a bug if SOGo removes the "'":


https://tools.ietf.org/html/rfc5322

3.2.3.  Atom

   Several productions in structured header field bodies are simply
   strings of certain basic characters.  Such productions are called
   atoms.

   Some of the structured header field bodies also allow the period
   character (".", ASCII value 46) within runs of atext.  An additional
   "dot-atom" token is defined for those purposes.

  Note: The "specials" token does not appear anywhere else in this
  specification.  It is simply the visible (i.e., non-control, non-
  white space) characters that do not appear in atext.  It is
  provided only because it is useful for implementers who use tools
  that lexically analyze messages.  Each of the characters in
  specials can be used to indicate a tokenization point in lexical
  analysis.

   atext   =   ALPHA / DIGIT /; Printable US-ASCII
   "!" / "#" /;  characters not including
   "$" / "%" /;  specials.  Used for atoms.
   "&" / "'" /
   "*" / "+" /
   "-" / "/" /
   "=" / "?" /
   "^" / "_" /
   "`" / "{" /
   "|" / "}" /
   "~"

   atom=   [CFWS] 1*atext [CFWS]

   dot-atom-text   =   1*atext *("." 1*atext)

   dot-atom=   [CFWS] dot-atom-text [CFWS]

   specials=   "(" / ")" /; Special characters that do
   "<" / ">" /;  not appear in atext
   "[" / "]" /
   ":" / ";" /
   "@" / "\" /
   "," / "." /
   DQUOTE


   Both atom and dot-atom are interpreted as a single unit, comprising
   the string of characters that make it up.  Semantically, the optional
   comments and FWS surrounding the rest of the characters are not part
   of the atom; the atom is only the run of atext characters in an atom,
   or the atext and "." characters in a dot-atom.

3.2.4.  Quoted Strings

   Strings of characters that include characters other than those
   allowed in atoms can be represented in a quoted string format, where
   the characters are surrounded by quote (DQUOTE, ASCII value 34)
   characters.
[...]



I would ditch that address and get one without special characters.
I have seen too many SMTP servers not accepting such addresses at all.


Then they aren't RFC compliant.

For instance: an e-mail address like foo+...@example.com (Postfix: 
recipient_delimiter = + and the e-mail will then finally be delivered to 
f...@example.com) is widely used (and I never saw a problem with such an 
address on Postfix, Dovecot, Thunderbird etc.).


According to the RFC that "+" is within the same category of characters 
like the "'" of Dano'rou...@gmail.com (atext) and therefore has to be 
accepted by any compliant software.


Just my $ 0.02

Kind regards,
Markus
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Issues with Apostrophe (Single Quote)

[Anselm Martin Hoffmeister]

Hi Andrew,

I just tested writing a mail from SOGo webmail (4.1.0 in this case) to a 
fake version of my private account elsewhere, having inserted an 
apostrophe '. My private server rightfully refuses the (invalid) 
destination address - it seems SOGo does everything correctly here and 
hands through the apostrophe exactly as I would expect.


Trying to replicate the problem, doing the same with both the forward 
and backward tick ´` (single quotation marks or accent over blank, or 
whatever you call them), the same happens, SOGo hands through those 
mails and the destination server then refuses - the forward tick for 
"invalid postbox", the backtick as "restricted characters in address", 
and the non-delivery mail quotes the refused target address including 
the superfluous characters.


So it seems (my) SOGo 4.1.0 works correctly. But there may be other 
parties involved: Usually SOGo hands off the mail to a local running 
exim (or postfix), which then forwards the mail as applicable. There 
may be a different mail path between roundcube and SOGo, depending on 
your local configuration.


Can you find some relevant lines in the mail server logs? In exim case 
and on Debian(ish) Linuxes, /var/log/exim4/mainlog would be the place to 
investigate.


Also having details on the software version involved and perhaps the 
relevant parts of the SOGO config may be helpful.


Best regards

Anselm

Am 26.11.2019 um 13:37 schrieb Andrew Mogg (and...@logicomm.co.uk):


Hi

We are having issues with a particular email address which has a ‘ in 
its email address. Such as Dano’rou...@gmail.com


When the email is sent from SOGo, it removes the ‘ from the email 
address, so the email is actually sent to danorou...@gmail.com 
 and therefore fails (ie bounces). 
Interestingly, when I access the server via Roundcube and send, this 
does not happen, so its SOGo


Has anyone had any experience of this?


This email has been scanned for email related threats and delivered 
safely by Exascale.

For more information please visit https://www.exascale.co.uk


--
users@sogo.nu
https://inverse.ca/sogo/lists

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Issues with Apostrophe (Single Quote)

[Christian Mack]

Hello

Am 26.11.19 um 13:37 schrieb Andrew Mogg (and...@logicomm.co.uk):
> Hi
> We are having issues with a particular email address which has a ' in its 
> email address. Such as Dano'rou...@gmail.com
> When the email is sent from SOGo, it removes the ' from the email address, so 
> the email is actually sent to 
> danorou...@gmail.com and therefore fails (ie 
> bounces). Interestingly, when I access the server via Roundcube and send, 
> this does not happen, so its SOGo
> Has anyone had any experience of this?
> 
> 

That is an invalid email address.
You need Quotes around it to work:
"Dano'rourke"@gmail.com

I would ditch that address and get one without special characters.
I have seen too many SMTP servers not accepting such addresses at all.


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Issues with Apostrophe (Single Quote)

[Andrew Mogg]

Hi
We are having issues with a particular email address which has a ' in its email 
address. Such as Dano'rou...@gmail.com
When the email is sent from SOGo, it removes the ' from the email address, so 
the email is actually sent to danorou...@gmail.com 
and therefore fails (ie bounces). Interestingly, when I access the server via 
Roundcube and send, this does not happen, so its SOGo
Has anyone had any experience of this?


--
This message has been scanned by Exascale and is believed to be clean.


-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Active Sync sogo_cache_folder tables missing column

[Lars Liedtke]

Hello all,

Using SOGo 4.0.8, ActiveSync, MariaDB on FreeBSD. When connecting via
ActiveSync a table per user is created with the name
sogo_cache_folder_. But the connection fails, because a column
in this table seems to be missing:

2019-11-26 11:36:53.106 sogod[51376:100608]    ERROR: Unknown column 'c_uid' in 'where clause'
Nov 26 11:36:53 sogod [51376]: 
<0x80ccb8988[SOGoCacheGCSObject]:bluemail256874964> an exception occurred when 
executing query 'SELECT * FROM sogo_cache_folder_ry22 WHERE c_path = 
'/bluemail256874964' AND c_uid = 'ry22''
Nov 26 11:36:53 sogod [51376]: 
<0x80ccb8988[SOGoCacheGCSObject]:bluemail256874964> exception is 
' NAME:ExecutionFailed REASON:Unknown column 
'c_uid' in 'where clause''
Nov 26 11:36:53 sogod [51376]: [ERROR] <0x0x80c6fe958[NSDataMalloc]> 
xml2wbxmlFromContent: failed: Parsing of XML Document Failed

When I create this column manually as simple Integer Column, and
recreate the account connection on my Android 9 mobile, everything works
fine afterwards.

Have I made a mistake somewhere on the way or is this a Bug?

Best Regards

Lars

--- 
punkt.de GmbH
Lars Liedtke
.infrastructure

Kaiserallee 13a 
76133 Karlsruhe

Tel. +49 721 9109 500
https://infrastructure.punkt.de
i...@punkt.de

AG Mannheim 108285
Geschäftsführer: Jürgen Egeling, Daniel Lienert, Fabian Stein

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

0xDD6D744EC1628062.asc
Description: application/pgp-keys