A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=776 ====================================================================== Reported By: dbakken Assigned To: netvulture ====================================================================== Project: DBMail Issue ID: 776 Category: IMAP daemon Reproducibility: always Severity: major Priority: normal Status: assigned target: ====================================================================== Date Submitted: 03-Mar-09 18:12 CET Last Modified: 04-Mar-09 00:23 CET ====================================================================== Summary: INTERNALDATE is wrong time zone Description: INTERNALDATE values returned by dbmail-imap are labeled with the wrong time zone. Internal dates are stored in UTC. When displayed in IMAP, INTERNALDATE is returned in UTC, but labeled as -0800. This confuses clients like Mac Mail.app which use INTERNALDATE for the IMAP folder list. ======================================================================
---------------------------------------------------------------------- (0002800) dbakken (reporter) - 03-Mar-09 19:54 http://www.dbmail.org/mantis/view.php?id=776#c2800 ---------------------------------------------------------------------- The problem is that dbmail assumes MySQL is set to the same timezone as the server. Dates are stored using the MySQL timezone but retrieved using the server's system timezone. This would be fine if conversion was done, but it isn't. ---------------------------------------------------------------------- (0002801) netvulture (developer) - 03-Mar-09 21:04 http://www.dbmail.org/mantis/view.php?id=776#c2801 ---------------------------------------------------------------------- This issue was resolved in the 2.3.x branch with simply using the UTC +0000 timezone as the internal date is stored in the database as UTC when inserted. I will look into making a patch for 2.2, but until then, as a workaround you can set the dbmail server to UTC. ---------------------------------------------------------------------- (0002802) netvulture (developer) - 03-Mar-09 21:22 http://www.dbmail.org/mantis/view.php?id=776#c2802 ---------------------------------------------------------------------- I have uploaded a patch for testing. It takes the function as is from the 2.3.x branch and puts it in place in 2.2.x. Please recompile with this patch and test. I have not tested it as I no longer have a database setup with 2.2 data and don't have the time to set it up at the moment. ---------------------------------------------------------------------- (0002803) dbakken (reporter) - 03-Mar-09 23:01 http://www.dbmail.org/mantis/view.php?id=776#c2803 ---------------------------------------------------------------------- Thanks for the patch. Before you uploaded it, I fixed the problem by hacking the dbmail source code in exactly the same way, except I didn't return g_strdup(_imapdate). ---------------------------------------------------------------------- (0002804) dbakken (reporter) - 04-Mar-09 00:23 http://www.dbmail.org/mantis/view.php?id=776#c2804 ---------------------------------------------------------------------- I can confirm that the patch fixes the issue. Issue History Date Modified Username Field Change ====================================================================== 03-Mar-09 18:12 dbakken New Issue 03-Mar-09 19:54 dbakken Note Added: 0002800 03-Mar-09 21:04 netvulture Note Added: 0002801 03-Mar-09 21:04 netvulture Status new => assigned 03-Mar-09 21:04 netvulture Assigned To => netvulture 03-Mar-09 21:21 netvulture File Added: 2_2_internaldate_utc.diff 03-Mar-09 21:22 netvulture Note Added: 0002802 03-Mar-09 23:01 dbakken Note Added: 0002803 04-Mar-09 00:23 dbakken Note Added: 0002804 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev