View Issue Details

IDProjectCategoryView StatusLast Update
0003126SOGoActiveSyncpublic2015-09-25 17:33
ReporterRaido Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionsuspended 
Platform[Server] LinuxOSUbuntuOS Version12.04 LTS
Product Version2.2.16 
Summary0003126: Some email with wrong date and time.
Description

Our client complains that webmail/outlook/android phone shows some emails recieved with future date. For example client recieves email at 10:00, webmail shows email date in same day, but e.g 17:00

Additional Information

I attatched an eml file whichs shows that I recieved client forwaded email at Tuesday, March 10, 2015 10:32 AM, but client sees this email date as: Sent: Tuesday, March 10, 2015 5:42 PM

TagsNo tags attached.

Relationships

related to 0000708 resolvedludovic SOGoMailListViewColumnsOrder uuid (imap unique identifiers) 

Activities

Raido

Raido

2015-03-10 08:58

reporter  

future date email.eml (26,982 bytes)
Raido

Raido

2015-03-10 09:10

reporter   ~0008253

Forgot to mention, that baruwa shows attatched email date and time as: March 10, 2015, 9:42 a.m.

And problem is with multiple users. With ActiveSync and IMAP as well.

Raido

Raido

2015-03-10 09:15

reporter   ~0008254

Sogo log from same sender:
S[0x7fc171dc3060]: * 3341 FETCH (FLAGS (\Seen) UID 17211 RFC822.SIZE 24800 ENVELOPE ("Tue, 10 Mar 2015 08:42:02 -0700" "=?utf-8?B?S3VpZGFzIG3DvMO8YSB0w6RuYT8=?=" (("=?utf-8?B?TcO8w7xnaW1laXN0ZXI=?=" NIL "etreening" "1business.eu")) (("=?utf-8?B?TcO8w7xnaW1laXN0ZXI=?=" NIL "etreening" "1business.eu")) (("=?utf-8?B?TcO8w7xnaW1laXN0ZXI=?=" NIL "vasta" "1business.eu")) ((NIL NIL "tanel" "torm.ee")) NIL NIL NIL "<56ACE6674B9FBEBD61642D9BDF9732FA@butep>") BODYSTRUCTURE (("TEXT" "PLAIN" ("CHARSET" "utf-8") NIL NIL "QUOTED-PRINTABLE" 2567 62 NIL NIL NIL NIL)("TEXT" "HTML" ("CHARSET" "utf-8") NIL NIL "QUOTED-PRINTABLE" 19973 371 NIL NIL NIL NIL) "ALTERNATIVE" ("BOUNDARY" "----=_NextPart_000_06AE_01D05B0E.14474830") NIL NIL NIL) BODY[HEADER.FIELDS (X-PRIORITY)] {17}

tfu

tfu

2015-03-10 21:01

reporter   ~0008257

What is your timezone in sogo.conf and in users' preference?

Raido

Raido

2015-03-16 08:23

reporter   ~0008277

In sogo conf I don't see timezone variable. In user preferences it is europe/tallinn

more /etc/sogo/sogo.conf

{
/* ***** Main SOGo configuration file **

  • *
  • Since the content of this file is a dictionary in OpenStep plist format, *
  • the curly braces enclosing the body of the configuration are mandatory. *
  • See the Installation Guide for details on the format. *
  • *
  • C and C++ style comments are supported. *
  • *
  • This example configuration contains only a subset of all available *
  • configuration parameters. Please see the installation guide more details. *
  • *
  • ~sogo/GNUstep/Defaults/.GNUstepDefaults has precedence over this file, *
  • make sure to move it away to avoid unwanted parameter overrides. *
  • *
  • **/

    / Database configuration (mysql:// or postgresql://) /
    //SOGoProfileURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile";
    //OCSFolderInfoURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info";
    //OCSSessionsFolderURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder";

    / Mail /
    //SOGoDraftsFolderName = Drafts;
    //SOGoSentFolderName = Sent;
    //SOGoTrashFolderName = Trash;
    //SOGoIMAPServer = localhost;
    //SOGoSieveServer = sieve://127.0.0.1:4190;
    //SOGoSMTPServer = 127.0.0.1;
    //SOGoMailDomain = acme.com;
    //SOGoMailingMechanism = smtp;
    //SOGoForceExternalLoginWithEmail = NO;
    //SOGoMailSpoolPath = /var/spool/sogo;
    //NGImap4ConnectionStringSeparator = "/";

    / Notifications /
    //SOGoAppointmentSendEMailNotifications = NO;
    //SOGoACLsSendEMailNotifications = NO;
    //SOGoFoldersSendEMailNotifications = NO;

    / Authentication /
    //SOGoPasswordChangeEnabled = YES;

    / LDAP authentication example /
    //SOGoUserSources = (
    // {
    // type = ldap;
    // CNFieldName = cn;
    // UIDFieldName = uid;
    // IDFieldName = uid; // first field of the DN for direct binds
    // bindFields = (uid, mail); // array of fields to use for indirect binds
    // baseDN = "ou=users,dc=acme,dc=com";
    // bindDN = "uid=sogo,ou=users,dc=acme,dc=com";
    // bindPassword = qwerty;
    // canAuthenticate = YES;
    // displayName = "Shared Addresses";
    // hostname = ldap://127.0.0.1:389;
    // id = public;
    // isAddressBook = YES;
    // }
    //);

    / LDAP AD/Samba4 example /
    //SOGoUserSources = (
    // {
    // type = ldap;
    // CNFieldName = cn;
    // UIDFieldName = sAMAccountName;
    // baseDN = "CN=users,dc=domain,dc=tld";
    // bindDN = "CN=sogo,CN=users,DC=domain,DC=tld";
    // bindFields = (sAMAccountName, mail);
    // bindPassword = password;
    // canAuthenticate = YES;
    // displayName = "Public";
    // hostname = ldap://127.0.0.1:389;
    // filter = "mail = '*'";
    // id = directory;
    // isAddressBook = YES;
    // }
    //);

    / SQL authentication example /
    /* These database columns MUST be present in the view/table:

  • c_uid - will be used for authentication - it's the username or username@domain.tld)
  • c_name - which can be identical to c_uid - will be used to uniquely identify entries
  • c_password - password of the user, plain-text, md5 or sha encoded for now
  • c_cn - the user's common name - such as "John Doe"
  • mail - the user's mail address
  • See the installation guide for more details
    */
    //SOGoUserSources =
    // (
    // {
    // type = sql;
    // id = directory;
    // viewURL = "postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view";
    // canAuthenticate = YES;
    // isAddressBook = YES;
    // userPasswordAlgorithm = md5;
    // }
    // );

    / Web Interface /
    //SOGoPageTitle = SOGo;
    //SOGoVacationEnabled = YES;
    //SOGoForwardEnabled = YES;
    //SOGoSieveScriptsEnabled = YES;
    //SOGoMailAuxiliaryUserAccountsEnabled = YES;
    //SOGoTrustProxyAuthentication = NO;

    / General /
    //SOGoLanguage = English;
    //SOGoTimeZone = America/Montreal;
    //SOGoCalendarDefaultRoles = (
    // PublicDAndTViewer,
    // ConfidentialDAndTViewer
    //);
    //SOGoSuperUsernames = (sogo1, sogo2); // This is an array - keep the parens!
    //SxVMemLimit = 384;
    //WOPidFile = "/var/run/sogo/sogo.pid";
    //SOGoMemcachedHost = "/var/run/memcached.sock";

    / Debug /
    //SOGoDebugRequests = YES;
    //SoDebugBaseURL = YES;
    //ImapDebugEnabled = YES;
    //LDAPDebugEnabled = YES;
    //PGDebugEnabled = YES;
    //MySQL4DebugEnabled = YES;
    //SOGoUIxDebugEnabled = YES;
    //WODontZipResponse = YES;
    //WOLogFile = /var/log/sogo/sogo.log;
    }

tfu

tfu

2015-03-16 10:18

reporter   ~0008278

What timestamp do you think is wrong? Is it the Sent:-timestamp mentioned in the quoted message?

From: Müügimeister [mailto:etreening@1business.eu]
Sent: Tuesday, March 10, 2015 5:42 PM <<<<<<<<<<<<<<???
To: tanel@torm.ee
Subject: Kuidas müüa täna?

Raido

Raido

2015-03-17 08:47

reporter   ~0008281

Yes the same. Email was recieved March 10, 2015, 9:42 a.m. but webmail and outlook display recieving time as March 10, 2015 5:42 PM

Raido

Raido

2015-03-17 08:48

reporter   ~0008282

Client gets this kind on mismatched time letters few times a week

tfu

tfu

2015-03-17 10:54

reporter   ~0008284

This is more a client (sender) issue (I assume outlook). See following links discussing such issues:
https://uk.answers.yahoo.com/question/index?qid=20100818143717AA6Wegf
http://answers.microsoft.com/en-us/office/forum/officeversion_other-outlook/reply-andor-forward-email-body-having-recipient/68fe30d4-4f89-48f0-a973-0e4d387bc1e8
http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/outlook-is-it-possible-to-have-the-time-zone/b6bafefe-af3a-438e-9713-68a57d9eebda

Raido

Raido

2015-03-23 08:23

reporter   ~0008338

These topic are about replying and forwarding messages as I can understand.

tfu

tfu

2015-03-23 09:05

reporter   ~0008340

Not sure what you mean with above statement. You confirmed above that it’s about the timestamp in the quoted message (in the body of the mail) and the topics are about issue when forwarding messages ...

Raido

Raido

2015-03-23 10:38

reporter   ~0008346

I think that we have misspoken here.

Problem here is.

Client receives an email at 11:00 (europe/Tallinn timezone). But in webmail and in outlook receiving time is shown e.g same date 17:00 (in future).

Sorry if i am causing a confusion, but I want to make sure, that this problem is caused by persons who send those letters.

tfu

tfu

2015-03-23 10:45

reporter   ~0008347

Screenshot + raw source of the email please.

Raido

Raido

2015-03-23 13:15

reporter   ~0008349

I try to get raw source within few days. Screenshots are added to the topic.

Raido

Raido

2015-03-23 13:15

reporter  

sc1.png (193,652 bytes)   
sc1.png (193,652 bytes)   
Raido

Raido

2015-03-23 13:15

reporter  

sc2.png (143,491 bytes)   
sc2.png (143,491 bytes)   
Raido

Raido

2015-04-08 13:49

reporter   ~0008406

Is it possible that this is somehow related to spam mail? Beacause all these letters with future date is somesort of advertise emails?

Christian Mack

Christian Mack

2015-07-03 14:14

developer   ~0008694

"Sent:" is set by the email client of the sender.
If he sets a wrong date/time, you receive a wrong date/time.
There is nothing SOGo can do about that.

I saw some spammer use that with dates in the future, in order to get it always on top of the email queue.

But SOGo could list emails based on their reception date/time instead of the "Sent:" date/time.

Christian Mack

Christian Mack

2015-07-06 15:54

developer   ~0008702

Check also bug 0000708

ludovic

ludovic

2015-09-25 17:33

administrator   ~0008958

Suspended for now. Reopen with evidences if necessary.

Issue History

Date Modified Username Field Change
2015-03-10 08:58 Raido New Issue
2015-03-10 08:58 Raido File Added: future date email.eml
2015-03-10 09:10 Raido Note Added: 0008253
2015-03-10 09:15 Raido Note Added: 0008254
2015-03-10 21:01 tfu Note Added: 0008257
2015-03-16 08:23 Raido Note Added: 0008277
2015-03-16 10:18 tfu Note Added: 0008278
2015-03-17 08:47 Raido Note Added: 0008281
2015-03-17 08:48 Raido Note Added: 0008282
2015-03-17 10:54 tfu Note Added: 0008284
2015-03-18 13:40 ludovic Severity major => minor
2015-03-23 08:23 Raido Note Added: 0008338
2015-03-23 09:05 tfu Note Added: 0008340
2015-03-23 10:38 Raido Note Added: 0008346
2015-03-23 10:45 tfu Note Added: 0008347
2015-03-23 13:15 Raido Note Added: 0008349
2015-03-23 13:15 Raido File Added: sc1.png
2015-03-23 13:15 Raido File Added: sc2.png
2015-04-08 13:49 Raido Note Added: 0008406
2015-07-03 14:14 Christian Mack Note Added: 0008694
2015-07-06 15:54 Christian Mack Note Added: 0008702
2015-07-06 15:54 Christian Mack Relationship added related to 0000708
2015-09-25 17:33 ludovic Note Added: 0008958
2015-09-25 17:33 ludovic Status new => resolved
2015-09-25 17:33 ludovic Resolution open => suspended
2015-09-25 17:33 ludovic Assigned To => ludovic