Hi Travis,
The attachment does not have a Content-Disposition header set or the
'name' portion of content-type which is why Eventum isn't displaying it.
Of course according to the RFC, neither of these are required so Eventum
needs to handle emails like this. I just need to see how this affects
other emails.
/bryan
Travis Pierce wrote:
> One of my departments has created a scheduled job that
> does a database schema comparison in MSSQL 2005. The
> job then uses the email mechanism in MSSQL to send an
> email with the schema report as an attachement. We
> use exchange here in the company and get the report
> without any issue.
>
> A copy of the email is sent into Eventum to store the
> report as part of our regulatory compliance. Eventum
> gets the email, but does not recognize the attachment
> as such. I think the email is not correctly formatted
> by the MSSQL server causing Eventum not to recognize
> the attachement.
>
> Can someone tell me what they think is occuring, and
> maybe give me some suggestions? If it's a MSSQL issue,
> then I'll ask Redmond for the souce code :)
>
>
> Here is a copy of the raw email:
>
>
> Received: from athena (172.29.166.17 [172.29.166.17])
> by slkexu02.blahbing.com with SMTP (Microsoft Exchange
> Internet Mail Service Version 5.5.2657.72)
> id PC6JMD6A; Mon, 24 Jul 2006 18:00:12 -0600
> sensitivity: Normal
> reply-to: FILM.reports@stripped
> importance: Normal
> mime-version: 1.0
> X-Sybari-Trust: 422f9283 95c75ce7 c2ffaf33 00000139
> from: "FILM Database Server"
> <FILM.reports@stripped>
> to: davie.l.williams@stripped,
> stevo.braithwaite@stripped,
> CTG.Resolutions@stripped
> date: 24 Jul 2006 18:00:08 -0600
> subject: FILM Schema Report
> content-type: multipart/mixed;
> boundary=--boundary_0_990f1463-c0f6-4c74-a5fc-2c72c73f5333
>
>
> ----boundary_0_990f1463-c0f6-4c74-a5fc-2c72c73f5333
> content-type: text/plain; charset=utf-8
> content-transfer-encoding: base64
>
> RkVQUyBkYXRhYmFzZSBiYXNlbGluZSBjb21wYXJpc29uLg0KDQo=
>
> ----boundary_0_990f1463-c0f6-4c74-a5fc-2c72c73f5333
> content-type: application/octet-stream;
> name=FILMBaselineComparison.xls
> content-transfer-encoding: base64
>
> PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz48V29ya2Jvb2sgeG1sbnM9InVy
> bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOnNwcmVhZHNoZWV0IiB4bWxuczpvPSJ1cm46
> c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTpvZmZpY2UiIHhtbG5zOng9InVybjpzY2hlbWFz
> LW1pY3Jvc29mdC1jb206b2ZmaWNlOmV4Y2VsIiB4bWxuczpzcz0idXJuOnNjaGVtYXMtbWljcm9z
> b2Z0LWNvbTpvZmZpY2U6c3ByZWFkc2hlZXQiIHhtbG5zOmh0bWw9Imh0dHA6Ly93d3cudzMub3Jn
> L1RSL1JFQy1odG1sNDAiPjxTdHlsZXM+PFN0eWxlIHNzOklEPSJEZWZhdWx0IiBzczpOYW1lPSJO
> b3JtYWwiPjxBbGlnbm1lbnQgc3M6VmVydGljYWw9IkJvdHRvbSIgLz48Qm9yZGVycyAvPjxGb250
> IC8+PEludGVyaW9yIC8+PE51bWJlckZvcm1hdCAvPjxQcm90ZWN0aW9uIC8+PC9TdHlsZT48U3R5
> bGUgc3M6SUQ9InMyMSI+PEFsaWdubWVudCBzczpIb3Jpem9udGFsPSJDZW50ZXIiIHNzOlZlcnRp
> Y2FsPSJCb3R0b20iIC8+PC9TdHlsZT48U3R5bGUgc3M6SUQ9InMyMyI+PEFsaWdubWVudCBzczpI
> b3Jpem9udGFsPSJDZW50ZXIiIHNzOlZlcnRpY2FsPSJCb3R0b20iIC8+PEZvbnQgeDpGYW1pbHk9
> IlN3aXNzIiBzczpCb2xkPSIxIiAvPjwvU3R5bGU+PFN0eWxlIHNzOklEPSJzMjQiPjxJbnRlcmlv
> ciBzczpDb2xvcj0iI0MwQzBDMCIgc3M6UGF0dGVybj0iU29saWQiIC8+PC9TdHlsZT48L1N0eWxl
> cz48V29ya3NoZWV0IHNzOk5hbWU9IlNRTCBDb21wYXJlIFJlcG9ydCI+PFRhYmxlPjxDb2x1bW4g
> c3M6QXV0b0ZpdFdpZHRoPSIwIiBzczpXaWR0aD0iNjYuNzUiIC8+PENvbHVtbiBzczpBdXRvRml0
> V2lkdGg9IjAiIHNzOldpZHRoPSI2MCIgLz48Q29sdW1uIHNzOkF1dG9GaXRXaWR0aD0iMCIgc3M6
> V2lkdGg9IjExMi41IiAvPjxDb2x1bW4gc3M6QXV0b0ZpdFdpZHRoPSIwIiBzczpXaWR0aD0iNjAi
> IC8+PENvbHVtbiBzczpBdXRvRml0V2lkdGg9IjAiIHNzOldpZHRoPSIxMTIuNSIgLz48Q29sdW1u
> IHNzOkF1dG9GaXRXaWR0aD0iMCIgc3M6V2lkdGg9IjYwLjc1IiAvPjxSb3c+PENlbGwgc3M6SW5k
> ZXg9IjIiIHNzOk1lcmdlQWNyb3NzPSI0IiBzczpTdHlsZUlEPSJzMjMiPjxEYXRhIHNzOlR5cGU9
> IlN0cmluZyI+U1FMIENvbXBhcmUgUmVwb3J0OiAyNCBKdWwgMjAwNiA1OjMwIFBNPC9EYXRhPjwv
> Q2VsbD48L1Jvdz48Um93PjxDZWxsIHNzOkluZGV4PSIyIiBzczpNZXJnZUFjcm9zcz0iMSIgc3M6
> U3R5bGVJRD0iczIzIj48RGF0YSBzczpUeXBlPSJTdHJpbmciPlpFVVMuQUNTLU9QUy5DT00uRmVw
> czwvRGF0YT48L0NlbGw+PENlbGwgc3M6U3R5bGVJRD0iczIxIj48RGF0YSBzczpUeXBlPSJTdHJp
> bmciPnZzPC9EYXRhPjwvQ2VsbD48Q2VsbCBzczpNZXJnZUFjcm9zcz0iMSIgc3M6U3R5bGVJRD0i
> czIzIj48RGF0YSBzczpUeXBlPSJTdHJpbmciPlpFVVMuQUNTLU9QUy5DT00uRmVwczwvRGF0YT48
> L0NlbGw+PC9Sb3c+PFJvdz48Q2VsbCBzczpTdHlsZUlEPSJzMjQiPjxEYXRhIHNzOlR5cGU9IlN0
> cmluZyI+VHlwZTwvRGF0YT48L0NlbGw+PENlbGwgc3M6U3R5bGVJRD0iczI0Ij48RGF0YSBzczpU
> eXBlPSJTdHJpbmciPk93bmVyPC9EYXRhPjwvQ2VsbD48Q2VsbCBzczpTdHlsZUlEPSJzMjQiPjxE
> YXRhIHNzOlR5cGU9IlN0cmluZyI+T2JqZWN0PC9EYXRhPjwvQ2VsbD48Q2VsbCBzczpTdHlsZUlE
> PSJzMjQiPjxEYXRhIHNzOlR5cGU9IlN0cmluZyI+U3RhdHVzPC9EYXRhPjwvQ2VsbD48Q2VsbCBz
> czpTdHlsZUlEPSJzMjQiPjxEYXRhIHNzOlR5cGU9IlN0cmluZyI+T2JqZWN0PC9EYXRhPjwvQ2Vs
> bD48Q2VsbCBzczpTdHlsZUlEPSJzMjQiPjxEYXRhIHNzOlR5cGU9IlN0cmluZyI+T3duZXI8L0Rh
> dGE+PC9DZWxsPjwvUm93PjwvVGFibGU+PC9Xb3Jrc2hlZXQ+PC9Xb3JrYm9vaz4=
>
> ----boundary_0_990f1463-c0f6-4c74-a5fc-2c72c73f5333--
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
--
Bryan Alsdorf, Manager of Support Systems
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
