Re: [SOGo] failed to parse RFC822 date field

2021-08-03 Thread mj

Thanks Christian and Emmanuel!

Thanks for your help, I will see what I can find!

MJ

On 8/3/21 5:04 PM, Christian Mack (christian.m...@uni-konstanz.de) wrote:

Hello

Am 03.08.21 um 13:41 schrieb mj (li...@merit.unu.edu):

Hi Emmanuel,

On 02/08/2021 14:17, Emmanuel Dreyfus (m...@netbsd.org) wrote:


I guess the problem is that RFC822 format is Sat, Jul 10 2021 11:56:18
+



Yes you are right. But the question remains: where does this faulty date
in the system come from, and how to get it out.

Because even though the faulty date is juli 10, still today my sogo is
trying to process it, and fails and complains about the format.

(and two minutes later tries again)

I also have a similar one from July 3.


RFC822 is specifying the email format.
Therefore that date originates from an email in the users postbox.
Everytime SOGo parses that email, you get that error message.
The only way to get rid of it is to delete that email.

And yes, whoever/whatever program wrote that email should get publicly
blamed for not knowing how to generate a valid email.


Kind regards,
Christian Mack


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


Re: [SOGo] failed to parse RFC822 date field

2021-08-03 Thread Christian Mack
Hello

Am 03.08.21 um 13:41 schrieb mj (li...@merit.unu.edu):
> Hi Emmanuel,
> 
> On 02/08/2021 14:17, Emmanuel Dreyfus (m...@netbsd.org) wrote:
>>
>> I guess the problem is that RFC822 format is Sat, Jul 10 2021 11:56:18
>> +
>>
> 
> Yes you are right. But the question remains: where does this faulty date
> in the system come from, and how to get it out.
> 
> Because even though the faulty date is juli 10, still today my sogo is
> trying to process it, and fails and complains about the format.
> 
> (and two minutes later tries again)
> 
> I also have a similar one from July 3.
> 
RFC822 is specifying the email format.
Therefore that date originates from an email in the users postbox.
Everytime SOGo parses that email, you get that error message.
The only way to get rid of it is to delete that email.

And yes, whoever/whatever program wrote that email should get publicly
blamed for not knowing how to generate a valid email.


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature


Re: [SOGo] failed to parse RFC822 date field

2021-08-03 Thread Emmanuel Dreyfus
On Tue, Aug 03, 2021 at 01:41:16PM +0200, mj wrote:
> Yes you are right. But the question remains: where does this faulty date in
> the system come from, and how to get it out.

Scrub the database?
mysqldump sogo | grep 'Sat Jul 10 11:56:18 UTC 2021' and see from what
table it comes? Hopefully, a PRODID property will tell you what client
did it.

Then you could fix it with something like this: 
update table_xxx 
   set c_content = replace(
c_content,
'Sat Jul 10 11:56:18 UTC 2021',
'Sat, Jul 10 11:56:18 2021 +')
 where c_content like '%Sat Jul 10 11:56:18 UTC 2021%';

If you have many of them, you will need something more complex.
Backup advised, as usual.

-- 
Emmanuel Dreyfus
m...@netbsd.org
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] failed to parse RFC822 date field

2021-08-03 Thread mj

Hi Emmanuel,

On 02/08/2021 14:17, Emmanuel Dreyfus (m...@netbsd.org) wrote:


I guess the problem is that RFC822 format is Sat, Jul 10 2021 11:56:18 +



Yes you are right. But the question remains: where does this faulty date 
in the system come from, and how to get it out.


Because even though the faulty date is juli 10, still today my sogo is 
trying to process it, and fails and complains about the format.


(and two minutes later tries again)

I also have a similar one from July 3.

Anyway, thanks for replying!

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


Re: [SOGo] failed to parse RFC822 date field

2021-08-02 Thread Emmanuel Dreyfus
On Mon, Aug 02, 2021 at 01:30:47PM +0200, mj wrote:
> > sogod [32661]: <0x0x5570fe0afcd0[NGMimeRFC822DateHeaderFieldParser]> 
> > WARNING: failed to parse RFC822 date field: 'Sat Jul 10 11:56:18 UTC 2021'
> 
> These appear for various dates and times.
> 
> Can anyone explain?

I guess the problem is that RFC822 format is Sat, Jul 10 2021 11:56:18 +

-- 
Emmanuel Dreyfus
m...@netbsd.org
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] failed to parse RFC822 date field

2021-08-02 Thread mj

Hi,

Suddenly I notice in our logs:


sogod [32661]: <0x0x5570fe0afcd0[NGMimeRFC822DateHeaderFieldParser]> WARNING: 
failed to parse RFC822 date field: 'Sat Jul 10 11:56:18 UTC 2021'


These appear for various dates and times.

Can anyone explain?

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