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

Reply via email to