Mailing List Archive: DBMail: dev

dbmail_envelope dates

Index | Next | Previous | View Threaded

cloos at jhcloos

Apr 29, 2008, 2:48 PM

Post #1 of 3 (199 views)
Permalink

dbmail_envelope dates

Should dbmail normalize the timezone in the date chunk of the
dbmail_envelope.envelope field?

While doing some analysis I was inserting said date data into a
timestamp with timezone column and received some errors. They
were easy enough to work around, but got me curious.

The broken timezone offsets in my mail store were:

+0470, +1930, -1700, -2200, -2330

Should dbmail convert those to ±HHMM in [-1200 .. +1200] format?

Or does IMAP prefer the data be exactly as found in the original mail,
even when ill formed?

-JimC
--
James Cloos <cloos[at]jhcloos.com> OpenPGP: 1024D/ED7DAEA6
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev[at]dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev

paul at nfg

Apr 30, 2008, 1:57 PM

Post #2 of 3 (179 views)
Permalink

Re: dbmail_envelope dates [In reply to]

James Cloos wrote:
> Should dbmail normalize the timezone in the date chunk of the
> dbmail_envelope.envelope field?
>
> While doing some analysis I was inserting said date data into a
> timestamp with timezone column and received some errors. They
> were easy enough to work around, but got me curious.
>
> The broken timezone offsets in my mail store were:
>
> +0470, +1930, -1700, -2200, -2330
>
> Should dbmail convert those to ±HHMM in [-1200 .. +1200] format?
>
> Or does IMAP prefer the data be exactly as found in the original mail,
> even when ill formed?

We totally rely on libgmime to produce the envelope date astring for a
message object. Is it possible those invalid tz values were inserted by
an older gmime version?

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev[at]dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev

cloos at jhcloos

Apr 30, 2008, 10:46 PM

Post #3 of 3 (182 views)
Permalink

Re: dbmail_envelope dates [In reply to]

>>>>> "Paul" == Paul J Stevens <paul[at]nfg.nl> writes:

Paul> We totally rely on libgmime to produce the envelope date astring
Paul> for a message object. Is it possible those invalid tz values were
Paul> inserted by an older gmime version?

Gentoo still only has 2.2.17, even though I see that 2.2.18 was released
back in March. But the diffs, according to svn log and svn diff, don't
seem to be relevant. It looks like all of the mail in question came in
while I had 2.2.17 installed.

The Date header in the messgeblk matches exactly in every instance I
looked at (a random sample), so the numeric offset was kept as is.

I don't see anything in the rfc addressing this. I'll poke over to the
ietf and u-wash lists and see what the preference is.

-JimC
--
James Cloos <cloos[at]jhcloos.com> OpenPGP: 1024D/ED7DAEA6
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev[at]dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com